Merge branch 'master' of http://101.37.171.70:10101/r/YqnMes

ouyangqing

2021-01-22 6b42ce7bf82339904e817f4f57e67ebaa5dc5200

 SCM/ϵͳ¹ÜÀí/Xt_UserNew.cs

@@ -20,6 +20,7 @@
        public Pub_Class.ClsPub.Enum_InputMode InputMode;  //录入状态标志(0-非录入状态 1-增加 2-修改)
        public string Czybm;
        public Int64 HOrgID = -1;
        public string HProcNo = "";
        //窗体加载
        private void Xt_UserNew_Load(object sender, EventArgs e)
        {
@@ -178,7 +179,7 @@
            SCM.ClsXt_ORGANIZATIONS_View oORG = new ClsXt_ORGANIZATIONS_View();
            try
            {
                oDs = oWeb.getDataSetBySQL("select Czybm,Czymc,Explain,HEmpID,HK3UserID,HCloudUserName,HCloudUserPsd,HKeeperID,HKeeper,HSecManagerID,HSecManager,HSellManID,HSellMan,HDeptID,HDept,HWhID,HWHName,HSupID,HSupName,HUSEORGID from Gy_Czygl where Czybm='" + sCzybm + "'", "Gy_Czygl", ref ClsPub.sExeReturnInfo);
                oDs = oWeb.getDataSetBySQL("select Czybm,Czymc,Explain,HEmpID,HK3UserID,HCloudUserName,HCloudUserPsd,HKeeperID,HKeeper,HSecManagerID,HSecManager,HSellManID,HSellMan,HDeptID,HDept,HWhID,HWHName,HSupID,HSupName,HUSEORGID,HGroup,HGroupID,HProc,HProcNo,HProcName,HSource,HSourceID,HWorkCenter,HWorkCenterID from Gy_Czygl where Czybm='" + sCzybm + "'", "Gy_Czygl", ref ClsPub.sExeReturnInfo);
                if (oDs == null)
                {
                    MessageBox.Show("显示失败！原因：" + ClsPub.sExeReturnInfo);
@@ -234,6 +235,15 @@
                    txtHSupID.Tag = oDs.Tables[0].Rows[0]["HSupID"].ToString().Trim();
                    txtHCloudUserName.Text = oDs.Tables[0].Rows[0]["HCloudUserName"].ToString().Trim();
                    txtHCloudUserPsd.Text = oDs.Tables[0].Rows[0]["HCloudUserPsd"].ToString().Trim();
                    textHGroupID.Text = oDs.Tables[0].Rows[0]["HGroup"].ToString().Trim();
                    textHGroupID.Tag = oDs.Tables[0].Rows[0]["HGroupID"].ToString().Trim();
                    textHProcNo.Text = oDs.Tables[0].Rows[0]["HProc"].ToString().Trim();
                    textHProcNo.Tag = oDs.Tables[0].Rows[0]["HProcName"].ToString().Trim();
                    textHWorkCenterID.Text = oDs.Tables[0].Rows[0]["HWorkCenter"].ToString().Trim();
                    textHWorkCenterID.Tag = oDs.Tables[0].Rows[0]["HWorkCenterID"].ToString().Trim();
                    textHSourceID.Text = oDs.Tables[0].Rows[0]["HSource"].ToString().Trim();
                    textHSourceID.Tag = oDs.Tables[0].Rows[0]["HSourceID"].ToString().Trim();
                    HProcNo = oDs.Tables[0].Rows[0]["HProcNo"].ToString().Trim();
                }
            }
            catch (Exception e)
@@ -362,6 +372,15 @@
                    ",HCloudUserName='" + txtHCloudUserName.Text.ToString() + "'" +
                    ",HCloudUserPsd='" + txtHCloudUserPsd.Text.ToString() + "'" +
                    ",HUSEORGID=" + HOrgID.ToString() +
                    ",HGroup='" + textHGroupID.Text.ToString() + "'" +
                    ",HGroupID=" + ClsPub.isLong(textHGroupID.Tag).ToString() +
                    ",HProc='" + textHProcNo.Text.ToString() +"'"+
                    ",HProcName='" + textHProcNo.Tag.ToString() +"'"+
                    ",HProcNo='" + HProcNo + "'" +
                    ",HWorkCenter='" + textHWorkCenterID.Text.ToString() + "'" +
                    ",HWorkCenterID=" + ClsPub.isLong(textHWorkCenterID.Tag).ToString() +
                    ",HSource='" + textHSourceID.Text.ToString() + "'" +
                    ",HSourceID=" + ClsPub.isLong(textHSourceID.Tag).ToString() +
                    "where Czybm='" + Czybm + "'", ref DBUtility.ClsPub.sExeReturnInfo);
                //
                oWeb.getRunProc("delete from  System_UserGroupInfo where UserId='" + Czybm + "'", ref DBUtility.ClsPub.sExeReturnInfo);
@@ -370,7 +389,7 @@
                    oWeb.getRunProc("insert into  System_UserGroupInfo (GroupId,UserId) values (" + ClsPub.isLong(Get_Code(this.LbYes.Items[i].ToString())) + ",'" + Czybm + "')", ref DBUtility.ClsPub.sExeReturnInfo);
                }
                lblError.Text = "* ä¿®æ”¹æˆåŠŸï¼";
                tabControl1.SelectedIndex = 0;
                tabControl1.SelectedIndex = 0; 
            }
        }
        //单据完整性判断
@@ -693,8 +712,76 @@
        }



        #endregion

        private void cmdHGroupID_Click(object sender, EventArgs e)
        {
            SCM.ClsGy_Group_View oEmp = new SCM.ClsGy_Group_View();
            string DeWhere = "";
            DeWhere = " ";
            if (oEmp.RefreshView(DeWhere))
            {
                this.textHGroupID.Text = oEmp.oModel.HName;
                this.textHGroupID.Tag = oEmp.oModel.HItemID.ToString();
            }
            else
            {
                this.textHGroupID.Text = "";
                this.textHGroupID.Tag = 0;
            }
        }

        private void cmdHProcNo_Click(object sender, EventArgs e)
        {
            SCM.ClsIF_Process_View oEmp = new SCM.ClsIF_Process_View();
            string DeWhere = "";
            DeWhere = " ";
            if (oEmp.RefreshView(DeWhere))
            {
                this.textHProcNo.Text = oEmp.oModel.HName;
                this.textHProcNo.Tag = oEmp.oModel.HNumber;
                HProcNo = oEmp.oModel.HRemark;
            }
            else
            {
                this.textHProcNo.Text = "";
                this.textHProcNo.Tag = 0;
            }
        }

        private void cmdHSourceID_Click(object sender, EventArgs e)
        {
            SCM.ClsIF_Source_View oEmp = new SCM.ClsIF_Source_View();
            string DeWhere = "";
            DeWhere = " ";
            if (oEmp.RefreshView(DeWhere))
            {
                this.textHSourceID.Text = oEmp.oModel.HName;
                this.textHSourceID.Tag = oEmp.oModel.HItemID.ToString();
            }
            else
            {
                this.textHSourceID.Text = "";
                this.textHSourceID.Tag = 0;
            }
        }

        private void cmdHWorkCenterID_Click(object sender, EventArgs e)
        {
            SCM.ClsIF_WorkCenter_View oEmp = new SCM.ClsIF_WorkCenter_View();
            string DeWhere = "";
            DeWhere = " ";
            if (oEmp.RefreshView(DeWhere))
            {
                this.textHWorkCenterID.Text = oEmp.oModel.HName;
                this.textHWorkCenterID.Tag = oEmp.oModel.HItemID.ToString();
            }
            else
            {
                this.textHWorkCenterID.Text = "";
                this.textHWorkCenterID.Tag = 0;
            }
        }
    }
}