110,570
社区成员
发帖
与我相关
我的任务
分享
select dwmc,riqi,count(id) as num from cbs_jiaotong group by dwmc,riqi
DateTime start=DateTime.Now.AddMonths(-1);
DataRow []rows=null;
String []dwmcs=new String[]{"xx队","xxx队"};
while(start<DateTime.Now)
{
foreach(String mc in dwmcs)
{
rows=data.select("riqi='"+start.ToString("yyyy-MM-dd")+"' and dwmc='"+mc +"'");
if(rows!=null&&rows.Count>0)
{
rows[0]["num"]//这个就是单位mc对应的违规次数
.......
}
rows=null;
}
start.AddDays(1);
}
DateTime start=DateTime.Now.AddMonths(-1);
DataRow []rows=null;
while(start<DateTime.Now)
{
rows=data.select("日期='"+start.ToString("yyyy-MM-dd")+"'");
.....
进行图表赋值
.....
rows=null;
start.AddDays(1);
}