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