private void AddDeptandPerson(Coolite.Ext.Web.TreeNodeCollection nodes, string deptid)
{
var father = dc.Department.First(p => p.Deptnumber == deptid);
var per = (from p in dc.Person
from v in dc.Vgetpl
where p.Personnumber == v.Personnumber && p.Areadeptid == deptid && v.Operatortag == "YH_fcfk" && v.Moduletag == "HiddenDanage_HDprocess"
select new
{
p.Personnumber,
p.Name,
Deptname = father.Deptname
}).Distinct();
foreach (var r in per)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Name;
asyncNode.NodeID = r.Personnumber;
asyncNode.Icon = Icon.User;
asyncNode.CustomAttributes.Add(new ConfigItem("data", r.Deptname, ParameterMode.Value));
asyncNode.Listeners.DblClick.Handler = string.Format("PersonSelector.add({0},{1});", "GridPanel3", "[new Ext.data.Record({Personnumber:'" + r.Personnumber + "',Name:'" + r.Name + "',Deptname:'" + r.Deptname + "'})]");
asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
void IHttpHandler.ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/json";
string nodeId = context.Request["node"];
if (!string.IsNullOrEmpty(nodeId))
{
Coolite.Ext.Web.TreeNodeCollection nodes = new Coolite.Ext.Web.TreeNodeCollection(false);
DataTable dt = logic.category.getByParent(Convert.ToInt32(nodeId));
foreach (DataRow dr in dt.Rows)
{
Coolite.Ext.Web.TreeNode node = new Coolite.Ext.Web.TreeNode();
node.Text = dr["name"].ToString();
node.NodeID = dr["categoryId"].ToString();
if (dr["treelevel"].ToString() == "1")
{
node.Leaf = true;
node.Href = "javascript:getList(" + dr["categoryId"].ToString() + ");";
}
nodes.Add(node);
}
context.Response.Write(nodes.ToJson());
context.Response.End();
}
}
private void AddYh(Coolite.Ext.Web.TreeNodeCollection nodes, decimal LevelId, decimal TypeId)
{
var data = from yh in dc.Yhbase
where yh.Levelid == LevelId && yh.Typeid == TypeId
select new
{
yh.Yhid,
yh.Yhnumber,
yh.Yhcontent
};
foreach (var r in data)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Yhcontent;//"["+r.Yhnumber+"]"
asyncNode.Qtip = r.Yhcontent;
asyncNode.NodeID = r.Yhid.ToString();
//asyncNode.Icon = Icon.User;
//asyncNode.CustomAttributes.Add(new ConfigItem("Type", r.Typename, ParameterMode.Value));
//asyncNode.CustomAttributes.Add(new ConfigItem("Level", r.Levelname, ParameterMode.Value));
asyncNode.Listeners.Click.Handler = "Coolite.AjaxMethods.LoadYh2Haz(" + r.Yhid.ToString() + ",1)";
//asyncNode.Listeners.DblClick.Handler = string.Format("PersonSelector.add({0},{1});", "GridPanel3", "[new Ext.data.Record({Personnumber:'" + r.Personnumber + "',Name:'" + r.Name + "',Deptname:'" + r.Deptname + "'})]");
asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
private void AddPlace(Coolite.Ext.Web.TreeNodeCollection nodes, string deptid)
{
var father = dc.Placeareas.First(p => p.Pareasid == decimal.Parse(deptid));
var per = from p in dc.Place
where p.Pareasid == decimal.Parse(deptid) && p.Maindeptid == father.Maindeptid && p.Placestatus == 1//所有有效地点
select new
{
p.Placeid,
p.Placename,
father.Pareasname
};
foreach (var r in per)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Placename;
asyncNode.NodeID = r.Placeid.ToString();
asyncNode.Icon = Icon.House;
asyncNode.CustomAttributes.Add(new ConfigItem("data", r.Pareasname, ParameterMode.Value));
asyncNode.Listeners.DblClick.Handler = string.Format("PersonSelector.add({0},{1});", "GridPanel2", "[new Ext.data.Record({Placeid:'" + r.Placeid + "',Placename:'" + r.Placename + "',Pareasname:'" + r.Pareasname + "',Zdcs:1})]");
asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
private void AddGZRW(Coolite.Ext.Web.TreeNodeCollection nodes, string pid)
{
var gzrw = dc.Worktasks.Where(p => p.Professionalid == decimal.Parse(pid));
foreach (var r in gzrw)
{
AsyncTreeNode asyncNode = new AsyncTreeNode();
asyncNode.Text = r.Worktask;
asyncNode.NodeID = "w" + r.Worktaskid.ToString();
nodes.Add(asyncNode);
}
}
public string NodeLoad(string nodeID)
{
Coolite.Ext.Web.TreeNodeCollection nodes = new Coolite.Ext.Web.TreeNodeCollection();
switch (nodeID.Substring(0, 1))
{
case "z":
AddGZRW(nodes, nodeID.Substring(1));
break;
}
string a = nodes.ToJson();
return(nodes.ToJson());
}
private void AddGX(Coolite.Ext.Web.TreeNodeCollection nodes, string pid)
{
var gx = dc.Process.Where(p => p.Worktaskid == decimal.Parse(pid)).OrderBy(p => p.Serialnumber);
foreach (var r in gx)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Name;
asyncNode.NodeID = "p" + r.Processid.ToString();
//asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad('{0}','F');", r["PROCESSID"].ToString().Trim());
//asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
private Coolite.Ext.Web.TreeNodeCollection LoadTree(Coolite.Ext.Web.TreeNodeCollection nodes)
{
if (nodes == null)
{
nodes = new Coolite.Ext.Web.TreeNodeCollection();
}//根节点为null时
tpkind.Root.Clear();
Coolite.Ext.Web.TreeNode root = new Coolite.Ext.Web.TreeNode();
root.Text = "-1";
root.NodeID = "走动部门";
tpkind.Root.Add(root);
TreeBuild(root.Nodes, -1);
return(nodes);
}
private void AddGZRW(Coolite.Ext.Web.TreeNodeCollection nodes, string p)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("select * from worktasks where professionalid={0}", p));
DataTable dt = OracleHelper.Query(strSql.ToString()).Tables[0];
foreach (DataRow r in dt.Rows)
{
AsyncTreeNode asyncNode = new AsyncTreeNode();
asyncNode.Text = r["WORKTASK"].ToString();
asyncNode.NodeID = "w" + r["WORKTASKID"].ToString();
nodes.Add(asyncNode);
}
}
private void AddHaz(Coolite.Ext.Web.TreeNodeCollection nodes, string pid)
{
var gx = dc.Hazards.Where(p => p.Processid == decimal.Parse(pid));
foreach (var r in gx)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.HContent;
asyncNode.Qtip = r.HContent;
asyncNode.NodeID = r.Hazardsid.ToString();
asyncNode.Listeners.Click.Handler = "Coolite.AjaxMethods.LoadYh2Haz(" + r.Hazardsid.ToString() + ",1)";
//asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad('{0}','F');", r["PROCESSID"].ToString().Trim());
asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
private void AddGX(Coolite.Ext.Web.TreeNodeCollection nodes, string p)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("select * from process where WORKTASKID={0} order by SERIALNUMBER", p));
DataTable dt = OracleHelper.Query(strSql.ToString()).Tables[0];
foreach (DataRow r in dt.Rows)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r["NAME"].ToString();
asyncNode.NodeID = "p" + r["PROCESSID"].ToString();
asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad('{0}','F');", r["PROCESSID"].ToString().Trim());
asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
public string NodeLoad(string nodeID)
{
Coolite.Ext.Web.TreeNodeCollection nodes = new Coolite.Ext.Web.TreeNodeCollection();
var dm = dc.SqsDomain.Where(p => p.Fid == decimal.Parse(nodeID));
foreach (var r in dm)
{
//Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
AsyncTreeNode asyncNode = new AsyncTreeNode();
asyncNode.Text = r.Dname;
asyncNode.NodeID = r.Did.ToString();
asyncNode.Qtip = "满分分值:" + r.Fullscore.ToString() + ",系数:" + r.Rate.ToString();
if (dc.SqsDomain.Count(p => p.Fid == r.Did) == 0)
{
asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad({0});", r.Did.ToString());
asyncNode.Leaf = true;
}
nodes.Add(asyncNode);
}
return(nodes.ToJson());
}
private void TreeBuild(Coolite.Ext.Web.TreeNodeCollection nodes, decimal pid)
{
var dept = from c in dc.Department
where c.Visualfield == 3 //视野为3 全局
select new
{
c.Deptnumber,
c.Deptname
};
foreach (var r in dept)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Deptname;
asyncNode.NodeID = r.Deptnumber.ToString();
nodes.Add(asyncNode);
asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad('{0}');", r.Deptnumber.ToString());
asyncNode.Leaf = true;
}
}
private void TreeBuild(Coolite.Ext.Web.TreeNodeCollection nodes, decimal pid)
{
var lavel = from c in dc.CsBaseinfoset
where c.Fid == int.Parse(PublicMethod.ReadXmlReturnNode("SWJB", this))
select new
{
c.Infoid,
c.Infoname
};
foreach (var r in lavel)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Infoname;
asyncNode.NodeID = r.Infoid.ToString();
nodes.Add(asyncNode);
asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad({0});", r.Infoid.ToString());
asyncNode.Leaf = true;
}
}
private void AddGZRW(Coolite.Ext.Web.TreeNodeCollection nodes, string p)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(string.Format("select * from worktasks where professionalid={0}", p));
DataTable dt = OracleHelper.Query(strSql.ToString()).Tables[0];
foreach (DataRow r in dt.Rows)
{
//AsyncTreeNode asyncNode = new AsyncTreeNode();
//asyncNode.Text = r["WORKTASK"].ToString();
//asyncNode.NodeID = "w" + r["WORKTASKID"].ToString();
//nodes.Add(asyncNode);
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r["WORKTASK"].ToString();
asyncNode.NodeID = "w" + r["WORKTASKID"].ToString();
asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad({0});", r["WORKTASKID"].ToString().Trim());
asyncNode.Leaf = true;
nodes.Add(asyncNode);
}
}
private void TreeBuild(Coolite.Ext.Web.TreeNodeCollection nodes, decimal pid)
{
var kind = dc.SqsDomain.Where(p => p.Fid == pid && p.Usingdept == SessionBox.GetUserSession().DeptNumber);
foreach (var r in kind)
{
Coolite.Ext.Web.TreeNode asyncNode = new Coolite.Ext.Web.TreeNode();
asyncNode.Text = r.Dname + "(" + r.Fullscore.ToString() + ")";
asyncNode.NodeID = r.Did.ToString();
asyncNode.Qtip = "满分分值:" + r.Fullscore.ToString() + ",系数:" + r.Rate.ToString();
nodes.Add(asyncNode);
if (dc.SqsDomain.Where(p => p.Fid == r.Did).Count() > 0)
{
TreeBuild(asyncNode.Nodes, r.Did);
}
else
{
asyncNode.Listeners.Click.Handler = string.Format("Coolite.AjaxMethods.GVLoad({0});", r.Did.ToString());
asyncNode.Leaf = true;
}
}
}
public string RefreshMenu()
{
Coolite.Ext.Web.TreeNodeCollection nodes = LoadTree(tpkind.Root);
return(nodes.ToJson());
}
private Coolite.Ext.Web.TreeNodeCollection LoadTree(Coolite.Ext.Web.TreeNodeCollection nodes)
{
if (nodes == null)
{
nodes = new Coolite.Ext.Web.TreeNodeCollection();
}//根节点为null时
tpPerson.Root.Clear();
Coolite.Ext.Web.TreeNode root = new Coolite.Ext.Web.TreeNode();
if (cbbJctype.SelectedItem.Value == "2")
{
var dept = dc.Department.First(p => p.Deptnumber == "000000000");
root = new Coolite.Ext.Web.TreeNode(dept.Deptnumber, dept.Deptname, Icon.UserHome);
tpPerson.Root.Add(root);
var per = (from d in dc.Department
where //d.Deptnumber.Substring(0, 4) == "1303"
//&& (d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级")
//&&
d.Visualfield == 3
select new
{
d.Deptnumber,
d.Deptname
}).OrderBy(p => p.Deptname);
foreach (var r in per)
{
AsyncTreeNode asyncNode = new AsyncTreeNode(r.Deptnumber, r.Deptname);
asyncNode.Icon = Icon.UserEarth;
root.Nodes.Add(asyncNode);
}
//局端排查人
var person = from p in dc.Person
from d in dc.Department
where p.Areadeptid == d.Deptnumber && p.Visualfield == 100//返回空结构
select new
{
p.Personnumber,
p.Name,
d.Deptname
};
SelectedStore.DataSource = person;
SelectedStore.DataBind();
}
else
{
var dept = dc.Department.First(p => p.Deptnumber == SessionBox.GetUserSession().DeptNumber);
root = new Coolite.Ext.Web.TreeNode(dept.Deptnumber, dept.Deptname, Icon.UserHome);
tpPerson.Root.Add(root);
var per = (from v in dc.Vgetpl
where v.Operatortag == "YH_fcfk" && v.Moduletag == "HiddenDanage_HDprocess" && v.Unitid == SessionBox.GetUserSession().DeptNumber
select new
{
v.Deptnumber,
v.Deptname
}).Distinct().OrderBy(p => p.Deptname);
foreach (var r in per)
{
AsyncTreeNode asyncNode = new AsyncTreeNode(r.Deptnumber, r.Deptname);
asyncNode.Icon = Icon.UserEarth;
root.Nodes.Add(asyncNode);
}
//排查人初始绑定
var person = (from pl in dc.Vgetpl
where pl.Moduletag == "YSNewProcess_YHProcess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
pl.Personnumber == SessionBox.GetUserSession().PersonNumber
select new
{
pl.Personnumber,
pl.Name,
pl.Deptname
}).Distinct();
if (person.Where(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Count() > 0)
{
cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
var person1 = person.Where(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber);
SelectedStore.DataSource = person1;
SelectedStore.DataBind();
}
}
return(nodes);
}
public string NodeLoadYh(string nodeID, string TypeId)
{
Coolite.Ext.Web.TreeNodeCollection nodes = new Coolite.Ext.Web.TreeNodeCollection();
AddYh(nodes, decimal.Parse(nodeID), decimal.Parse(TypeId));
return(nodes.ToJson());
}
public string NodeLoad(string nodeID)
{
Coolite.Ext.Web.TreeNodeCollection nodes = new Coolite.Ext.Web.TreeNodeCollection();
AddDeptandPerson(nodes, nodeID);
return(nodes.ToJson());
}