/// <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));
}
