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