| | |
| | | return; |
| | | } |
| | | //è¶
èåæ°åææ¯æéå
¬å¸ æ¡ç ç¼å·ï¼å
±26ä½ï¼ = 代ç ï¼1ä½åºå®âSâï¼ + åå代ç ï¼2ä½åºå®âY3âï¼ + å¹´ï¼2ä½å¹´å两ä½ï¼ + æï¼1ä½10=A,11=B,12=Cï¼ + æµæ°´å·ï¼7ä½ï¼ + 代å·ï¼2ä½åºå®â1Pâï¼ + 客æ·ä»£ç ï¼8ä½åéè¶å®¢æ·ç©æå¯¹åºè¡¨å®¢æ·ç©æç¼ç ï¼ + ç©æçæ¬ï¼3ä½åç©æç¼ç åä¸ä½ï¼ |
| | | TM = "SY3" + sYear + sPeriod + LSH2 + "1P" + sHCusModelName + HMaterNumber; |
| | | TM = "SY3" + sYear + sPeriod + LSH2 + "1P" + sHCusModelName; |
| | | //TM = "SY3" + sYear + sPeriod + LSH2 + "1P" + sHCusModelName + HMaterNumber; |
| | | |
| | | HEntryID = j + 1; |
| | | HBarCode = TM.ToUpper(); |
| | |
| | | HRemark = ClsPub.isStrNull(grdMain.Rows[j].Cells[HRemarkCol].Value); |
| | | HMTONo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HMTONoCol].Value); |
| | | HInnerBillNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HInnerBillNoCol].Value); |
| | | HCode3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value).ToUpper(); |
| | | HSno = ClsPub.isStrNull(LSH); |
| | | HBoxNo = sTMNumber; |
| | | sHBaNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBaNoCol].Value); // çé¢ä¸è¾å
¥çæ¹æ¬¡ä½ |
| | | |
| | | //è¶
èåæ°åææ¯æéå
¬å¸ 客æ·ç©æç¼ç HCusModelNameãæµæ°´å·HSnoãæµæ°´å·HSupNumberãæµæ°´å·çæåç¼HBoxNo |
| | | //è¶
èåæ°åææ¯æéå
¬å¸ 客æ·ç©æç¼ç HCusModelNameãæµæ°´å·HSnoãæµæ°´å·HSupNumberãæµæ°´å·çæåç¼HBoxNoãç©æçæ¬HCode3 |
| | | oCn.RunProc("insert into Gy_BarCodeBill_Cus" + |
| | | "(HInterID,HEntryID,HBillType,HBarCode,HBarCodeType" + |
| | | ",HMaterID,HUnitID,HAuxPropID,HBatchNo,HQty" + |
| | |
| | | grdMain.Columns[HBaNoCol].Visible = false; |
| | | grdMain.Columns[HCode1Col].Visible = false; |
| | | grdMain.Columns[HCode2Col].Visible = false; |
| | | grdMain.Columns[HCode3Col].Visible = false; |
| | | //grdMain.Columns[HCode3Col].Visible = false; |
| | | grdMain.Columns[HInnerBillNoCol].Visible = false; |
| | | |
| | | //设置å¯ç¼è¾å |