| | |
| | | public Int64 HInterID = 0; |
| | | public string HBillNo = ""; |
| | | public string HBillType = "1202"; |
| | | public Int64 HMaterID = 0; |
| | | public string HBatchNo = ""; |
| | | public Int64 HAuxPropID = 0; |
| | | public Int64 HUnitID = 0; |
| | | public Int64 HWhID = 0; |
| | |
| | | public string PrintQtyCtl = ""; //æ¡ç æå°æ¬¡æ°æ§å¶ |
| | | public string UpdatePrintQtyCtl = ""; //æ¡ç æå°æ¬¡æ°æ´æ° |
| | | public string sBarCodeItemID = ""; //æ¡ç èªå¢å |
| | | public string HBarCode_Pack = ""; //ææ¡ç |
| | | public long HSNo = 0; //ç»æè®¡æ°ç¨ |
| | | public DAL.ClsGy_BarCodeBill_Ctl oBar = new DAL.ClsGy_BarCodeBill_Ctl(); |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | | SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); |
| | |
| | | { |
| | | HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo); //å¾å°æ°åæ®ID |
| | | HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); //å¾å°æ°åæ®å· |
| | | HSNo = 0; |
| | | this.lblSNo.Text = ""; |
| | | } |
| | | else if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HBack"]) == 1) |
| | | { |
| | | HInterID = DBUtility.ClsPub.CreateBillID_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo); //å¾å°æ°åæ®ID |
| | | HBillNo = DBUtility.ClsPub.CreateBillCode_Prod(HBillType, ref DBUtility.ClsPub.sExeReturnInfo, true); //å¾å°æ°åæ®å· |
| | | HSNo = 0; |
| | | this.lblSNo.Text = ""; |
| | | } |
| | | else |
| | | { |
| | |
| | | if (grdSub.Rows.Count > 0) |
| | | { |
| | | grdSub.Rows[0].Selected = true; |
| | | SourceBill(); |
| | | SourceBill(1); |
| | | txtHQty.Focus(); |
| | | } |
| | | else |
| | |
| | | return false; |
| | | } |
| | | |
| | | if (DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text) != "") |
| | | { |
| | | MessageBox.Show("å½åç»ææªç»æï¼è¯·ç»æç»æååç¹å»æ¢çï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | |
| | | } |
| | | Source_Display(); |
| | | grdSub.Rows[0].Selected = true; |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | SourceBill(); |
| | | SourceBill(2); |
| | | txtHBarCode.Text = ""; |
| | | txtHQty.Focus(); |
| | | } |
| | |
| | | } |
| | | Source_Display(); |
| | | grdSub.Rows[0].Selected = true; |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | SourceBill(); |
| | | SourceBill(2); |
| | | txtHBarCode.Text = ""; |
| | | txtHQty.Focus(); |
| | | } |
| | |
| | | |
| | | private void cmdSourceBillNo_Click(object sender, EventArgs e) |
| | | { |
| | | //åå§åå³è¾¹è¡¨å¤´ä¿¡æ¯ |
| | | cmbHBarCodeType.Items.Clear(); |
| | | cmbHBarCodeType.Items.Add("å¯ä¸æ¡ç "); |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | |
| | | if (grdSub.CurrentRow == null) |
| | | { |
| | | MessageBox.Show("请å¨å·¦è¾¹åæ®å表ä¸éæ©ä¸è¡åæ®ï¼", "æç¤º"); |
| | |
| | | } |
| | | else |
| | | { |
| | | SourceBill(); |
| | | SourceBill(3); |
| | | txtHQty.Focus(); |
| | | } |
| | | } |
| | |
| | | } |
| | | SaveBarCode(); |
| | | BarCode_Display(); |
| | | if (DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text) != "") |
| | | { |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | grdMain.Rows[0].Selected = true; |
| | | |
| | | sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); |
| | |
| | | HBadReasonID = DBUtility.ClsPub.isLong(txtHRemark.Tag); |
| | | HCusMaterName = DBUtility.ClsPub.isStrNull(txtHCusMaterName.Text); |
| | | HCusModel = DBUtility.ClsPub.isStrNull(txtHCusModel.Text); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | HSNo = HSNo + 1; |
| | | } |
| | | |
| | | try |
| | | { |
| | |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + |
| | | ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate,HMaterialJQty,HMaterialMQty,HNowQty " + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HGiveAwayFlag " + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HGiveAwayFlag,HBarCode_Pack " + |
| | | ",HOrderInterID,HOrderEntryID,HOrderBillNo,HCustomQty1,HMaterialModel,HCusModel " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo,HPackflag " + |
| | | ") Values (" |
| | | + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty.ToString() |
| | | + ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + HMaker + "',getdate(),0," + HQty.ToString() |
| | | + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "',''" |
| | | + ", 1," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'" |
| | | + ", 0,'',getdate(),'','" + sDate + "'," + HMaterialJQty.ToString() + "," + HMaterialMQty.ToString() + "," + HNowQty.ToString() |
| | | + ", " + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",''," + HInterID.ToString() + ",0" |
| | | + ", " + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",''," + HInterID.ToString() + ",0,'" + HBarCode_Pack + "'" |
| | | + ", " + HProcessExchangeInterID.ToString() + ",0,'" + HProcessExchangeBillNo + "'," + HBadReasonID.ToString() + ",'" + HCusMaterName + "','" + HCusModel + "'" |
| | | + ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1')"); |
| | | + ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1',0)"); |
| | | |
| | | //åå¡«æå¤§æµæ°´å· |
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "',1 "); |
| | |
| | | " Values(" |
| | | + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "'," + HMaterID.ToString() + "," + HAuxPropID.ToString() + ",0" |
| | | + "," + HWhID.ToString() + ",0," + HSPID.ToString() + ",0,0,''" |
| | | +",0," + HQty.ToString() + ",1,'" + HBatchNo + "','" + HBarCode + "',''" |
| | | +",'" + HMaker + "',getdate()," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillType + "','" + HSourceBillNo + "'" |
| | | +",0," + HQty.ToString() + ",1,'" + HBatchNo + "','" + HBarCode + "','" + HBarCode_Pack + "'" |
| | | + ",'" + HMaker + "',getdate()," + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillType + "','" + HSourceBillNo + "'" |
| | | +",0,0,'',0,'',0" |
| | | +"," + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",'','ç§°éå
¥åºçæ','2'" |
| | | +",0,0,'',0)"); |
| | |
| | | |
| | | #region //è¿åä¿¡æ¯ |
| | | |
| | | //è¿åæºååè¡¨ä¿¡æ¯ |
| | | private void SourceBill() |
| | | //è¿åæºåå表信æ¯(num=1ï¼æå¼æ¨¡åæ¶å è½½æ¾ç¤ºï¼num=2ï¼æ«æµè½¬å¡æ¾ç¤ºï¼num=3ï¼éåæé®æ¾ç¤º) |
| | | private void SourceBill(int num) |
| | | { |
| | | //æå¼æ¨¡åæ¶å è½½æ¾ç¤º |
| | | if (num == 1) |
| | | { |
| | | txtHBarCode_Pack.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HBarCode_Pack")].Value); |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HBarCode_Pack")].Value); |
| | | HSNo = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HSNo")].Value); |
| | | if (HBarCode_Pack == "") |
| | | { |
| | | this.lblSNo.Text = ""; |
| | | } |
| | | else |
| | | { |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | cmdHBPack.Enabled = false; |
| | | } |
| | | } |
| | | //æ«æµè½¬å¡æ¾ç¤º |
| | | if (num == 2) |
| | | { |
| | | //åå§åå³è¾¹è¡¨å¤´ä¿¡æ¯ |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | txtHBarCode_Pack.Text = HBarCode_Pack; |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | } |
| | | //éåæé®æ¾ç¤º |
| | | if (num == 3) |
| | | { |
| | | if (HBarCode_Pack != "" && (HMaterID != DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HMaterID")].Value) |
| | | || HBatchNo != DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ¹å·")].Value))) |
| | | { |
| | | MessageBox.Show("ææ«ææµè½¬å¡å¯¹åºç©æãæ¹å·ä¸å½åæ£å¨ç»æç©æãæ¹å·ä¸ä¸è´ï¼ä¸åç©æãæ¹å·ä¸å
è®¸ç»æå¨å䏿ä¸ï¼å¦éæ¢ç©æçææ¡ç 请å
ç»æå½åç»æï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | //åå§åå³è¾¹è¡¨å¤´ä¿¡æ¯ |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | txtHBarCode_Pack.Text = HBarCode_Pack; |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | } |
| | | txtHBillNo.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("åæ®å·")].Value); |
| | | txtHDeptName.Tag = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HDeptID")].Value); |
| | | txtHDeptName.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("车é´")].Value); |
| | |
| | | txtHBatchNo.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ¹å·")].Value); |
| | | txtHCusMaterName.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HCusMaterName")].Value); |
| | | txtHCusModel.Text = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HCusModel")].Value); |
| | | HMaterID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HMaterID")].Value); |
| | | HBatchNo = DBUtility.ClsPub.isStrNull(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("æ¹å·")].Value); |
| | | HAuxPropID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HAuxPropID")].Value); |
| | | HUnitID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HUnitID")].Value); |
| | | HWhID = DBUtility.ClsPub.isLong(grdSub.SelectedRows[0].Cells[Fun_GetSubCol("HWhID")].Value); |
| | |
| | | string HItemID = ""; |
| | | string HBarCode = ""; |
| | | string HBarCode2 = ""; |
| | | long HSNo_Temp = HSNo; |
| | | for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) |
| | | { |
| | | HItemID = HItemID + "," + DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value.ToString()); |
| | |
| | | { |
| | | HRemark = HRemark + "ã" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | } |
| | | //æ´æ°å½åå·²ç»æä»¶æ° |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) != "" |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) != "æçæ¡ç ") |
| | | { |
| | | HSNo = HSNo - 1; |
| | | } |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "æçæ¡ç ") |
| | | { |
| | | if (DBUtility.ClsPub.isBool(grdMain.SelectedRows[i].Cells[Fun_GetCol("HPackflag")].Value)) |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " 为æçæ¡ç ï¼ä¸å·²ç»æçæå¯¹åºç»æåï¼ä¸å
许ä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | else if (HSNo > 0) |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " 为æçæ¡ç ï¼ä¸å½åæçæ¡ç ä¸å·²çæå¯¹åºæ¡ç ï¼ä¸å
许ä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | HBarCode_Pack = ""; |
| | | } |
| | | } |
| | | } |
| | | if (HRemark != "") |
| | | { |
| | | HSNo = HSNo_Temp; |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼"+ HRemark.Remove(0, 1)+" å·²ä½åºï¼ä¸å
许éå¤ä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | |
| | | catch (Exception e2) |
| | | { |
| | | oCn.RollBack(); |
| | | HSNo = HSNo_Temp; |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(txtHBarCode_Pack.Text); |
| | | MessageBox.Show("ä½åºæ¡ç 失败ï¼" + e2.Message, "æç¤º"); |
| | | return; |
| | | } |
| | | //å·æ°ç§°éè®°å½åè¡¨ä¿¡æ¯ |
| | | BarCode_Display(); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | } |
| | | else |
| | | { |
| | | txtHBarCode_Pack.Text = ""; |
| | | this.lblSNo.Text = ""; |
| | | cmdHBPack.Enabled = true; |
| | | } |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + HBarCode.Remove(0, 1) + " ä½åºæåï¼", "æç¤º"); |
| | | } |
| | | } |
| | |
| | | string HItemID = ""; |
| | | string HBarCode = ""; |
| | | string HBarCode2 = ""; |
| | | long HSNo_Temp = HSNo; |
| | | bool HFlag = false; |
| | | |
| | | //çé¢ä¸ä¸ºæªå¯ç¨ç»æç¶æ |
| | | if (HBarCode_Pack == "") |
| | | { |
| | | for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) |
| | | { |
| | | //夿æ¡ç æ¯å¦ä¸ºæçæ¡ç ï¼æªçæç»æåï¼å·²ä½åºç¶æï¼çé¢ä¸ä¸ºæªç»æç¶æ |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "æçæ¡ç " |
| | | && DBUtility.ClsPub.isBool(grdMain.SelectedRows[i].Cells[Fun_GetCol("HPackflag")].Value) == false |
| | | && DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("ä½åºæ è®°")].Value) != "" |
| | | ) |
| | | { |
| | | HFlag = true; |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value); |
| | | break; |
| | | } |
| | | } |
| | | } |
| | | |
| | | for (int i = 0; i <= grdMain.SelectedRows.Count - 1; i++) |
| | | { |
| | | HItemID = HItemID + "," + DBUtility.ClsPub.isLong(grdMain.SelectedRows[i].Cells[Fun_GetCol("hmainid")].Value.ToString()); |
| | |
| | | { |
| | | HRemark = HRemark + "ã" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | } |
| | | |
| | | //æ¡ç ä¸ºç»ææ¡ç |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) != "") |
| | | { |
| | | //å·²ä¸ä¼ çæç»æå |
| | | if (DBUtility.ClsPub.isBool(grdMain.SelectedRows[i].Cells[Fun_GetCol("HPackflag")].Value)) |
| | | { |
| | | |
| | | } |
| | | //æªä¸ä¼ çæç»æå |
| | | else |
| | | { |
| | | //æ¡ç å¯¹åºææ¡ç åçé¢ä¸çææ¡ç ä¸è´ |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack) |
| | | { |
| | | //æ´æ°å½åå·²ç»æä»¶æ° |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) != "æçæ¡ç ") |
| | | { |
| | | HSNo = HSNo + 1; |
| | | } |
| | | |
| | | } |
| | | //æ¡ç å¯¹åºææ¡ç åçé¢ä¸çææ¡ç ä¸ä¸è´ |
| | | else |
| | | { |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value) + " å¯¹åºææ¡ç ï¼" + DBUtility.ClsPub.isStrNull(grdMain.SelectedRows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) + " å·²çæç»æåï¼æå·²ä½åºï¼ä¸å
许åä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | } |
| | | } |
| | | } |
| | | if (HRemark != "") |
| | | { |
| | | HSNo = HSNo_Temp; |
| | | if(HFlag) |
| | | { |
| | | HBarCode_Pack = ""; |
| | | } |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + HRemark.Remove(0, 1) + " æªä½åºï¼ä¸å
许åä½åºï¼", "æç¤º"); |
| | | return; |
| | | } |
| | |
| | | ",HCusID,HDeptID,HCusBarCode,HMulSourceBill) " + |
| | | " select " + HInterID.ToString() + ",'" + HBillNo + "','" + HBillType + "',HMaterID,HAuxPropID,0" + |
| | | ",HWhID,0,HSPID,0,0,''" + |
| | | ",0,HQty,1,HBatchNo,HBarCode,''" + |
| | | ",0,HQty,1,HBatchNo,HBarCode,HBarCode_Pack" + |
| | | ",'" + HMaker + "',getdate(),HSourceInterID,HSourceEntryID,HSourceBillType,HSourceBillNo" + |
| | | ",0,0,'',0,'',0" + |
| | | ",HSTOCKORGID,HSTOCKORGID,HSTOCKORGID,'','ç§°éå
¥åºçæ-åä½åº','2'" + |
| | | ",0,0,'',0" + |
| | | "from Gy_BarCodeBill with(nolock) where HItemID in (" + HItemID + ")" |
| | | "from Gy_BarCodeBill with(nolock) where HItemID in (" + HItemID + ") and HBarCodeType='å¯ä¸æ¡ç ' " |
| | | ); |
| | | |
| | | //åå
¥ç³»ç»æ¥å¿ |
| | |
| | | catch (Exception e2) |
| | | { |
| | | oCn.RollBack(); |
| | | HSNo = HSNo_Temp; |
| | | if (HFlag) |
| | | { |
| | | HBarCode_Pack = ""; |
| | | } |
| | | MessageBox.Show("åä½åºæ¡ç 失败ï¼" + e2.Message, "æç¤º"); |
| | | return; |
| | | } |
| | | //å·æ°ç§°éè®°å½åè¡¨ä¿¡æ¯ |
| | | BarCode_Display(); |
| | | if (HBarCode_Pack != "") |
| | | { |
| | | txtHBarCode_Pack.Text = HBarCode_Pack; |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | cmdHBPack.Enabled = false; |
| | | } |
| | | else |
| | | { |
| | | txtHBarCode_Pack.Text = ""; |
| | | this.lblSNo.Text = ""; |
| | | cmdHBPack.Enabled = true; |
| | | } |
| | | MessageBox.Show("æéæ¡ç ç¼å·ï¼" + HBarCode.Remove(0, 1) + " åä½åºæåï¼", "æç¤º"); |
| | | } |
| | | } |
| | |
| | | |
| | | #endregion |
| | | |
| | | #region //å¼å§ç»æ |
| | | private void cmdHBPack_Click(object sender, EventArgs e) |
| | | { |
| | | if (!PackSub_AllowSave()) |
| | | { |
| | | return; |
| | | } |
| | | HSNo = 0; |
| | | SavePackBarCode(); |
| | | BarCode_Display(); |
| | | this.lblSNo.Text = "å½åå·²ç» " + HSNo + " ä»¶"; |
| | | grdMain.Rows[0].Selected = true; |
| | | txtHBarCode_Pack.Text = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); |
| | | cmdHBPack.Enabled = false; |
| | | |
| | | sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); |
| | | //èªå¨æå° |
| | | //if (chkHDYFlag.Checked == true) |
| | | //{ |
| | | // //æå°æ¡ç |
| | | // Sub_SetReport("æçæ¡ç "); |
| | | // Report.Print(false); |
| | | // Thread.Sleep(1000); |
| | | //} |
| | | //else |
| | | { |
| | | //éæ©æå°æ¨¡æ¿ |
| | | BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); |
| | | oFrm.sBillName = ModName; |
| | | oFrm.sBillModel = ModCaption; |
| | | oFrm.ShowDialog(); |
| | | if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) |
| | | { |
| | | Sub_SetReport(oFrm.sOpenTmp); |
| | | Report.Print(false); |
| | | Thread.Sleep(1000); |
| | | } |
| | | } |
| | | } |
| | | |
| | | //æ¡ç çæå夿 |
| | | private bool PackSub_AllowSave() |
| | | { |
| | | //夿å½ååæ®IDæ¯å¦å·²ä¸ä¼ çæåæ® |
| | | DataSet Ds = oCn.RunProcReturn("select top 1 1 from KF_WeighSource_Temp with(nolock) where HInterID=" + HInterID.ToString() + " and HRelationInterID=1 ", "KF_WeighSource_Temp", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (Ds == null || Ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("å½åæ¡ç è®°å½å·²æ¢çä¸ä¼ çæåæ®ï¼è¯·éåºåéæ°è¿å
¥è¯¥æ¨¡åè¿è¡æ¡ç çææä½ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | |
| | | if (HInterID == 0 || HBillNo == "") |
| | | { |
| | | MessageBox.Show("è·åæ¡ç 对åºåæ®IDæåæ®å·å¤±è´¥ï¼è¯·éæ°å·æ°çé¢ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | if (HProcessExchangeInterID == 0) |
| | | { |
| | | MessageBox.Show("请å
æ«ææµè½¬å¡å·ï¼", "æç¤º"); |
| | | return false; |
| | | } |
| | | return true; |
| | | } |
| | | |
| | | //çææçæ¡ç |
| | | private void SavePackBarCode() |
| | | { |
| | | int LSHlen = 6; //æµæ°´å·é¿åº¦ |
| | | Int64 LSH = 0; //æµæ°´å· |
| | | string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | string sDate = ""; //æ¥æ |
| | | string sYear = ""; //å¹´ |
| | | string sPeriod = ""; //æ |
| | | string sDay = ""; //æ¥ |
| | | string sTMNumber = ""; //æ¡ç èªå®ä¹åç¼ |
| | | string TM = ""; //æ¡ç ç¼å· |
| | | DataSet Ds; |
| | | |
| | | //æ¥æè·åæ¹å¼ |
| | | sDate = dtpHDate.Value.ToShortDateString(); |
| | | sYear = DBUtility.ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | sPeriod = "0" + DBUtility.ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | sDay = "0" + DBUtility.ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | //================================== |
| | | //æ¡ç åç¼ = 'TP' + ç»ç»ä»£ç + å¹´ + æ + æ¥ |
| | | sTMNumber = "TP" + DBUtility.ClsPub.HOrgNumber + sYear + sPeriod + sDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]); |
| | | LSH = LSH + 1; |
| | | LSH2 = LSH.ToString(); |
| | | while (LSH2.Length < LSHlen) //å¦ææµæ°´å·å°äº6使°åé¢è¡¥0 |
| | | { |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | TM = sTMNumber + LSH2; |
| | | |
| | | string HBarCode = ""; |
| | | string HBarCodeType = ""; |
| | | string HMaterID = ""; //ç©æå
ç |
| | | string HBatchNo = ""; //æ¹æ¬¡ |
| | | string HMaterName = ""; |
| | | string HMaterModel = ""; |
| | | string HProcessExchangeBillNo = ""; |
| | | string HCusMaterName = ""; //客æ·ç©æåç§° |
| | | string HCusModel = ""; //客æ·è§æ ¼åå· |
| | | |
| | | HBarCode = TM; |
| | | HBarCodeType = "æçæ¡ç "; |
| | | HMaterID = DBUtility.ClsPub.isStrNull(txtHMaterNumber.Tag); |
| | | HBatchNo = DBUtility.ClsPub.isStrNull(txtHBatchNo.Text); |
| | | HMaterName = DBUtility.ClsPub.isStrNull(txtHMaterName.Text); |
| | | HMaterModel = DBUtility.ClsPub.isStrNull(txtHMaterModel.Text); |
| | | HProcessExchangeBillNo = DBUtility.ClsPub.isStrNull(txtHBillNo.Text); |
| | | HCusMaterName = DBUtility.ClsPub.isStrNull(txtHCusMaterName.Text); |
| | | HCusModel = DBUtility.ClsPub.isStrNull(txtHCusModel.Text); |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //åå
¥æ¡ç æ¡£æ¡ |
| | | oCn.RunProc("Insert into Gy_BarCodeBill " + |
| | | "(HBarCode,HBarCodeType,HMaterID,HUnitID,HQty,HBarCode_Pack" + |
| | | ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " + |
| | | ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + |
| | | ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate,HMaterialJQty,HMaterialMQty,HNowQty " + |
| | | ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HGiveAwayFlag " + |
| | | ",HOrderInterID,HOrderEntryID,HOrderBillNo,HCustomQty1,HMaterialModel,HCusModel " + |
| | | ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo,HLogo,HPackflag " + |
| | | ") Values (" |
| | | + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + ",1,'" + HBarCode + "'" |
| | | + ",'" + HBatchNo + "'," + HSupID.ToString() + ",0,'" + HMaker + "',getdate(),0,1" |
| | | + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "',''" |
| | | + ",1,0,0,0,0,''" |
| | | + ", 0,'',getdate(),'','" + sDate + "',0,0,0" |
| | | + ", " + HStockOrgID.ToString() + "," + HStockOrgID.ToString() + ",''," + HInterID.ToString() + ",0" |
| | | + ", " + HProcessExchangeInterID.ToString() + ",0,'" + HProcessExchangeBillNo + "',0,'" + HCusMaterName + "','" + HCusModel + "'" |
| | | + ",'" + HMaterName + "','" + HMaterModel + "',''," + HAuxPropID.ToString() + ",'','','1',0)"); |
| | | |
| | | //åå¡«æå¤§æµæ°´å· |
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "',1 "); |
| | | oCn.Commit(); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | | oCn.RollBack(); |
| | | MessageBox.Show("æçæ¡ç çæå¤±è´¥ï¼" + e.Message); |
| | | } |
| | | } |
| | | |
| | | |
| | | #endregion |
| | | |
| | | #region //ç»æç»æ |
| | | private void cmdHEPack_Click(object sender, EventArgs e) |
| | | { |
| | | //çæç»æåå夿 |
| | | if(HBarCode_Pack=="") |
| | | { |
| | | MessageBox.Show("请å
ç¹å»å¼å§ç»æï¼è¿è¡æ¡ç ç»ææä½ï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | bool b = false; |
| | | for (int i = 0; i < grdMain.RowCount; i++) |
| | | { |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("æ¡ç ç±»å")].Value) == "å¯ä¸æ¡ç " |
| | | && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("HBarCode_Pack")].Value) == HBarCode_Pack |
| | | && DBUtility.ClsPub.isStrNull(grdMain.Rows[i].Cells[Fun_GetCol("ä½åºæ è®°")].Value) == "") |
| | | { |
| | | b = true; |
| | | break; |
| | | } |
| | | } |
| | | if (b == false) |
| | | { |
| | | MessageBox.Show("å½åæçæ¡ç ä¸è¿æ²¡çæå¯¹åºæ¡ç ï¼ä¸å
许çæç»æåï¼", "æç¤º"); |
| | | return; |
| | | } |
| | | |
| | | //夿ä¼è®¡ææ¯å¦åç |
| | | string s = ""; |
| | | int sYear = 0; |
| | | int sPeriod = 0; |
| | | if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(HDate, ref sYear, ref sPeriod, ref s) == false) |
| | | { |
| | | MessageBox.Show(s, "æç¤º"); |
| | | return; |
| | | } |
| | | |
| | | try |
| | | { |
| | | oCn.BeginTran(); |
| | | //çæçäº§ç»æå |
| | | Int64 HPUInterID = DBUtility.ClsPub.CreateBillID_Prod("3783", ref DBUtility.ClsPub.sExeReturnInfo); //å¾å°ææ°çäº§ç»æåID |
| | | string HPUBillNo = DBUtility.ClsPub.CreateBillCode_Prod("3783", ref DBUtility.ClsPub.sExeReturnInfo, true); //å¾å°ææ°çäº§ç»æåå· |
| | | |
| | | //åå
¥çäº§ç»æå主表 |
| | | oCn.RunProc("Insert Into Sc_PackUnionBillMain " + |
| | | "(HInterID,HBillNo,HBillType,HBillSubType,HDate,HRemark" + |
| | | ",HYear,HPeriod,HChecker,HCheckDate,HMaker,HMakeDate" + |
| | | ",HICMOInterID,HICMOBillNo,HBarCode_Pack,HMaterID,HUnitID,HProdOrgID" + |
| | | ") Values (" |
| | | + " " + HPUInterID.ToString() + ",'" + HPUBillNo + "','3783','3783',convert(varchar(10),getdate(),120),''" |
| | | + "," + sYear.ToString() + "," + sPeriod.ToString() + ",'" + HMaker + "',getdate(),'" + HMaker + "',getdate()" |
| | | + ",0,'','" + HBarCode_Pack + "',0,0," + HStockOrgID.ToString() + ") "); |
| | | |
| | | //åå
¥ç产è£
ç®±åå表 |
| | | oCn.RunProc("Insert into Sc_PackUnionBillSub " + |
| | | "(HInterID,HEntryID,HRelationQty,HRelationMoney,HRemark" + |
| | | ",HMaterID,HUnitID,HQty,HBarCode,HBarCode_Pack,HScanDate" + |
| | | ",HAuxPropID,HBatchNo,HMTONo" + |
| | | ",HSourceID,HEquipID,HGroupID,HWorkerID,HStatus" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType) " + |
| | | " select " + HPUInterID.ToString() + ",HItemID,0,0,''" + |
| | | ",HMaterID,HUnitID,HQty,HBarCode,HBarCode_Pack,getdate()" + |
| | | ",HAuxPropID,HBatchNo,HMTONo" + |
| | | ",0,0,0,0,0" + |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType" + |
| | | " from Gy_BarCodeBill with(nolock) where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0 and HBarCodeType='å¯ä¸æ¡ç ' " |
| | | ); |
| | | |
| | | //åå¡«æ¡ç æ¡£æ¡ç»ææ è®° |
| | | oCn.RunProc("update Gy_BarCodeBill set HPackflag=1 where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | |
| | | MessageBox.Show("çæçäº§ç»æåï¼" + HPUBillNo + " æåï¼", "æç¤º"); |
| | | |
| | | txtHBarCode_Pack.Text = ""; |
| | | HBarCode_Pack = ""; |
| | | cmdHBPack.Enabled = true; |
| | | HSNo = 0; |
| | | this.lblSNo.Text = ""; |
| | | BarCode_Display(); |
| | | oCn.Commit(); |
| | | return; |
| | | } |
| | | catch (Exception e2) |
| | | { |
| | | oCn.RollBack(); |
| | | MessageBox.Show("çæçäº§ç»æå失败ï¼" + e2.Message); |
| | | return; |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | |
| | | { |
| | | if (double.TryParse(strArray[i], out double ret))//夿æ¯å¦æ¯æ°å |
| | | { |
| | | //ä¿çä¸ä½å°æ° |
| | | double temp = double.Parse(strArray[i]); |
| | | temp = Math.Round(temp,1); |
| | | |
| | | Message += double.Parse(strArray[i]) + ";"; |
| | | } |
| | |
| | | fs.Close(); |
| | | } |
| | | } |
| | | |
| | | #endregion |
| | | |
| | | #endregion |
| | | |
| | | |
| | | |
| | | } |
| | | } |