protected void BtnDel_Click(object sender, EventArgs e)
{
string sqlText = "delete from tb_inf where id=@id";
string connStr = WebConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
foreach (GridViewRow row in GridView1.Rows)
{
CheckBox chkSel = (CheckBox)row.FindControl("ChkSel");
if (chkSel.Checked)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlText;
cmd.Parameters.AddWithValue("@id", row.Cells[1].Text);
conn.Open();
int rowsAffected = cmd.ExecuteNonQuery();
conn.Close();
if (rowsAffected > 0)
{
StrHelper.Alert("删除成功！");
}
else
{
StrHelper.Alert("删除失败！");
}
}
}
}
DisplayData();
}
protected void BtnUpd_Click(object sender, EventArgs e)
{
string sqlText = "Update tb_inf set issueDate=@UpdateTime where id=@id";
string connStr = WebConfigurationManager.ConnectionStrings["ConnStr"].ConnectionString;
for (int i = 0; i <= GridView1.Rows.Count - 1; i++)
{
CheckBox chkSel = (CheckBox)GridView1.Rows[i].FindControl("ChkSel");
if (chkSel != null)
{
if (chkSel.Checked)
{
using (SqlConnection conn = new SqlConnection(connStr))
{
SqlCommand cmd = conn.CreateCommand();
cmd.CommandText = sqlText;
cmd.Parameters.AddWithValue("@UpdateTime", DateTime.Now);
cmd.Parameters.AddWithValue("@id", GridView1.Rows[i].Cells[1].Text);
conn.Open();
int rowsAffected = cmd.ExecuteNonQuery();
conn.Close();
if (rowsAffected > 0)
{
StrHelper.Alert("更新成功！");
}
else
{
StrHelper.Alert("更新失败！");
}
}
}
}
}
DisplayData();
}