分组计算[根据日期][C#]

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);
            }