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