/// <summary> /// 获取工厂行为报表 /// </summary> public static List<ClientsBaseEntity> GetClientsAgentActionReport(int type, string begintime, string endtime, string clientId) { List<ClientsBaseEntity> list = new List<ClientsBaseEntity>(); DataSet ds = ClientDAL.BaseProvider.GetClientsAgentActionReport(type, begintime, endtime,clientId); if ( ds.Tables.Count>0) { foreach (DataColumn dc in ds.Tables[0].Columns) { if (dc.ColumnName != "ReportDate") { List<ClientsItem> item = new List<ClientsItem>(); foreach (DataRow dr in ds.Tables[0].Rows) { ClientsItem model = new ClientsItem(); model.Name = dr["ReportDate"].ToString(); model.Value = int.Parse(dr[dc.ColumnName].ToString()); item.Add(model); } ClientsBaseEntity clientloginEntity = new ClientsBaseEntity { Name =GetCloumnName(dc.ColumnName), Items = item }; list.Add(clientloginEntity); } } } return list; }
/// <summary> /// 获取工厂登陆报表 /// </summary> public static List<ClientsBaseEntity> GetClientsLoginReport(int type, string begintime, string endtime) { List<ClientsBaseEntity> list = new List<ClientsBaseEntity>(); DataSet ds = ClientDAL.BaseProvider.GetClientsLoginReport(type, begintime, endtime); int k = 0; foreach (DataTable dt in ds.Tables) { List<ClientsItem> item = new List<ClientsItem>(); foreach (DataRow dr in dt.Rows) { ClientsItem model = new ClientsItem(); model.Name = dr["ReportDate"].ToString(); model.Value = int.Parse(dr["Num"].ToString()); item.Add(model); } if (item.Any()) { ClientsBaseEntity clientloginEntity = new ClientsBaseEntity { Name = (k == 0 ? "登录次数" : (k == 1 ? "登陆人数" : "登陆工厂数")), Items = item }; list.Add(clientloginEntity); } k++; } return list; }