private void InitDept() { HBBLL hb = new HBBLL(); var dept = hb.GetVPDept(); var data = from d in dept select new { Deptnumber = d.DeptNumber, Deptname = d.DeptName }; DeptStore.DataSource = data; DeptStore.DataBind(); if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0")) { cbbDept.Items.Insert(0, new Coolite.Ext.Web.ListItem("--全部--", "-1")); cbbDept.SelectedItem.Value = "-1"; cbbDept.Disabled = false; } else { cbbDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber; cbbDept.Disabled = true; } }
private void SearchLoad()//查询窗口初始化 已改 { //DBSCMDataContext dc = new DBSCMDataContext(); //初始化日期 //df_begin.SelectedDate = System.DateTime.Today.AddDays(-6); //df_end.SelectedDate = System.DateTime.Today; //初始化部门 var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptnumber.Substring(7) == "00" orderby d.Deptname select new { d.Deptnumber, d.Deptname }; DeptStore.DataSource = dept; DeptStore.DataBind(); //初始化级别 var lavel = from c in dc.CsBaseinfoset where c.Fid == int.Parse(PublicMethod.ReadXmlReturnNode("SWJB", this)) select new { SWLevelID = c.Infoid, SWLevel = c.Infoname }; LevelStore.DataSource = lavel; LevelStore.DataBind(); }
private void BaseSet() { var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptlevel == "正科级" orderby d.Deptname select new { d.Deptnumber, d.Deptname }; if (dept.Count() > 0) { DeptStore.DataSource = dept; DeptStore.DataBind(); } else { var de = from d in dc.Department where d.Deptnumber.Substring(4) == "00000" select new { d.Deptnumber, d.Deptname }; DeptStore.DataSource = de; DeptStore.DataBind(); } dfDate.SelectedDate = System.DateTime.Today; }
protected void Page_Load(object sender, EventArgs e) { if (!Ext.IsAjaxRequest) { StoreLoad(); DeptStore.DataSource = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber); DeptStore.DataBind(); //获取三违预警设置 //hdnScore.SetValue(PublicCode.GetSWMaxScoreSet(SessionBox.GetUserSession().DeptNumber)); hdnScore.Value = PublicCode.GetSWMaxScoreSet(SessionBox.GetUserSession().DeptNumber).ToString(); hdnCount.Value = PublicCode.GetSWMaxCountSet(SessionBox.GetUserSession().DeptNumber).ToString(); } }
private void BaseBind() { var dept = from d in db.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptlevel == "正科级" orderby d.Deptname select new { d.Deptnumber, d.Deptname }; DeptStore.DataSource = dept; DeptStore.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Ext.IsAjaxRequest) { StoreLoad(); var dept = from d in dc.Department where d.Deptnumber.Substring(0, 4) == SessionBox.GetUserSession().DeptNumber.Substring(0, 4) && d.Deptlevel == "正科级" orderby d.Deptname select new { d.Deptnumber, d.Deptname }; DeptStore.DataSource = dept; DeptStore.DataBind(); } }
private void SearchLoad()//查询窗口初始化 { //初始化日期 df_begin.SelectedDate = System.DateTime.Today.AddDays(-2); df_end.SelectedDate = System.DateTime.Today; #region 初始化部门 var dep = from d in dc.Department from p in dc.Person where d.Deptnumber == p.Areadeptid && p.Maindeptid == SessionBox.GetUserSession().DeptNumber select new { DeptName = d.Deptname, DeptID = d.Deptnumber }; DeptStore.DataSource = dep; DeptStore.DataBind(); #endregion #region 初始化单位 if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1) { UnitStore.DataSource = PublicCode.GetMaindept(""); UnitStore.DataBind(); cbbUnit.Disabled = false; cbb_part.Disabled = true; } else { var dept = from d in dc.Department where d.Deptnumber == SessionBox.GetUserSession().DeptNumber select new { d.Deptname, d.Deptnumber }; UnitStore.DataSource = dept; UnitStore.DataBind(); cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber; cbbUnit.Disabled = true; } #endregion }
private void BaseSet() { var dept = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber); DeptStore.DataSource = dept; DeptStore.DataBind(); var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber orderby pl.Placename ascending select new { placID = pl.Placeid, placName = pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); }
public void PYsearch(string py, string store) { if (py.Trim() == "") { return; } switch (store.Trim()) { case "DeptStore": var dept = from d in dc.Department where (d.Deptnumber.Substring(0, 2) == "13" || d.Deptnumber.Substring(0, 4) == "2364") && //1303为集团公司处级,2364为设备管理中心 (d.Deptnumber.Substring(7) == "00" || d.Deptlevel == "正科级") && (d.Visualfield != 3 || d.Visualfield == null) && (dc.F_PINYIN(d.Deptname).ToLower().Contains(py.ToLower()) || d.Deptname.Contains(py.Trim())) select new { d.Deptnumber, d.Deptname }; DeptStore.DataSource = dept.Distinct(); DeptStore.DataBind(); break; case "personStore": var person = from pl in dc.Person where (pl.Areadeptid == hdnKindid.Value.ToString() || pl.Maindeptid == hdnKindid.Value.ToString()) && (pl.Visualfield != 3 || pl.Visualfield == null) && (dc.F_PINYIN(pl.Name).ToLower().Contains(py.ToLower()) || pl.Name.Contains(py.Trim())) select new { pl.Personnumber, pl.Name }; personStore.DataSource = person.Distinct(); personStore.DataBind(); break; } }
private void SearchLoad()//查询窗口初始化 { //初始化日期 df_begin.SelectedDate = System.DateTime.Today.AddDays(-15); df_end.SelectedDate = System.DateTime.Today; #region 初始化部门 DeptStore.DataSource = PublicCode.GetKQdept(SessionBox.GetUserSession().DeptNumber); DeptStore.DataBind(); #endregion #region 初始化单位 if (SessionBox.GetUserSession().rolelevel.Trim().IndexOf("1") > -1) { UnitStore.DataSource = PublicCode.GetMaindept(""); UnitStore.DataBind(); cbbUnit.Disabled = false; cbb_part.Disabled = true; } else { UnitStore.DataSource = PublicCode.GetMaindept(SessionBox.GetUserSession().DeptNumber); UnitStore.DataBind(); cbbUnit.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber; cbbUnit.Disabled = true; } #endregion //三违级别 var lavel = from c in dc.CsBaseinfoset where c.Fid == int.Parse(PublicMethod.ReadXmlReturnNode("SWJB", this)) select new { SWLevelID = c.Infoid, SWLevel = c.Infoname }; LevelStore.DataSource = lavel; LevelStore.DataBind(); }
private void BaseSet() { HBBLL hb = new HBBLL(); var data = hb.GetLeaderRole(SessionBox.GetUserSession().DeptNumber, 431); var q = from p in data select new { Personnumber = p.personnumber, Name = p.name }; perStore.DataSource = q; perStore.DataBind(); if (SessionBox.GetUserSession().Role.Contains("11,矿级管理员")) { //cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber; if (SessionBox.GetUserSession().Role.Contains("431,副总及以上领导")) { cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber; cbbPerson.Disabled = false; } else { cbbPerson.SelectedIndex = 0; } } else { cbbPerson.Items.Add(new Coolite.Ext.Web.ListItem(SessionBox.GetUserSession().Name, SessionBox.GetUserSession().PersonNumber)); cbbPerson.SelectedItem.Value = SessionBox.GetUserSession().PersonNumber; cbbPerson.Disabled = true; } df_begin.MinDate = System.DateTime.Today; df_begin.SelectedDate = df_begin.MinDate; //cx_date.SelectedDate = System.DateTime.Today; //var q = from p in dc.Person // where p.Personnumber==SessionBox.GetUserSession().PersonNumber // select new // { // p.Personnumber, // p.Name // }; //perStore.DataSource = q; //perStore.DataBind(); DeptStore.DataSource = PublicCode.GetMaindept(""); DeptStore.DataBind(); if (SessionBox.GetUserSession().rolelevel.Contains("1") || SessionBox.GetUserSession().rolelevel.Contains("0")) { cbbDept.Items.Insert(0, new Coolite.Ext.Web.ListItem("--全部--", "-1")); cbbDept.SelectedItem.Value = "-1"; cbbDept.Disabled = false; } else { cbbDept.SelectedItem.Value = SessionBox.GetUserSession().DeptNumber; cbbDept.Disabled = true; } //HBBLL hb = new HBBLL(); //var data2 = hb.GetYPPT(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber, "个人"); //var pt = from r in data2 // select new // { // Id = r.Id, // Name = r.Name, // Level = r.TLevel // }; //placeTemplateStore.DataSource = pt; //placeTemplateStore.DataBind(); //cboPlaceTemplate.Items.Insert(0, new Coolite.Ext.Web.ListItem("--不使用模板--", "-1")); cx_date.SelectedValue = DateTime.Today; }
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 }