用户类型设置

yxj

2023-09-23 fc8127e549c87edefe168cf48ebbfa90cbe62b84

 BLL/系统管理/用户管理/Xt_UserNew.cs

@@ -27,6 +27,7 @@
            lblError.Text = "";
            LbYes.Items.Clear();
            LbNo.Items.Clear();
            cmbHUserType.SelectedIndex = 0;
            //鍔犺浇缁勭粐淇℃伅
            Sub_AddOrdList();
            Init();
@@ -185,7 +186,7 @@
            DAL.ClsIF_Supplier_View oSup = new DAL.ClsIF_Supplier_View();
            try
            {
                oDs = oCn.RunProcReturn("select Czybm,Czymc,Explain,HEmpID,HK3UserID,HCloudUserName,HCloudUserPsd,HKeeperID,HKeeper,HSecManagerID,HSecManager,HSellManID,HSellMan,HDeptID,HDept,HWhID,HWHName,HSCWHID,HSCWHName,HSupID,HSupName,HUSEORGID from Gy_Czygl where Czybm='" + sCzybm + "'", "Gy_Czygl", ref ClsPub.sExeReturnInfo);
                oDs = oCn.RunProcReturn("select Czybm,Czymc,Explain,HEmpID,HK3UserID,HCloudUserName,HCloudUserPsd,HKeeperID,HKeeper,HSecManagerID,HSecManager,HSellManID,HSellMan,HDeptID,HDept,HWhID,HWHName,HSCWHID,HSCWHName,HSupID,HSupName,HUSEORGID,HUserType from Gy_Czygl where Czybm='" + sCzybm + "'", "Gy_Czygl", ref ClsPub.sExeReturnInfo);
                if (oDs == null)
                {
                    MessageBox.Show("鏄剧ず澶辫触锛佸師鍥狅細" + ClsPub.sExeReturnInfo);
@@ -299,6 +300,10 @@
                    }
                    txtHCloudUserName.Text = oDs.Tables[0].Rows[0]["HCloudUserName"].ToString().Trim();
                    txtHCloudUserPsd.Text = oDs.Tables[0].Rows[0]["HCloudUserPsd"].ToString().Trim();
                    if (oDs.Tables[0].Rows[0]["HUserType"].ToString() != "")
                    {
                        cmbHUserType.Text = oDs.Tables[0].Rows[0]["HUserType"].ToString().Trim();
                    }
                }
            }
            catch (Exception e)
@@ -386,14 +391,14 @@
                    ",HKeeperID,HKeeper,HSecManagerID,HSecManager " +
                    ",HSellManID,HSellMan,HDeptID,HDept " +
                    ",HWhID,HWHName,HSupID,HSupName " +
                    ",HSCWHID,HSCWHName " +
                    ",HSCWHID,HSCWHName,HUserType " +
                    ",HCloudUserName,HCloudUserPsd,HUSEORGID)" +
                    "values ("
                    + "'" + txtCzybm.Text.ToString() + "','" + txtCzymc.Text.ToString() + "','" + ClsPub.StrToPsd(txtCzymm.Text.ToString()) + "','" + txtExplain.Text.ToString() + "'," + ClsPub.isLong(txtHEmpID.Tag).ToString() + "," + ClsPub.isLong(txtHK3UserID.Tag).ToString() +
                    "," + ClsPub.isLong(txtHKeeperID.Tag).ToString() + ",'" + txtHKeeperID.Text.ToString() + "'," + ClsPub.isLong(txtHSecManagerID.Tag).ToString() + ",'" + txtHSecManagerID.Text.ToString() + "'" +
                    "," + ClsPub.isLong(txtHSellManID.Tag).ToString() + ",'" + txtHSellManID.Text.ToString() + "'," + ClsPub.isLong(txtHDeptID.Tag).ToString() + ",'" + txtHDeptID.Text.ToString() + "'" +
                    "," + ClsPub.isLong(txtHWhID.Tag).ToString() + ",'" + txtHWhID.Text.ToString() + "'," + ClsPub.isLong(txtHSupID.Tag).ToString() + ",'" + txtHSupID.Text.ToString() + "'" +
                    "," + ClsPub.isLong(txtHSCWH.Tag).ToString() + ",'" + txtHSCWH.Text.ToString() + "'" +
                    "," + ClsPub.isLong(txtHSCWH.Tag).ToString() + ",'" + txtHSCWH.Text.ToString() + "'" + ",'" + cmbHUserType.Text + "'" +
                    ",'" + txtHCloudUserName.Text.ToString() + "','" + txtHCloudUserPsd.Text.ToString() + "'," + HOrgID +
                    ")");
                oDs = oCn.RunProcReturn("Select * from  Gy_Czygl where Czybm='" + txtCzybm.Text.ToString()+"'", "Gy_Czygl");
@@ -433,6 +438,7 @@
                    ",HSupName='" + txtHSupID.Text.ToString() + "'" +
                    ",HCloudUserName='" + txtHCloudUserName.Text.ToString() + "'" +
                    ",HCloudUserPsd='" + txtHCloudUserPsd.Text.ToString() + "'" +
                    ",HUserType='" + cmbHUserType.Text.ToString() + "'" +
                    ",HUSEORGID=" + HOrgID.ToString() +
                    "where Czybm='" + Czybm + "'");
                //