/// <summary> /// 添加喷漆大客户套餐 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public static int AddPackageConfig(SqlConnection conn, VipPaintPackageConfigModel model) { #region Sql var sql = @"INSERT INTO Configuration..VipPaintPackageConfig ( PackagePid , PackageName , PackagePrice , VipUserId , ServicePids , SettlementMethod , Operator ) OUTPUT Inserted.PKID VALUES ( @PackagePid , @PackageName , @PackagePrice , @VipUserId , @ServicePids , @SettlementMethod , @Operator );"; #endregion var parameters = new[] { new SqlParameter("@PackagePid", model.PackagePid ?? string.Empty), new SqlParameter("@PackageName", model.PackageName), new SqlParameter("@PackagePrice", model.PackagePrice), new SqlParameter("@VipUserId", model.VipUserId), new SqlParameter("@ServicePids", model.ServicePids), new SqlParameter("@SettlementMethod", model.SettlementMethod), new SqlParameter("@Operator", model.Operator) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters))); }
/// <summary> /// 更新喷漆大客户套餐配置 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public static bool UpdatePackageConfig(SqlConnection conn, VipPaintPackageConfigModel model) { #region Sql var sql = @"UPDATE Configuration..VipPaintPackageConfig SET PackagePrice = @PackagePrice , VipUserId = @VipUserId , ServicePids = @ServicePids , SettlementMethod = @SettlementMethod , Operator = @Operator , IsDeleted = 0, LastUpdateDateTime=GETDATE() WHERE PKID = @PKID;"; var parameters = new[] { new SqlParameter("@PackagePrice", model.PackagePrice), new SqlParameter("@VipUserId", model.VipUserId), new SqlParameter("@ServicePids", model.ServicePids), new SqlParameter("@SettlementMethod", model.SettlementMethod), new SqlParameter("@Operator", model.Operator), new SqlParameter("@PKID", model.PKID) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0); #endregion }
public ActionResult DeleteVipPaintPackage(VipPaintPackageConfigModel model) { if (model == null || model.PKID <= 0 || string.IsNullOrWhiteSpace(model.PackageName)) { return(Json(new { Status = false, Msg = "未知的删除对象" })); } var manager = new VipPaintPackageManager(); var illegal = manager.IsExistPromotionRecord(model.PKID); if (illegal) { return(Json(new { Status = false, Msg = "该套餐已给用户塞券,不可删除" })); } var result = manager.DeletePackageConfig(model.PackageName, User.Identity.Name); return(Json(new { Status = result, Msg = $"删除喷漆大客户套餐配置{(result ? "成功" : "失败")}" })); }
public ActionResult AddVipPaintPackage(VipPaintPackageConfigModel model) { #region 数据验证 if (model == null) { return(Json(new { Status = false, Msg = "未知的添加对象" })); } if (string.IsNullOrWhiteSpace(model.PackageName)) { return(Json(new { Status = false, Msg = "套餐名称不能为空" })); } if (model.VipUserId == null || model.VipUserId.Equals(Guid.Empty)) { return(Json(new { Status = false, Msg = "请选择套餐所属大客户" })); } if (model.PackagePrice <= 0) { return(Json(new { Status = false, Msg = "请输入套餐价格" })); } if (string.IsNullOrWhiteSpace(model.SettlementMethod)) { return(Json(new { Status = false, Msg = "请选择结算方式" })); } var servicePids = model.ServicePids?.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries)?.ToList(); if (servicePids == null || !servicePids.Any()) { return(Json(new { Status = false, Msg = "请选择适用Pid" })); } #endregion model.PackagePid = string.Empty; model.Operator = User.Identity.Name; var manager = new VipPaintPackageManager(); var isExist = manager.IsExistPackageConfig(model.PackageName, model.PKID); if (isExist) { return(Json(new { Status = false, Msg = "套餐已存在,不可重复添加" })); } var result = manager.AddPackageConfig(model); return(Json(new { Status = result, Msg = $"添加喷漆大客户套餐配置{(result ? "成功" : "失败")}" })); }
/// <summary> /// 添加喷漆大客户套餐配置 /// </summary> /// <param name="model"></param> /// <param name="user"></param> /// <returns></returns> public bool AddPackageConfig(VipPaintPackageConfigModel model) { var result = false; try { var oldValue = dbScopeManagerConfigurationRead.Execute(conn => DalVipPaintPackage.GetPackageConfig(conn, model.PackageName)); dbScopeManagerConfiguration.CreateTransaction (conn => { var addResult = false; if (oldValue == null) { var pkid = DalVipPaintPackage.AddPackageConfig(conn, model); addResult = pkid > 0; model.PKID = addResult ? pkid : 0; } if (addResult) { model.PackagePid = $"FU-PQXB-KAT|{model.PKID.ToString()}"; var pidResult = DalVipPaintPackage.UpdatePackagePID(conn, model.PKID, model.PackagePid); if (pidResult) { var packagePid = CreatePaintPackageProduct(model.PKID.ToString(), model.PackageName, model.Operator); if (string.IsNullOrWhiteSpace(packagePid)) { throw new Exception($"CreatePaintPackageProduct失败,待创建产品{JsonConvert.SerializeObject(model)}"); } else if (!string.Equals(packagePid, model.PackagePid)) { model.PackagePid = packagePid; result = DalVipPaintPackage.UpdatePackagePID(conn, model.PKID, model.PackagePid); } else { result = true; } } else { throw new Exception($"AddVipPackageConfig失败,待插入配置{JsonConvert.SerializeObject(model)}"); } } }); if (result) { model.CreateDateTime = DateTime.Now; model.LastUpdateDateTime = DateTime.Now; var log = new { ObjectId = $"PackageConfig_{model.PackageName}", ObjectType = "VipPaintPackage", BeforeValue = "", AfterValue = JsonConvert.SerializeObject(model), Remark = $"添加喷漆大客户套餐:{model.PackageName}的配置", Creator = model.Operator }; LoggerManager.InsertLog("CommonConfigLog", log); } } catch (Exception ex) { result = false; Logger.Error("AddVipPackageConfig", ex); } return(result); }