public ActionResult ModifyPackageCate()
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 702))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
Validation validation = new Validation();
int categoryID = validation.GetInt("categoryID");
PackageBLL packageBLL = new PackageBLL();
PackageCateObj packageCateObj = packageBLL.GetPackageCate(categoryID);
if (packageCateObj != null)
{
packageCateObj.CategoryName = validation.Get("categoryName", false, "分类名称不可为空！");
packageCateObj.Sort = validation.GetInt("sort");
if (validation.HasError)
{
return(Json(new { success = false, msg = validation.GetError() }));
}
packageBLL.ModifyPackageCate(packageCateObj);
return(Json(new { success = true }));
}
else
{
return(Json(new { success = false, msg = "该类别不存在！" }));
}
}
public ActionResult AddPackageCate()
{
if (!AppData.IsManagerLogin)
{
return(Json(new { success = false, msg = "您未登录后台或会话已过期" }));
}
if (PrivilegeBLL.HasNotPrivilege(AppData.SessionUserID, 701))
{
return(Json(new { success = false, msg = "您没有执行该操作的权限" }));
}
Validation vld = new Validation();
PackageCateObj packageCateObj = new PackageCateObj();
packageCateObj.CategoryName = vld.Get("categoryName", false, "类别名不可为空！");
packageCateObj.Sort = vld.GetInt("sort");
packageCateObj.ParentID = vld.GetInt("categoryID");
if (vld.HasError)
{
return(Json(new { success = false, msg = vld.GetError() }));
}
PackageBLL packageBLL = new PackageBLL();
packageBLL.AddPackageCate(packageCateObj);
return(Json(new { success = true }));
}
public void ModifyPackageCate(PackageCateObj packageCateObj)
{
using (helper = new SqlHelper())
{
helper.AddIntParameter("@CategoryID", packageCateObj.CategoryID);
helper.AddStringParameter("@CategoryName", 50, packageCateObj.CategoryName);
helper.AddIntParameter("@ParentID", packageCateObj.ParentID);
helper.AddIntParameter("@Sort", packageCateObj.Sort);
helper.ExecuteNonQuery("update PackageCates set CategoryName=@CategoryName,ParentID=@ParentID,Sort=@Sort where CategoryID=@CategoryID", CommandType.Text);
}
}
public void AddPackageCate(PackageCateObj packageCateObj)
{
using (helper = new SqlHelper())
{
helper.AddStringParameter("@CategoryName", 50, packageCateObj.CategoryName);
helper.AddIntParameter("@ParentID", packageCateObj.ParentID);
helper.AddIntParameter("@Sort", packageCateObj.Sort);
packageCateObj.CategoryID = helper.GetIntValue("select Max(CategoryID) from PackageCates", CommandType.Text) + 1;
helper.AddIntParameter("@CategoryID", packageCateObj.CategoryID);
helper.ExecuteNonQuery("insert into PackageCates (CategoryID,CategoryName,ParentID,Sort) values (@CategoryID,@CategoryName,@ParentID,@Sort)", CommandType.Text);
}
}
public PackageCateObj GetPackageCate(int categoryID)
{
using (SqlHelper helper = new SqlHelper())
{
helper.AddIntParameter("@CategoryID", categoryID);
using (SqlDataReader dr = helper.ExecuteReader("select CategoryName,ParentID,Sort from PackageCates where CategoryID=@CategoryID", CommandType.Text))
{
if (dr.HasRows && dr.Read())
{
PackageCateObj cateObj = new PackageCateObj();
cateObj.CategoryID = categoryID;
cateObj.CategoryName = (string)dr[0];
cateObj.ParentID = (int)dr[1];
cateObj.Sort = dr[2] == DBNull.Value ? 0 : (int)dr[2];
return(cateObj);
}
else
{
return(null);
}
}
}
}
public void ModifyPackageCate(PackageCateObj packageCateObj)
{
dal.ModifyPackageCate(packageCateObj);
}
public void AddPackageCate(PackageCateObj packageCateObj)
{
dal.AddPackageCate(packageCateObj);
}