Exemplo n.º 1
0
        /// <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;
            }
        }
Exemplo n.º 2
0
        private void PostLogOutput(JobRequest job)
        {
            string put = $"Close:\t{HttpUtility.UrlDecode(job.RequestDate)}\t{job.RequestNO}";

            CSPLogger.Output(put);
        }