private void InitVesselBerth(DataRow dr) { if (dr != null) { REPORT_DATE = DateTime.Parse(dr["REPORT_DATE"].ToString()); VSL_CNNAME = dr["VSL_CNNAME"].ToString(); if (!string.IsNullOrEmpty(dr["VBT_PBTHDT"].ToString())) { VBT_PBTHDT = DateTime.Parse(dr["VBT_PBTHDT"].ToString()); } else { VBT_PBTHDT = null; } if (!string.IsNullOrEmpty(dr["VBT_ABTHDT"].ToString())) { VBT_ABTHDT = DateTime.Parse(dr["VBT_ABTHDT"].ToString()); } else { VBT_ABTHDT = null; } VBT_STATUS = dr["VBT_STATUS"].ToString(); if (!string.IsNullOrEmpty(dr["VOT_AWKSTTM"].ToString())) { VOT_AWKSTTM = DateTime.Parse(dr["VOT_AWKSTTM"].ToString()); } else { VOT_AWKSTTM = null; } ISLATER = dr["ISLATER"].ToString(); MyDate = REPORT_DATE.ToString("yyyy-MM-dd"); } else { throw new Exception("Unable to init VesselBerth."); } }
private void InitVesselEfficiency(DataRow dr) { if (dr != null) { REPORT_DATE = DateTime.Parse(dr["REPORT_DATE"].ToString()); VSL_CNNAME = dr["VSL_CNNAME"].ToString(); QCOPTM = dr["QCOPTM"].ToString(); QCNETTM = dr["QCNETTM"].ToString(); AVGEFF = dr["AVGEFF"].ToString(); ABTHNO = dr["ABTHNO"].ToString(); MyDate = REPORT_DATE.ToString("yyyy-MM-dd"); } else { throw new Exception("Unable to init DailyReport."); } }
private void InitDailyReport(DataRow dr) { if (dr != null) { REPORT_DATE = DateTime.Parse(dr["REPORT_DATE"].ToString()); LASTALLDAY_PLAN = dr["LASTALLDAY_PLAN"].ToString(); LASTALLDAY_ACTUAL = dr["LASTALLDAY_ACTUAL"].ToString(); LASTALLDAY_BARGE = dr["LASTALLDAY_BARGE"].ToString(); LASTALLDAY_SHUTTLE = dr["LASTALLDAY_SHUTTLE"].ToString(); LASTALLDAY_COMPLETERATE = dr["round(LASTALLDAY_COMPLETERATE,5)"].ToString(); MONTHLY_PLAN = dr["MONTHLY_PLAN"].ToString(); MONTHLY_TARGET = dr["MONTHLY_TARGET"].ToString(); MONTHLY_ACTUAL = dr["MONTHLY_ACTUAL"].ToString(); MONTHLY_BARGE = dr["MONTHLY_BARGE"].ToString(); MONTHLY_SHUTTLE = dr["MONTHLY_SHUTTLE"].ToString(); MONTHLY_COMPLETERATE = dr["round(MONTHLY_COMPLETERATE,5)"].ToString(); MONTHLY_PLANCONTAINER = dr["round(MONTHLY_PLANCONTAINER,5)"].ToString(); ANNUAL_PLAN = dr["ANNUAL_PLAN"].ToString(); ANNUAL_ACTUAL = dr["ANNUAL_ACTUAL"].ToString(); ANNUAL_BARGE = dr["ANNUAL_BARGE"].ToString(); ANNUAL_SHUTTLE = dr["ANNUAL_SHUTTLE"].ToString(); ANNUAL_COMPLETERATE = dr["round(ANNUAL_COMPLETERATE,5)"].ToString(); ANNUAL_PLANCONTAINER = dr["round(ANNUAL_PLANCONTAINER,5)"].ToString(); if (!string.IsNullOrEmpty(LASTALLDAY_COMPLETERATE)) { MyLASTALLDAY_COMPLETERATE = double.Parse(LASTALLDAY_COMPLETERATE).ToString("0.##%"); } if (!string.IsNullOrEmpty(MONTHLY_COMPLETERATE)) { MyMONTHLY_COMPLETERATE = double.Parse(MONTHLY_COMPLETERATE).ToString("0.##%"); } if (!string.IsNullOrEmpty(ANNUAL_COMPLETERATE)) { MyANNUAL_COMPLETERATE = double.Parse(ANNUAL_COMPLETERATE).ToString("0.##%"); } MyDate = REPORT_DATE.ToString("yyyy-MM-dd"); } else { throw new Exception("Unable to init DailyReport."); } }