public ActionResult SubmitCsPackageInfo(CsPackage model)
{
if (_csPackageBll.GetModelList($" and PackageName ='{model.PackageName}'").Any() &&
model.PackageId == 0)
{
return(Json(new ResModel
{
Data = "已存在该套餐，请重新设置",
ResStatus = ResStatue.Warn
}));
}
ResStatue code;
if (model.PackageId > 0)
{
model.OperationDate = DateTime.Now;
code = _csPackageBll.Update(model) ? ResStatue.Yes : ResStatue.Warn;
}
else
{
model.PackageWeight = 0;
model.PackageStock = 1000;
model.PackageImage = "Images/10007.jpg";
model.OperationDate = DateTime.Now;
model.PackageType = 1;
code = _csPackageBll.Add(model) > 0 ? ResStatue.Yes : ResStatue.Warn;
}
return(Json(new ResModel
{
ResStatus = code,
Data = code == ResStatue.Yes ? "更新成功" : "执行完成,但是没有数据受影响"
}));
}
public bool Update(CsPackage model)
{
var strSql = new StringBuilder();
strSql.Append("UPDATE CrabShop.dbo.[CsPackage] SET ");
strSql.Append("PackageType = @PackageType,PackageName = @PackageName,PackageNumber = @PackageNumber,PackageImage = @PackageImage,PackageWeight = @PackageWeight,PackagePrice = @PackagePrice,PackageState = @PackageState,OperationDate = @OperationDate,PackageStock = @PackageStock");
strSql.Append(" WHERE PackageId = @PackageId");
return(DbClient.Excute(strSql.ToString(), model) > 0);
}
public int Add(CsPackage model)
{
var strSql = new StringBuilder();
strSql.Append("INSERT INTO CrabShop.dbo.[CsPackage] (");
strSql.Append("PackageType,PackageName,PackageNumber,PackageImage,PackageWeight,PackagePrice,PackageState,OperationDate,PackageStock");
strSql.Append(") VALUES (");
strSql.Append("@PackageType,@PackageName,@PackageNumber,@PackageImage,@PackageWeight,@PackagePrice,@PackageState,@OperationDate,@PackageStock);");
strSql.Append("SELECT @@IDENTITY");
return(DbClient.ExecuteScalar <int>(strSql.ToString(), model));
}
