即时库存列表

王 垚

2022-04-22 0e0a2b76c2df34e5503ba312faff14d32c8a794c

 BaseSet/¹«ÓÃ×ÊÁÏ/ÆäËû»ù´¡×ÊÁÏ/Gy_StdWorkTimes.cs

@@ -46,8 +46,9 @@
        public DAL.ClsGy_StdWorkTimes_Ctl BillNew = new DAL.ClsGy_StdWorkTimes_Ctl();
        public Model.ClsGy_StdWorkTimes_Model BillOld = new Model.ClsGy_StdWorkTimes_Model();
        ClsGridViewSum oSumGrid = new ClsGridViewSum();
        SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();

        

        #region å›ºå®šä»£ç 
        //合计
        private void Total()
@@ -58,12 +59,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,10 +185,13 @@
        {
            //打印初始化    
            oSumGrid.NoCol = HSnoCol;
            oSumGrid.ogrdMain = grdMain;
            oSumGrid.ogrdMain = grdMain1;
            oSumGrid.oGridsum = grdSum;
            lblCaption.Text = ModName;
            textBox1.Hide();
            textBox2.Hide();
            this.Text = ModName;
           
        }


@@ -236,7 +240,44 @@
        //修改按纽
        private void xg_Click(object sender, EventArgs e)
        {
            this.Sub_EditBill();
            try
            {
                if (int.Parse(txtHStdWorkTimes.Text)<=0)
                {
                    MessageBox.Show("标准工时必须大于0", "提示");
                }
                if (int.Parse(txtHUpperlimit.Text) <= 0)
                {
                    MessageBox.Show("上限比例必须大于0", "提示");
                }
                if (int.Parse(txtHLowerlimit.Text) <= 0)
                {
                    MessageBox.Show("下线比例必须大于0", "提示");
                }
                oCn.BeginTran();
                string sql = string.Format(@"Update Gy_StdWorkTimes set" +
                            " HMaterID=" + textBox1.Text +
                            ",HProcID=" + textBox2.Text +
                            ",HStdWorkTimes=" + txtHStdWorkTimes.Text +
                            ",HUpperlimit=" + txtHUpperlimit.Text +
                            ",HLowerlimit=" + txtHLowerlimit.Text +
                            ",HMaker='" + DBUtility.ClsPub.CurUserName + "'" +
                            ",HMakeDate='" + DateTime.Now + "'" +
                            ",HUSEORGID=" + DBUtility.ClsPub.HOrgID +
                             " where HItemID=" + BillOld.HItemID);
                oCn.RunProc(sql);
                oCn.Commit();
                MessageBox.Show("修改成功,请退出并刷新", "提示");
            }
            catch (Exception)
            {
                oCn.RollBack();
                MessageBox.Show("修改失败", "提示");
                throw;
            }
            

            
        }
        //删除按钮
        private void sc_Click(object sender, EventArgs e)
@@ -293,7 +334,7 @@
        {
            timer1.Enabled = false;
            Sub_ControlLocation();
            if (BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_View)//|| BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Viewonly
            if (BillOld.HItemID.ToString()!=null)//|| BillStatus == DBUtility.ClsPub.Enum_BillStatus.BillStatus_Viewonly
            {
                this.Sub_ShowBill();
            }
@@ -387,60 +428,65 @@
            DAL.ClsIF_Material_View oMater = new DAL.ClsIF_Material_View();
            DAL.ClsIF_Process_View oProc = new DAL.ClsIF_Process_View();
            //判断是否存在单据
            if (BillNew.ShowBill(BillOld.HItemID, ref ClsPub.sExeReturnInfo) == false)
            {
                MessageBox.Show(ClsPub.sExeReturnInfo, "提示");
                return;
            }
            DataSet DsSub = oCn.RunProcReturn("Select * from h_v_Gy_StdWorkTimesListNew Where HitemID=" + BillOld.HItemID.ToString(), "Gy_StdWorkTimes");
            DataRow dr = DsSub.Tables[0].Rows[0];
            
            //清空
            Sub_ClearBill();
            

            //
            this.txtHMaker.Text = BillOld.HMaker;
            this.txtHMakeDate.Text = BillOld.HMakeDate;
            this.txtHChecker.Text = BillOld.HChecker;
            this.textBox1.Text = dr["HMaterID"].ToString();
            this.txtHMaterID.Text = dr["物料代码"].ToString();
            this.txtHMaterName.Text = dr["物料名称"].ToString();
            this.txtHMaterModel.Text = dr["规格型号"].ToString();
            this.textBox2.Text = dr["HProcID"].ToString();
            this.txtHProcID.Text = dr["工序代码"].ToString();
            this.txtHProcName.Text = dr["工序名称"].ToString();
            this.txtHStdWorkTimes.Text = dr["标准工时"].ToString();
            this.txtHUpperlimit.Text = dr["上线比例"].ToString();
            this.txtHLowerlimit.Text = dr["下线比例"].ToString();

            //加载表体
            initGrid();
            int i = 0;
            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 (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;
                }
                else
                {
                    grdMain.Rows[i].Cells[HMaterNumberCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterNameCol].Value = "";
                    grdMain.Rows[i].Cells[HMaterModelCol].Value = "";
                }
                grdMain.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;
                }
                else
                {
                    grdMain.Rows[i].Cells[HProcNumberCol].Value = "";
                    grdMain.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;
                i = i + 1;
            }
            //initGrid();
            //int i = 0;
            //foreach (Model.ClsGy_StdWorkTimes_Model oSub in BillNew.DetailColl)
            //{
            //    //
            //    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))
            //    {
            //        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
            //    {
            //        grdMain1.Rows[i].Cells[HMaterNumberCol].Value = "";
            //        grdMain1.Rows[i].Cells[HMaterNameCol].Value = "";
            //        grdMain1.Rows[i].Cells[HMaterModelCol].Value = "";
            //    }
            //    grdMain1.Rows[i].Cells[HProcIDCol].Value = oSub.HProcID.ToString();
            //    if (oProc.GetInfoByID(oSub.HProcID))
            //    {
            //        grdMain1.Rows[i].Cells[HProcNumberCol].Value = oProc.omodel.HNumber;
            //        grdMain1.Rows[i].Cells[HProcNameCol].Value = oProc.omodel.HName;
            //    }
            //    else
            //    {
            //        grdMain1.Rows[i].Cells[HProcNumberCol].Value = "";
            //        grdMain1.Rows[i].Cells[HProcNameCol].Value = "";
            //    }

            //    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允许刷新
            DBUtility.Xt_BaseBillFun.SetSumGrid(oSumGrid);
            //合计
@@ -462,21 +508,16 @@
            //}

            //明细表是否为零行
            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()
@@ -494,26 +535,35 @@
            lblCaption.Focus();
            //
            if (!Sub_AllowSave())//单据完整性判断
                return false;
            { return false; }

            //
            //明细类赋值
            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.HUSEORGID = ClsPub.HOrgID;
                    oSub.HStopflag = true;
                    oSub.HMaker = ClsPub.CurUserName;
                    oSub.HMakeDate = DateTime.Today.ToString();
                    oSub.HRemark = ClsPub.isStrNull(grdMain.Rows[i].Cells[HRemarkCol].Value);
                    BillNew.DetailColl.Add(oSub);
                    if (DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HStdWorkTimes].Value)>0&& DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HUpperlimit].Value) > 0&& DBUtility.ClsPub.isLong(grdMain1.Rows[i].Cells[HLowerlimit].Value) > 0)
                    {
                        Model.ClsGy_StdWorkTimes_Model oSub = new Model.ClsGy_StdWorkTimes_Model();
                        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 = false;
                        oSub.HMaker = ClsPub.CurUserName;
                        oSub.HMakeDate = DateTime.Today.ToString();
                        oSub.HRemark = ClsPub.isStrNull(grdMain1.Rows[i].Cells[HRemarkCol].Value);
                        BillNew.DetailColl.Add(oSub);
                    }
                    else
                    {
                        MessageBox.Show("第" + (i+1) + "行,标准工时,上限比例和下限比例都应大于0", "提示");
                        return false;
                    }
                }
            }
            //保存完毕后处理
@@ -568,28 +618,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 +714,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 +758,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 +795,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 +833,7 @@

        private void grdMain_EditingControlShowing(object sender, DataGridViewEditingControlShowingEventArgs e)
        {
            if (grdMain.CurrentCell != null)
            if (grdMain1.CurrentCell != null)
            {
                if (e.Control is DataGridViewTextBoxEditingControl)
                {
@@ -797,7 +847,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)