62,074
社区成员
发帖
与我相关
我的任务
分享
DataTable dt1 = ds.Tables[0];
DataTable dt = new DataTable();
DataColumn dc = null;
dc = dt.Columns.Add("ID", Type.GetType("System.Int32"));
dc.AutoIncrement = true;
dc.AutoIncrementSeed = 1;
dc.AutoIncrementStep = 1;
dc.AllowDBNull = false;
DataRow newRow;
dc = dt.Columns.Add("EggDate", Type.GetType("System.DateTime"));
dc = dt.Columns.Add("EggZC", Type.GetType("System.Int32"));
dc = dt.Columns.Add("SumEggZC", Type.GetType("System.Int32"));
dc = dt.Columns.Add("EggTotalCount", Type.GetType("System.Int32"));
dc = dt.Columns.Add("SumEggTotalCount", Type.GetType("System.Int32"));
foreach (DataRow row in ds.Tables[0].Rows)
{
DateValue.Add(row["EggDate"]);
}
for (int j = 0; j < XDateValue.Count; j++)
{
newRow = dt.NewRow();
dt.Rows.Add(newRow);
dt.Rows[j]["EggDate"] = date_From;
dt.Rows[j]["EggZC"] = 0;
dt.Rows[j]["SumEggZC"] = 0;
dt.Rows[j]["EggTotalCount"] = 0;
dt.Rows[j]["SumEggTotalCount"] = 0;
for (int h = 0; h < DateValue.Count; h++)
{
if (date_From == Convert.ToDateTime(DateValue[h]))
{
dt.Rows[j]["EggZC"] = Convert.ToInt32(dt1.Rows[h]["EggZC"]);
dt.Rows[j]["EggTotalCount"] = Convert.ToInt32(dt1.Rows[h]["EggTotalCount"]);
if (j == 0)
{
dt.Rows[j]["SumEggZC"] = Convert.ToInt32(dt1.Rows[j]["EggZC"]);
dt.Rows[j]["SumEggTotalCount"] = Convert.ToInt32(dt1.Rows[j]["EggTotalCount"]);
}
else if (j == 1)
{
dt.Rows[j]["SumEggZC"] = Convert.ToInt32(dt1.Rows[j - 1]["SumEggZC"]) + Convert.ToInt32(dt1.Rows[j]["EggZC"]);
dt.Rows[j]["SumEggTotalCount"] = Convert.ToInt32(dt1.Rows[j - 1]["SumEggTotalCount"]) + Convert.ToInt32(dt1.Rows[j]["EggTotalCount"]);
}
else
{
dt.Rows[j]["SumEggZC"] = Convert.ToInt32(dt1.Rows[j - 1]["SumEggZC"]) + Convert.ToInt32(dt1.Rows[j]["EggZC"]);
dt.Rows[j]["SumEggTotalCount"] = Convert.ToInt32(dt1.Rows[j - 1]["SumEggTotalCount"]) + Convert.ToInt32(dt1.Rows[j]["EggTotalCount"]);
}
}
}
date_From = date_From.AddDays(1);