protected void Button1_Click(object sender, EventArgs e)
{
int BLID = Convert.ToInt32(this.DropDownList1.SelectedValue);
string BSName = this.TextBox1.Text;
//if (BSCategoryDAL.selBystype(BLID, BSName) == 0)
//{
//}
//else
//{
// Alert("此类别已存在");
//}
if (BSName == "")
{
Alert("请输入小类别名");
}
else
{
if (BSCategoryDAL.addBLCategory(BLID, BSName) > 0)
{
Alert("添加小类成功");
Response.Redirect("goodSType.aspx");
}
else
{
Alert("添加小类失败");
}
}
}
protected void ImageButton1_Click(object sender, EventArgs e)
{
ImageButton btu = sender as ImageButton;
int BSID = Convert.ToInt32(btu.CommandArgument);
if (BSCategoryDAL.deleteByBSID(BSID) > 0)
{
Alert("删除成功");
ShowDate();
}
else
{
Alert("删除失败");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int BLID = Convert.ToInt32(Request.QueryString["BLID"]);
int BSID = Convert.ToInt32(Request.QueryString["BSID"]);
string BSName = this.TextBox1.Text;
if (BSCategoryDAL.updateByBSID(BLID, BSName, BSID) > 0)
{
Alert("编辑成功");
Response.Redirect("goodSType.aspx");
}
else
{
Alert("编辑失败");
}
}
public static SqlDataReader SelectBook(int count, int page, int BSID)
{
return(BSCategoryDAL.SelectBook(count, page, BSID));
}
public static List <BSCategory> SelectBSIDAll(int BSID)
{
return(BSCategoryDAL.SelectBSIDAll(BSID));
}
/// <summary>
/// 根据id删除
/// </summary>
/// <param name="BSID"></param>
/// <returns></returns>
public static int deleteByBSID(int BSID)
{
return(BSCategoryDAL.deleteByBSID(BSID));
}
/// <summary>
/// 根据id修改
/// </summary>
/// <param name="BSID"></param>
/// <param name="BLName"></param>
/// <returns></returns>
public static int updateByBSID(int BLID, string BLName, int BSID)
{
return(BSCategoryDAL.updateByBSID(BLID, BLName, BSID));
}
/// <summary>
/// 添加小类
/// </summary>
/// <param name="BLID"></param>
/// <param name="BLName"></param>
/// <returns></returns>
public static int addBLCategory(int BLID, string BLName)
{
return(BSCategoryDAL.addBLCategory(BLID, BLName));
}