protected void Btn_Do_Click(object sender, EventArgs e)
{
//www.flyso.cn
string keyValues = "";
for (int i = 0; i < Repeater.Items.Count; i++)
{
CheckBox chkbox = (CheckBox)Repeater.Items[i].FindControl("op");
if (chkbox!=null)
{
if (chkbox.Checked == true)
{
string key = ((Label)Repeater.Items[i].Controls[2]).Text + ",";
keyValues = keyValues + key;
}
}
}
if (keyValues != "")
{
keyValues = keyValues.Substring(0, keyValues.Length - 1);
SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["sqlcon"]);
con.Open();
string nowtime = DateTime.Now.ToString();
string op = ddl_op.Text.ToString();
string cmdsql = "";
if (op == "del")
{
cmdsql= "delete from " + tablename + " Where id in (" + keyValues + ")"; //生成Sql 语句。
}
//Response.Write(cmdsql);
//return;
SqlCommand cmd = new SqlCommand(cmdsql, con);
cmd.ExecuteNonQuery(); //执行sql语句。
con.Close();
//得到当前页参数以便返回
string str_Return = GetStrReturn().ToString();
if (str_Return != "")
{
str_Return = str_Return.Replace("&", pagename + "?");
}
else
{
str_Return = pagename;
}
Response.Write(ShowOPInfo("操作成功!", str_Return));
}
else
{
//得到当前页参数以便返回
string str_Return = GetStrReturn().ToString();
if (str_Return != "")
{
str_Return = str_Return.Replace("&", pagename+"?");
}
else
{
str_Return = pagename;
}
Response.Write(ShowOPInfo("请选择操作项目!", str_Return));
}
}