public ActionResult GetLableStatistics() { var data = basebll.GetPageList(""); DistrictBLL districtbll = new DistrictBLL(); List <DistrictEntity> AreaList = districtbll.GetListByOrgIdAndParentId("", "0"); List <KbsEntity> klist = new List <KbsEntity>(); int Znum = 0; foreach (var item in AreaList) { KbsEntity kbs = new KbsEntity(); kbs.Name = item.DistrictName; kbs.Num = data.Where(a => a.AreaCode.Contains(item.DistrictCode)).Count(); Znum += kbs.Num; kbs.Num2 = kbs.Num; klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; Proportion = Proportion * 100; } klist[j].Proportion = Proportion.ToString("0") + "%"; } return(Content(klist.ToJson())); }
public ActionResult GetLableStatistics() { var dt = lablemanagebll.GetLableStatistics(); List <LablemanageEntity> lblist = lablemanagebll.GetList("").Where(it => it.IsBind == 1).ToList();; DataItemBLL di = new DataItemBLL(); //先获取到字典项 DataItemEntity DataItems = di.GetEntityByCode("LabelType"); DataItemDetailBLL did = new DataItemDetailBLL(); //根据字典项获取值 List <DataItemDetailEntity> didList = did.GetList(DataItems.ItemId).ToList(); List <KbsEntity> klist = new List <KbsEntity>(); int Znum = 0; foreach (var item in didList) { KbsEntity kbs = new KbsEntity(); kbs.Name = item.ItemName; int num = 0; int zxnum = 0; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["labletypeid"].ToString() == item.ItemValue) { num = Convert.ToInt32(dt.Rows[i]["cou"]); zxnum = lblist.Where(it => it.LableTypeId == item.ItemValue && it.State == "在线").Count(); break; } } kbs.Num = num; Znum += num; kbs.Num2 = zxnum; klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; Proportion = Proportion * 100; } klist[j].Proportion = Proportion.ToString("0") + "%"; } return(Content(klist.ToJson())); }
public ActionResult GetUserOnlineGroupJson() { string sql = string.Format("select t.labletypename,t.labletypeid,count(1)as num from bis_lableonlinelog d join bis_lablemanage t on d.lableid=t.lableid where d.isout=0 and t.type=0 and t.state='在线' group by t.labletypename,t.labletypeid "); var dt = Opertickebll.GetDataTable(sql); DataItemBLL di = new DataItemBLL(); //先获取到字典项 DataItemEntity DataItems = di.GetEntityByCode("LabelType"); DataItemDetailBLL did = new DataItemDetailBLL(); //根据字典项获取值 List <DataItemDetailEntity> didList = did.GetList(DataItems.ItemId).Where(a => a.ItemName != "厂外车辆" && a.ItemName != "厂内车辆").ToList(); List <KbsEntity> klist = new List <KbsEntity>(); int Znum = 0; foreach (var item in didList) { KbsEntity kbs = new KbsEntity(); kbs.Name = item.ItemName; int num = 0; for (int i = 0; i < dt.Rows.Count; i++) { if (dt.Rows[i]["labletypeid"].ToString() == item.ItemValue) { num = Convert.ToInt32(dt.Rows[i]["num"]); break; } } kbs.Num = num; Znum += num; klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; Proportion = Proportion * 100; } klist[j].Num2 = Znum; klist[j].Proportion = Proportion.ToString("0.00") + "%"; } return(Content(klist.ToJson())); }
/// <summary> /// 作业实时分布统计图 /// </summary> /// <returns></returns> public ActionResult GetWorkRealTimeDistribution() { string sql = string.Format(@"select tasktype,count(1) as num from bis_safeworkcontrol d where ( (Actualstarttime<=to_date('{0}','yyyy-mm-dd hh24:mi:ss') and ActualEndTime >=to_date('{0}','yyyy-mm-dd hh24:mi:ss') )or( Actualstarttime<=to_date('{0}','yyyy-mm-dd hh24:mi:ss') and ActualEndTime is null)) and state=1 group by d.tasktype", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); DataTable dt = Opertickebll.GetDataTable(sql); DataItemDetailBLL pdata = new DataItemDetailBLL(); var list = pdata.GetDataItemListByItemCode("SafeWorkType"); List <KbsEntity> klist = new List <KbsEntity>(); int Znum = 0; foreach (var item in list) { KbsEntity kbs = new KbsEntity(); kbs.Name = item.ItemName; int num = 0; for (int i = 0; i < dt.Rows.Count; i++) { if (item.ItemValue == dt.Rows[i][0].ToString()) { num = Convert.ToInt32(dt.Rows[i]["num"]); break; } } kbs.Num = num; Znum += num; klist.Add(kbs); } for (int j = 0; j < klist.Count; j++) { double Proportion = 0; if (Znum != 0) { Proportion = (double)klist[j].Num / Znum; Proportion = Proportion * 100; } klist[j].Proportion = Proportion.ToString("0.00") + "%"; } dt.Dispose(); return(Content(klist.ToJson())); }