<%@ Page Language="C#" %> <%@ Import Namespace ="eMIS" %> <% string programId = Request.QueryString["pid"].ToString(); string bgid = Request.QueryString["bgid"] == null ? "1" : Request.QueryString["bgid"].ToString(); string defaultId = Request.QueryString["did"] == null ? "" : Request.QueryString["did"].ToString(); string treejson; string treeCond = ""; if (Request.QueryString["tree"] != null) { treejson = Request.QueryString["tree"].ToString(); } else { treejson = Request.QueryString["tjson"].ToString(); treejson = DataManager.Decrypt(treejson); } MenuTree treeObj =Newtonsoft.Json.JsonConvert.DeserializeObject(treejson); 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; } } } string condition = Request.QueryString["cond"] == null ? "" : Request.QueryString["cond"].ToString(); if(condition=="") condition = DataManager.Encrypt("1=1"); /*----------------------------------------*/ 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() + "']"; } } /*----------------------------------------*/ %>