public bool InsertCategory(L_CategoryInfo info)
{
string sqlStr = "insert into Category(productCategoryName,parentID,categoryDepth) values('{0}',{1},{2})";
sqlStr = string.Format(sqlStr, info.ProductCategoryName, info.ParentID, info.CategoryDepth);
if (SqlHelper.ExecuteNonQuery(CommandType.Text, sqlStr, null) != 0)
{
return(true);
}
else
{
return(false);
}
}
protected void btnAddCategory_Click(object sender, EventArgs e)
{
L_CategoryInfo info = new L_CategoryInfo();
info.ProductCategoryName = txtCategoryName.Text;
info.CategoryDepth = Convert.ToInt32(ddlLevel.SelectedValue.Split(',')[0]) + 1;
info.ParentID = Convert.ToInt32(ddlLevel.SelectedValue.Split(',')[1]);
if (category.InsertCategory(info))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("添加类别成功"));
ReSetPage();
}
txtCategoryName.Text = "";
}
protected void btnedit_Click(object sender, EventArgs e)
{
L_CategoryInfo info = new L_CategoryInfo();
info.ProductCategoryID = Convert.ToInt32(Request.Form["lbdivid"].ToString());
info.ProductCategoryName = Request.Form["tbname"].ToString();
info.CategoryDepth = Convert.ToInt32(ddldiv.SelectedValue.Split(',')[0]) + 1;
info.ParentID = Convert.ToInt32(ddldiv.SelectedValue.Split(',')[1]);
int step = info.CategoryDepth - Convert.ToInt32(Request.Form["olddepth"].ToString()) - 1;
if (category.UpdateCategoryByID(info, step))
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("修改类别成功"));
ReSetPage();
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "", WebUnitily.AlertUrl("修改类别成功"));
}
}
public Collection <L_CategoryInfo> GetSubCategoryById(int categoryID)
{
string sqlStr = "select * from Category where parentID={0}";
sqlStr = string.Format(sqlStr, categoryID);
DataTable dt = SqlHelper.ExecuteDateSet(CommandType.Text, sqlStr, null).Tables[0];
Collection <L_CategoryInfo> allCategory = new Collection <L_CategoryInfo>();
for (int i = 0; i < dt.Rows.Count; i++)
{
L_CategoryInfo categoryinfo = new L_CategoryInfo();
categoryinfo.ProductCategoryID = Convert.ToInt32(dt.Rows[i]["productCategoryID"]);
categoryinfo.ProductCategoryName = dt.Rows[i]["productCategoryName"].ToString();
categoryinfo.ParentID = Convert.ToInt32(dt.Rows[i]["parentID"]);
categoryinfo.CategoryDepth = Convert.ToInt32(dt.Rows[i]["categoryDepth"]);
categoryinfo.CategoryDetail = dt.Rows[i]["categoryDepth"].ToString() + ',' + dt.Rows[i]["productCategoryID"];
allCategory.Add(categoryinfo);
}
return(allCategory);
}
public bool UpdateCategoryByID(L_CategoryInfo category, int step)
{
Collection <L_CategoryInfo> allCategory = new Collection <L_CategoryInfo>();
GetCategory(allCategory, category.ProductCategoryID);
try
{
string sqlStr = "Update category set ProductCategoryName='{0}',parentID={1},categoryDepth={2} where ProductCategoryID={3}";
sqlStr = string.Format(sqlStr, category.ProductCategoryName, category.ParentID, category.CategoryDepth, category.ProductCategoryID);
SqlHelper.ExecuteNonQuery(CommandType.Text, sqlStr, null);
foreach (L_CategoryInfo categoryinfo in allCategory)
{
sqlStr = "Update category set categoryDepth={0} wher productCategoryID={1}";
sqlStr = string.Format(sqlStr, categoryinfo.CategoryDepth + step, categoryinfo.ProductCategoryID);
SqlHelper.ExecuteNonQuery(CommandType.Text, sqlStr, null);
}
return(true);
}
catch
{
return(false);
}
}
public bool UpdateCategoryByID(L_CategoryInfo categoryAll, int step)
{
return(category.UpdateCategoryByID(categoryAll, step));
}
public bool InsertCategory(L_CategoryInfo info)
{
return(category.InsertCategory(info));
}
