private void pcPersonLoad()
{
var person = (from pl in dc.Vgetpl
where pl.Moduletag == "HiddenDanage_HDprocess" && pl.Operatortag == "YH_fcfk" && pl.Unitid == SessionBox.GetUserSession().DeptNumber &&
pl.Personnumber == SessionBox.GetUserSession().PersonNumber
select new
{
pl.Personnumber,
pl.Name,
pl.Deptname
}).Distinct();
PCpersonStore.DataSource = person;
PCpersonStore.DataBind();
if (person.Where(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber).Count() > 0)
{
cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber;
var per = person.Where(p => p.Personnumber == SessionBox.GetUserSession().PersonNumber);
//tfPerson.Text = per.First().Name;
//hdnPerson.SetValue(SessionBox.GetUserSession().PersonNumber);
SelectedStore.DataSource = per;
SelectedStore.DataBind();
//string js=string.Format("PersonSelector.add({0},{1});", "GridPanel3", "[new Ext.data.Record({Personnumber:'" + per.Personnumber + "',Name:'" + per.Name + "',Deptname:'" + per.Deptname + "'})]");
//Ext.DoScript(js);
}
}
public void StoreBind()
{
var per = (from v in dc.Position where v.Movegblevel == cbbStatus.SelectedItem.Value
select new
{
Name = v.Posname
}).Distinct().OrderBy(p => p.Name);
SelectedStore.DataSource = per;
SelectedStore.DataBind();
}
private void GetPersonName(int Yhid)
{
var per = from ym in dc.NyhinputMore
from p in dc.Person
from d in dc.Department
where ym.Personid == p.Personnumber && p.Areadeptid == d.Deptnumber && ym.Yhputinid == Yhid
select new
{
p.Personnumber,
p.Name,
d.Deptname
};
SelectedStore.DataSource = per;
SelectedStore.DataBind();
if (per.Count() > 0)
{
string strPer = "";
string strName = "";
foreach (var r in per)
{
strPer += r.Personnumber + ",";
strName += r.Name + ",";
}
var person = from p in dc.Person
where p.Personnumber == SessionBox.GetUserSession().PersonNumber
select new
{
Personnumber = strPer.Substring(0, strPer.Length - 1),
Name = strName.Substring(0, strName.Length - 1)
};
PCpersonStore.DataSource = person;
PCpersonStore.DataBind();
cbbPerson.SelectedIndex = 0;
//tfPerson.Text = strName.Substring(0, strName.Length - 1);
//hdnPerson.SetValue(strPer.Substring(0, strPer.Length - 1));
}
else
{
cbbPerson.Items.Clear();
//tfPerson.Text = "";
//hdnPerson.SetValue("");
}
}
private void SelectedStoreLoad()
{
var data = from sw in dc.Nswinput
from per in dc.Person
from dep in dc.Department
where sw.Swpersonid == per.Personnumber &&
per.Deptid == dep.Deptnumber &&
sw.Maindeptid == SessionBox.GetUserSession().DeptNumber &&
sw.Islearn == 1
orderby sw.Intime descending
select new
{
per.Personnumber,
per.Name,
dep.Deptname
};
SelectedStore.DataSource = data;
SelectedStore.DataBind();
}
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);
}
