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