Repeater 多选操作

时间:2015/11/23 14:40:00来源:互联网 作者:flyso 点击: 1047 次

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

    }

Copyright © 2005 - 2016 flyso.cn. 飞搜 版权所有 鄂ICP备11002783号-3