DataTable dtSource = SQLHelp.RunSQLReturnDT("SELECT ID, GAMENAME, CONVERT(char(10), RECORDDT, 120) AS RECORDDT, GAMECOUNT, GAMETIME_H FROM tb_PlatformBaseData where Recorddt>='" + Convert.ToDateTime(startdata).AddDays(lastDays).ToString() + "' and Recorddt<='" + Convert.ToDateTime(enddate).ToString() + "'");
DataTable dt = dtSource.Clone();
DataTable dtS = dtSource.DefaultView.ToTable(true, "RECORDDT");
for (int i = 0; i < dtS.Rows.Count; i++)
{
DataRow[] rows = dtSource.Select(string.Format("RECORDDT>='{0}' and RECORDDT<='{0}'", dtS.Rows[i][0]));
DataTable temp = dtSource.Clone();
foreach (DataRow row in rows)
{
temp.Rows.Add(row.ItemArray);
}
DataRow dr = dt.NewRow();
dr["RECORDDT"] = dtS.Rows[i][0].ToString();
dr["GAMECOUNT"] = temp.Compute("sum(GAMECOUNT)", "");
dr["GAMETIME_H"] = temp.Compute("sum(GAMETIME_H)", "");
dt.Rows.Add(dr);
}
DataTable dt = dtSource.Clone();
DataTable dtS = dtSource.DefaultView.ToTable(true, "RECORDDT");
for (int i = 0; i < dtS.Rows.Count; i++)
{
DataRow[] rows = dtSource.Select(string.Format("RECORDDT>='{0}' and RECORDDT<='{0}'", dtS.Rows[i][0]));
DataTable temp = dtSource.Clone();
foreach (DataRow row in rows)
{
temp.Rows.Add(row.ItemArray);
}
DataRow dr = dt.NewRow();
dr["RECORDDT"] = dtS.Rows[i][0].ToString();
dr["GAMECOUNT"] = temp.Compute("sum(GAMECOUNT)", "");
dr["GAMETIME_H"] = temp.Compute("sum(GAMETIME_H)", "");
dt.Rows.Add(dr);
}