private static void UpdateVMS_daily_por(BasicDBServer svr) { var tbl = HydrometInfoUtility.DailyInventory; svr.RunSqlCommand("truncate table vms_daily_por"); DataTable vms_daily_por = svr.Table("vms_daily_por"); for (int i = 0; i < tbl.Rows.Count; i++) { var cbtt = tbl.Rows[i]["cbtt"].ToString().ToLower(); if (cbtt.Trim() == "") { continue; } var pcode = tbl.Rows[i]["pcode"].ToString().ToLower(); var por = HydrometInfoUtility.ArchivePeriodOfRecord(cbtt, pcode); vms_daily_por.Rows.Add(cbtt, pcode, por.T1, por.T2); Console.WriteLine(cbtt + " " + pcode); } svr.SaveTable(vms_daily_por); }