| | |
| | | } |
| | | } |
| | | |
| | | //条形码回车 |
| | | private void txtLzk_KeyDown(object sender, KeyEventArgs e) |
| | | { |
| | | if (e.KeyCode == Keys.Enter) |
| | |
| | | private void ZZ_GlueWeigh_Load(object sender, EventArgs e) |
| | | { |
| | | this.cmbEquip.SelectedIndex = 0; |
| | | this.cmbEquip.DropDownStyle = ComboBoxStyle.DropDownList; |
| | | this.cmbEquip.DropDownStyle = ComboBoxStyle.DropDownList;//只读 |
| | | |
| | | this.cmbPro.DropDownStyle = ComboBoxStyle.DropDownList; |
| | | this.cmbJYSelect.DropDownStyle = ComboBoxStyle.DropDownList; |
| | | this.cmbPro.DropDownStyle = ComboBoxStyle.DropDownList;//只读 |
| | | this.cmbJYSelect.DropDownStyle = ComboBoxStyle.DropDownList;//只读 |
| | | this.cmbJYSelect.SelectedIndex = 0; |
| | | this.txtHMakerNumber.ReadOnly = true; |
| | | this.txtPcm.ReadOnly = true; |
| | | this.txtHMakerNumber.ReadOnly = true;//只读 |
| | | this.txtPcm.ReadOnly = true;//只读 |
| | | } |
| | | |
| | | //查询称重的重量 |
| | |
| | | break; |
| | | } |
| | | |
| | | //查询 顶部点胶重量 和 底部点胶重量 当前最大的数据 |
| | | DataSet ds = oCN.RunProcReturn(@"select top 1 HTechParamName,HResult,HCreateTime from Sb_EquipMentCollectionTechParam_Temp |
| | | where HSourceCode = '" + HNumber + @"' and HTechParamName = '顶部点胶重量' and HCreateTime in( |
| | | select max(HCreateTime) from Sb_EquipMentCollectionTechParam_Temp |
| | |
| | | |
| | | if (ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | //获取 顶部点胶重量 和 底部点胶重量 |
| | | for (int i = 0; i < ds.Tables[0].Rows.Count; i++) |
| | | { |
| | | string HTechParamName = ds.Tables[0].Rows[i]["HTechParamName"].ToString(); |
| | |
| | | long HInterID = oCN.CreateBillID_Prod(BillType, ref sExeReturnInfo); |
| | | string HBillNo = oCN.CreateBillCode(BillType, ref sExeReturnInfo, true); |
| | | |
| | | //判断当前流转卡对应的工序有没有开工 |
| | | DataSet ds = oCN.RunProcReturn(@"select staus.HSourceID,a.HICMOInterID,a.HICMOEntryID,a.HICMOBillNo,a.HPlanQty,a.HInterID HProcExchInterID, |
| | | staus.HSourceEntryID HProcExchEntryID,a.HBillNo HProcExchBillNo,a.HQty,a.HMaterID |
| | | from Sc_ProcessExchangeBillMain a with(nolock) |
| | |
| | | { |
| | | HLastResults = 0; |
| | | } |
| | | |
| | | //新增子表 |
| | | oCN.RunProc("Insert into QC_FirstPieceCheckBillSub " + |
| | | " (HInterID,HBillNo_bak,HEntryID,HCloseMan" + |
| | | ",HEntryCloseDate,HCloseType,HRemark,HSourceInterID" + |
| | |
| | | long HInterID = oCN.CreateBillID_Prod(BillType, ref sExeReturnInfo); |
| | | string HBillNo = oCN.CreateBillCode(BillType, ref sExeReturnInfo, true); |
| | | |
| | | //判断当前流转卡对应的工序有没有开工 |
| | | DataSet ds = oCN.RunProcReturn(@"select staus.HSourceID,a.HICMOInterID,a.HICMOEntryID,a.HICMOBillNo,a.HPlanQty,a.HInterID HProcExchInterID, |
| | | staus.HSourceEntryID HProcExchEntryID,a.HBillNo HProcExchBillNo,a.HQty,a.HMaterID |
| | | from Sc_ProcessExchangeBillMain a with(nolock) |
| | |
| | | long HInterID = oCN.CreateBillID_Prod(BillType, ref sExeReturnInfo); |
| | | string HBillNo = oCN.CreateBillCode(BillType, ref sExeReturnInfo, true); |
| | | |
| | | //判断当前流转卡对应的工序有没有开工 |
| | | DataSet ds = oCN.RunProcReturn(@"select staus.HSourceID,a.HICMOInterID,a.HICMOEntryID,a.HICMOBillNo,a.HPlanQty,a.HInterID HProcExchInterID, |
| | | staus.HSourceEntryID HProcExchEntryID,a.HBillNo HProcExchBillNo,a.HQty,a.HMaterID,staus.HProcID |
| | | from Sc_ProcessExchangeBillMain a with(nolock) |