From fc8127e549c87edefe168cf48ebbfa90cbe62b84 Mon Sep 17 00:00:00 2001 From: yxj <yxj@hz-kingdee.com> Date: 星期六, 23 九月 2023 11:04:10 +0800 Subject: [PATCH] 用户类型设置 --- BLL/系统管理/用户管理/Xt_User.cs | 21 +++++++++++++++++++-- 1 files changed, 19 insertions(+), 2 deletions(-) diff --git "a/BLL/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_User.cs" "b/BLL/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_User.cs" index 46fdffb..35a7379 100644 --- "a/BLL/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_User.cs" +++ "b/BLL/\347\263\273\347\273\237\347\256\241\347\220\206/\347\224\250\346\210\267\347\256\241\347\220\206/Xt_User.cs" @@ -78,7 +78,16 @@ { SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); DataSet oDs = new DataSet(); - oDs = oCn.RunProcReturn("select * from h_v_Gy_Czygl order by 用户", "h_v_Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo); + string sWhere=""; + if(rbHUserType1.Checked==true) + { + sWhere = "" + "用户类型 = '内部账号' "; + } + else + { + sWhere = "" + "用户类型 = '供应商账号' "; + } + oDs = oCn.RunProcReturn("select * from h_v_Gy_Czygl where " + sWhere + " order by 用户", "h_v_Gy_Czygl", ref DBUtility.ClsPub.sExeReturnInfo); if (oDs == null) { MessageBox.Show("显示失败!原因:" + DBUtility.ClsPub.sExeReturnInfo); @@ -363,7 +372,15 @@ } } - + private void rbHUserType1_CheckedChanged(object sender, EventArgs e) + { + Display1(); + } + private void radioButton1_CheckedChanged(object sender, EventArgs e) + { + + Display1(); + } } } \ No newline at end of file -- Gitblit v1.9.1