public void PYsearch(string py, string store) { HBBLL hb = new HBBLL(); switch (store.Trim()) { //case "perStore": // var data = hb.GetLeaderRole(py, SessionBox.GetUserSession().DeptNumber, 431); // var q = from p in data // select new // { // Personnumber = p.personnumber, // Name = p.name // }; // perStore.DataSource = q; // perStore.DataBind(); // break; case "placeStore": var place = from pl in dc.Place where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber&& pl.Placestatus == 1 && (dc.F_PINYIN(pl.Placename) + pl.Placename).ToLower().Contains(py.ToLower()) select new { pl.Placeid, pl.Placename }; placeStore.DataSource = place; placeStore.DataBind(); break; } }
private void UpdateStatus() { RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count > 0) { HBBLL hb = new HBBLL(); YPPT data = hb.GetYPPTByID(int.Parse(sm.SelectedRows[0].RecordID)); if (data.CreatePersonNumber == SessionBox.GetUserSession().PersonNumber) { btnDel.Disabled = false; btnDetail.Disabled = false; btnPlan.Disabled = false; } else { btnPlan.Disabled = true; btnDetail.Disabled = false; btnDel.Disabled = true; } } else { btnPlan.Disabled = true; btnDetail.Disabled = true; btnDel.Disabled = true; } }
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; } }
protected void YHputinStore_RefershData(object sender, StoreRefreshDataEventArgs e) { int PageSize = this.pagecut.PageSize; //获取当前在页面中PagingToolBar 的PageSize的值 int Count = 0; int CurPage = e.Start / PageSize + 1; //获取当前的页码是多少,也就是第几页 HBBLL hb = new HBBLL(); //绑定隐患录入信息 var data2 = hb.GetYHInput2(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber, ref Count); var data = from yh in data2 orderby yh.INTime descending select new { YHPutinID = yh.YHPutinID, DeptName = yh.DeptName, PlaceName = yh.PlaceName, YHContent = yh.YHContent, Remarks = yh.Remarks, BanCi = yh.BanCi, Name = yh.Name, INTime = yh.INTime, PCTime = yh.PCTime, YHType = yh.TypeName, Status = yh.Status }; e.TotalCount = Count; if (e.TotalCount > 0) { this.YHputinStore.DataSource = data.Skip(e.Start <= 0 ? 0 : e.Start).Take(PageSize);//绑定数据 this.YHputinStore.DataBind(); } }
public void SuerDeleteT(string id) { HBBLL hb = new HBBLL(); hb.DeleteYPPT(int.Parse(id)); Ext.Msg.Alert("提示", "删除成功!").Show(); Ext.DoScript("#{placeTemplateStore}.reload();"); }
private void BindDownDetail(string mm, string personnumber) { HBBLL hb = new HBBLL(); var data = hb.GetDownDetail(mm, personnumber); DownDetailStore.DataSource = data; DownDetailStore.DataBind(); }
private void BindDBDetail(string mm, string personnumber, string banci) { HBBLL hb = new HBBLL(); var data = hb.GetDBDetail(mm, personnumber, banci); DBDetailStore.DataSource = data; DBDetailStore.DataBind(); }
protected void placeTemplateStore_RefershData(object sender, StoreRefreshDataEventArgs e) { HBBLL hb = new HBBLL(); var data2 = hb.GetYPPT(SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber); this.placeTemplateStore.DataSource = data2; this.placeTemplateStore.DataBind(); UpdateStatus(); }
public void PlaceDown() { RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count == 1) { HBBLL hb = new HBBLL(); int id = int.Parse(sm.SelectedRows[0].RecordID.Trim()); hb.MoveDown(id, hb.GetMoveOrderByID(id), int.Parse(TID.Value.ToString())); Ext.DoScript("#{YPPTDetailStore}.reload();"); } }
protected void YPPTDetailStore_RefershData(object sender, StoreRefreshDataEventArgs e) { if (TID.Value.ToString() != "") { HBBLL hb = new HBBLL(); var data2 = hb.GetYPPTDetail(int.Parse(TID.Value.ToString()), "", SessionBox.GetUserSession().DeptNumber, ""); this.YPPTDetailStore.DataSource = data2; this.YPPTDetailStore.DataBind(); UpdateStatus1(); } }
protected void YPPTDetailStore_RefershData(object sender, StoreRefreshDataEventArgs e) { if (cboPlaceTemplate.SelectedIndex > 0) { if (cboPlaceTemplate.SelectedItem.Value != "-1") { HBBLL hb = new HBBLL(); var data2 = hb.GetYPPTDetail(int.Parse(cboPlaceTemplate.SelectedItem.Value), "", SessionBox.GetUserSession().DeptNumber, ""); this.YPPTDetailStore.DataSource = data2; this.YPPTDetailStore.DataBind(); } } }
private void InitPost(string deptid) { HBBLL hb = new HBBLL(); var post = hb.GetVPPost(deptid); var data = from p in post select new { PosID = p.PosId, PosName = p.PosName }; PostStore.DataSource = data; PostStore.DataBind(); cboPost.Items.Insert(0, new Coolite.Ext.Web.ListItem("--全部--", "-1")); cboPost.SelectedItem.Value = "-1"; }
//[AjaxMethod] //public void PYsearch(string py, string store) //{ // // switch (store.Trim()) // { // case "perStore": // var q = from p in dc.Person // where p.Maindeptid == SessionBox.GetUserSession().DeptNumber // && (p.Pinyin + p.Name + p.Personnumber).ToLower().Contains(py.ToLower()) && p.Personstatus == 1 // select new // { // p.Personnumber, // p.Name // }; // perStore.DataSource = q; // perStore.DataBind(); // break; // case "placeStore": // var place = from pl in dc.Place // where pl.Maindeptid == SessionBox.GetUserSession().DeptNumber && pl.Placestatus == 1 // && (dc.F_PINYIN(pl.Placename) + pl.Placename).ToLower().Contains(py.ToLower()) // select new // { // pl.Placeid, // pl.Placename // }; // placeStore.DataSource = place; // placeStore.DataBind(); // break; // } //} #endregion protected void CitiesRefresh(object sender, StoreRefreshDataEventArgs e) { HBBLL hb = new HBBLL(); var data2 = hb.GetYPPT(cbbPerson.SelectedItem.Value, SessionBox.GetUserSession().DeptNumber); var pt = from r in data2 select new { Id = r.Id, Name = r.TLevel == "矿级" ? string.Format("{0}({1})", r.Name, r.TLevel) : r.Name, Level = r.TLevel }; placeTemplateStore.DataSource = pt; placeTemplateStore.DataBind(); //cboPlaceTemplate.Items.Insert(0, new Coolite.Ext.Web.ListItem("--不使用模板--", "-1")); }
public void PlaceDown() { RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count == 1) { RowSelectionModel sm1 = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; //DBSCMDataContext db = new DBSCMDataContext(); var pp = dc.YPlanplace.First(p => p.Ctid == Decimal.Parse(sm1.SelectedRecordID) && p.Id == decimal.Parse(sm.SelectedRows[0].RecordID)); HBBLL hb = new HBBLL(); hb.MoveDown2(pp.Id, pp.Moveorder.Value, pp.Ctid); PlanPlaceStoreLoad(Decimal.Parse(sm1.SelectedRecordID)); } }
public void PlaceAdd() { if (cbbplace.SelectedIndex == -1) { Ext.Msg.Alert("提示", "请选择地点!").Show(); return; } RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; var detail = dc.YPlanplace.Where(p => p.Ctid == Decimal.Parse(sm.SelectedRecordID)).OrderByDescending(p => p.Moveorder); decimal index = 1; if (detail.Count() > 0) { //foreach (var r in detail) //{ // index = r.Moveorder.Value + 1; // break; //} index = (from d in detail select d.Moveorder).Max().Value + 1; } YPlanplace pp = new YPlanplace { Recordtime = DateTime.Now, Placeid = decimal.Parse(cbbplace.SelectedItem.Value), Moveorder = index, Ctid = Decimal.Parse(sm.SelectedRecordID) }; //dc.YPlanplace.InsertOnSubmit(pp); try { HBBLL hb = new HBBLL(); hb.AddYPlanplace(pp.Recordtime, pp.Placeid, pp.Moveorder.Value, pp.Ctid); //dc.SubmitChanges(); } catch (Exception ex) { Ext.Msg.Alert("错误", ex.Message).Show(); return; } RecordAction(Decimal.Parse(sm.SelectedRecordID), "添加地点"); cbbplace.Value = null; Ext.Msg.Alert("提示", "添加成功!").Show(); PlanPlaceStoreLoad(Decimal.Parse(sm.SelectedRecordID)); }
public void SuerDelete() { RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count > 0) { List <int> ids = new List <int>(); foreach (var item in sm.SelectedRows) { ids.Add(Convert.ToInt32(item.RecordID)); } HBBLL hb = new HBBLL(); hb.DeleteYPPTDetail(ids); hb.UpdateYPPTDetailOrder(int.Parse(TID.Value.ToString())); Ext.Msg.Alert("提示", "删除成功!").Show(); Ext.DoScript("#{YPPTDetailStore}.reload();"); } }
private void storeload() { string person = ""; if (txtName.Text.Trim() != "") { string[] ss = System.Text.RegularExpressions.Regex.Split(txtName.Text.Trim(), "\\s+|[,,]"); foreach (var s in ss) { person = string.Format("'{0}',", s); } person = person.Substring(0, person.Length - 1); } HBBLL hb = new HBBLL(); var vp = hb.GetVP(cbbDept.SelectedItem.Value, cboPost.SelectedItem.Value, person); var minetotal = hb.GetMineTotal(person, string.Format("{0}-{1}", cboYear.SelectedItem.Value, cboMonth.SelectedItem.Value.PadLeft(2, '0'))); var daibantotal = hb.GetDaiBanTotal(person, string.Format("{0}-{1}", cboYear.SelectedItem.Value, cboMonth.SelectedItem.Value.PadLeft(2, '0'))); var data = from v in vp join m in minetotal on v.PersonNumber equals m.PersonId into x from v_m in x.DefaultIfEmpty() join d in daibantotal on v.PersonNumber equals d.PersonNumber into y from v_d in y.DefaultIfEmpty() select new LeaderDownMine { MainDeptNumber = v.DeptNumber, MainDeptName = v.DeptName, PersonNumber = v.PersonNumber, PersonName = v.Name, PostID = v.PosId, PostName = v.PosName, DownMineTotal = v_m == null?0:v_m.Count.Value, DaiBanZao = v_d == null?0:v_d.Zao.Value, DaiBanZhong = v_d == null?0:v_d.Zhong.Value, DaiBanYe = v_d == null?0:v_d.Ye.Value, DaiBanTotal = (v_d == null ? 0 : v_d.Zao.Value) + (v_d == null ? 0 : v_d.Zhong.Value) + (v_d == null ? 0 : v_d.Ye.Value), About = "" }; ldm = data.ToList <LeaderDownMine>(); Store1.DataSource = data; Store1.DataBind(); }
public void SaveTName() { if (txtTName.Text.Trim() != "") { HBBLL hb = new HBBLL(); if (TID.Value.ToString() == "") { hb.AddYPPT(txtTName.Text.Trim(), rKuangJi.Checked == true?rKuangJi.BoxLabel:rGeRen.BoxLabel, SessionBox.GetUserSession().PersonNumber, SessionBox.GetUserSession().DeptNumber); Ext.Msg.Alert("提示", "新增成功!").Show(); Ext.DoScript("#{placeTemplateStore}.reload();"); } else { hb.UpdateYPPT(txtTName.Text.Trim(), int.Parse(TID.Value.ToString())); Ext.Msg.Alert("提示", "修改成功!").Show(); Ext.DoScript("#{placeTemplateStore}.reload();"); } } }
private void UpdateStatus1() { RowSelectionModel sm = this.GridPanel2.SelectionModel.Primary as RowSelectionModel; HBBLL hb = new HBBLL(); var data = hb.GetYPPTByID(int.Parse(TID.Value.ToString())); if (data.CreatePersonNumber == SessionBox.GetUserSession().PersonNumber) { switch (sm.SelectedRows.Count) { case 0: btnPlaceUpdate.Disabled = true; btnPlaceDel.Disabled = true; btnDown.Disabled = true; btnUp.Disabled = true; break; case 1: btnPlaceUpdate.Disabled = false; btnPlaceDel.Disabled = false; btnDown.Disabled = false; btnUp.Disabled = false; break; default: btnPlaceUpdate.Disabled = true; btnPlaceDel.Disabled = false; btnDown.Disabled = true; btnUp.Disabled = true; break; } } else { btnPlaceAdd.Disabled = true; btnPlaceUpdate.Disabled = true; btnPlaceDel.Disabled = true; btnDown.Disabled = true; btnUp.Disabled = true; } }
public void RouteMan() { RowSelectionModel sm = this.GridPanel1.SelectionModel.Primary as RowSelectionModel; if (sm.SelectedRows.Count > 0) { HBBLL hb = new HBBLL(); TID.SetValue(sm.SelectedRows[0].RecordID.Trim()); TID.Value = sm.SelectedRows[0].RecordID.Trim(); TID.Text = sm.SelectedRows[0].RecordID.Trim(); string id = TID.Value.ToString(); id = TID.Text; lblDetail.Text = hb.GetYPPTNameByID(int.Parse(id)); DetailWindow.Show(); UpdateStatus1(); Ext.DoScript("#{YPPTDetailStore}.reload();"); } else { Ext.Msg.Alert("提示", "请选择一个模板!").Show(); } }
public void ExportXls() { HBBLL hb = new HBBLL(); DataTable dt = Util.LinqQueryToDataTable <LeaderDownMine>(ldm); dt.TableName = "tt"; var s = Aspose.Cells.CellsHelper.GetVersion(); WorkbookDesigner designer = new WorkbookDesigner(); designer.Open(MapPath("tt.xls")); //数据源 designer.SetDataSource(dt); //报表标题 designer.SetDataSource("Title", string.Format("{0}副总以上领导下井人员情况汇总表", cbbDept.SelectedItem.Value == "-1"?"各矿":cbbDept.SelectedItem.Text)); designer.SetDataSource("DownDate", string.Format("{0}年{1}月)", cboYear.SelectedItem.Value, cboMonth.SelectedItem.Value.PadLeft(2, '0'))); designer.Process(); designer.Save(string.Format("各矿副总以上领导下井人员情况汇总表{0}.xls", DateTime.Now.ToString("yyyyMMddHHmmssffff")), SaveType.OpenInExcel, FileFormatType.Excel97To2003, Response); Response.Flush(); Response.Close(); designer = null; Response.End(); }
public void BaseSave() { if (cbbplace.SelectedIndex == -1) { Ext.Msg.Alert("提示", "请选择地点!").Show(); return; } if (TDID.Value.ToString() == "") { HBBLL hb = new HBBLL(); hb.AddYPPTDetail(int.Parse(TID.Value.ToString()), int.Parse(cbbplace.SelectedItem.Value), hb.GetMaxMoveOrder(int.Parse(TID.Value.ToString())) + 1); cbbplace.Value = null; Ext.Msg.Alert("提示", "新增成功!").Show(); Ext.DoScript("#{YPPTDetailStore}.reload();"); } else { HBBLL hb = new HBBLL(); hb.UpdateYPPTDetail(int.Parse(cbbplace.SelectedItem.Value), int.Parse(TDID.Value.ToString())); cbbplace.Value = null; Ext.Msg.Alert("提示", "修改成功!").Show(); Ext.DoScript("#{YPPTDetailStore}.reload();"); } }
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; }
public string BaseSave() { if (df_begin.SelectedValue == null || cbbBc.SelectedIndex == -1 || cbbPerson.SelectedIndex == -1) { //Ext.Msg.Alert("提示", "请填写完整信息!").Show(); return("请填写完整信息!"); } if (df_begin.SelectedDate < System.DateTime.Today) { //Ext.Msg.Alert("提示", "只能制定本日及以后的计划!").Show(); return("只能制定本日及以后的计划!"); } if (dc.YChargetable.Where(p => p.Cdate == df_begin.SelectedDate && p.Cbanci == cbbBc.SelectedItem.Value && p.Cperson == cbbPerson.SelectedItem.Value).Count() > 0) { //Ext.Msg.Alert("提示", "已添加的计划!").Show(); return("已添加的计划!"); } if (cboPlaceTemplate.SelectedIndex <= -1) { YChargetable ct = new YChargetable { Recordtime = System.DateTime.Now, Rperson = SessionBox.GetUserSession().PersonNumber, Cdate = df_begin.SelectedDate, Cbanci = cbbBc.SelectedItem.Value, Cperson = cbbPerson.SelectedItem.Value, Maindept = SessionBox.GetUserSession().DeptNumber, Status = 1 }; dc.YChargetable.InsertOnSubmit(ct); dc.SubmitChanges(); //RecordAction(ct.Id, "新增"); //Ext.Msg.Alert("提示", "新增成功!").Show(); Ext.DoScript("#{Store1}.reload();"); return("新增成功!"); } else if (cboPlaceTemplate.SelectedItem.Value != "-1") { HBBLL hb = new HBBLL(); if (hb.HaveMoveTemplate(int.Parse(cboPlaceTemplate.SelectedItem.Value)) > 0) { DateTime dt = System.DateTime.Now; YChargetable ct = new YChargetable { Recordtime = dt, Rperson = SessionBox.GetUserSession().PersonNumber, Cdate = df_begin.SelectedDate, Cbanci = cbbBc.SelectedItem.Value, Cperson = cbbPerson.SelectedItem.Value, Maindept = SessionBox.GetUserSession().DeptNumber, Status = 1 }; dc.YChargetable.InsertOnSubmit(ct); dc.SubmitChanges(); foreach (YPPTDetail pt in hb.GetYPPTDetail(int.Parse(cboPlaceTemplate.SelectedItem.Value), "", SessionBox.GetUserSession().DeptNumber, "")) { YPlanplace pp = new YPlanplace { Ctid = ct.Id, Recordtime = dt, Placeid = decimal.Parse(pt.PlaceId.ToString()), Moveorder = decimal.Parse(pt.MoveOrder.ToString()) }; hb.AddYPlanplace(pp.Recordtime, pp.Placeid, pp.Moveorder.Value, pp.Ctid); //dc.YPlanplace.InsertOnSubmit(pp); //dc.SubmitChanges(); } //RecordAction(ct.Id, "新增"); //RecordAction(ct.Id, "添加地点"); //Ext.Msg.Alert("提示", "新增成功!").Show(); //storeload(); Ext.DoScript("#{Store1}.reload();"); return("新增成功!"); } else { //Ext.Msg.Alert("提示", "请确保模板里有走动线路!").Show(); return("请确保模板里有走动线路!"); } } else { //Ext.Msg.Alert("提示", "未知错误!").Show(); return("未知错误!"); } }