| | |
| | | public int selectRow = 0; |
| | | public Int64 HInterID = 0; //å
ç |
| | | public Int64 HOrgID = ClsPub.HOrgID; |
| | | public string HCusModel = "Z"; //åå代ç |
| | | public string sDate = ""; //æ¥æ |
| | | public string sYear = ""; //å¹´ï¼2ä½ï¼ |
| | | public string sYear4 = ""; //å¹´ï¼4ä½ï¼ |
| | |
| | | //æ¸
空çé¢ |
| | | public void Sub_ClearBill() |
| | | { |
| | | cmbHBarCodeType.Items.Clear(); |
| | | cmbSourceBillType.Items.Clear(); |
| | | //æ¡ç ç±»å |
| | | cmbHBarCodeType.Items.Add("å
ç®±ç "); |
| | | cmbHBarCodeType.Items.Add("å¤ç®±ç "); |
| | | //æºåç±»å |
| | | cmbSourceBillType.Items.Add("çäº§æ±æ¥å"); |
| | | cmbSourceBillType.Items.Add("ç产订å"); |
| | | |
| | | DBUtility.Xt_BaseBillFun.Sub_ClearBill(gbUp); |
| | | //è·åå½åç»ç» |
| | |
| | | //å 载客æ·ä¿¡æ¯ |
| | | private void Sub_AddHCusNameList() |
| | | { |
| | | DataSet ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_Cus " + HOrgID.ToString(), "h_p_Gy_CusBarCodeBill_Cus"); |
| | | DataSet ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_Cus_KaiBei " + HOrgID.ToString(), "h_p_Gy_CusBarCodeBill_Cus_KaiBei"); |
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
| | | { |
| | | cmbHCusName.DataSource = null; |
| | |
| | | sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | | sDay = sDay.Substring(sDay.Length - 2, 2); |
| | | //================================== |
| | | switch (sYear) |
| | | { |
| | | case "22": |
| | | sYear = "N"; |
| | | break; |
| | | case "23": |
| | | sYear = "P"; |
| | | break; |
| | | case "24": |
| | | sYear = "Q"; |
| | | break; |
| | | case "25": |
| | | sYear = "R"; |
| | | break; |
| | | case "26": |
| | | sYear = "S"; |
| | | break; |
| | | case "27": |
| | | sYear = "T"; |
| | | break; |
| | | case "28": |
| | | sYear = "U"; |
| | | break; |
| | | case "29": |
| | | sYear = "V"; |
| | | break; |
| | | case "30": |
| | | sYear = "W"; |
| | | break; |
| | | case "31": |
| | | sYear = "X"; |
| | | break; |
| | | case "32": |
| | | sYear = "Y"; |
| | | break; |
| | | case "33": |
| | | sYear = "Z"; |
| | | break; |
| | | default: |
| | | sYear = ""; |
| | | break; |
| | | } |
| | | if (sYear == "") |
| | | { |
| | | MessageBox.Show("é误ç年份ï¼"); |
| | | return false; |
| | | } |
| | | |
| | | switch (sPeriod) |
| | | { |
| | | case "01": |
| | |
| | | double HSourceQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[HInitQtyCol].Value); // æºåæ°é |
| | | double HQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[HQtyCol].Value); // æ°é |
| | | double HMinQty = DBUtility.ClsPub.isDoule(grdMain.Rows[j].Cells[HMinQtyCol].Value); // æå°å
è£
æ° |
| | | string HCusModelName = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value); // å®¢æ·æå· |
| | | string HCusModelName = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value); // 客æ·ç©æç¼ç |
| | | string HCode1 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode1Col].Value); // ç©æç±»å« |
| | | string HCode2 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode2Col].Value); // æ¹æ¬¡ä½ |
| | | HCode2 = HCode2.ToUpper(); |
| | | string HCode3 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value); // çæ¬å· |
| | | string HBatchNoNumber = HCode1 + sYear + sPeriod + sDay + HCusModel; // æ¹æ¬¡çæåç¼ |
| | | HBatchNoNumber = HBatchNoNumber.ToUpper(); |
| | | string HBarCodeType = DBUtility.ClsPub.isStrNull(cmbHBarCodeType.Text); // æ¡ç ç±»å |
| | | string HBatchNoNumber = ""; // æ¹æ¬¡çæåç¼ |
| | | string HBarCodeType = "è¶
èåå
æ ç¾"; // æ¡ç ç±»å |
| | | string HInnerBillNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HInnerBillNoCol].Value); // 客æ·è®¢åå· |
| | | |
| | | if (HMaterID != 0) |
| | |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[j].Cells[HBaNoCol].Value = HCode2; |
| | | grdMain.Rows[j].Cells[HBatchNoCol].Value = DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HBatchNo"]); |
| | | grdMain.Rows[j].Cells[HCode2Col].Value = DBUtility.ClsPub.isStrNull(oDsCheck.Tables[0].Rows[0]["HCode2"]); |
| | | |
| | | if (DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HExpiryDateCol].Value) == "") |
| | | { |
| | | if (DBUtility.ClsPub.isBool(oDsCheck.Tables[0].Rows[0]["HISKFPERIOD"])) |
| | |
| | | try |
| | | { |
| | | string TM = ""; //æ¡ç |
| | | int LSHlen = 4; //æµæ°´å·é¿åº¦ |
| | | int LSHlen = 7; //æµæ°´å·é¿åº¦ |
| | | double HSumQty = 0; //äº§åæ°é |
| | | double HMinQty = 0; //æå°å
è£
æ° |
| | | int HBQty = 0; //ç®±æ° |
| | | int LSH = 0; //å
ç®±æµæ°´å· |
| | | int LWSH = 0; //å¤ç®±æµæ°´å· |
| | | int LSH = 0; //æµæ°´å· |
| | | string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | string HCode1 = ""; //ç©æç±»å« |
| | | string HCode2 = ""; //æ¹æ¬¡ä½ |
| | | string HCode3 = ""; //çæ¬å· |
| | | string sTMNumber = ""; //å¤ç®±æ¡ç åç¼ |
| | | string sTMNumber = ""; //æ¡ç åç¼ |
| | | DataSet Ds; |
| | | |
| | | Int64 HEntryID = 0; |
| | |
| | | string HBatchNo = ""; //æ¹æ¬¡ |
| | | double HQty = 0; //æ°é |
| | | Int64 HCusID = 0; //客æ·ID |
| | | string HCusModelName = ""; //å®¢æ·æå· |
| | | string HCusModelName = ""; //客æ·ç©æç¼ç |
| | | bool HGiveAwayFlag = false; //èµ åæ è®° |
| | | string HProduceDate; //çäº§æ¥æï¼ä¿è´¨æç¨ï¼ |
| | | string HExpiryDate; //ä¿è´¨æè³ï¼ä¿è´¨æç¨ï¼ |
| | |
| | | string HMTONo = ""; //MTOå· |
| | | string HRemark = ""; //夿³¨ |
| | | string HInnerBillNo = ""; //客æ·è®¢åå· |
| | | string HSno = ""; //æ¹æ¬¡åºåå· |
| | | string HSno = ""; //æµæ°´å· |
| | | string HBoxNo = ""; //æ¹æ¬¡çæåç¼ |
| | | string sHBaNo = ""; //çé¢ä¸è¾å
¥çæ¹æ¬¡ä½ |
| | | int HSumBQty = 0; //å䏿¹çææ¡ç æ»ç®±æ° |
| | |
| | | Application.DoEvents(); |
| | | if (ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value) != 0) |
| | | { |
| | | HBatchNo = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HBatchNoCol].Value); |
| | | HCode3 = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value); |
| | | string HMaterNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNumberCol].Value); |
| | | HMaterNumber = HMaterNumber.Substring(HMaterNumber.Length - 3, 3); //åç©æä»£ç åä¸ä½ |
| | | string sHCusModelName = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HCusModelNameCol].Value); //客æ·ä»£ç ï¼åéè¶å®¢æ·ç©æå¯¹åºè¡¨å®¢æ·ç©æç¼ç ï¼ |
| | | |
| | | if (cmbHBarCodeType.Text == "å
ç®±ç ") |
| | | { |
| | | //è·åæå¤§æµæ°´å· |
| | | LSH = 0; |
| | | Ds = oCn.RunProcReturn("select top 1 HSno from Gy_BarCodeBill_Cus where HBatchNo='" + HBatchNo + "' order by HSno desc", "Gy_BarCodeBill_Cus"); |
| | | if (Ds != null && Ds.Tables[0].Rows.Count != 0) |
| | | { |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | } |
| | | } |
| | | //å¤ç®±ç ä¾åºå代ç ï¼æµªæ½®å®ä¹çä¾åºå代ç ï¼+8使¥æï¼ä¾å¦20230905ï¼+5使µæ°´ç ï¼çº¯æ°åï¼ |
| | | else |
| | | { |
| | | //æ¡ç åç¼ = ä¾åºå代ç + å¹´ + æ + æ¥ |
| | | sTMNumber = HCusModel + sYear + sPeriod + sDay; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LWSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | } |
| | | //æ¡ç åç¼ = å¹´ + æ |
| | | sTMNumber = sYear + sPeriod; |
| | | Ds = oCn.RunProcReturn("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo"); //è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | |
| | | HBQty = ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); |
| | | HMinQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HMinQtyCol].Value); |
| | |
| | | HSumBQty = HSumBQty + ClsPub.isInt(grdMain.Rows[j].Cells[HBQtyCol].Value); |
| | | pb1.Maximum = HSumBQty; |
| | | |
| | | int nn = 0; //æ¬æ¬¡æµæ°´å·ç´¯è®¡ä½¿ç¨ä¸ªæ° |
| | | for (int i = 0; i < HBQty; i++) |
| | | { |
| | | pb1.Value = n+1; |
| | |
| | | HMinQty = HSumQty; |
| | | } |
| | | // |
| | | if (cmbHBarCodeType.Text == "å
ç®±ç ") |
| | | LSH = LSH + 1; |
| | | LSH2 = LSH.ToString(); |
| | | while (LSH2.Length < LSHlen) //å¦ææµæ°´å·ä½æ°å°äº æµæ°´å·é¿åº¦ åé¢è¡¥0 |
| | | { |
| | | LSH = LSH + 1; |
| | | LSH2 = ConvertToBase(LSH, 36); |
| | | while (LSH2.Length < LSHlen) //å¦ææµæ°´å·ä½æ°å°äº LSHlen åé¢è¡¥0 |
| | | { |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | //æ¡ç ç¼å· = æ¹æ¬¡ + æµæ°´å· + çæ¬å· |
| | | TM = HBatchNo + LSH2 + HCode3; |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | //å¤ç®±ç |
| | | else |
| | | if (LSH2.Length != 7) |
| | | { |
| | | LWSH = LWSH + 1; |
| | | LSH2 = LWSH.ToString(); |
| | | while (LSH2.Length < 5) //å¦ææµæ°´å·ä½æ°å°äº 5 åé¢è¡¥0 |
| | | { |
| | | LSH2 = "0" + LSH2; |
| | | } |
| | | TM = sTMNumber + LSH2; |
| | | MessageBox.Show("æ¡ç æµæ°´å·ä¸º[" + LSH2 + "]ï¼é¿åº¦ä¸å
许è¶
è¿7ä½ï¼"); |
| | | 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; |
| | | |
| | | HEntryID = j + 1; |
| | | HBarCode = TM.ToUpper(); |
| | | HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text); |
| | | HBarCodeType = "è¶
èåå
æ ç¾"; |
| | | HMaterID = ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value); |
| | | HUnitID = ClsPub.isLong(grdMain.Rows[j].Cells[HUnitIDCol].Value); |
| | | HAuxPropID = ClsPub.isLong(grdMain.Rows[j].Cells[HAuxPropIDCol].Value); |
| | |
| | | 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); |
| | | HCode1 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode1Col].Value).ToUpper(); |
| | | HCode2 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode2Col].Value).ToUpper(); |
| | | HCode3 = ClsPub.isStrNull(grdMain.Rows[j].Cells[HCode3Col].Value).ToUpper(); |
| | | HSno = ClsPub.isStrNull(LSH); |
| | | HBoxNo = HCode1 + sYear + sPeriod + sDay + HCusModel; |
| | | HBoxNo = HBoxNo.ToUpper(); |
| | | HBoxNo = sTMNumber; |
| | | sHBaNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBaNoCol].Value); // çé¢ä¸è¾å
¥çæ¹æ¬¡ä½ |
| | | |
| | | //å®¢æ·æå·HCusModelNameãç©æç±»å«HCode1ãæ¹æ¬¡ä½HCode2ãçæ¬å·HCode3ãæ¹æ¬¡åºåå·HSnoãæ¹æ¬¡çæåç¼HBoxNoãåå代ç HCusModel |
| | | //çé¢ä¸è¾å
¥çæ¹æ¬¡ä½HSupNameã36è¿å¶æ¹æ¬¡åºåå·HSupNumberã客æ·è®¢åå·HInnerBillNo |
| | | //è¶
èåæ°åææ¯æéå
¬å¸ 客æ·ç©æç¼ç HCusModelNameãæµæ°´å·HSnoãæµæ°´å·HSupNumberãæµæ°´å·çæåç¼HBoxNo |
| | | oCn.RunProc("insert into Gy_BarCodeBill_Cus" + |
| | | "(HInterID,HEntryID,HBillType,HBarCode,HBarCodeType" + |
| | | ",HMaterID,HUnitID,HAuxPropID,HBatchNo,HQty" + |
| | |
| | | ",HCode2,HCode3,HBackDataFlag,HSno,HBoxNo" + |
| | | ") values (" + HInterID + "," + HEntryID + ",'','" + HBarCode + "','" + HBarCodeType + "'" |
| | | + "," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HAuxPropID.ToString() + ",'" + HBatchNo + "'," + HQty.ToString() |
| | | + "," + HCusID.ToString() + ",'" + HCusModel + "','" + HCusModelName + "','" + sDate + "',''" |
| | | + "," + HCusID.ToString() + ",'','" + HCusModelName + "','" + sDate + "',''" |
| | | + "," + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + "," + DBUtility.ClsPub.BoolToString(HISKFPERIOD) + ",''" |
| | | + "," + (HProduceDate == "" ? "NULL" : "'" + HProduceDate + "'") + "," + (HExpiryDate == "" ? "NULL" : "'" + HExpiryDate + "'") |
| | | + "," + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + ",1,0" |
| | |
| | | + ",'','','" + LSH2 + "','" + sHBaNo + "','" + HCode1 + "'" |
| | | + ",'" + HCode2 + "','" + HCode3 + "','','" + HSno + "','" + HBoxNo + "')"); |
| | | n = n + 1; |
| | | nn = nn + 1; |
| | | Application.DoEvents(); |
| | | } |
| | | //åå¡«æµæ°´å·ä¿¡æ¯ |
| | | oCn.RunProc("exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + nn.ToString() + " "); |
| | | } |
| | | } |
| | | oCn.Commit(); |
| | |
| | | grdMain.Columns[HMaterNumberCol].HeaderText = "ç©æä»£ç "; |
| | | grdMain.Columns[HMaterNameCol].HeaderText = "ç©æåç§°"; |
| | | grdMain.Columns[HMaterModelCol].HeaderText = "è§æ ¼åå·"; |
| | | grdMain.Columns[HCusModelNameCol].HeaderText = "å®¢æ·æå·"; |
| | | grdMain.Columns[HCusModelNameCol].HeaderText = "客æ·ç©æç¼ç "; |
| | | grdMain.Columns[HUnitIDCol].HeaderText = "计éåä½ID"; |
| | | grdMain.Columns[HUnitNumberCol].HeaderText = "计éåä½ä»£ç "; |
| | | grdMain.Columns[HUnitNameCol].HeaderText = "计éåä½åç§°"; |
| | |
| | | grdMain.Columns[HAuxPropNumberCol].Visible = false; |
| | | grdMain.Columns[HAuxPropNameCol].Visible = false; |
| | | grdMain.Columns[HBatchManagerCol].Visible = false; |
| | | grdMain.Columns[HBatchNoCol].Visible = false; |
| | | grdMain.Columns[HGiveAwayFlagCol].Visible = false; |
| | | grdMain.Columns[HProduceDateCol].Visible = false; |
| | | grdMain.Columns[HExpiryDateCol].Visible = false; |
| | |
| | | grdMain.Columns[HEXPPERIODCol].Visible = false; |
| | | grdMain.Columns[HLSHCol].Visible = false; |
| | | grdMain.Columns[HBaNoCol].Visible = false; |
| | | grdMain.Columns[HCode1Col].Visible = false; |
| | | grdMain.Columns[HCode2Col].Visible = false; |
| | | grdMain.Columns[HCode3Col].Visible = false; |
| | | grdMain.Columns[HInnerBillNoCol].Visible = false; |
| | | |
| | | //设置å¯ç¼è¾å |
| | | string sAllowCol = HQtyCol.ToString()+ |
| | |
| | | |
| | | private void cmdSourceBillNo_Click(object sender, EventArgs e) |
| | | { |
| | | if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") |
| | | if (cmbSourceBillType.Text.Trim() == "ç产订å") |
| | | { |
| | | string sWhere = " and HOrgID =" + HOrgID.ToString(); |
| | | DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei oIF_ICMOBillList = new DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill_KaiBei(); |
| | | if (oIF_ICMOBillList.Refresh(sWhere)) //éæ©åå |
| | | { |
| | | FillSelectData(oIF_ICMOBillList.oBillSelectColl); |
| | | } |
| | | } |
| | | else if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") |
| | | { |
| | | string sWhere = " and HOrgID =" + HOrgID.ToString(); |
| | | DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill oIF_ICMOReportBillList = new DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill(); |
| | |
| | | foreach (DBUtility.BillSelect oSelectRow in oList) |
| | | { |
| | | i = i + 1; |
| | | //ç产订å |
| | | if (oSelectRow.BillType == "3710") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | grdMain.Rows[i].Cells[HTagCol].Value = "*"; |
| | | //å¾å°ä¿¡æ¯ |
| | | Ds = oCn.RunProcReturn("exec h_p_Gy_CusBarCodeBill_ICMOBillList " + oSelectRow.BillMainID.ToString() + "," + oSelectRow.BillSubID.ToString() + ",'1'", "h_p_Gy_CusBarCodeBill_ICMOBillList"); |
| | | //åå
¥ä¿¡æ¯ |
| | | Sub_WriteInForm1(Ds.Tables[0], i); |
| | | GetCusMatNo(1); |
| | | } |
| | | //çäº§æ±æ¥å |
| | | if (oSelectRow.BillType == "3711") |
| | | else if (oSelectRow.BillType == "3711") |
| | | { |
| | | grdMain.Rows.Add(); |
| | | grdMain.Rows[i].Cells[HTagCol].Value = "*"; |
| | |
| | | return; |
| | | } |
| | | //æ ¹æ®æºåç±»å åæºåå· è·åä¿¡æ¯ |
| | | if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") |
| | | if (cmbSourceBillType.Text.Trim() == "ç产订å") |
| | | { |
| | | DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill oIF_ICMOBillList = new DAL.Cls_S_IF_ICMOBillList_CusBarCodeBill(); |
| | | if (oIF_ICMOBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' and HOrgID =" + HOrgID.ToString())) //éæ©åå |
| | | { |
| | | FillSelectData(oIF_ICMOBillList.oBillSelectColl); |
| | | txtHSourceBillNo.Text = ""; |
| | | } |
| | | else |
| | | { |
| | | MessageBox.Show("æªæ¥è¯¢å°ä»»å¡æ°æ®ï¼è¯·ç¡®è®¤æéç»ç»ãæºåç±»å䏿ºååå·æ¯å¦æ£ç¡®ï¼"); |
| | | return; |
| | | } |
| | | } |
| | | else if (cmbSourceBillType.Text.Trim() == "çäº§æ±æ¥å") |
| | | { |
| | | DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill oIF_ICMOReportBillList = new DAL.Cls_S_IF_ICMOReportBillList_CusBarCodeBill(); |
| | | if (oIF_ICMOReportBillList.RefreshBySourceBillNo(" Where åæ®å· like '%" + txtHSourceBillNo.Text + "' and HOrgID =" + HOrgID.ToString())) //éæ©åå |