public bool Update(Model.T_Singer model) { //读取配置文件中的相关节点信息:数据库连接字符串 string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString(); SqlConnection myconn = new SqlConnection(setting); myconn.Open(); SqlCommand cmd = new SqlCommand("update T_Singer set Name=@name,Sex=@sex where Id=@id", myconn); cmd.Parameters.AddWithValue("@id", model.Id); cmd.Parameters.AddWithValue("@name", model.Name); cmd.Parameters.AddWithValue("@sex", model.Sex); if (cmd.ExecuteNonQuery() > 0) { cmd.Dispose(); myconn.Dispose(); return(true); } else { cmd.Dispose(); myconn.Dispose(); return(false); } }
protected void Update_Click(object sender, EventArgs e) { Model.T_Singer Singer = new Model.T_Singer(); Singer.Id = Convert.ToInt32(S_Id.Value); Singer.Name = SingerName.Text.Trim(); Singer.Sex = SingerSex.SelectedItem.ToString(); //Singer.ClassNO = ddlClass.SelectedValue.ToString(); BLL.T_Singer SingerBll = new BLL.T_Singer(); if (SingerBll.Update(Singer)) { Response.Write("DONE"); Add.Visible = true; Update.Visible = false; BindDate(); } else { Response.Write("FAILURE"); } }
public bool Delete(Model.T_Singer model) { //读取配置文件中的相关节点信息:数据库连接字符串 string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString(); //创建数据库对象 SqlConnection myconn = new SqlConnection(setting); //打开连接 myconn.Open(); //创建命令对象,并准备好操作数据库的SQL语句 SqlCommand cmd = new SqlCommand("delete from T_Singer where Id=@id;delete from T_Music where SingerId=@singerid", myconn); //为SQL语句匹配相关参数,并赋值 cmd.Parameters.AddWithValue("@id", model.Id); cmd.Parameters.AddWithValue("@singerid", model.Id); //执行相关SQL语句并返回受影响的行数,若受影响行数大于0,则表示执行成功,否者,执行失败 if (cmd.ExecuteNonQuery() > 0) { cmd.Dispose(); myconn.Dispose(); return(true); } else { cmd.Dispose(); myconn.Dispose(); return(false); } }
public bool Add(Model.T_Singer model) { //读取配置文件中的相关节点信息:数据库连接字符串 string setting = ConfigurationManager.ConnectionStrings["connstring"].ToString(); //创建数据库对象 SqlConnection myconn = new SqlConnection(setting); //打开连接 myconn.Open(); //创建命令对象,并准备好操作数据库的SQL语句 SqlCommand cmd = new SqlCommand("insert into T_Singer([Name],[Sex]) values (@name,@sex)", myconn); //为SQL语句匹配相关参数,并赋值 cmd.Parameters.AddWithValue("@name", model.Name); cmd.Parameters.AddWithValue("@sex", model.Sex); //执行相关SQL语句并返回受影响的行数,若受影响行数大于0,则表示执行成功,否者,执行失败 if (cmd.ExecuteNonQuery() > 0) { cmd.Dispose(); myconn.Dispose(); return(true); } else { cmd.Dispose(); myconn.Dispose(); return(false); } }
protected void GVSinger_RowDeleting(object sender, GridViewDeleteEventArgs e) { Model.T_Singer Singer = new Model.T_Singer(); BLL.T_Singer SingerBll = new T_Singer(); //Singer.Id = Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text); Singer.Id = Convert.ToInt32(SingerBll.Select(Convert.ToInt32(GVSinger.Rows[e.RowIndex].Cells[0].Text)).Tables[0].Rows[0][0].ToString()); if (SingerBll.Delete(Singer)) { Response.Write("DONE"); BindDate(); } else { Response.Write("FAILURE"); } }
//添加按钮,增加数据 protected void Add_Click(object sender, EventArgs e) { Model.T_Singer singer = new Model.T_Singer(); singer.Name = SingerName.Text.Trim(); singer.Sex = SingerSex.SelectedItem.ToString(); BLL.T_Singer SingerBll = new BLL.T_Singer(); if (SingerBll.Add(singer)) { Response.Write("保存成功"); BindDate(); } else { Response.Write("保存失败"); } }
//更新 public bool Update(Model.T_Singer model) { return(db.Update(model)); }
//删除 public bool Delete(Model.T_Singer model) { return(db.Delete(model)); }
//增加 public bool Add(Model.T_Singer model) { return(db.Add(model)); }