Beispiel #1
0
 protected void btn_back_Click(object sender, EventArgs e)
 {
     string sqlUpdate = "";
     HyoaClass.Hyoa_global hyoaGlobal = new Hyoa_global();
     string[] arryDocid = this.txtuids.Value.Split(',');
     string[] arryHtmlId = { "Tablesyyhfwxy_new", "Tableszdsywfwht_new", "Tablejwdscsxy_new", "Tablejwdsjm", "Tablesjcsfwht_new", "Tablekdjrht_new", "Tablegcsght", "Tablesjgdcsfwht_new", "Tablesjtxyyhzxy_new", "Tablesyyhfwxy", "Tablejdhazfwht", "TableVODfwxy", "Tableffpdfwht", "TableDVBazfwdght", "Tablejwdsjsxy", "Tablejwdscsxy", "Tablekdjrht", "Tablesjcsfwht", "Tablesjgdcsfwht", "Tablesjtxyyhzxy", "Tablezdyht", "Tableqtht", "Tablegxhzhht" };
     if (this.st_bdmc.Value != "")
     {
         for (int i = 0; i < arryDocid.Length; i++)
         {
             sqlUpdate += " update hyc_" + this.st_bdmc.Value + " set hy_iftx='' where docid ='" + arryDocid[i] + "' ";
             hyoaGlobal.ExcuteSQL(sqlUpdate);
         }
     }
     else
     {
         for (int j = 0; j < arryHtmlId.Length; j++)
         {
             for (int i = 0; i < arryDocid.Length; i++)
             {
                 sqlUpdate += " update hyc_" + arryHtmlId[j] + " ";
                 sqlUpdate += "set hy_iftx='' where docid ='" + arryDocid[i] + "' ";
                 hyoaGlobal.ExcuteSQL(sqlUpdate);
             }
         }
     }
     DataPlay();
 }