private void Bind(string deptnm, string psn) { DataSet ds = GetKaoHeInfo.GetPersonSWPoint(deteedit.Date, ASPxDateEdit1.Date, deptnm, psn); ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); }
private void Bind(string deptnm, string kequ) { DataSet ds = GetKaoHeInfo.GetDeptYHFine(deteedit.Date, ASPxDateEdit1.Date, deptnm, kequ); ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); }
private void Bind(string deptnm) { DataSet ds = GetKaoHeInfo.GetAllPerSWCount(deteedit.Date, ASPxDateEdit1.Date, deptnm); ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); }
private void Bind(string maindept, string deptnm, string psn) { DataSet ds = GetKaoHeInfo.GetUserOptTotal(dateBegin.Date, dateEnd.Date, maindept, deptnm, psn); gvUserOptTotal.DataSource = ds; gvUserOptTotal.DataBind(); }
public static int getYujingSW(string deptnumber)//三违预警 { //DataSet ds = GetKaoHeInfo.GetPersonSWPoint(DateTime.Parse(System.DateTime.Today.Year + "-01-01"), DateTime.Parse(System.DateTime.Today.Year + "-12-31"), deptnumber, ""); //System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]); //string filter = "三违总数>=" + PublicCode.GetSWMaxCountSet(deptnumber) + " or TOTAL>="+PublicCode.GetSWMaxScoreSet(deptnumber); //dv.RowFilter = filter; //ds.Tables.Clear(); //ds.Tables.Add(dv.ToTable()); //return ds.Tables[0].Rows.Count; DateTime today = DateTime.Today; DateTime dateTime = DateTime.Parse(string.Concat(today.Year, "-01-01")); today = DateTime.Today; DataSet personSWPoint = GetKaoHeInfo.GetPersonSWPoint(dateTime, DateTime.Parse(string.Concat(today.Year, "-12-31")), deptnumber, ""); DataView dataViews = new DataView(personSWPoint.Tables[0]); object[] sWMaxCountSet = new object[] { "三违总数>=", PublicCode.GetSWMaxCountSet(deptnumber), " or TOTAL>=", PublicCode.GetSWMaxScoreSet(deptnumber) }; dataViews.RowFilter = string.Concat(sWMaxCountSet); personSWPoint.Tables.Clear(); personSWPoint.Tables.Add(dataViews.ToTable()); return(personSWPoint.Tables[0].Rows.Count); //DBSCMDataContext dc = new DBSCMDataContext(); //var data = (from sw in dc.Nswinput // from per in dc.Person // from dep in dc.Department // from sb in dc.Swbase // from s in dc.Swscore // where sw.Swpersonid == per.Personnumber && per.Areadeptid == dep.Deptnumber && sw.Swid == sb.Swid && sb.Levelid == s.Levelid // && sw.Pctime >= DateTime.Parse(System.DateTime.Today.Year + "-01-01") && sw.Pctime <= DateTime.Parse(System.DateTime.Today.Year + "-12-31") // && sw.Maindeptid == deptnumber && sw.Isend == 1 // select new // { // per.Personnumber, // per.Name, // dep.Deptnumber, // dep.Deptname, // s.Kcscore // }).ToList(); //var group = from p in data // group p by new // { // p.Deptname, // p.Name // } // into g // select new // { // g.Key.Deptname, // g.Key.Name, // Score = g.Sum(p => p.Kcscore), // Count = g.Count() // }; //return group.Count(p => p.Score >= 12 || p.Count >= 2); }
private void Bind(string unitnm, string deptname) { //string sql = "select * from GETALLYHSWCOUNTBYPER where unitid='" + SessionBox.GetUserSession().DeptNumber + "'"; //DataSet ds = OracleHelper.Query(sql); DataSet ds = GetKaoHeInfo.getallyhswcountbyper(deteedit.Date, ASPxDateEdit1.Date, unitnm); if (deptname != "") { System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]); //dv.RowFilter = "DEPTNUMBER='" + deptnm + "'"; dv.RowFilter = "DEPTNAME='" + deptname + "'"; ds.Tables.Clear(); ds.Tables.Add(dv.ToTable()); } ASPxGridView1.DataSource = ds; ASPxGridView1.DataBind(); }
private void StoreLoad() { //var data = from sw in dc.Nswinput // from per in dc.Person // from dep in dc.Department // from sb in dc.Swbase // from s in dc.Swscore // where sw.Swpersonid == per.Personnumber && per.Areadeptid == dep.Deptnumber && sw.Swid == sb.Swid && sb.Levelid == s.Levelid // && sw.Pctime >= DateTime.Parse(System.DateTime.Today.Year + "-01-01") && sw.Pctime <= DateTime.Parse(System.DateTime.Today.Year + "-12-31") // && sw.Maindeptid == SessionBox.GetUserSession().DeptNumber && sw.Isend==1 // select new // { // per.Personnumber, // per.Name, // dep.Deptnumber, // dep.Deptname, // s.Kcscore // }; //if (cbbforcheckDept.SelectedIndex > -1) //{ // data = data.Where(p => p.Deptnumber == cbbforcheckDept.SelectedItem.Value); //} //if (fb_zrr.SelectedIndex > -1) //{ // data = data.Where(p => p.Personnumber == fb_zrr.SelectedItem.Value); //} //var group = from p in data // group p by new // { // p.Deptname, // p.Name // } // into g // select new // { // g.Key.Deptname, // g.Key.Name, // Score = g.Sum(p => p.Kcscore), // Count = g.Count() // }; //SWStore.DataSource = group.Where(p => p.Score > 11 || p.Count > 1); //SWStore.DataBind(); DataSet ds = GetKaoHeInfo.GetPersonSWPoint(DateTime.Parse(System.DateTime.Today.Year + "-01-01"), DateTime.Parse(System.DateTime.Today.Year + "-12-31"), SessionBox.GetUserSession().DeptNumber, ""); System.Data.DataView dv = new System.Data.DataView(ds.Tables[0]); string filter = ""; if (cbbforcheckDept.SelectedIndex > -1) { filter += "DEPTNUMBER='" + cbbforcheckDept.SelectedItem.Value + "'"; } if (fb_zrr.SelectedItem.Value != "") { if (filter != "") { filter += " and "; } filter += "PERSONNUMBER='" + fb_zrr.SelectedItem.Value + "'"; } dv.RowFilter = filter; ds.Tables.Clear(); ds.Tables.Add(dv.ToTable()); SWStore.DataSource = ds; SWStore.DataBind(); }