public static void addNewRowForDataTable(DataTable dt, PollingStaDay psd)
{
DataRow newRow = dt.NewRow();
newRow["id"] = psd.id;
newRow["year"] = psd.year;
newRow["month"] = psd.month;
newRow["day"] = psd.day;
newRow["mscid"] = psd.mscid;
newRow["occurtime"] = psd.year + "-" + psd.month + "-" + psd.day;
for (int i = 0; i < 24; i++)
{
newRow["t" + (i + 1)] = psd.totalColumn[i];
newRow["n" + (i + 1)] = psd.netColumn[i];
}
dt.Rows.Add(newRow);
}
private void createInitTable(List <string> mscList, DataTable insertDT)
{
DateTime startTimeCopy = startTime;
while (startTimeCopy < endTime)
{
for (int i = 0; i < mscList.Count; i++)
{
PollingStaDay psd = new PollingStaDay();
psd.id = 0;
psd.year = startTimeCopy.Year;
psd.month = startTimeCopy.Month;
psd.day = startTimeCopy.Day;
psd.mscid = int.Parse(mscList[i]);
CommonUtil.addNewRowForDataTable(insertDT, psd);
}
startTimeCopy = startTimeCopy.AddDays(1);
}
// LogUtil.log("finish creating InitTable, insertDT rows:" + insertDT.Rows.Count);
}
