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