private static SqlParameter[] GetParameters(M_CateDetail catedetail)
{
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter("@CateDetailName", SqlDbType.NVarChar, 50);
parameter[0].Value = catedetail.CateDetailName;
parameter[1] = new SqlParameter("@CateDetailID", SqlDbType.Int);
parameter[1].Value = catedetail.CateDetailID;
return(parameter);
}
public bool Add(M_CateDetail catedetail)
{
string sqlStr = "INSERT INTO ZL_CateDetail(CateDetailName,CateID) VALUES(@CateDetailName,@CateID)";
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter("@CateDetailName", SqlDbType.NVarChar, 50);
parameter[0].Value = catedetail.CateDetailName;
parameter[1] = new SqlParameter("@CateID", SqlDbType.Int);
parameter[1].Value = catedetail.CateID;
return(SqlHelper.ExecuteSql(sqlStr, parameter));
}
public bool Update(M_CateDetail catedetail)
{
string sqlStr = "UPDATE ZL_CateDetail SET CateDetailName=@CateDetailName where CateDetailID=@CateDetailID";
SqlParameter[] cmdParams = GetParameters(catedetail);
int temp = SqlHelper.ExecuteNonQuery(CommandType.Text, sqlStr, cmdParams);
if (temp == 1)
{
return(true);
}
else
{
return(false);
}
}
protected void Button8_Click(object sender, EventArgs e)
{
if (Button8.Text == "添加")
{
M_CateDetail temp = new M_CateDetail();
temp.CateDetailName = TextBox1.Text;
temp.CateID = Convert.ToInt32(Session["cateid"]);
if (B_CateDetail.Add(temp))
{
this.Bind();
}
}
if (Button8.Text == "更新")
{
Button8.Text = "添加";
M_CateDetail temp = new M_CateDetail();
temp.CateID = Convert.ToInt32(Session["CateID"]);
temp.CateDetailName = TextBox1.Text;
temp.CateDetailID = Convert.ToInt32(Session["catedetailid"]);
B_CateDetail.Update(temp);
this.Bind();
}
}
protected void GridView1_RowCommand1(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "mydelete")
{
for (int i = 0; i < GridView1.Rows.Count; i++)
{
CheckBox IdCheck;
IdCheck = (CheckBox)GridView1.Rows[i].FindControl("detailCheckBox");
if (IdCheck.Checked)
{
B_CateDetail.DeleteByID(Convert.ToInt32(e.CommandArgument.ToString()));
}
}
}
if (e.CommandName == "myupdate")
{
Session.Add("catedetailid", e.CommandArgument);
M_CateDetail temp = B_CateDetail.GetcatedetailById(Convert.ToInt32(e.CommandArgument));
TextBox1.Text = temp.CateDetailName;
Button8.Text = "更新";
}
}
public M_CateDetail GetcatedetailById(int catedetailid)
{
M_CateDetail tempCateDetail = new M_CateDetail();
string sqlstr = "select CateDetailid,catedetailname from zl_catedetail where catedetailid=@catedetailid";
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter("@catedetailid", DbType.Int32);
parameter[0].Value = catedetailid;
DataTable dt = SqlHelper.ExecuteTable(CommandType.Text, sqlstr, parameter);
if (dt.Rows.Count != 1)
{
return(null);
}
else
{
tempCateDetail.CateDetailName = (dt.Rows[0]["catedetailname"]).ToString();
tempCateDetail.CateDetailID = Convert.ToInt32(dt.Rows[0]["catedetailid"]);
}
return(tempCateDetail);
}
public static bool Update(M_CateDetail catedetailInfo)
{
return(catedetail.Update(catedetailInfo));
}
public static bool Add(M_CateDetail catedetailInfo)
{
return(catedetail.Add(catedetailInfo));
}
