用户信息增加工序流水号

zgq

2021-01-21 c40eecdf100bc5fb5007abbfb6dbe355e7d78f6e

用户信息增加工序流水号

 Model/»ù´¡×ÊÁÏ/ClsGy_Process_Model.cs

@@ -19,5 +19,6 @@
        public double HFixPrice;//         money        //班产定额    (8小时工资)        New
        public double HOverFixPrice;//        money    //加班补贴定额    ï¼ˆ8小时工资）            New
        public Int64 HProcMulID;//New
        public string HProcNo;
    }
}

 SCM/»ù´¡×ÊÁÏ/ClsIF_Process_View.cs

@@ -20,11 +20,11 @@
        {
            base.MvarReportTitle = "工序设置";
            base.MvarItemKey = "h_v_IF_Process";
            base.SQLName = "Select HItemID,HNumber å·¥åºä»£ç ,HName å·¥åº from h_v_IF_Process where HStopflag=0   ";
            base.SQLName = "Select HItemID,HNumber å·¥åºä»£ç ,HName å·¥åº,HProcNo å·¥åºå· from h_v_IF_Process where HStopflag=0   ";
            base.SQLOrder = " Order by HItemID  ";
            base.SQLList = "Select top 100 * from " + MvarItemKey + " ";
            //下拉SQL
            base.SQLNameForDown = " Select top 30 HItemID,HNumber å·¥åºä»£ç ,HName å·¥åº from h_v_IF_Process ";
            base.SQLNameForDown = " Select top 30 HItemID,HNumber å·¥åºä»£ç ,HName å·¥åº,HProcNo å·¥åºå· from h_v_IF_Process ";
            base.SQLOrderForDown = "  Order by HNumber ";
            base.SQLWhereForDown = "  where HStopflag=0  ";
        }
@@ -92,6 +92,7 @@
                omodel.HStopflag = DBUtility.ClsPub.isBool(DS.Tables[0].Rows[0]["HStopflag"]);
                omodel.HBarCode = DS.Tables[0].Rows[0]["HBarCode"].ToString().Trim();
                omodel.HRemark = DBUtility.ClsPub.isStrNull(DS.Tables[0].Rows[0]["HRemark"]);
                omodel.HProcNo = DS.Tables[0].Rows[0]["HProcNo"].ToString().Trim();
                return true;
 
            }
@@ -149,6 +150,7 @@
                    oModel.HItemID = Pub_Class.ClsPub.isLong(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[0].Value);
                    oModel.HNumber = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[1].Value);
                    oModel.HName = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[2].Value);
                    oModel.HRemark = Pub_Class.ClsPub.isStrNull(ofrm.grdShow.Rows[ofrm.grdShow.CurrentRow.Index].Cells[3].Value);
                }
                else
                {

 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,HGroup,HGroupID,HProc,HProcNo,HSource,HSourceID,HWorkCenter,HWorkCenterID 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);
@@ -237,11 +238,12 @@
                    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]["HProcNo"].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)
@@ -373,7 +375,8 @@
                    ",HGroup='" + textHGroupID.Text.ToString() + "'" +
                    ",HGroupID=" + ClsPub.isLong(textHGroupID.Tag).ToString() +
                    ",HProc='" + textHProcNo.Text.ToString() +"'"+
                    ",HProcNo='" + textHProcNo.Tag.ToString() +"'"+
                    ",HProcName='" + textHProcNo.Tag.ToString() +"'"+
                    ",HProcNo='" + HProcNo + "'" +
                    ",HWorkCenter='" + textHWorkCenterID.Text.ToString() + "'" +
                    ",HWorkCenterID=" + ClsPub.isLong(textHWorkCenterID.Tag).ToString() +
                    ",HSource='" + textHSourceID.Text.ToString() + "'" +
@@ -386,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; 
            }
        }
        //单据完整性判断
@@ -738,6 +741,7 @@
            {
                this.textHProcNo.Text = oEmp.oModel.HName;
                this.textHProcNo.Tag = oEmp.oModel.HNumber;
                HProcNo = oEmp.oModel.HRemark;
            }
            else
            {