Beispiel #1
0
        protected void delete_Click(object sender, EventArgs e)
        {
            List <string> eng_ID             = new List <string>();
            string        strID              = "";
            int           rowEffected        = 0;
            string        sql_checkEngidUsed = "";

            foreach (RepeaterItem labID in Reproject1.Items)
            {
                CheckBox chk = (CheckBox)labID.FindControl("CheckBox1");
                if (chk.Checked)
                {
                    //查找该CheckBox所对应纪录的id号,在labID中
                    strID = ((Label)labID.FindControl("eng_ID")).Text;
                    sql_checkEngidUsed = "select TSA_STFORCODE from TBPM_TCTSASSGN where TSA_STFORCODE='" + strID + "'";
                    SqlDataReader dr = DBCallCommon.GetDRUsingSqlText(sql_checkEngidUsed);
                    if (dr.HasRows)
                    {
                        Response.Write("<script>alert('工程代号:【" + strID + "】已被引用,无法删除!!!')</script>");
                        return;
                    }
                    eng_ID.Add(strID);
                }
            }
            lbl_Info.Text += strID;
            foreach (string id in eng_ID)
            {
                DBCallCommon.DeleteENGByENG_ID(id);
                rowEffected++;
            }
            //防止刷新
            Response.Redirect("enginfo.aspx?q=1");
            Response.Write("<script>alert('数据已删除!!!\\r\\r提示:共删除" + rowEffected + "条记录')</script>");
        }
Beispiel #2
0
        protected void delete_Click(object sender, EventArgs e)
        {
            List <string> eng_ID      = new List <string>();
            string        strID       = "";
            int           rowEffected = 0;

            foreach (RepeaterItem labID in Reproject1.Items)
            {
                CheckBox chk = (CheckBox)labID.FindControl("CheckBox1");
                if (chk.Checked)
                {
                    //查找该CheckBox所对应纪录的id号,在labID中
                    strID = ((Label)labID.FindControl("eng_ID")).Text;
                    eng_ID.Add(strID);
                }
            }
            lbl_Info.Text += strID;
            foreach (string id in eng_ID)
            {
                DBCallCommon.DeleteENGByENG_ID(id);
                rowEffected++;
            }
            //防止刷新
            Response.Redirect("enginfo.aspx?q=1");
        }