protected void Button_Save_Click(object sender, EventArgs e) { string ls_olduserid = this.txtolduserid.Text; string ls_newuserid = this.txtnewuserid.Text; if (ls_olduserid != "" && ls_newuserid != "") { HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); string sql = "update hyt_user set hy_userid='" + ls_newuserid + "' where hy_userid='" + ls_olduserid + "'"; Hyoa_global.ExcuteSQL_USER(sql); sql = "update hyt_user set hy_loginuid='" + ls_newuserid + "' where hy_loginuid='" + ls_olduserid + "'"; Hyoa_global.ExcuteSQL_USER(sql); sql = "update hyt_roleuser set hy_userid='" + ls_newuserid + "' where hy_userid='" + ls_olduserid + "'"; Hyoa_global.ExcuteSQL_BASE(sql); sql = "update hyt_flowtacheuser set hy_userid='" + ls_newuserid + "' where hy_userid='" + ls_olduserid + "'"; Hyoa_global.ExcuteSQL_BASE(sql); sql = "update hyt_dbsy set hy_dbrid='" + ls_newuserid + "' where hy_dbrid='" + ls_olduserid + "'"; Hyoa_global.ExcuteSQL(sql); sql = "update hyt_dbsy set hy_fsrid='" + ls_newuserid + "' where hy_fsrid='" + ls_olduserid + "'"; Hyoa_global.ExcuteSQL(sql); sql = "update hyp_flowhistoryinfo_cy set hy_cyrid=replace(hy_cyrid,'" + ls_olduserid + "','" + ls_newuserid + "') where ','+hy_cyrid+',' like '%," + ls_olduserid + ",%' "; Hyoa_global.ExcuteSQL(sql); sql = "update hyp_flowhistoryinfo_cl set hy_clrid=replace(hy_clrid,'" + ls_olduserid + "','" + ls_newuserid + "') where ','+hy_clrid+',' like '%," + ls_olduserid + ",%' "; Hyoa_global.ExcuteSQL(sql); sql = "update hyp_flowhistoryinfo_cl set hy_cyrid=replace(hy_cyrid,'" + ls_olduserid + "','" + ls_newuserid + "') where ','+hy_cyrid+',' like '%," + ls_olduserid + ",%'"; Hyoa_global.ExcuteSQL(sql); Response.Write("<script>alert('更改成功');</script>"); } }
//执行 protected void Button_Zx_Click(object sender, EventArgs e) { string ls_return = ""; if (txtsql2.Value == "") { ls_return = "请填写执行语句"; } if (ddldbconn.SelectedValue == "") { ls_return = "请选择连接"; } HyoaClass.Hyoa_global Hyoa_global = new HyoaClass.Hyoa_global(); if (ddldbconn.SelectedValue == "base") { if (Hyoa_global.ExcuteSQL_BASE(txtsql2.Value) == true) ls_return = "执行成功"; else ls_return = "执行失败"; } if (ddldbconn.SelectedValue == "pro") { if (Hyoa_global.ExcuteSQL(txtsql2.Value) == true) ls_return = "执行成功"; else ls_return = "执行失败"; } if (ddldbconn.SelectedValue == "user") { if (Hyoa_global.ExcuteSQL_USER(txtsql2.Value) == true) ls_return = "执行成功"; else ls_return = "执行失败"; } lbljg.Text = ls_return; }