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();
}
