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)); }