public static void SetViewCustomerServiceData(ViewCustomerService item, CustomerService_TimeShiXiao myTimeItem)
        {
            if (myTimeItem == null || item == null)
            {
                return;
            }
            item.XiaDanDate            = myTimeItem.XiaDanDate;
            item.XiaDanTakeHour        = myTimeItem.XiaDanTakeHour;
            item.XiaDanTimeOutStatus   = myTimeItem.XiaDanTimeOutStatus;
            item.XiaDanChaoShiTakeHour = myTimeItem.XiaDanChaoShiTakeHour;

            item.PaiDanDate            = myTimeItem.PaiDanDate;
            item.PaiDanTakeHour        = myTimeItem.PaiDanTakeHour;
            item.PaiDanTimeOutStatus   = myTimeItem.PaiDanTimeOutStatus;
            item.PaiDanChaoShiTakeHour = myTimeItem.PaiDanChaoShiTakeHour;

            item.ResponseTime            = myTimeItem.ResponseTime;
            item.ResponseTakeHour        = myTimeItem.ResponseTakeHour;
            item.ResponseTimeOutStatus   = myTimeItem.ResponseTimeOutStatus;
            item.ResponseChaoShiTakeHour = myTimeItem.ResponseChaoShiTakeHour;

            item.ResponseTime            = myTimeItem.ResponseTime;
            item.ResponseTakeHour        = myTimeItem.ResponseTakeHour;
            item.ResponseTimeOutStatus   = myTimeItem.ResponseTimeOutStatus;
            item.ResponseChaoShiTakeHour = myTimeItem.ResponseChaoShiTakeHour;

            item.CheckTime            = myTimeItem.CheckTime;
            item.CheckTakeHour        = myTimeItem.CheckTakeHour;
            item.CheckTimeOutStatus   = myTimeItem.CheckTimeOutStatus;
            item.CheckChaoShiTakeHour = myTimeItem.CheckChaoShiTakeHour;

            item.ChuliDate              = myTimeItem.ChuliDate;
            item.ProcessTakeHour        = myTimeItem.ProcessTakeHour;
            item.ProcessTimeOutStatus   = myTimeItem.ProcessTimeOutStatus;
            item.ProcessChaoShiTakeHour = myTimeItem.ProcessChaoShiTakeHour;

            //item.BanJieTime = myTimeItem.BanJieTime;
            item.BanJieTakeHour        = myTimeItem.BanJieTakeHour;
            item.BanJieTimeOutStatus   = myTimeItem.BanJieTimeOutStatus;
            item.BanJieChaoShiTakeHour = myTimeItem.BanJieChaoShiTakeHour;

            //item.CloseTime = myTimeItem.CloseTime;
            item.CloseTakeHour        = myTimeItem.CloseTakeHour;
            item.CloseTimeOutStatus   = myTimeItem.CloseTimeOutStatus;
            item.CloseChaoShiTakeHour = myTimeItem.CloseChaoShiTakeHour;
        }
        public static void SetTimeShiXiaoData(ViewCustomerService item, CustomerService_TimeShiXiao myTimeItem, List <string> sqlList)
        {
            string cmdtext = string.Empty;

            if (item == null)
            {
                return;
            }
            if (item.ServiceStatus != 1 || !item.IsClosed)
            {
                if (myTimeItem != null)
                {
                    cmdtext = $"delete from [CustomerService_TimeShiXiao] where ServiceID={item.ID};";
                }
            }
            else if (myTimeItem == null)
            {
                cmdtext = $@"insert into [CustomerService_TimeShiXiao] ([ServiceID]
           ,[XiaDanDate]
           ,[XiaDanTakeHour]
           ,[XiaDanTimeOutStatus]
           ,[XiaDanChaoShiTakeHour]
           ,[PaiDanDate]
           ,[PaiDanTakeHour]
           ,[PaiDanTimeOutStatus]
           ,[PaiDanChaoShiTakeHour]
           ,[ResponseTime]
           ,[ResponseTakeHour]
           ,[ResponseTimeOutStatus]
           ,[ResponseChaoShiTakeHour]
           ,[CheckTime]
           ,[CheckTakeHour]
           ,[CheckTimeOutStatus]
           ,[CheckChaoShiTakeHour]
           ,[ChuliDate]
           ,[ProcessTakeHour]
           ,[ProcessTimeOutStatus]
           ,[ProcessChaoShiTakeHour]
           ,[BanJieTime]
           ,[BanJieTakeHour]
           ,[BanJieTimeOutStatus]
           ,[BanJieChaoShiTakeHour]
           ,[CloseTime]
           ,[CloseTakeHour]
           ,[CloseTimeOutStatus]
           ,[CloseChaoShiTakeHour]) values({item.ID}
            ,{GetDateTimeStr(item.XiaDanDate)}
           ,{item.XiaDanTakeHour}
           ,{item.XiaDanTimeOutStatus}
           ,{item.XiaDanChaoShiTakeHour}
           ,{GetDateTimeStr(item.PaiDanDate)}
           ,{item.PaiDanTakeHour}
           ,{item.PaiDanTimeOutStatus}
           ,{item.PaiDanChaoShiTakeHour}
           ,{GetDateTimeStr(item.ResponseTime)}
           ,{item.ResponseTakeHour}
           ,{item.ResponseTimeOutStatus}
           ,{item.ResponseChaoShiTakeHour}
           ,{GetDateTimeStr(item.CheckTime)}
           ,{item.CheckTakeHour}
           ,{item.CheckTimeOutStatus}
           ,{item.CheckChaoShiTakeHour}
           ,{GetDateTimeStr(item.ChuliDate)}
           ,{item.ProcessTakeHour}
           ,{item.ProcessTimeOutStatus}
           ,{item.ProcessChaoShiTakeHour}
           ,{GetDateTimeStr(item.BanJieTime)}
           ,{item.BanJieTakeHour}
           ,{item.BanJieTimeOutStatus}
           ,{item.BanJieChaoShiTakeHour}
           ,{GetDateTimeStr(item.CloseTime)}
           ,{item.CloseTakeHour}
           ,{item.CloseTimeOutStatus}
           ,{item.CloseChaoShiTakeHour});";
            }
            else
            {
                cmdtext = $@"update [CustomerService_TimeShiXiao] set [ServiceID] = {item.ID}
      ,[XiaDanDate] ={GetDateTimeStr(item.XiaDanDate)}
      ,[XiaDanTakeHour] = {item.XiaDanTakeHour}
      ,[XiaDanTimeOutStatus] = {item.XiaDanTimeOutStatus}
      ,[XiaDanChaoShiTakeHour] = {item.XiaDanChaoShiTakeHour}
      ,[PaiDanDate] = {GetDateTimeStr(item.PaiDanDate)}
      ,[PaiDanTakeHour] = {item.PaiDanTakeHour}
      ,[PaiDanTimeOutStatus] = {item.PaiDanTimeOutStatus}
      ,[PaiDanChaoShiTakeHour] = {item.PaiDanChaoShiTakeHour}
      ,[ResponseTime] = {GetDateTimeStr(item.ResponseTime)}
      ,[ResponseTakeHour] = {item.ResponseTakeHour}
      ,[ResponseTimeOutStatus] = {item.ResponseTimeOutStatus}
      ,[ResponseChaoShiTakeHour] = {item.ResponseChaoShiTakeHour}
      ,[CheckTime] = {GetDateTimeStr(item.CheckTime)}
      ,[CheckTakeHour] = {item.CheckTakeHour}
      ,[CheckTimeOutStatus] = {item.CheckTimeOutStatus}
      ,[CheckChaoShiTakeHour] = {item.CheckChaoShiTakeHour}
      ,[ChuliDate] = {GetDateTimeStr(item.ChuliDate)}
      ,[ProcessTakeHour] = {item.ProcessTakeHour}
      ,[ProcessTimeOutStatus] = {item.ProcessTimeOutStatus}
      ,[ProcessChaoShiTakeHour] = {item.ProcessChaoShiTakeHour}
      ,[BanJieTime] = {GetDateTimeStr(item.BanJieTime)}
      ,[BanJieTakeHour] = {item.BanJieTakeHour}
      ,[BanJieTimeOutStatus] = {item.BanJieTimeOutStatus}
      ,[BanJieChaoShiTakeHour] = {item.BanJieChaoShiTakeHour}
      ,[CloseTime] = {GetDateTimeStr(item.CloseTime)}
      ,[CloseTakeHour] = {item.CloseTakeHour}
      ,[CloseTimeOutStatus] = {item.CloseTimeOutStatus}
      ,[CloseChaoShiTakeHour] = {item.CloseChaoShiTakeHour} where ServiceID={item.ID};";
            }
            if (!string.IsNullOrEmpty(cmdtext.Trim()))
            {
                sqlList.Add(cmdtext);
            }
            return;
        }