| | |
| | | public const Int16 HCusModelCol = 49; |
| | | // |
| | | public string ModName = "85"; |
| | | public string ModCaption = "æ°åä¸å®¢æ·æ ç¾çæ"; |
| | | public string ModCaption = "æ°åä¸ã䏿¹éä¿¡ãç»åãç´«å
åæºå®¢æ·æ ç¾çæ"; |
| | | public const string ModRightName = "Gy_CusBarCodeBill_KaiBei_HuaSan"; |
| | | |
| | | public DBUtility.ClsPub.Enum_BillStatus BillStatus; |
| | |
| | | { |
| | | HBarCodeType = "䏿¹éä¿¡å
ç®±ç "; |
| | | } |
| | | else if (cmbHCusName.Text.Contains("ç»å")) |
| | | { |
| | | HBarCodeType = "ç»åå
ç®±ç "; |
| | | } |
| | | else if (cmbHCusName.Text.Contains("ç´«å
åæº")) |
| | | { |
| | | HBarCodeType = "ç´«å
åæºå
ç®±ç "; |
| | | } |
| | | else |
| | | { |
| | | HBarCodeType = "æ°åä¸å
ç®±ç "; |
| | |
| | | //æ¡ç åç¼ = 2ä½åºå®ç ï¼'09'ï¼ + CPN客æ·ç¼ç ï¼è§æ ¼åå·ï¼+ 2ä½é¢çç ï¼åºå®'01'ï¼+ 5ä½å¹´å¹´ææ¥æ¥ï¼YYMDDï¼ + 3ä½09ç æµæ°´å·ï¼åºå®'001'ï¼ + ä¾åºå代ç ï¼åºå®'105652'ï¼ |
| | | sWTMNumber = "09" + HMaterModel + "01" + sYear + sPeriod + sDay + "001105652"; |
| | | } |
| | | //æ°åä¸ |
| | | //æ°åä¸ãç»åãç´«å
åæº |
| | | else |
| | | { |
| | | //æ¡ç åç¼ = 2ä½åºå®ç ï¼'09'ï¼ + CPN客æ·ç¼ç ï¼è§æ ¼åå·ï¼+ 2ä½é¢çç ï¼åºå®'01'ï¼+ 5ä½å¹´å¹´ææ¥æ¥ï¼YYMDDï¼ + 3ä½09ç æµæ°´å·ï¼åºå®'001'ï¼ + ä¾åºå代ç ï¼åºå®'151091'ï¼ |
| | |
| | | if (cmbHCusName.Text.Contains("䏿¹éä¿¡")) |
| | | { |
| | | HBarCodeType = "䏿¹éä¿¡å¤ç®±ç "; |
| | | } |
| | | else if (cmbHCusName.Text.Contains("ç»å")) |
| | | { |
| | | HBarCodeType = "ç»åå¤ç®±ç "; |
| | | } |
| | | else if (cmbHCusName.Text.Contains("ç´«å
åæº")) |
| | | { |
| | | HBarCodeType = "ç´«å
åæºå¤ç®±ç "; |
| | | } |
| | | else |
| | | { |
| | |
| | | private void Display() |
| | | { |
| | | //å·æ°å
ç®±ç å表 |
| | | DataSet DSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and (æ¡ç ç±»å='æ°åä¸å
ç®±ç ' or æ¡ç ç±»å='䏿¹éä¿¡å
ç®±ç ) order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | DataSet DSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and (æ¡ç ç±»å in ('æ°åä¸å
ç®±ç ','䏿¹éä¿¡å
ç®±ç ','ç»åå
ç®±ç ','ç´«å
åæºå
ç®±ç ') order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //çæé¦è¡æ é¢ |
| | | if (DSet == null) |
| | | { |
| | |
| | | grdSub.DataSource = DSet.Tables[0].DefaultView; |
| | | |
| | | //å·æ°å¤ç®±ç å表 |
| | | DataSet DWSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and (æ¡ç ç±»å='æ°åä¸å¤ç®±ç ' or æ¡ç ç±»å='䏿¹éä¿¡å¤ç®±ç ) order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | DataSet DWSet = oCn.RunProcReturn("select * from h_v_Gy_BarCodeBill_CusList where HInterID=" + HInterID.ToString() + " and (æ¡ç ç±»å in ('æ°åä¸å¤ç®±ç ','䏿¹éä¿¡å¤ç®±ç ','ç»åå¤ç®±ç ','ç´«å
åæºå¤ç®±ç ') order by HItemID", "h_v_Gy_BarCodeBill_CusList", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | //çæé¦è¡æ é¢ |
| | | if (DWSet == null) |
| | | { |
| | |
| | | { |
| | | try |
| | | { |
| | | oCn.RunProc("update Gy_BarCodeBill_Cus set HPrintQty=isnull(HPrintQty,0)+1 where HBarCodeType in ('æ°åä¸å
ç®±ç ','䏿¹éä¿¡å
ç®±ç ') and HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.RunProc("update Gy_BarCodeBill_Cus set HPrintQty=isnull(HPrintQty,0)+1 where HBarCodeType in ('æ°åä¸å
ç®±ç ','䏿¹éä¿¡å
ç®±ç ','ç»åå
ç®±ç ','ç´«å
åæºå
ç®±ç ') and HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | { |
| | | try |
| | | { |
| | | oCn.RunProc("update Gy_BarCodeBill_Cus set HPrintQty=isnull(HPrintQty,0)+1 where HBarCodeType in ('æ°åä¸å¤ç®±ç ','䏿¹éä¿¡å¤ç®±ç ') and HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | oCn.RunProc("update Gy_BarCodeBill_Cus set HPrintQty=isnull(HPrintQty,0)+1 where HBarCodeType in ('æ°åä¸å¤ç®±ç ','䏿¹éä¿¡å¤ç®±ç ','ç»åå¤ç®±ç ','ç´«å
åæºå¤ç®±ç ') and HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); |
| | | } |
| | | catch (Exception e) |
| | | { |