yxj
2022-04-21 74df9dfff2c73f969626a4cdcbbc27fdcb421107
BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_StdWorkTimes.cs
@@ -58,12 +58,12 @@
        private void bclk_Click(object sender, EventArgs e)
        {
            //保存列宽
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain, this.Name);
            DBUtility.Xt_BaseBillFun.SaveGrid(grdMain1, this.Name);
        }
        private void mrlk_Click(object sender, EventArgs e)
        {
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain, this.Name);
            DBUtility.Xt_BaseBillFun.DefaultGridView(grdMain1, this.Name);
        }
       
        //清空界面
@@ -184,7 +184,7 @@
        {
            //打印初始化    
            oSumGrid.NoCol = HSnoCol;
            oSumGrid.ogrdMain = grdMain;
            oSumGrid.ogrdMain = grdMain1;
            oSumGrid.oGridsum = grdSum;
            lblCaption.Text = ModName;
            this.Text = ModName;
@@ -406,39 +406,39 @@
            foreach (Model.ClsGy_StdWorkTimes_Model oSub in BillNew.DetailColl)
            {
                //
                if (i >= grdMain.RowCount - 1)
                    grdMain.Rows.Add();
                grdMain.Rows[i].Cells[HTagCol].Value = "*";
                grdMain.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString();
                if (i >= grdMain1.RowCount - 1)
                    grdMain1.Rows.Add();
                grdMain1.Rows[i].Cells[HTagCol].Value = "*";
                grdMain1.Rows[i].Cells[HMaterIDCol].Value = oSub.HMaterID.ToString();
                if (oMater.GetInfoByID(oSub.HMaterID))
                {
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
                    grdMain1.Rows[i].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber;
                    grdMain1.Rows[i].Cells[HMaterNameCol].Value = oMater.omodel.HName;
                    grdMain1.Rows[i].Cells[HMaterModelCol].Value = oMater.omodel.HModel;
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
                    grdMain1.Rows[i].Cells[HMaterNumberCol].Value = "";
                    grdMain1.Rows[i].Cells[HMaterNameCol].Value = "";
                    grdMain1.Rows[i].Cells[HMaterModelCol].Value = "";
                }
                grdMain.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString();
                grdMain1.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString();
                if (oProc.GetInfoByID(oSub.HProcID))
                {
                    grdMain.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
                    grdMain.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
                    grdMain1.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
                    grdMain1.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HProcNameCol].Value = "";
                    grdMain1.Rows[i].Cells[HProcNumberCol].Value = "";
                    grdMain1.Rows[i].Cells[HProcNameCol].Value = "";
                }
                
                grdMain.Rows[i].Cells[HStdWorkTimes].Value = oSub.HStdWorkTimes.ToString();
                grdMain.Rows[i].Cells[HUpperlimit].Value = oSub.HUpperlimit.ToString();
                grdMain.Rows[i].Cells[HLowerlimit].Value = oSub.HLowerlimit.ToString();
                grdMain.Rows[i].Cells[HUSEORGID].Value = oSub.HUSEORGID.ToString();
                grdMain.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark;
                grdMain1.Rows[i].Cells[HStdWorkTimes].Value = oSub.HStdWorkTimes.ToString();
                grdMain1.Rows[i].Cells[HUpperlimit].Value = oSub.HUpperlimit.ToString();
                grdMain1.Rows[i].Cells[HLowerlimit].Value = oSub.HLowerlimit.ToString();
                grdMain1.Rows[i].Cells[HUSEORGID].Value = oSub.HUSEORGID.ToString();
                grdMain1.Rows[i].Cells[HRemarkCol].Value = oSub.HRemark;
                i = i + 1;
            }
            //GRID允许刷新
@@ -463,20 +463,15 @@
            //明细表是否为零行
            bool b = false;
            for (int i = 0; i < grdMain.RowCount; i++)
            {
                if (!IsNullRow(i))
                {
                    b = true;
                    break;
                }
            }
            if (b == false)
            if (!IsNullRow(0))
            {
                MessageBox.Show("表体明细行不存在!请录入!", "提示");
                return false;
            }
            return true;
            else
            {
                return true;
            }
        }
        //保存单据
        private bool Sub_SaveBill()
@@ -498,21 +493,21 @@
            //
            //明细类赋值
            BillNew.DetailColl = new List<Model.ClsGy_StdWorkTimes_Model>();
            for (i = 0; i <= grdMain.RowCount - 1; i++)
            for (i = 0; i <= grdMain1.RowCount - 1; i++)
            {
                if (DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value) != 0 && DBUtility.ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value) != 0)
                if (DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value) != 0 && DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value) != 0)
                {
                    Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model();
                    oSub.HMaterID = ClsPub.isLong(grdMain.Rows[i].Cells[HMaterIDCol].Value);
                    oSub.HProcID = ClsPub.isLong(grdMain.Rows[i].Cells[HProcIDCol].Value);
                    oSub.HStdWorkTimes = ClsPub.isDoule(grdMain.Rows[i].Cells[HStdWorkTimes].Value);
                    oSub.HUpperlimit = ClsPub.isDoule(grdMain.Rows[i].Cells[HUpperlimit].Value);
                    oSub.HLowerlimit = ClsPub.isDoule(grdMain.Rows[i].Cells[HLowerlimit].Value);
                    oSub.HMaterID = ClsPub.isLong(grdMain1.Rows[i].Cells[HMaterIDCol].Value);
                    oSub.HProcID = ClsPub.isLong(grdMain1.Rows[i].Cells[HProcIDCol].Value);
                    oSub.HStdWorkTimes = ClsPub.isDoule(grdMain1.Rows[i].Cells[HStdWorkTimes].Value);
                    oSub.HUpperlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HUpperlimit].Value);
                    oSub.HLowerlimit = ClsPub.isDoule(grdMain1.Rows[i].Cells[HLowerlimit].Value);
                    oSub.HUSEORGID = ClsPub.HOrgID;
                    oSub.HStopflag = true;
                    oSub.HStopflag = false;
                    oSub.HMaker = ClsPub.CurUserName;
                    oSub.HMakeDate = DateTime.Today.ToString();
                    oSub.HRemark = ClsPub.isStrNull(grdMain.Rows[i].Cells[HRemarkCol].Value);
                    oSub.HRemark = ClsPub.isStrNull(grdMain1.Rows[i].Cells[HRemarkCol].Value);
                    BillNew.DetailColl.Add(oSub);
                }
            }
@@ -568,28 +563,28 @@
        //初始化GRID
        private void initGrid()
        {
            grdMain.ColumnCount = 22;                       //总列数
            DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name);
            grdMain1.ColumnCount = 22;                       //总列数
            DBUtility.Xt_BaseBillFun.initGridFst(grdMain1, this.Name);
            //
            grdMain.Columns[HMaterIDCol].HeaderText = "物料ID";
            grdMain.Columns[HMaterNumberCol].HeaderText = "物料代码";
            grdMain.Columns[HMaterNameCol].HeaderText = "物料名称";
            grdMain.Columns[HMaterModelCol].HeaderText = "规格型号";
            grdMain.Columns[HProcIDCol].HeaderText = "工序ID";
            grdMain.Columns[HProcNumberCol].HeaderText = "工序代码";
            grdMain.Columns[HProcNameCol].HeaderText = "工序名称";
            grdMain1.Columns[HMaterIDCol].HeaderText = "物料ID";
            grdMain1.Columns[HMaterNumberCol].HeaderText = "物料代码";
            grdMain1.Columns[HMaterNameCol].HeaderText = "物料名称";
            grdMain1.Columns[HMaterModelCol].HeaderText = "规格型号";
            grdMain1.Columns[HProcIDCol].HeaderText = "工序ID";
            grdMain1.Columns[HProcNumberCol].HeaderText = "工序代码";
            grdMain1.Columns[HProcNameCol].HeaderText = "工序名称";
            grdMain.Columns[HStdWorkTimes].HeaderText = "标准工时";
            grdMain.Columns[HUpperlimit].HeaderText = "上限比例";
            grdMain.Columns[HLowerlimit].HeaderText = "下限比例";
            grdMain.Columns[HUSEORGID].HeaderText = "组织ID";
            grdMain.Columns[HRemarkCol].HeaderText = "备注";
            grdMain1.Columns[HStdWorkTimes].HeaderText = "标准工时";
            grdMain1.Columns[HUpperlimit].HeaderText = "上限比例";
            grdMain1.Columns[HLowerlimit].HeaderText = "下限比例";
            grdMain1.Columns[HUSEORGID].HeaderText = "组织ID";
            grdMain1.Columns[HRemarkCol].HeaderText = "备注";
            //
            //隐藏列
            grdMain.Columns[HTagCol].Visible = false;
            grdMain.Columns[HProcIDCol].Visible = false;
            grdMain.Columns[HMaterIDCol].Visible = false;
            grdMain.Columns[HUSEORGID].Visible = false;
            grdMain1.Columns[HTagCol].Visible = false;
            grdMain1.Columns[HProcIDCol].Visible = false;
            grdMain1.Columns[HMaterIDCol].Visible = false;
            grdMain1.Columns[HUSEORGID].Visible = false;
            //可编辑列
            string sAllowCol = HMaterNumberCol.ToString() +
                            "," + HProcNumberCol.ToString() +
@@ -664,7 +659,7 @@
        //是否是空行
        private bool IsNullRow(int Row)
        {
            if (ClsPub.isInt(grdMain.Rows[Row].Cells[HMaterIDCol].Value) == 0)
            if (ClsPub.isInt(grdMain1.Rows[Row].Cells[HMaterIDCol].Value) == 0)
            {
                return true;
            }
@@ -708,26 +703,26 @@
                        {
                            case HMaterNumberCol:
                                //BLL.ClsBaseSelect_K3.SetGridByMater_K3(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0);
                                BLL.ClsBaseSelect_InterFace.SetGridByMater(grdMain, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0);
                                BLL.ClsBaseSelect_InterFace.SetGridByMater(grdMain1, sRow, HMaterIDCol, HMaterNumberCol, HMaterNameCol, HMaterModelCol, 0, 0, 0);
                                if (rbHSelectCus.Checked)
                                {
                                    grdMain.Rows[sRow].Cells[HProcIDCol].Value = txtHProcID.Tag.ToString();
                                    grdMain.Rows[sRow].Cells[HProcNameCol].Value = txtHProcName.Text.Trim();
                                    grdMain.Rows[sRow].Cells[HProcNumberCol].Value = txtHProcID.Text.Trim();
                                    grdMain1.Rows[sRow].Cells[HProcIDCol].Value = txtHProcID.Tag.ToString();
                                    grdMain1.Rows[sRow].Cells[HProcNameCol].Value = txtHProcName.Text.Trim();
                                    grdMain1.Rows[sRow].Cells[HProcNumberCol].Value = txtHProcID.Text.Trim();
                                }
                                oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HMaterNumberCol].Value);
                                oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain1.Rows[sRow].Cells[HMaterNumberCol].Value);
                                break;
                            case HProcNumberCol:
                                //BLL.ClsBaseSelect.SetGridByProc(grdMain, sRow, HProcIDCol, HProcNumberCol, HProcNameCol);
                                BLL.ClsBaseSelect_InterFace.SetGridByProc(grdMain, sRow, HProcIDCol, HProcNumberCol, HProcNameCol);
                                BLL.ClsBaseSelect_InterFace.SetGridByProc(grdMain1, sRow, HProcIDCol, HProcNumberCol, HProcNameCol);
                                if (rbHSelectMater.Checked)
                                {
                                    grdMain.Rows[sRow].Cells[HMaterIDCol].Value = txtHMaterID.Tag.ToString();
                                    grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = txtHMaterID.Text.Trim();
                                    grdMain.Rows[sRow].Cells[HMaterNameCol].Value = txtHMaterName.Text.Trim();
                                    grdMain.Rows[sRow].Cells[HMaterModelCol].Value = txtHMaterModel.Text.Trim();
                                    grdMain1.Rows[sRow].Cells[HMaterIDCol].Value = txtHMaterID.Tag.ToString();
                                    grdMain1.Rows[sRow].Cells[HMaterNumberCol].Value = txtHMaterID.Text.Trim();
                                    grdMain1.Rows[sRow].Cells[HMaterNameCol].Value = txtHMaterName.Text.Trim();
                                    grdMain1.Rows[sRow].Cells[HMaterModelCol].Value = txtHMaterModel.Text.Trim();
                                }
                                oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[sRow].Cells[HProcNumberCol].Value);
                                oEdit.Text = DBUtility.ClsPub.isStrNull(grdMain1.Rows[sRow].Cells[HProcNumberCol].Value);
                                break;
                            default:
                                break;
@@ -745,7 +740,7 @@
        DataGridViewTextBoxEditingControl EditingControl;
        private void grdMain_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
        {
            int i = grdMain.CurrentCell.ColumnIndex;
            int i = grdMain1.CurrentCell.ColumnIndex;
            if (DBUtility.Xt_BaseBillFun.AllowEdit(grdStatus, oSumGrid, i))
            {
                e.Cancel = true;
@@ -783,7 +778,7 @@
        private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            if (grdMain.CurrentCell != null)
            if (grdMain1.CurrentCell != null)
            {
                if (e.Control is DataGridViewTextBoxEditingControl)
                {
@@ -797,7 +792,7 @@
        private void EditingControl_KeyDown(object sender, KeyEventArgs e)
        {
            //业务处理 
            Sub_GridKey(e.KeyValue, grdMain.CurrentRow.Index, grdMain.CurrentCell.ColumnIndex, EditingControl);
            Sub_GridKey(e.KeyValue, grdMain1.CurrentRow.Index, grdMain1.CurrentCell.ColumnIndex, EditingControl);
        }
        private void grdMain_RowHeadersWidthChanged(object sender, EventArgs e)