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; }