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