| | |
| | | cmbSourceBillType.Items.Clear(); |
| | | |
| | | cmbHBarCodeType.Items.Add("ç¹æ¯æå®¢æ·æ¡ç "); |
| | | cmbHBarCodeType.Items.Add("æ¯äºè¿ªå®¢æ·æ¡ç "); |
| | | cmbHBarCodeType.SelectedIndex = 0; |
| | | cmbSourceBillType.Items.Add("ç产订å"); |
| | | cmbSourceBillType.Items.Add("çäº§æ±æ¥å"); |
| | |
| | | MessageBox.Show(" 第" + ClsPub.isLong(grdMain.Rows[j].Cells[HSnoCol].Value) + "è¡ï¼ç©æï¼" + ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNameCol].Value) + " ï¼ä¸å卿°éãæå°å
è£
æ°ãç®±æ°ä¸º 0ï¼ä¸å
è®¸çææ¡ç ï¼"); |
| | | return false; |
| | | } |
| | | else if (CampanyName == "åç»´å°") |
| | | else if (cmbHBarCodeType.Text == "ç¹æ¯æå®¢æ·æ¡ç ") |
| | | { |
| | | long sHMaterID = 0; |
| | | sHMaterID = ClsPub.isLong(grdMain.Rows[j].Cells[HMaterIDCol].Value); |
| | |
| | | string LSH2 = ""; //æµæ°´å·è½¬æ¢æå符 |
| | | string sDate = ""; //æ¥æ |
| | | string sYear = ""; //å¹´ |
| | | string sYear2 = ""; //å¹´ |
| | | int sYear2 = 0; //å¹´ |
| | | string sPeriod = ""; //æ |
| | | string sDay = ""; //æ¥ |
| | | string HBatchNo = ""; //æ¹æ¬¡ |
| | |
| | | string TeSiLaTMDate = ""; //ç¹æ¯ææ¡ç çææ¥æ |
| | | string HProduceDate = ""; //çäº§æ¥æ |
| | | string HExpiryDate = ""; //å¤±ææ¥æ |
| | | string HBYDModel = ""; //é¶é¨ä»¶ä»£ç |
| | | DataSet Ds; |
| | | pb1.Value = 0; |
| | | for (int j = 0; j < grdMain.Rows.Count; j++) |
| | |
| | | HBatchNo = ClsPub.isStrNull(grdMain.Rows[j].Cells[HBatchNoCol].Value); |
| | | sDate = dtpHDate.Value.ToShortDateString(); |
| | | sYear = ClsPub.isDate(sDate).Year.ToString().Substring(2, 2); |
| | | sYear2 = ClsPub.isDate(sDate).Year.ToString(); |
| | | sYear2 = ClsPub.isDate(sDate).Year; |
| | | sPeriod = "0" + ClsPub.isDate(sDate).Month.ToString(); |
| | | sPeriod = sPeriod.Substring(sPeriod.Length - 2, 2); |
| | | sDay = "0" + ClsPub.isDate(sDate).Day.ToString(); |
| | |
| | | HNumber = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterNumberCol].Value); |
| | | HProduceDate = DateTime.Now.ToString("yyyyMMdd"); |
| | | HExpiryDate = DateTime.Now.AddYears(2).ToString("yyyyMMdd"); |
| | | } |
| | | else if (cmbHBarCodeType.Text == "æ¯äºè¿ªå®¢æ·æ¡ç ") |
| | | { |
| | | LSHlen = 5; //æµæ°´å·é¿åº¦ |
| | | HBYDModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HModelCol].Value); |
| | | HModel = DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HModelCol].Value); |
| | | |
| | | int HBYDModelbyteLen = System.Text.Encoding.Default.GetByteCount(HBYDModel); |
| | | if (HBYDModelbyteLen <= 0) |
| | | { |
| | | MessageBox.Show("é¶é¨ä»¶ä»£ç ä¸è½ä¸ºç©ºï¼"); |
| | | return; |
| | | } |
| | | //è·å年份对åºä»£ç |
| | | if (sYear2 <2011) |
| | | { |
| | | MessageBox.Show("æéæ¥æå¹´ä»½ä¸è½å°äº2011å¹´!"); |
| | | return; |
| | | } |
| | | else |
| | | { |
| | | sYear = ConvertToYear(sYear2 - 2011); |
| | | } |
| | | |
| | | //è·åæä»½å¯¹åºä»£ç |
| | | switch (sPeriod) |
| | | { |
| | | case "01": |
| | | sPeriod = "1"; |
| | | break; |
| | | case "02": |
| | | sPeriod = "2"; |
| | | break; |
| | | case "03": |
| | | sPeriod = "3"; |
| | | break; |
| | | case "04": |
| | | sPeriod = "4"; |
| | | break; |
| | | case "05": |
| | | sPeriod = "5"; |
| | | break; |
| | | case "06": |
| | | sPeriod = "6"; |
| | | break; |
| | | case "07": |
| | | sPeriod = "7"; |
| | | break; |
| | | case "08": |
| | | sPeriod = "8"; |
| | | break; |
| | | case "09": |
| | | sPeriod = "9"; |
| | | break; |
| | | case "10": |
| | | sPeriod = "0"; |
| | | break; |
| | | case "11": |
| | | sPeriod = "A"; |
| | | break; |
| | | case "12": |
| | | sPeriod = "B"; |
| | | break; |
| | | default: |
| | | sPeriod = ""; |
| | | break; |
| | | } |
| | | if (sPeriod == "") |
| | | { |
| | | MessageBox.Show("é误çæä»½!"); |
| | | return; |
| | | } |
| | | |
| | | //æ¯äºè¿ªæ¡ç ç¼ç è§å = 6ä½ä¾åºå代ç åºå®ï¼127035ï¼+ 4ä½é¶é¨ä»¶ä»£ç + 4ä½çäº§æ¥æä»£ç + 5ä½ç产åºåå·ï¼æµæ°´å·ï¼ |
| | | sTMNumber = "127035" + HBYDModel + sYear + sPeriod + sDay; |
| | | Ds = oWeb.getDataSetBySQL("exec h_p_WMS_GetMaxNo '" + sTMNumber + "'", "h_p_WMS_GetMaxNo", ref DBUtility.ClsPub.sExeReturnInfo);//è·åæå¤§æµæ°´å· |
| | | LSH = ClsPub.isInt(Ds.Tables[0].Rows[0][0]); |
| | | } |
| | | else |
| | | { |
| | |
| | | |
| | | if (cmbHBarCodeType.Text == "ç¹æ¯æå®¢æ·æ¡ç ") |
| | | { |
| | | //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· |
| | | TM = sTMNumber + LSH2; |
| | | |
| | | //ç¹æ¯ææ¡ç è§å 3SC4I + æ°éï¼6ä½ï¼ä¸è¶³åé¢0è¡¥é½ï¼ + æ¡ç å¼ æ°ï¼001å¼å§ï¼36è¿å¶ï¼ + çäº§æ¥æï¼ä»2017å¹´7æ1æ¥å¼å§è®¡ç®ï¼ä»000å¼å§ï¼36è¿å¶ï¼ + è§æ ¼åå·ï¼å符串ä¸å»é¤â-âï¼æªåâï¼ï¼âååç¬¦ä¸²ï¼ |
| | | //è·åæ¡ç æ°éï¼ä¸è¶³6ä½åé¢0è¡¥é½ |
| | | string sQty = ""; //æ°éè½¬æ¢æå符 |
| | |
| | | CusTM = "[)>+06:" + TeSiLaTM + ":V170474:P" + HModel + ":1P" + HNumber + ":Q" + sQty + ":6D" + HProduceDate + ":14D" + HExpiryDate + ":T:1T" + HBatchNo + ":13E+#"; |
| | | } |
| | | |
| | | //æ¡ç ç¼å· = æ¡ç åç¼ + æµæ°´å· |
| | | TM = sTMNumber + LSH2; |
| | | if (TM.Trim() == "") |
| | | { |
| | | MessageBox.Show("æ¡å½¢ç ä¸è½ä¸ºç©ºï¼ä¸è½çææ¡ç ï¼"); |
| | |
| | | HRemark = "ç¹æ¯æå®¢æ·æ¡ç "; |
| | | HBarCodeStatus = ""; |
| | | } |
| | | else if (cmbHBarCodeType.Text == "æ¯äºè¿ªå®¢æ·æ¡ç ") |
| | | { |
| | | HBarCodeType = "å¯ä¸æ¡ç "; |
| | | HRemark = "æ¯äºè¿ªå®¢æ·æ¡ç "; |
| | | HBarCodeStatus = ""; |
| | | } |
| | | else |
| | | { |
| | | HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text); |
| | |
| | | grdMain.Columns[HMaterNumberCol].HeaderText = "ç©æä»£ç "; |
| | | grdMain.Columns[HMaterNameCol].HeaderText = "ç©æåç§°"; |
| | | grdMain.Columns[HMaterModelCol].HeaderText = "è§æ ¼åå·"; |
| | | grdMain.Columns[HModelCol].HeaderText = "产ååå·"; |
| | | grdMain.Columns[HModelCol].HeaderText = "é¶é¨ä»¶ä»£ç "; |
| | | grdMain.Columns[HPinfanCol].HeaderText = "åçª"; |
| | | grdMain.Columns[HPinfanBarCodeCol].HeaderText = "HPinfanBarCode"; |
| | | grdMain.Columns[HAuxPropIDCol].HeaderText = "è¾
å©å±æ§ID"; |
| | |
| | | grdMain.Columns[HSubIDCol].Visible = false; |
| | | grdMain.Columns[HBillTypeCol].Visible = false; |
| | | grdMain.Columns[HMaterIDCol].Visible = false; |
| | | grdMain.Columns[HModelCol].Visible = false; |
| | | //grdMain.Columns[HModelCol].Visible = false; |
| | | grdMain.Columns[HAuxPropIDCol].Visible = false; |
| | | grdMain.Columns[HUnitIDCol].Visible = false; |
| | | grdMain.Columns[HUnitNumberCol].Visible = false; |
| | |
| | | switch (sCol) |
| | | { |
| | | case HMaterNumberCol: |
| | | oMater.WherePart = ""; |
| | | sWhere = " and HUSEORGID = " + sHOrgID; |
| | | if (oMater.RefreshViewForBig(sWhere)) |
| | | if(cmbHBarCodeType.Text == "æ¯äºè¿ªå®¢æ·æ¡ç ") |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | grdMain.Rows[sRow].Cells[HUnitIDCol].Value = oMater.omodel.HUnitID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = oMater.omodel.HUnitNumber; |
| | | grdMain.Rows[sRow].Cells[HUnitNameCol].Value = oMater.omodel.HUnitName; |
| | | grdMain.Rows[sRow].Cells[HMinQtyCol].Value = oMater.omodel.HQtyMin; |
| | | grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; |
| | | oEdit.Text = oMater.omodel.HNumber; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMinQtyCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; |
| | | } |
| | | if (CampanyName == "åç»´å°") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | { |
| | | sHMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[sRow].Cells[HMaterIDCol].Value); |
| | | //è·ååçª |
| | | oDs2 = oWeb.getDataSetBySQL("exec h_p_HMaterPinfan " + sHMaterID, "h_p_HMaterPinfan", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | if (oDs2 != null && oDs2.Tables[0].Rows.Count > 0) |
| | | oMater.WherePart = ""; |
| | | sWhere = " and HUSEORGID = " + sHOrgID; |
| | | if (oMater.RefreshViewForBYD(sWhere)) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HPinfanCol].Value = DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HPinfan"]); |
| | | grdMain.Rows[sRow].Cells[HPinfanBarCodeCol].Value = DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HPinfanBarCode"]); |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | grdMain.Rows[sRow].Cells[HUnitIDCol].Value = oMater.omodel.HUnitID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = oMater.omodel.HUnitNumber; |
| | | grdMain.Rows[sRow].Cells[HUnitNameCol].Value = oMater.omodel.HUnitName; |
| | | grdMain.Rows[sRow].Cells[HMinQtyCol].Value = oMater.omodel.HQtyMin; |
| | | grdMain.Rows[sRow].Cells[HModelCol].Value = oMater.omodel.HCusRelationNumber; |
| | | oEdit.Text = oMater.omodel.HNumber; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HPinfanCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HPinfanBarCodeCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMinQtyCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HModelCol].Value = ""; |
| | | } |
| | | if (CampanyName == "åç»´å°") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | { |
| | | sHMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[sRow].Cells[HMaterIDCol].Value); |
| | | //è·ååçª |
| | | oDs2 = oWeb.getDataSetBySQL("exec h_p_HMaterPinfan " + sHMaterID, "h_p_HMaterPinfan", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | if (oDs2 != null && oDs2.Tables[0].Rows.Count > 0) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HPinfanCol].Value = DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HPinfan"]); |
| | | grdMain.Rows[sRow].Cells[HPinfanBarCodeCol].Value = DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HPinfanBarCode"]); |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HPinfanCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HPinfanBarCodeCol].Value = ""; |
| | | } |
| | | } |
| | | } |
| | | else |
| | | { |
| | | oMater.WherePart = ""; |
| | | sWhere = " and HUSEORGID = " + sHOrgID; |
| | | if (oMater.RefreshViewForBig(sWhere)) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = oMater.omodel.HItemID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = oMater.omodel.HNumber; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = oMater.omodel.HName; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = oMater.omodel.HModel; |
| | | grdMain.Rows[sRow].Cells[HUnitIDCol].Value = oMater.omodel.HUnitID.ToString(); |
| | | grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = oMater.omodel.HUnitNumber; |
| | | grdMain.Rows[sRow].Cells[HUnitNameCol].Value = oMater.omodel.HUnitName; |
| | | grdMain.Rows[sRow].Cells[HMinQtyCol].Value = oMater.omodel.HQtyMin; |
| | | grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; |
| | | oEdit.Text = oMater.omodel.HNumber; |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HMaterIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HMaterNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMaterModelCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HUnitIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HUnitNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HUnitNameCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HMinQtyCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HAuxPropIDCol].Value = 0; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNumberCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HAuxPropNameCol].Value = ""; |
| | | } |
| | | if (CampanyName == "åç»´å°") //ç³»ç»åæ° å®¢æ·å®å¶ååç§° |
| | | { |
| | | sHMaterID = DBUtility.ClsPub.isLong(grdMain.Rows[sRow].Cells[HMaterIDCol].Value); |
| | | //è·ååçª |
| | | oDs2 = oWeb.getDataSetBySQL("exec h_p_HMaterPinfan " + sHMaterID, "h_p_HMaterPinfan", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | // |
| | | if (oDs2 != null && oDs2.Tables[0].Rows.Count > 0) |
| | | { |
| | | grdMain.Rows[sRow].Cells[HPinfanCol].Value = DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HPinfan"]); |
| | | grdMain.Rows[sRow].Cells[HPinfanBarCodeCol].Value = DBUtility.ClsPub.isStrNull(oDs2.Tables[0].Rows[0]["HPinfanBarCode"]); |
| | | } |
| | | else |
| | | { |
| | | grdMain.Rows[sRow].Cells[HPinfanCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HPinfanBarCodeCol].Value = ""; |
| | | } |
| | | } |
| | | } |
| | | break; |
| | |
| | | return newNumber; |
| | | } |
| | | |
| | | //æ¯äºè¿ªè·å年份对åºä»£ç |
| | | public string ConvertToYear(int num) |
| | | { |
| | | string chars = "BCDEFGHJKLMNPRSTVWXY123456789A"; |
| | | int r; |
| | | string newNumber = ""; |
| | | if (num >= 30) |
| | | { |
| | | r = num % 30; |
| | | newNumber = chars[r].ToString(); |
| | | } |
| | | else |
| | | { |
| | | newNumber = chars[num].ToString(); |
| | | } |
| | | return newNumber; |
| | | } |
| | | |
| | | //忥åºç¡èµæä¿¡æ¯ |
| | | private void tb_Click(object sender, EventArgs e) |
| | | { |