<%@ Page Language="C#" Debug="true" %> <%@ Import Namespace ="eMIS" %> <%@ Import Namespace ="System.Data" %> <% string programId = Request.QueryString["pid"].ToString(); string treejson = DataManager.UrlDecode(Request.QueryString["tree"].ToString()); string objectValue = DataManager.UrlDecode(Request.QueryString["ov"].ToString()); InstanceManager inst = new InstanceManager(Context, programId); string tableName = inst.Program.ListTableName; string condition = inst.DefaultCondition; if (condition == "") condition = "1=1"; /* {treeType:2,condList:[{role:"9",cond:""},{role:"7",cond:""},{role:"2",cond:""},{role:"8",cond:""},{role:"23",cond:"(ZGRY='<#session.userid#>' or id='<#session.userid#>')"},{role:"1",cond:"ID='<#session.userid#>'"}],table:"View_CW_成本中心",primaryField:"id",parentField:"fid",rootId:"0",rootDesc:"成本中心",descField:"FYZX",displayCount:0} */ MenuTree treeObj =Newtonsoft.Json.JsonConvert.DeserializeObject(treejson); string treeCond = ""; if (treeObj.condList != null) { DataManager dm = new DataManager(); dm.OpenConnection(); System.Data.DataTable dt = dm.ExecuteTable("select gangwei_id from COM_YHGWDZB where renyuan_id=" + Session["userid"].ToString()); dm.CloseConnection(); TagManager tag = new TagManager(); tag.Context = Context; foreach (MenuTreeCond cond in treeObj.condList) { if (cond.role == "default" && treeCond=="") { treeCond = DataManager.Encrypt(tag.ReplaceExpression(cond.cond, "")); break; } else if (dt.Select("gangwei_id=" + cond.role).Length != 0) { treeCond = DataManager.Encrypt(tag.ReplaceExpression(cond.cond, "")); break; } } } condition = DataManager.Encrypt(condition); /*----------------------------------------*/ string rootQuery = "[]"; string sql = ""; if (treeObj.rootDesc != null) { if (treeObj.rootDesc == "<#org#>") sql = "select keshi_id, qc from com_ksb where org_id = (select org_id from com_yhb where id = " + Session["userid"].ToString() +")"; else if (treeObj.rootDesc == "<#orgname#>") sql = "select '0', qc from com_ksb where org_id = (select org_id from com_yhb where id = " + Session["userid"].ToString() +")"; if (sql != "") { DataManager dm = new DataManager(); System.Data.DataTable dt = dm.ExecuteTable(sql); rootQuery = "[" + dt.Rows[0][0].ToString() + ", '" + dt.Rows[0][1].ToString() + "']"; } } /*----------------------------------------*/ %>