protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
colleges n = new colleges();
GridViewRow gvr = GridView1.Rows[e.RowIndex];
n.College = GridView1.DataKeys[e.RowIndex].Value.ToString(); //获取当前行主键id
cm.Delete(n);
gridviewBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
colleges n = new colleges();
n.College = TextBox1.Text.Trim();
n.Creater = Session["adminId"].ToString();
cm.Insert(n);
gridviewBind();
ScriptManager.RegisterStartupScript(this, this.GetType(), "updateScript", "alert(\"新增成功\");", true);
}
/// <summary>
/// 删除学院
/// </summary>
/// <param name="n">学院实体类</param>
/// <returns></returns>
public bool Delete(colleges n)
{
bool flag = false;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@college", n.College),
};
int res = sqlhelper.ExecuteNonQuery("DELETE FROM colleges where college=@college", paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return(flag);
}
/// <summary>
/// 新增学院
/// </summary>
/// <param name="n">学院实体类</param>
/// <returns></returns>
public bool Insert(colleges n)
{
bool flag = false;
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@college", n.College),
new SqlParameter("@creater", n.Creater),
new SqlParameter("@modifier", n.Creater),
};
int res = sqlhelper.ExecuteNonQuery("INSERT INTO colleges (college, creater, modifier) VALUES (@college,@creater,@modifier)", paras, CommandType.Text);
if (res > 0)
{
flag = true;
}
return(flag);
}
/// <summary>
/// 删除学院
/// </summary>
/// <param name="n">学院实体类</param>
/// <returns></returns>
public bool Delete(colleges n)
{
return(ndao.Delete(n));
}
/// <summary>
/// 新增学院
/// </summary>
/// <param name="n">学院实体类</param>
/// <returns></returns>
public bool Insert(colleges n)
{
return(ndao.Insert(n));
}
