智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2023-09-25 45900455b491ca9282f8debaeef06b1e258928ee 
 BLL/ϵͳ¹ÜÀí/Óû§¹ÜÀí/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();


        }


    }


}