/// <summary>
/// 獲取cell所在列的第一個cell的值,和列名進行match and fill JobRequestInfo的屬性值
/// </summary>
/// <param name="cell"></param>
/// <param name="job"></param>
private void FillJobRequestInfo(IXLCell cell, ref JobRequest job)
{
try
{
switch (cell.WorksheetColumn().FirstCell().GetValue <string>().Trim())
{
case "ContactPerson":
job.ContactPerson = cell.GetValue <string>();
break;
case "Location":
job.Location = cell.GetValue <string>();
break;
case "Company":
job.Company = cell.GetValue <string>();
break;
case "RequestType":
job.RequestType = cell.GetValue <string>();
break;
case "Symptom":
job.Symptom = cell.GetValue <string>();
break;
case "ScheduleTime":
job.ScheduleTime = cell.GetValue <string>();
break;
case "ServeTime1":
job.ServeTime1 = cell.GetValue <string>();
break;
case "ServeTime2":
job.ServeTime2 = cell.GetValue <string>();
break;
case "ServiceDescription":
job.ServiceDescription = cell.GetValue <string>();
break;
}
}
catch (Exception)
{
throw;
}
}
private void PostLogOutput(JobRequest job)
{
string put = $"Close:\t{HttpUtility.UrlDecode(job.RequestDate)}\t{job.RequestNO}";
CSPLogger.Output(put);
}