public void ModifyPackageProdCate(PackageProdCatesObj packageProdCatesObj)
{
using (helper = new SqlHelper())
{
helper.BeginTran();
helper.AddIntParameter("@PpcID", packageProdCatesObj.PpcID);
helper.AddStringParameter("@PpcName", 20, packageProdCatesObj.PpcName);
helper.ExecuteNonQuery("update PackageProdCates set PpcName=@PpcName where PpcID=@PpcID", CommandType.Text);
helper.ExecuteNonQuery("delete from PackageProducts where PpcID=@PpcID", CommandType.Text);
if (packageProdCatesObj.PackageProducts != null)
{
foreach (var productID in packageProdCatesObj.PackageProducts)
{
helper.ClearParameters();
helper.AddIntParameter("@PpcID", packageProdCatesObj.PpcID);
helper.AddIntParameter("@ProductID", productID);
helper.ExecuteNonQuery("insert into PackageProducts (ProductID,PpcID) values (@ProductID,@PpcID)", CommandType.Text);
}
}
helper.CommitTran();
}
}
public void AddPackageProdCate(PackageProdCatesObj packageProdCatesObj)
{
using (helper = new SqlHelper())
{
helper.BeginTran();
SqlParameter idParam = helper.AddOutputParameter("@PpcID");
helper.AddIntParameter("@PackageID", packageProdCatesObj.PackageID);
helper.AddStringParameter("@PpcName", 20, packageProdCatesObj.PpcName);
helper.ExecuteNonQuery("insert into PackageProdCates (PackageID,PpcName) values (@PackageID,@PpcName) select @PpcID=@@IDENTITY", CommandType.Text);
packageProdCatesObj.PpcID = (int)idParam.Value;
if (packageProdCatesObj.PackageProducts != null)
{
foreach (var prdId in packageProdCatesObj.PackageProducts)
{
helper.ClearParameters();
helper.AddIntParameter("@PpcID", packageProdCatesObj.PpcID);
helper.AddIntParameter("@ProductID", prdId);
helper.ExecuteNonQuery("insert into PackageProducts (ProductID,PpcID) values (@ProductID,@PpcID)", CommandType.Text);
}
}
helper.CommitTran();
}
}
public ActionResult AddPackageDetail()
{
if (Request.HttpMethod == "POST")
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 904))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
Validation vld = new Validation();
PackageProdCatesObj packageProdCatesObj = new PackageProdCatesObj();
packageProdCatesObj.PackageID = vld.GetInt("packageID");
packageProdCatesObj.PpcName = vld.Get("name", false, "请填写产品组名称");
string sProducts = vld.Get("products", false, "请至少添加一个产品", regex: @"^\d+(,\d+)*$", regexText: "类别参数错误");
if (vld.HasError)
{
return(Json(new { success = false, msg = vld.GetError() }));
}
IList <int> products;
if (string.IsNullOrEmpty(sProducts))
{
products = null;
}
else
{
string[] aCategoryIDs = sProducts.Split(',');
products = new List <int>();
for (int i = 0; i < aCategoryIDs.Length; i++)
{
products.Add(int.Parse(aCategoryIDs[i]));
}
}
packageProdCatesObj.PackageProducts = products;
PackageBLL packageBLL = new PackageBLL();
packageBLL.AddPackageProdCate(packageProdCatesObj);
return(Json(new { success = true }));
}
else
{
if (!AppData.IsManagerLogin)
{
return(Redirect("/Manage/Error/1.html"));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 904))
{
return(Redirect("/Manage/Error/2.html"));
}
return(View());
}
}
public PackageProdCatesObj GetPackageDetailByID(int ppcID)
{
using (helper = new SqlHelper())
{
helper.AddIntParameter("@PpcID", ppcID);
SqlDataReader dr;
PackageProdCatesObj packageProdCatesObj;
using (dr = helper.ExecuteReader("select PpcID,PpcName,PackageID from PackageProdCates where PpcID=@PpcID", CommandType.Text))
{
if (dr.HasRows && dr.Read())
{
packageProdCatesObj = new PackageProdCatesObj();
packageProdCatesObj.PpcID = dr[0] == DBNull.Value ? 0 : (int)dr[0];
packageProdCatesObj.PpcName = dr[1] == DBNull.Value ? null : (string)dr[1];
packageProdCatesObj.PackageID = dr[2] == DBNull.Value ? 0 : (int)dr[2];
}
else
{
packageProdCatesObj = null;
}
}
if (packageProdCatesObj != null)
{
using (dr = helper.ExecuteReader("select ProductID from PackageProducts where PpcID=@PpcID", CommandType.Text))
{
if (dr.HasRows)
{
packageProdCatesObj.PackageProducts = new List <int>();
while (dr.Read())
{
packageProdCatesObj.PackageProducts.Add((int)dr[0]);
}
}
}
}
return(packageProdCatesObj);
}
}
public void ModifyPackageProdCate(PackageProdCatesObj packageProdCatesObj)
{
dal.ModifyPackageProdCate(packageProdCatesObj);
}
public void AddPackageProdCate(PackageProdCatesObj packageProdCatesObj)
{
dal.AddPackageProdCate(packageProdCatesObj);
}
