username@email.com
2025-03-07 2fee7b9b90c1acf7a17aef84ee22c2a31b801fe2
CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanDAL.cs
@@ -107,7 +107,10 @@
                                              new SqlParameter("@Biddingcompany",trueModel.Biddingcompany),
                                               new SqlParameter("@shifouDelivery",trueModel.shifouDelivery),
                                                new SqlParameter("@Lianxiren",trueModel.Lianxiren),
                                                     new SqlParameter("@CompanyName",trueModel.CompanyName),
                                                     new SqlParameter("@CompanyName",string.IsNullOrEmpty(trueModel.CompanyName)?"":trueModel.CompanyName),
                                                     new SqlParameter("@Deliveredstatus",trueModel.Deliveredstatus.HasValue?trueModel.Deliveredstatus.Value:0),
                                                     new SqlParameter("@TransferType",trueModel.TransferType.HasValue?trueModel.TransferType.Value:0),
                                                     new SqlParameter("@TransferName",string.IsNullOrEmpty(trueModel.TransferName)?"":trueModel.TransferName),
            };
            try
            {
@@ -159,30 +162,33 @@
                    new SqlParameter("@FirmId",trueModel.FirmId),
                    new SqlParameter("@BuyerId",trueModel.BuyerId),
                    DeliveredTime,
                    new SqlParameter("@Zhuyishixiang",trueModel.Zhuyishixiang),
                    new SqlParameter("@Gongzuokaoping",trueModel.Gongzuokaoping),
                    new SqlParameter("@Zhuyishixiang",string.IsNullOrEmpty(trueModel.Zhuyishixiang)?"":trueModel.Zhuyishixiang  ),
                    new SqlParameter("@Gongzuokaoping",string.IsNullOrEmpty(trueModel.Gongzuokaoping)?"":trueModel.Gongzuokaoping ),
                    new SqlParameter("@CarId",trueModel.CarId),
                      new SqlParameter("@DriverId",trueModel.DriverId),
                        new SqlParameter("@Transferstatus",trueModel.Transferstatus),
                          TransfersTime,
                            new SqlParameter("@Creater",trueModel.Creater),
                              new SqlParameter("@CreateTime",trueModel.CreateTime),
                                new SqlParameter("@Updater",trueModel.Updater),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
                                new SqlParameter("@Updater",trueModel.Updater.HasValue?trueModel.Updater.Value:Guid.Empty),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime.HasValue?trueModel.LastUpdateTime.Value:DateTime.MinValue),
                                    new SqlParameter("@Sort",trueModel.Sort),
                                        new SqlParameter("@DeliverTime",trueModel.DeliverTime),
                                         new SqlParameter("@wentifankui",trueModel.wentifankui),
                                           new SqlParameter("@Yichangchuli",trueModel.Yichangchuli),
                                        new SqlParameter("@Xingzhengzhuize",trueModel.Xingzhengzhuize),
                                         new SqlParameter("@wentifankui",string.IsNullOrEmpty(trueModel.wentifankui)?"":trueModel.wentifankui),
                                           new SqlParameter("@Yichangchuli",string.IsNullOrEmpty(trueModel.Yichangchuli)?"":trueModel.Yichangchuli),
                                        new SqlParameter("@Xingzhengzhuize",string.IsNullOrEmpty(trueModel.Xingzhengzhuize)?"":trueModel.Xingzhengzhuize),
                                        new SqlParameter("@SellerOrderId",trueModel.SellerOrderId),
                                          new SqlParameter("@Dianhua",trueModel.Dianhua),
                                           new SqlParameter("@Dizhi",trueModel.Dizhi),
                                            new SqlParameter("@Remark",trueModel.Remark),
                                             new SqlParameter("@BusinessManagerId",trueModel.BusinessManagerId),
                                              new SqlParameter("@Biddingcompany",trueModel.Biddingcompany),
                                              new SqlParameter("@Biddingcompany",trueModel.Biddingcompany.HasValue?trueModel.Biddingcompany.Value:0),
                                               new SqlParameter("@shifouDelivery",trueModel.shifouDelivery),
                                                new SqlParameter("@Lianxiren",trueModel.Lianxiren),
                                                  new SqlParameter("@CompanyName",trueModel.CompanyName),
                                                  new SqlParameter("@CompanyName",string.IsNullOrEmpty(trueModel.CompanyName)?"":trueModel.CompanyName),
                                                     new SqlParameter("@Deliveredstatus",trueModel.Deliveredstatus.HasValue?trueModel.Deliveredstatus.Value:0),
                                                     new SqlParameter("@TransferType",trueModel.TransferType.HasValue?trueModel.TransferType.Value:0),
                                                     new SqlParameter("@TransferName",string.IsNullOrEmpty(trueModel.TransferName)?"":trueModel.TransferName),
            };
            try
            {