protected void btndelinfo_Click(object sender, EventArgs e) { HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); String[] v_uids = this.txtuids.Value.Split(','); for (var i = 0; i < v_uids.Length; i++) { if (v_uids[i] != "") { Hyoa_flowfield.ID = v_uids[i]; Hyoa_flowfield.Delete(); } } this.txtuids.Value = ""; //DataPlay(1); DataPlay(System.Int32.Parse(this.curpage.Text)); }
protected void btndelinfo_Click(object sender, EventArgs e) { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); HyoaClass.Hyoa_flowfield Hyoa_flowfield = new HyoaClass.Hyoa_flowfield(); String[] v_uids = this.txtuids.Value.Split(','); for (var i = 0; i < v_uids.Length; i++) { if (v_uids[i] != "") { //找到字段配置信息 DataTable dt = Hyoa_flowfield.Getflowfield(v_uids[i]); //删除SQL中的字段 string sql = "ALTER TABLE hyc_" + this.txttableid.Value; sql += " DROP COLUMN hyc_" + dt.Rows[0]["hy_fieldid"].ToString(); Hyoa_global.ExcuteSQL(sql); Hyoa_flowfield.ID = v_uids[i]; Hyoa_flowfield.Delete(); } } this.txtuids.Value = ""; //DataPlay(1); DataPlay(System.Int32.Parse(this.curpage.Text)); }