public static void addNewRowForDataTable(DataTable dt, PollingStaYear psy)
{
char colLabel = 'M';
DataRow newRow = dt.NewRow();
newRow["id"] = psy.id;
newRow["year"] = psy.year;
newRow["mscid"] = psy.mscid;
newRow["fcid"] = 0;
newRow["haveData"] = 0;
if (psy is PollingStaDay)
{
psy = (PollingStaDay)psy;
colLabel = 'H';
newRow["month"] = ((PollingStaDay)psy).month;
newRow["day"] = ((PollingStaDay)psy).day;
newRow["occurtime"] = psy.year + "-" + ((PollingStaDay)psy).month + "-" + ((PollingStaDay)psy).day;
for (int i = 0; i <= 23; i++)
{
newRow[colLabel + "" + i] = psy.totalColumn[i];
newRow[colLabel + "n" + i] = psy.netColumn[i];
}
}
else if (psy is PollingStaMonth)
{
psy = (PollingStaMonth)psy;
colLabel = 'D';
newRow["month"] = ((PollingStaMonth)psy).month;
newRow["occurtime"] = psy.year + "-" + ((PollingStaMonth)psy).month + "-01";
for (int i = 1; i <= 31; i++)
{
newRow[colLabel + "" + i] = psy.totalColumn[i - 1];
newRow[colLabel + "n" + i] = psy.netColumn[i - 1];
}
}
else
{
newRow["occurtime"] = psy.year + "-01-01";
for (int i = 1; i <= 12; i++)
{
newRow[colLabel + "" + i] = psy.totalColumn[i - 1];
newRow[colLabel + "n" + i] = psy.netColumn[i - 1];
}
}
dt.Rows.Add(newRow);
}
private void createInitTable(List <string> mscList, DataTable insertDT)
{
DateTime startTimeCopy = startTime;
while (new DateTime(startTimeCopy.Year, 1, 1) < proceeTime)
{
for (int i = 0; i < mscList.Count; i++)
{
PollingStaYear psm = new PollingStaYear();
psm.id = 0;
psm.year = startTimeCopy.Year;
psm.mscid = int.Parse(mscList[i]);
CommonUtil.addNewRowForDataTable(insertDT, psm);
}
startTimeCopy = startTimeCopy.AddYears(1);
}
}
