8,736
社区成员
发帖
与我相关
我的任务
分享
//获得项目每天产出人天
[WebMethod]
public List<ProjectRenTian> GetProjectRenTian()
{
List<ProjectRenTian> reProjectRenTian = new List<ProjectRenTian>();
OleDbCommand com = new OleDbCommand();
//SQLExcute("Select 项目名称,完成时间,sum(折合人天) from BaseData group by 项目名称,完成时间 order by 项目名称,完成时间", com);
SQLExcute("Select 完成时间,sum(折合人天) from BaseData1 group by 完成时间 order by 完成时间", com);
OleDbDataAdapter ProRenTianAdp = new OleDbDataAdapter();
ProRenTianAdp.SelectCommand = com;
DataSet ds = new DataSet();
ProRenTianAdp.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
ProjectRenTian rt = new ProjectRenTian();
//rt.ProjectName = dr[0].ToString();
rt.Date1 = dr[0].ToString().Replace(" 0:00:00","");
rt.RenTian = Convert.ToInt32(dr[1]);
reProjectRenTian.Add(rt);
}
return reProjectRenTian;
}