| | |
| | | using System.Linq; |
| | | using System.Text; |
| | | using System.Windows.Forms; |
| | | using Microsoft.VisualBasic; |
| | | |
| | | namespace WarM.æ¡ç æå° |
| | | { |
| | |
| | | public bool BillChange; // |
| | | public bool grdStatus; |
| | | public int selectRow = 0; |
| | | |
| | | //è®°å½å½åç»æçæ¡ç çæºåIDãåIDï¼ç¨äºä¿è¯å½åæä¸ææåæ¡ç 为åä¸ä¸ªå·¥åçæ |
| | | public int HSourceInterID_ICMO = 0; |
| | | public int HSourceEntryID_ICMO = 0; |
| | | |
| | | private void Gy_PackBarCodeBill_automaticallyByPLC_Load(object sender, EventArgs e) |
| | | { |
| | |
| | | DBUtility.Xt_BaseBillFun.initGridList(grdSub, this.Name + "grdSub"); |
| | | |
| | | getDisplay_GrdMain(); |
| | | |
| | | if (grdMain.Rows.Count > 0 && grdMain.Rows[0].Cells[4].Value!=null) |
| | | { |
| | | getPackQty(grdMain.Rows[0].Cells[4].Value.ToString()); |
| | | } |
| | | } |
| | | |
| | | |
| | |
| | | //æªæ»¡æçæ æé® ç¹å»äºä»¶ |
| | | private void button_produceByHand_Click(object sender, EventArgs e) |
| | | { |
| | | if (HQty == 0) |
| | | try |
| | | { |
| | | MessageBox.Show("请æ«ç åæ¡ç !"); |
| | | return; |
| | | if (HQty == 0) |
| | | { |
| | | MessageBox.Show("请æ«ç åæ¡ç !"); |
| | | return; |
| | | } |
| | | this.Sub_SaveBill(); |
| | | |
| | | //ç»ææååï¼æ¸
ç©ºç»ææ°é䏿ºåä¿¡æ¯ |
| | | set_clearPackQtyAndSourceInfo(); |
| | | } |
| | | this.Sub_SaveBill(); |
| | | catch(Exception ex) |
| | | { |
| | | MessageBox.Show(ex.Message); |
| | | } |
| | | } |
| | | |
| | | //èªå¨ç»æ |
| | | private void button_startListen_Click(object sender, EventArgs e) |
| | | { |
| | | if (DBUtility.ClsPub.isLong(textBox_PackQty.Text) == 0) |
| | | { |
| | | MessageBox.Show("è¯·è®¾ç½®ææ¡ç çæå°å
è£
æ°ï¼"); |
| | | return; |
| | | } |
| | | //if (DBUtility.ClsPub.isLong(textBox_PackQty.Text) == 0) |
| | | //{ |
| | | // MessageBox.Show("è¯·è®¾ç½®ææ¡ç çæå°å
è£
æ°ï¼"); |
| | | // return; |
| | | //} |
| | | |
| | | isStartListen = 1; |
| | | |
| | |
| | | comboBox_SourceNameParams.Enabled = false; |
| | | |
| | | button_saveParams.Enabled = false; |
| | | |
| | | textBox_HBarCode.Focus(); |
| | | } |
| | | |
| | | //åæ¢ç»æ |
| | |
| | | { |
| | | if(isStartListen == 1) |
| | | { |
| | | if(HQty == DBUtility.ClsPub.isDoule(textBox_PackQty.Text)) |
| | | try |
| | | { |
| | | this.Sub_SaveBill(); |
| | | |
| | | //设置æå°æ¨¡æ¿ï¼æå° |
| | | grdSub.Rows[0].Cells[0].Value = "*"; |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); |
| | | if (comboBox_PrinterParams.Text != "") |
| | | if (HQty == DBUtility.ClsPub.isDoule(textBox_PackQty.Text)) |
| | | { |
| | | Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(é»è®¤)", ""); |
| | | this.Sub_SaveBill(); |
| | | |
| | | //设置æå°æ¨¡æ¿ï¼æå° |
| | | grdSub.Rows[0].Cells[0].Value = "*"; |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); |
| | | if (comboBox_PrinterParams.Text != "") |
| | | { |
| | | Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(é»è®¤)", ""); |
| | | } |
| | | Report.Print(false); |
| | | |
| | | //ç»ææååï¼æ¸
ç©ºç»ææ°é䏿ºåä¿¡æ¯ |
| | | set_clearPackQtyAndSourceInfo(); |
| | | } |
| | | Report.Print(false); |
| | | }catch(Exception ex) |
| | | { |
| | | MessageBox.Show(ex.Message); |
| | | } |
| | | } |
| | | } |
| | |
| | | //çææçæ¡ç |
| | | private bool Sub_SaveBill() |
| | | { |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | if (HOrgID == -1) |
| | | try |
| | | { |
| | | MessageBox.Show("éæ©ç»ç»æé误ï¼"); |
| | | return false; |
| | | } |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | if (HOrgID == -1) |
| | | { |
| | | throw new Exception("éæ©ç»ç»æé误ï¼"); |
| | | } |
| | | |
| | | if (!Sub_AllowSave())//忮宿´æ§å¤æ |
| | | if (!Sub_AllowSave())//忮宿´æ§å¤æ |
| | | { |
| | | throw new Exception("忮宿´æ§å¤æå¤±è´¥ï¼"); |
| | | } |
| | | |
| | | SaveBarCode(); |
| | | return true; |
| | | }catch(Exception ex) |
| | | { |
| | | return false; |
| | | string sql = "exec h_p_WMS_PackBarCodeBill_dealDataWhenError '" + textBox_HPackBarCode + "'"; |
| | | oCn.RunProc(sql); |
| | | throw new Exception(ex.Message); |
| | | } |
| | | |
| | | |
| | | SaveBarCode(); |
| | | return true; |
| | | |
| | | } |
| | | |
| | | //忮宿´æ§å¤æ æªå®æ |
| | |
| | | |
| | | sSQLMul[1] = " exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + HQty.ToString() + " "; |
| | | |
| | | //夿å½åæçæ¡ç æ¯å¦å·²ç»éè¿ä¸´æ¶ç»æå¨æ¡ç æ¡£æ¡ä¸çæäºï¼è¥å·²ç»çæäºåä¸éè¦å¨æå
¥ |
| | | ds = oCn.RunProcReturn("select * from Gy_BarCodeBill where HBarCode = '" + textBox_HPackBarCode.Text + "' and HSTOCKORGID = " + HOrgID, "Gy_BarCodeBill"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | sSQLMul[0] = ""; |
| | | } |
| | | |
| | | oCn.BeginTran(); |
| | | |
| | | if (getRunProcByMul_Back(sSQLMul, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | //MessageBox.Show("æ¡ç çæå®æ¯ï¼"); |
| | |
| | | setPackBarCodeBillData(); |
| | | |
| | | getDisplay_GrdMain(); |
| | | |
| | | oCn.Commit(); |
| | | } |
| | | else |
| | | { |
| | | //MessageBox.Show("æ¡ç çæå¤±è´¥ï¼" + DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.RollBack(); |
| | | } |
| | | |
| | | //oCn.Commit(); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | //MessageBox.Show("æ¡ç çæå¤±è´¥ï¼" + e.Message); |
| | | oCn.RollBack(); |
| | | throw new Exception(e.Message); |
| | | } |
| | | } |
| | | |
| | |
| | | { |
| | | for (int i = 0; i < 1; i++) |
| | | { |
| | | oCn.RunProc(sSQL[i]); |
| | | if (sSQL[i].Length > 0) |
| | | { |
| | | oCn.RunProc(sSQL[i]); |
| | | } |
| | | } |
| | | |
| | | |
| | | |
| | | //ä¸ä¼ ç»æä¿¡æ¯å°æå¡å¨ |
| | | send(); |
| | | oCn.Commit(); |
| | | } |
| | | else |
| | | { |
| | | sErrMsg = "æ²¡ææ°æ®ï¼"; |
| | | oCn.Commit(); |
| | | return false; |
| | | sErrMsg = "æ²¡ææ°æ®ï¼"; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | oCn.Commit(); |
| | | //oCn.Commit(); |
| | | return true; |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = e.Message; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | } |
| | | #endregion |
| | |
| | | private void send() |
| | | { |
| | | string err = ""; |
| | | if (!CheckModRight(ModRightNamePackUnion, DBUtility.ClsPub.CurUserName, ref err)) |
| | | { |
| | | MessageBox.Show(err); |
| | | return; |
| | | } |
| | | //if (!CheckModRight(ModRightNamePackUnion, DBUtility.ClsPub.CurUserName, ref err)) |
| | | //{ |
| | | // MessageBox.Show(err); |
| | | // return; |
| | | //} |
| | | //if (MessageBox.Show("ç¡®å®è¦ä¸ä¼ ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel) |
| | | //{ |
| | | // return; |
| | | //} |
| | | LoadData(); |
| | | try |
| | | { |
| | | LoadData(); |
| | | }catch(Exception ex) |
| | | { |
| | | throw new Exception(ex.Message); |
| | | } |
| | | } |
| | | |
| | | //å¤æç¨æ·æé |
| | |
| | | //夿æ¯å¦æ°æ®å®æ´ |
| | | if (AllowLoadData() == false) |
| | | { |
| | | return; |
| | | throw new Exception("æ°æ®å®æ´æ§å¤æå¤±è´¥ï¼"); |
| | | } |
| | | try |
| | | { |
| | |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("çæå¤±è´¥ï¼åå :" + err); |
| | | return; |
| | | string error = "çæå¤±è´¥ï¼åå :" + err; |
| | | throw new Exception(error); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | MessageBox.Show("åæ®å·ï¼" + textBox_sBillID.Text + "ï¼åæ®IDï¼" + textBox_sBillID.Text + "ï¼ä¸ä¼ 失败ï¼" + e.Message); |
| | | return; |
| | | string error = "åæ®å·ï¼" + textBox_sBillID.Text + "ï¼åæ®IDï¼" + textBox_sBillID.Text + "ï¼ä¸ä¼ 失败ï¼" + e.Message; |
| | | throw new Exception(error); |
| | | } |
| | | } |
| | | |
| | |
| | | public bool set_SavePackUnionBill_Add(Int64 HInterID, string HBillType, string HBillNo, string HBarCode_Pack, string HMaker, Int64 HStockOrgID, ref string sErrMsg) |
| | | { |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | | oCn.BeginTran(); |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | DataSet ds = oCn.RunProcReturn("exec h_p_Sc_PackUnionBill_Insert_New " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "','" + HBarCode_Pack + "','" + HMaker + "'," + HStockOrgID.ToString(), "h_p_Sc_PackUnionBill_Insert_New"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | sErrMsg = "åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼ä¸ä¼ 失败ï¼"; |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = "åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼ä¸ä¼ 失败ï¼"; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | else |
| | | { |
| | | if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 1) |
| | | { |
| | | sErrMsg = "ä¸ä¼ 失败ï¼åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = "ä¸ä¼ 失败ï¼åæ®å·ï¼" + HBillNo + "ï¼åæ®IDï¼" + HInterID + "ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HRemark"]); |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | else |
| | | { |
| | | //sErrMsg = "çæçäº§ç»æåæåï¼åæ®å·ä¸ºï¼" + HBillNo; |
| | | oCn.Commit(); |
| | | //sErrMsg = "çæçäº§ç»æåæåï¼åæ®å·ä¸ºï¼" + HBillNo; |
| | | return true; |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | sErrMsg = "çæçäº§ç»æå失败ï¼" + e.Message; |
| | | oCn.RollBack(); |
| | | return false; |
| | | sErrMsg = "çæçäº§ç»æå失败ï¼" + e.Message; |
| | | throw new Exception(sErrMsg); |
| | | } |
| | | } |
| | | |
| | |
| | | { |
| | | if (e.KeyChar == (char)Keys.Return) |
| | | { |
| | | //é²é夿 |
| | | if(!judgeIsSameSourceBill(textBox_HBarCode.Text.Trim())) |
| | | { |
| | | textBox_HBarCode.Text = ""; |
| | | return; |
| | | } |
| | | |
| | | SetBarCode_Webs(); |
| | | textBox_HBarCode.Text = ""; |
| | | textBox_HBarCode.Focus(); |
| | | |
| | | autoProducePackBarCode(); |
| | | |
| | | if (grdMain.Rows.Count ==1 ) |
| | | { |
| | | getPackQty(grdMain.Rows[0].Cells[4].Value.ToString()); |
| | | } |
| | | } |
| | | } |
| | | catch (Exception e2) |
| | | { |
| | | //if (DBUtility.ClsPub.bSound) |
| | | //{ |
| | | // DBUtility.ClsPub.MessageBeep((int)DBUtility.ClsPub.BeepType.Warning); |
| | | //} |
| | | MessageBox.Show("åçç½ç»å¼å¸¸ï¼è¯·ç¨ååè¯ï¼"); |
| | | textBox_HBarCode.Text = ""; |
| | | textBox_HBarCode.Focus(); |
| | | MessageBox.Show(e2.Message); |
| | | } |
| | | } |
| | | //å°æ¡ç ä¿¡æ¯åå
¥æ¡ç åºå
¥åºä¸´æ¶è¡¨ |
| | |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show(err); |
| | | return; |
| | | throw new Exception(err); |
| | | } |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | MessageBox.Show("æ«æåæ¡ç ï¼åå
¥ä¸´æ¶è¡¨ä¿¡æ¯å¤±è´¥ï¼" + e.Message + err); |
| | | string sError = "æ«æåæ¡ç ï¼åå
¥ä¸´æ¶è¡¨ä¿¡æ¯å¤±è´¥ï¼" + e.Message + err; |
| | | throw new Exception(sError); |
| | | } |
| | | } |
| | | |
| | |
| | | private void toolStripButton_Delete_Click(object sender, EventArgs e) |
| | | { |
| | | deleteGrdMainNote(); |
| | | |
| | | if (grdMain.Rows.Count== 0) |
| | | { |
| | | set_clearPackQtyAndSourceInfo(); |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | |
| | | { |
| | | if (grdMain.SelectedRows != null && grdMain.SelectedRows.Count==1) |
| | | { |
| | | if (MessageBox.Show("ç¡®å®è¦å é¤ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel) |
| | | //if (MessageBox.Show("ç¡®å®è¦å é¤ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel) |
| | | //{ |
| | | // return; |
| | | //} |
| | | //if (MessageBox.Show("å é¤åå°ä¸å¯æ¢å¤ï¼ç¡®å®è¦ç»§ç»æä½ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel) |
| | | //{ |
| | | // return; |
| | | //} |
| | | |
| | | string pwd = Interaction.InputBox("请è¾å
¥å¯ç ", "å é¤ç¡®è®¤ï¼", "", 100, 100); |
| | | |
| | | //ç¹å»åæ¶ |
| | | if(pwd == "") |
| | | { |
| | | return; |
| | | } |
| | | if (MessageBox.Show("å é¤åå°ä¸å¯æ¢å¤ï¼ç¡®å®è¦ç»§ç»æä½ï¼", "æç¤º", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.Cancel) |
| | | |
| | | if(pwd != "123456") |
| | | { |
| | | MessageBox.Show("å¯ç é误ï¼"); |
| | | return; |
| | | } |
| | | |
| | | Delete(); |
| | | } |
| | | else |
| | |
| | | } |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | #region 临æ¶ç»æ |
| | | #region 临æ¶ç»æ æé®ç¹å»äºä»¶ |
| | | private void button_produceTemp_Click(object sender, EventArgs e) |
| | | { |
| | | if (HQty == 0) |
| | | { |
| | | MessageBox.Show("请æ«ç åæ¡ç !"); |
| | | return; |
| | | } |
| | | this.produceTemp(); |
| | | |
| | | //设置æå°æ¨¡æ¿ï¼æå° |
| | | grdSub.Rows[0].Cells[0].Value = "*"; |
| | | Report = new GridppReport(); |
| | | Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + "_Temp" + ".grf"); //here . |
| | | Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); |
| | | Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); |
| | | Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); |
| | | if (comboBox_PrinterParams.Text != "") |
| | | { |
| | | Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(é»è®¤)", ""); |
| | | } |
| | | Report.Print(false); |
| | | |
| | | //ç»ææååï¼æ¸
ç©ºç»ææ°é䏿ºåä¿¡æ¯ |
| | | set_clearPackQtyAndSourceInfo(); |
| | | } |
| | | #endregion |
| | | |
| | | #region 临æ¶ç»æ |
| | | private void produceTemp() |
| | | { |
| | | //夿æ¡ç æ¡£æ¡ä¸æ¯å¦å·²ç»åå¨è¯¥ææ¡ç ï¼è¥åå¨ï¼åä¸éè¦åå建ãéæ°å è½½çé¢å³å¯ã |
| | | DataSet ds_getPackBarCode; |
| | | string sql_getPackBarCode = "select * from Gy_BarCodeBill where HBarCode = '" + textBox_HPackBarCode.Text + "'"; |
| | | ds_getPackBarCode = oCn.RunProcReturn(sql_getPackBarCode, "Gy_BarCodeBill"); |
| | | if (ds_getPackBarCode != null && ds_getPackBarCode.Tables[0].Rows.Count > 0) |
| | | { |
| | | //éæ°å è½½çé¢ |
| | | getDisplay_grdSub(); |
| | | |
| | | setPackBarCodeBillData(); |
| | | |
| | | getDisplay_GrdMain(); |
| | | return; |
| | | } |
| | | |
| | | |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | //éªè¯ç»ç» |
| | | if (HOrgID == -1) |
| | | { |
| | | MessageBox.Show("éæ©ç»ç»æé误ï¼"); |
| | | return; |
| | | } |
| | | |
| | | //忮宿´æ§å¤æ |
| | | if (!Sub_AllowSave()) |
| | | { |
| | | return; |
| | | } |
| | | |
| | | //è·åå½å产线å产线å
ç |
| | | long HSourceID = 0; |
| | | string sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "' "; |
| | | DataSet ds = oCn.RunProcReturn(sql, "Gy_Source"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | |
| | | //æ¼æ¥ä¸´æ¶ç»ææ¶ï¼ææ¡ç ççæè¯å¥ |
| | | sSQLMul = new string[2]; |
| | | sSQLMul[0] = "insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + |
| | | ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HJiaYe " + |
| | | ",HPressModel,HCusModel,HMaterialModel,HColor,HBarCodeDate " + |
| | | ",HLogo,HPackageSize,HMaterialJQty,HMaterialMQty,HCustomBatchNo " + |
| | | ",HSTOCKORGID,HOWNERID,HBeginDate,HSeOrderBillNo,HGBBarCode " + |
| | | ",POOrderBillNo,HInterID,HInitSourceEntryID,HBarCode_Pack " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo " + |
| | | ",HCustomQty1,HLayerNumber,HCusBarCode,HBarCodeStatus,HSourceID " + |
| | | ") values (" |
| | | + "'" + textBox_HPackBarCode.Text + "','" + HBarCodeType + "',0,0,1" |
| | | + ",'',0,0,'" + ClsPub.CurUserName + "',getdate(),0,1" |
| | | + ",0,0,'','',''" |
| | | + "," + HQty.ToString() + ",1,0,0,0,''" |
| | | + ",0,'','','',''" |
| | | + ",'','','','','" + sDate + "'" |
| | | + ",'','',0,0,''" |
| | | + "," + HOrgID.ToString() + "," + HOrgID.ToString() + ",'','',''" |
| | | + ",''," + HInterID.ToString() + ",0,'" + textBox_HPackBarCode.Text + "'" |
| | | + ",'','','',0,''" |
| | | + ",0,0,'',''," + HSourceID + |
| | | ")"; |
| | | //æ¼æ¥ æ´æ° ææ¡ç æµæ°´å· çsqlè¯å¥ |
| | | sSQLMul[1] = " exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + HQty.ToString() + " "; |
| | | |
| | | if (sSQLMul.Length > 0) |
| | | { |
| | | //æ§è¡ææ¡ç ççæè¯å¥ä¸ææ¡ç æµæ°´å·çæ´æ°è¯å¥ |
| | | for (int i = 0; i < 1; i++) |
| | | { |
| | | oCn.RunProc(sSQLMul[i]); |
| | | } |
| | | |
| | | //éæ°å è½½çé¢ |
| | | getDisplay_grdSub(); |
| | | |
| | | setPackBarCodeBillData(); |
| | | |
| | | getDisplay_GrdMain(); |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("æ²¡ææ°æ®ï¼"); |
| | | return; |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region ææ¡ç æ«ç |
| | | private void textBox_HPackBarCode__KeyPress(object sender, KeyPressEventArgs e) |
| | | { |
| | | if (e.KeyChar == (char)Keys.Return) |
| | | { |
| | | //è·åæ«æçææ¡ç |
| | | string HPackBarCode = textBox_HPackBarCode.Text; |
| | | //æ¡ç ç±»å |
| | | HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text); |
| | | //è·åç»ç»ä¿¡æ¯ |
| | | HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text); |
| | | HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text); |
| | | |
| | | //声æç¨äºæ°æ®åºæ¥è¯¢çåé |
| | | string sql = ""; |
| | | DataSet ds; |
| | | |
| | | //夿 ææ¡ç æ¯å¦å·²ç»çæç»æå |
| | | sql = "select * from Sc_PackUnionBillMain where HBarCode_Pack = '" + HPackBarCode + "'"; |
| | | ds = oCn.RunProcReturn(sql, "Sc_PackUnionBillMain"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | MessageBox.Show("ææ¡ç [" + HPackBarCode + "]å·²ç»ç»æï¼"); |
| | | return; |
| | | } |
| | | |
| | | |
| | | //è·åå½å产线 |
| | | long HSourceID = 0; |
| | | sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "'"; |
| | | ds = oCn.RunProcReturn(sql, "Gy_Source"); |
| | | if (ds != null && ds.Tables[0].Rows.Count > 0) |
| | | { |
| | | HSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"].ToString()); |
| | | } |
| | | |
| | | |
| | | //è·åç¼ååè¡¨ä¸ ææ¡ç 对åºç ç»æè®°å½ |
| | | sql = "select top(1) a.* from Sc_PackUnionBill_Temp as a inner join Gy_BarCodeBill as b on a.HBarCode = b.HBarCode where a.HBarCode_Pack = '" + HPackBarCode + "' and b.HSourceID = " + HSourceID + " and a.HStockorgID = " + HOrgID; |
| | | //sql = "select top(1) a.* from Sc_PackUnionBill_Temp as a where a.HBarCode_Pack = '" + HPackBarCode + "' and a.HStockorgID = " + HOrgID; |
| | | ds = oCn.RunProcReturn(sql, "Sc_PackUnionBill_Temp"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | MessageBox.Show("ç¼ååè¡¨ä¸æªæ¥è¯¢å°è¯¥ææ¡ç ä¸åæ¡ç çç»æè®°å½ï¼"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | string HBarCode_Pack = ds.Tables[0].Rows[0]["HBarCode_Pack"].ToString(); |
| | | long HBillID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"].ToString()); |
| | | string HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString(); |
| | | |
| | | textBox_HPackBarCode.Text = HBarCode_Pack; |
| | | textBox_sBillID.Text = HBillID.ToString(); |
| | | textBox_sBillNo.Text = HBillNo; |
| | | |
| | | getDisplay_GrdMain(); |
| | | |
| | | if (grdMain.Rows.Count > 0 && grdMain.Rows[0].Cells[4].Value != null) |
| | | { |
| | | getPackQty(grdMain.Rows[0].Cells[4].Value.ToString()); |
| | | } |
| | | } |
| | | |
| | | |
| | | } |
| | | } |
| | | #endregion |
| | | #endregion |
| | | |
| | | |
| | | #region æ ¹æ®æ¡ç ç¼å·ï¼è·åæ¡ç ä¸ç©ææå¯¹åºçç»ææ°éï¼åæ¶è®°å½æºå主IDãåID |
| | | private void getPackQty(string HBarCode) |
| | | { |
| | | string sql = "select * from h_v_IF_BarCodeBillList_getPackQty where æ¡ç ç¼å· = '" + HBarCode + "'"; |
| | | DataSet ds_getPackQty = oCn.RunProcReturn(sql, "h_v_IF_BarCodeBillList_getPackQty"); |
| | | if (ds_getPackQty == null || ds_getPackQty.Tables[0].Rows.Count <= 0) |
| | | { |
| | | HSourceInterID_ICMO = 0; |
| | | HSourceEntryID_ICMO = 0; |
| | | |
| | | textBox_PackQty.Text = ""; |
| | | return; |
| | | } |
| | | |
| | | HSourceInterID_ICMO = int.Parse(ds_getPackQty.Tables[0].Rows[0]["HSourceInterID"].ToString()); |
| | | HSourceEntryID_ICMO = int.Parse(ds_getPackQty.Tables[0].Rows[0]["HSourceEntryID"].ToString()); |
| | | textBox_PackQty.Text = Double.Parse(ds_getPackQty.Tables[0].Rows[0]["ç»ææ°é"].ToString()).ToString(); |
| | | } |
| | | #endregion |
| | | |
| | | #region 夿å½åæ«æçæ¡ç æ¯å¦ä¸å·²ç»æ«æè¿çæ¡ç 为åä¸å·¥åçæç |
| | | private bool judgeIsSameSourceBill(string HBarCode) |
| | | { |
| | | if (grdMain.Rows.Count == 0) |
| | | { |
| | | return true; |
| | | } |
| | | else |
| | | { |
| | | string sql = "select * from h_v_IF_BarCodeBillList_getPackQty where æ¡ç ç¼å· = '" + HBarCode + "'"; |
| | | DataSet ds_getPackQty = oCn.RunProcReturn(sql, "h_v_IF_BarCodeBillList_getPackQty"); |
| | | if (ds_getPackQty == null || ds_getPackQty.Tables[0].Rows.Count <= 0) |
| | | { |
| | | MessageBox.Show("å½åæ¡ç ä¸åå¨ï¼"); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | int HSourceInterID_ICMO_Bak = int.Parse(ds_getPackQty.Tables[0].Rows[0]["HSourceInterID"].ToString()); |
| | | int HSourceEntryID_ICMO_Bak = int.Parse(ds_getPackQty.Tables[0].Rows[0]["HSourceEntryID"].ToString()); |
| | | if (HSourceInterID_ICMO != HSourceInterID_ICMO_Bak || HSourceEntryID_ICMO != HSourceEntryID_ICMO_Bak) |
| | | { |
| | | MessageBox.Show("å½åæ«æçæ¡ç ä¸ä¹åææ«æçæ¡ç å·¥åä¸ä¸è´ï¼"); |
| | | return false; |
| | | } |
| | | else |
| | | { |
| | | return true; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | #endregion |
| | | |
| | | #region æ¸
空 ç»ææ°é ä¸è®°å½çæºå主IDãåID |
| | | private void set_clearPackQtyAndSourceInfo() |
| | | { |
| | | textBox_PackQty.Text = ""; |
| | | HSourceInterID_ICMO = 0; |
| | | HSourceEntryID_ICMO = 0; |
| | | } |
| | | #endregion |
| | | |
| | | } |
| | | } |
| | | |