/// <summary> /// 新增价格体系配置 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult AddPackageConfig(PaintDiscountPackageModel model) { if (model == null) { return(Json(new { Status = false, Msg = "未知的添加对象" }, JsonRequestBehavior.AllowGet)); } else if (string.IsNullOrWhiteSpace(model.PackageName)) { return(Json(new { Status = false, Msg = "活动名称不能为空" }, JsonRequestBehavior.AllowGet)); } else if (!Enum.IsDefined(typeof(UserType), model.UserType)) { return(Json(new { Status = false, Msg = "未定义的用户类型" }, JsonRequestBehavior.AllowGet)); } var manager = new PaintDiscountConfigManager(); var isExist = manager.IsExistPaintDiscountPackage(model); if (isExist) { return(Json(new { Status = false, Msg = "活动已存在,不能重复编辑" }, JsonRequestBehavior.AllowGet)); } var user = User.Identity.Name; var result = manager.AddPaintDiscountPackage(model, user); return(Json(new { Status = result > 0, Msg = $"添加{(result > 0 ? "成功" : "失败")}", PackageId = result } , JsonRequestBehavior.AllowGet)); }
/// <summary> /// 删除价格体系配置 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult DeletePackageConfig(PaintDiscountPackageModel model) { if (model.PKID < 1 || string.IsNullOrWhiteSpace(model.PackageName)) { return(Json(new { Status = false, Msg = "未知的删除对象" }, JsonRequestBehavior.AllowGet)); } var manager = new PaintDiscountConfigManager(); var user = User.Identity.Name; var result = manager.DeletePaintDiscountPackage(model, user); return(Json(new { Status = result, Msg = $"删除{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 是否存在重复的喷漆价格体系 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public static bool IsExistPaintDiscountPackage (SqlConnection conn, PaintDiscountPackageModel model) { #region Sql var sql = @"SELECT COUNT(1) FROM Configuration..PaintDiscountPackageConfig AS s WITH ( NOLOCK ) WHERE s.PackageName = @PackageName AND s.IsDeleted=0 AND s.PKID <> @PKID;"; #endregion var parameters = new[] { new SqlParameter("@PackageName", model.PackageName), new SqlParameter("@PKID", model.PKID) }; var count = Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters)); return(count > 0); }
/// <summary> /// 更新喷漆打折价格体系配置 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public static bool UpdatePaintDiscountPackage(SqlConnection conn, PaintDiscountPackageModel model) { #region Sql var sql = @"UPDATE Configuration..PaintDiscountPackageConfig SET IsEnabled = @IsEnabled , IsDeleted = 0 , UserType = @UserType, LastUpdateDateTime = GETDATE() WHERE PKID = @PKID;"; #endregion var parameters = new[] { new SqlParameter("@PackageName", model.PackageName), new SqlParameter("@IsEnabled", model.IsEnabled), new SqlParameter("@UserType", model.UserType), new SqlParameter("@PKID", model.PKID) }; return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, parameters) > 0); }
/// <summary> /// 添加喷漆打折价格体系配置 /// </summary> /// <param name="conn"></param> /// <param name="model"></param> /// <returns></returns> public static int AddPaintDiscountPackage(SqlConnection conn, PaintDiscountPackageModel model) { #region SQL var sql = @"INSERT INTO Configuration..PaintDiscountPackageConfig ( PackageName , UserType , IsEnabled ) VALUES ( @PackageName , @UserType , @IsEnabled ) SELECT SCOPE_IDENTITY();"; #endregion var parameters = new[] { new SqlParameter("@PackageName", model.PackageName), new SqlParameter("@UserType", model.UserType), new SqlParameter("@IsEnabled", model.IsEnabled) }; return(Convert.ToInt32(SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, parameters))); }
/// <summary> /// 更新价格体系配置 /// </summary> /// <param name="model"></param> /// <returns></returns> public ActionResult UpdatePackageConfig(PaintDiscountPackageModel model) { if (model == null || model.PKID < 1) { return(Json(new { Status = false, Msg = "未知的编辑对象" }, JsonRequestBehavior.AllowGet)); } if (string.IsNullOrWhiteSpace(model.PackageName)) { return(Json(new { Status = false, Msg = "活动名称不能为空" }, JsonRequestBehavior.AllowGet)); } var manager = new PaintDiscountConfigManager(); var isExist = manager.IsExistPaintDiscountPackage(model); if (isExist) { return(Json(new { Status = false, Msg = "已存在重复的数据,不能重复编辑" }, JsonRequestBehavior.AllowGet)); } var user = User.Identity.Name; var result = manager.UpdatePaintDiscountPackage(model, user); return(Json(new { Status = result, Msg = $"编辑{(result ? "成功" : "失败")}" }, JsonRequestBehavior.AllowGet)); }