| | |
| | | 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>() |
| | | { |
| | | |
| | |
| | | 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), |
| | |
| | | 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 |
| | | { |
| | |
| | | |
| | | |
| | | /// <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> |