username@email.com
2025-03-13 0fb5eab0d6787922d3e915543e95fe5073d767ff
CY_ECommercePlatform/CY.SQLDAL/OA/OA_DeliverPlanDAL.cs
@@ -155,6 +155,16 @@
                TransfersTime = new SqlParameter("@TransfersTime", DBNull.Value);
            }
            SqlParameter LastUpdateTime = null;
            if (trueModel.LastUpdateTime.HasValue)
            {
                LastUpdateTime = new SqlParameter("@LastUpdateTime", trueModel.LastUpdateTime.Value);
            }
            else
            {
                LastUpdateTime = new SqlParameter("@LastUpdateTime", DBNull.Value);
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
@@ -171,7 +181,7 @@
                            new SqlParameter("@Creater",trueModel.Creater),
                              new SqlParameter("@CreateTime",trueModel.CreateTime),
                                new SqlParameter("@Updater",trueModel.Updater.HasValue?trueModel.Updater.Value:Guid.Empty),
                                  new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime.HasValue?trueModel.LastUpdateTime.Value:DateTime.MinValue),
                                LastUpdateTime,
                                    new SqlParameter("@Sort",trueModel.Sort),
                                        new SqlParameter("@DeliverTime",trueModel.DeliverTime),
                                         new SqlParameter("@wentifankui",string.IsNullOrEmpty(trueModel.wentifankui)?"":trueModel.wentifankui),
@@ -189,6 +199,8 @@
                                                     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),
                                                     new SqlParameter("@DeliverPlanPaicheid", trueModel.DeliverPlanPaicheid.HasValue?trueModel.DeliverPlanPaicheid:Guid.Empty),
            };
            try
            {
@@ -251,6 +263,16 @@
        /// <summary>
        /// 全部查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_DeliverPlan> GetModelByDeliverPlanPaicheid(Guid deliverPlanPaicheid)
        {
            return _dataBase.SelectModel<Model.OA_DeliverPlan>(" * ", " OA_DeliverPlan ", " DeliverPlanPaicheid = '" + deliverPlanPaicheid + "'") as IList<Model.OA_DeliverPlan>;//执行查询
        }
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>