private void baseload() { #region 初始化级别 var lavel = from c in dc.CsBaseinfoset where c.Fid == int.Parse(PublicMethod.ReadXmlReturnNode("SWJB", this)) select new { YHLevelID = c.Infoid, YHLevel = c.Infoname }; LevelStore.DataSource = lavel; LevelStore.DataBind(); #endregion #region 初始化类型 var type = from t in dc.CsBaseinfoset where t.Fid == int.Parse(PublicMethod.ReadXmlReturnNode("ZY", this)) orderby t.Infoid ascending select new { YHTypeID = t.Infoid, YHType = t.Infoname }; TypeStore.DataSource = type; TypeStore.DataBind(); #endregion }
private void SearchLoad()//查询窗口初始化 { //初始化日期 df_begin.SelectedDate = System.DateTime.Today; df_end.SelectedDate = System.DateTime.Today; //df_begin.SelectedDate = System.DateTime.Today;//.AddDays(-1); //df_end.SelectedDate = System.DateTime.Today; #region 初始化职务 var pos = from p in dc.Position from per in dc.Person where p.Posid == per.Posid && per.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { p.Posid, p.Posname }; Store3.DataSource = pos; Store3.DataBind(); #endregion #region 初始化部门 //var dep = from d in dc.Department // where d.Fatherid == SessionBox.GetUserSession().DeptNumber // select new // { // d.Deptname, // Deptid = d.Deptnumber // }; //DeptStore.DataSource = dep; //DeptStore.DataBind(); var dep = from d in dc.Department from p in dc.Person where d.Deptnumber == p.Areadeptid && p.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { d.Deptname, Deptid = d.Deptnumber }; DeptStore.DataSource = dep; DeptStore.DataBind(); #endregion #region 初始化单位 if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1) { var dept = from d in dc.Department where d.Deptnumber.Substring(4) == "00000" && d.Deptname.EndsWith("矿") select new { d.Deptname, Deptid = d.Deptnumber }; UnitStore.DataSource = dept; UnitStore.DataBind(); cbbUnit.Disabled = false; cbb_position.Disabled = true; cbb_person.Disabled = true; cbb_part.Disabled = true; cbb_status.Disabled = true; } else { var dept = from d in dc.Department where d.Deptnumber == SessionBox.GetUserSession().DeptNumber select new { d.Deptname, Deptid = d.Deptnumber }; UnitStore.DataSource = dept; UnitStore.DataBind(); cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber; cbbUnit.Disabled = true; } #endregion //#region 初始化级别 //var lavel = from l in dc.Yinhuanlevel // select new // { // l.YHLevelID, // l.YHLevel // }; //LevelStore.DataSource = lavel; //LevelStore.DataBind(); //#endregion #region 初始化类型 int zyID = int.Parse(PublicMethod.ReadXmlReturnNode("ZY", this)); var type = from t in dc.CsBaseinfoset where t.Fid == zyID select new { YHTypeID = t.Infoid, YHType = t.Infoname }; TypeStore.DataSource = type; TypeStore.DataBind(); #endregion #region 初始化状态 StatusStore.DataBind(); #endregion }