public static int DeleteClass(M_Class newsclass)
{
string strsql = "delete Class where Class_ID=@Class_ID ";
SqlParameter[] comSql = new SqlParameter[] {
new SqlParameter("@Class_ID", newsclass.Class_ID),
};
return(DBHelper.IDUTable(strsql, comSql));
}
public static M_Class GetClass(SqlDataReader ClassTable)
{
M_Class newsclass = new M_Class();
newsclass.Class_ID = (int)ClassTable["Class_ID"];
newsclass.Class_Name = ClassTable["Class_Name"].ToString();
newsclass.Class_Desc = ClassTable["Class_Desc"].ToString();
newsclass.Class_Order = (int)ClassTable["Class_Order"];
newsclass.Item_ID = (int)ClassTable["Item_ID"];
return(newsclass);
}
public static int InsertClass(M_Class newsclass)
{
string strsql = "insert Class values(@Class_Name,@Class_Desc,@Class_Order,@Item_ID)";
SqlParameter[] comSql = new SqlParameter[] {
new SqlParameter("@Class_Name", newsclass.Class_Name),
new SqlParameter("@Class_Desc", newsclass.Class_Desc),
new SqlParameter("@Class_Order", newsclass.Class_Order),
new SqlParameter("@Item_ID", newsclass.Item_ID)
};
return(DBHelper.IDUTable(strsql, comSql));
}
public static int UpdateClass(M_Class newsclass)
{
string strsql = "update Class set Class_Name=@Class_Name,Class_Desc= @Class_Desc,Class_Order=@Class_Order,Item_ID=@Item_ID where Class_ID=@Class_ID ";
SqlParameter[] comSql = new SqlParameter[] {
new SqlParameter("@Class_ID", newsclass.Class_ID),
new SqlParameter("@Class_Name", newsclass.Class_Name),
new SqlParameter("@Class_Desc", newsclass.Class_Desc),
new SqlParameter("@Class_Order", newsclass.Class_Order),
new SqlParameter("@Item_ID", newsclass.Item_ID)
};
return(DBHelper.IDUTable(strsql, comSql));
}
protected void Button1_Click(object sender, EventArgs e)
{
M_Class newsclass = new M_Class();
newsclass.Class_Name = txtClassName.Text.Trim();
newsclass.Class_Desc = txtClassDesc.Text.Trim();
newsclass.Class_Order = Convert.ToInt32(txtClassOrder.Text.Trim());
newsclass.Item_ID = Convert.ToInt32(ddlItemID.SelectedValue);
if (B_Class.InsertClass(newsclass))
{
Response.Write("<script>alert('添加成功！')</script>");
}
else
{
Response.Write("<script>alert('添加失败！')</script>");
}
}
public static void DeleteClass(M_Class newsclass)
{
D_Class.DeleteClass(newsclass);
}
public static void UpdateClass(M_Class newsclass)
{
D_Class.UpdateClass(newsclass);
}
public static bool InsertClass(M_Class newsclass)
{
int count = D_Class.InsertClass(newsclass);
return(count > 0 ? true : false);
}
