本文整理汇总了C#中HyoaClass.Hyoa_global.ExcuteSQL_USER方法的典型用法代码示例。如果您正苦于以下问题：C# HyoaClass.Hyoa_global.ExcuteSQL_USER方法的具体用法？C# HyoaClass.Hyoa_global.ExcuteSQL_USER怎么用？C# HyoaClass.Hyoa_global.ExcuteSQL_USER使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类HyoaClass.Hyoa_global的用法示例。
在下文中一共展示了HyoaClass.Hyoa_global.ExcuteSQL_USER方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Button_Save_Click
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>");
}
}示例2: Button_Zx_Click
//执行
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;
}