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