| | |
| | | using gregn6Lib; |
| | | using Pub_Class; |
| | | using System.Threading; |
| | | using System.Text.RegularExpressions; |
| | | |
| | | namespace WarM |
| | | { |
| | |
| | | public const Int16 HBarCodeTypeCol = 16; |
| | | public const Int16 HQtyCol = 17; |
| | | public const Int16 HMinQtyCol = 18; |
| | | public const Int16 HBQtyCol = 19; |
| | | public const Int16 HinitQtyCol = 20; |
| | | public const Int16 HISKFPERIODCol = 21; |
| | | public const Int16 HProduceDateCol = 22; |
| | | public const Int16 HExpiryDateCol = 23; |
| | | public const Int16 HEXPUNITCol = 24; |
| | | public const Int16 HEXPPERIODCol = 25; |
| | | public const Int16 HGiveAwayFlagCol = 26; |
| | | public const Int16 HUnitIDCol = 27; |
| | | public const Int16 HUnitNumberCol = 28; |
| | | public const Int16 HUnitNameCol = 29; |
| | | public const Int16 HWhIDCol = 30; |
| | | public const Int16 HWhNumberCol = 31; |
| | | public const Int16 HWhNameCol = 32; |
| | | public const Int16 HSPIDCol = 33; |
| | | public const Int16 HSPNumberCol = 34; |
| | | public const Int16 HSPNameCol = 35; |
| | | public const Int16 HMTONoCol = 36; |
| | | public const Int16 HRemarkCol = 37; |
| | | public const Int16 HDeptIDCol = 38; |
| | | public const Int16 HDeptNumberCol = 39; |
| | | public const Int16 HDeptNameCol = 40; |
| | | public const Int16 HSourceIDCol = 41; |
| | | public const Int16 HSourceNumberCol = 42; |
| | | public const Int16 HSourceNameCol = 43; |
| | | public const Int16 HSupIDCol = 44; |
| | | public const Int16 HSupNumberCol = 45; |
| | | public const Int16 HSupNameCol = 46; |
| | | public const Int16 HGroupIDCol = 47; |
| | | public const Int16 HGroupNumberCol = 48; |
| | | public const Int16 HGroupNameCol = 49; |
| | | public const Int16 HCusIDCol = 50; |
| | | public const Int16 HCusNumberCol = 51; |
| | | public const Int16 HCusNameCol = 52; |
| | | public const Int16 HCusTypeCol = 53; |
| | | public const Int16 HSeOrderBillNoCol = 54; |
| | | public const Int16 HSeOrderSEQCol = 55; |
| | | public const Int16 HInnerBillNoCol = 56; |
| | | public const Int16 HEndDateCol = 57; |
| | | public const Int16 HSourceBillQtyCol = 58; |
| | | public const Int16 HAuxPropFlagCol = 59; |
| | | public const Int16 HBarCodeCol = 60; //æ¡ç ç¼å· |
| | | public const Int16 HTMNumberCol = 61; //æ¡ç åç¼ |
| | | public const Int16 HLSHCol = 62; //çææ¡ç æ¶è·åå¯¹åºæµæ°´å· |
| | | public const Int16 HBarcodeNoCol = 63; //è®°å½éåå¡«çæµæ°´å·æ°é |
| | | public const Int16 HPackBarQtyCol = 19; //è§æ ¼æ°éï¼å段å
容为æå¨è¾å
¥ |
| | | public const Int16 HBQtyCol = 20; |
| | | public const Int16 HinitQtyCol = 21; |
| | | public const Int16 HISKFPERIODCol = 22; |
| | | public const Int16 HProduceDateCol = 23; |
| | | public const Int16 HExpiryDateCol = 24; |
| | | public const Int16 HEXPUNITCol = 25; |
| | | public const Int16 HEXPPERIODCol = 26; |
| | | public const Int16 HGiveAwayFlagCol = 27; |
| | | public const Int16 HUnitIDCol = 28; |
| | | public const Int16 HUnitNumberCol = 29; |
| | | public const Int16 HUnitNameCol = 30; |
| | | public const Int16 HWhIDCol = 31; |
| | | public const Int16 HWhNumberCol = 32; |
| | | public const Int16 HWhNameCol = 33; |
| | | public const Int16 HSPIDCol = 34; |
| | | public const Int16 HSPNumberCol = 35; |
| | | public const Int16 HSPNameCol = 36; |
| | | public const Int16 HMTONoCol = 37; |
| | | public const Int16 HRemarkCol = 38; |
| | | public const Int16 HDeptIDCol = 39; |
| | | public const Int16 HDeptNumberCol = 40; |
| | | public const Int16 HDeptNameCol = 41; |
| | | public const Int16 HSourceIDCol = 42; |
| | | public const Int16 HSourceNumberCol = 43; |
| | | public const Int16 HSourceNameCol = 44; |
| | | public const Int16 HSupIDCol = 45; |
| | | public const Int16 HSupNumberCol = 46; |
| | | public const Int16 HSupNameCol = 47; |
| | | public const Int16 HGroupIDCol = 48; |
| | | public const Int16 HGroupNumberCol = 49; |
| | | public const Int16 HGroupNameCol = 50; |
| | | public const Int16 HCusIDCol = 51; |
| | | public const Int16 HCusNumberCol = 52; |
| | | public const Int16 HCusNameCol = 53; |
| | | public const Int16 HCusTypeCol = 54; |
| | | public const Int16 HSeOrderBillNoCol = 55; |
| | | public const Int16 HSeOrderSEQCol = 56; |
| | | public const Int16 HInnerBillNoCol = 57; |
| | | public const Int16 HEndDateCol = 58; |
| | | public const Int16 HSourceBillQtyCol = 59; |
| | | public const Int16 HAuxPropFlagCol = 60; |
| | | public const Int16 HBarCodeCol = 61; //æ¡ç ç¼å· |
| | | public const Int16 HTMNumberCol = 62; //æ¡ç åç¼ |
| | | public const Int16 HLSHCol = 63; //çææ¡ç æ¶è·åå¯¹åºæµæ°´å· |
| | | public const Int16 HBarcodeNoCol = 64; //è®°å½éåå¡«çæµæ°´å·æ°é |
| | | |
| | | // |
| | | public string ModName = "85"; |
| | | public string ModCaption = "è°æ¨æ¡ç çæ"; |
| | |
| | | { |
| | | sHRemark = sHRemark + " 第" + HSno + "è¡ï¼ç©æï¼" + HMaterNumber + sHRemark2; |
| | | } |
| | | |
| | | // æ£å表达å¼ï¼å¹é
æ´æ°ãæµ®ç¹æ°ãæ£è´å·ãç§å¦è®¡æ°æ³ï¼å¯æ ¹æ®éæ±è°æ´ï¼ |
| | | string numericRegex = @"^[+-]?(\d+(\.\d*)?|\.\d+)([eE][+-]?\d+)?$"; |
| | | if (!Regex.IsMatch(DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HPackBarQtyCol].Value), numericRegex) && DBUtility.ClsPub.isStrNull(grdMain.Rows[j].Cells[HPackBarQtyCol].Value) != "") |
| | | { |
| | | sHRemark = sHRemark + " 第" + HSno + "è¡ï¼è§æ ¼æ°éä¸ä¸ºæ°åæ ¼å¼ï¼è¯·è¾å
¥æ£ç¡®çæ°å¼ï¼" ; |
| | | } |
| | | |
| | | } |
| | | } |
| | | if (sHRemark != "") |
| | |
| | | string HMaterModel = ""; //产åè§æ ¼åå· |
| | | string HPinfan = ""; //åçª |
| | | DateTime HEndDate; //计åå®å·¥æ¥æ |
| | | double HPackBarQty = 0; //è§æ ¼æ°é |
| | | |
| | | oCn.BeginTran(); |
| | | Application.DoEvents(); |
| | |
| | | HMaterModel = ClsPub.isStrNull(grdMain.Rows[j].Cells[HMaterModelCol].Value); |
| | | HPinfan = ClsPub.isStrNull(grdMain.Rows[j].Cells[HPinfanCol].Value); |
| | | HEndDate = ClsPub.isDate(grdMain.Rows[j].Cells[HEndDateCol].Value); |
| | | HPackBarQty = ClsPub.isDoule(grdMain.Rows[j].Cells[HPackBarQtyCol].Value == "" ? 0 : grdMain.Rows[j].Cells[HPackBarQtyCol].Value); |
| | | |
| | | oCn.RunProc("insert into Gy_BarCodeBill" + |
| | | "(HInterID,HEntryID,HBarCode,HBarCodeType,HMaterID,HUnitID" + |
| | |
| | | ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HInitSourceEntryID,HRemark" + |
| | | ",HPrintQty,HSTOCKORGID,HOWNERID,HDeptID,HSupID,HGroupID" + |
| | | ",HCusID,HCusType,HSeOrderBillNo,HSeOrderSEQ,HInnerBillNo,HWorkLineName" + |
| | | ",HMaterName,HMaterModel,HPinfan,HEndDate,HMaker,HMakeDate" + |
| | | ",HMaterName,HMaterModel,HPinfan,HEndDate,HMaker,HMakeDate,HPackBarQty" + |
| | | ") values (" |
| | | + " " + HInterID.ToString() + "," + HEntryID.ToString() + ",'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() |
| | | + ", " + HAuxPropID.ToString() + ",'" + HBatchNo + "','" + HMTONo + "'," + HQty.ToString() + "," + HinitQty.ToString() + "," + HSourceBillQty.ToString() |
| | |
| | | + ", " + HSourceInterID.ToString() + "," + HSourceEntryID.ToString() + ",'" + HSourceBillNo + "','" + HSourceBillType + "'," + HInitSourceEntryID.ToString() + ",'" + HRemark + "'" |
| | | + ", " + HPrintQty.ToString() + "," + HSTOCKORGID.ToString() + "," + HOWNERID.ToString() + "," + HDeptID.ToString() + "," + HSupID.ToString() + "," + HGroupID.ToString() |
| | | + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HSeOrderBillNo + "'," + HSeOrderSEQ.ToString() + ",'" + HInnerBillNo + "','" + HWorkLineName + "'" |
| | | + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "','" + HEndDate.ToShortDateString() + "','" + ClsPub.CurUserName + "',getdate()" + |
| | | + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "','" + HEndDate.ToShortDateString() + "','" + ClsPub.CurUserName + "',getdate()" + "," + HPackBarQty + |
| | | ")"); |
| | | } |
| | | pb1.Value = j + 1; |
| | |
| | | private void initGrid() |
| | | { |
| | | grdMain.RowCount = 0; |
| | | grdMain.ColumnCount = 64; //æ»åæ° |
| | | grdMain.ColumnCount = 65; //æ»åæ° |
| | | DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); |
| | | grdMain.Columns[HSnoCol].HeaderText = "åºå·"; |
| | | grdMain.Columns[HMainIDCol].HeaderText = "æºå主ID"; |
| | |
| | | grdMain.Columns[HQtyCol].HeaderText = "æ°é"; |
| | | grdMain.Columns[HMinQtyCol].HeaderText = "éé"; |
| | | grdMain.Columns[HBQtyCol].HeaderText = "ç®±æ°"; |
| | | grdMain.Columns[HPackBarQtyCol].HeaderText = "è§æ ¼æ°é"; |
| | | grdMain.Columns[HinitQtyCol].HeaderText = "åå§åæ°é"; |
| | | grdMain.Columns[HSourceBillQtyCol].HeaderText = "æºåå¯çææ¡ç æ°é"; |
| | | grdMain.Columns[HBarCodeTypeCol].HeaderText = "æ¡ç ç±»å"; |
| | |
| | | "," + HBatchNoCol.ToString() + |
| | | "," + HBarCodeTypeCol.ToString() + |
| | | "," + HProduceDateCol.ToString() + |
| | | "," + HPackBarQtyCol.ToString() + |
| | | "," + HRemarkCol.ToString(); |
| | | |
| | | //设置å计å |
| | |
| | | grdMain.Rows[sRow].Cells[HISKFPERIODCol].Value = oMater.omodel.HISKFPERIOD; |
| | | grdMain.Rows[sRow].Cells[HBarCodeTypeCol].Value = oMater.omodel.HBarCodeType; |
| | | grdMain.Rows[sRow].Cells[HBQtyCol].Value = 1; |
| | | grdMain.Rows[sRow].Cells[HPackBarQtyCol].Value = 0; |
| | | //å¯ç¨æ¹æ¬¡ |
| | | if (oMater.omodel.HBatchManager) |
| | | { |
| | |
| | | grdMain.Rows[sRow].Cells[HEXPPERIODCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HProduceDateCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HExpiryDateCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HPackBarQtyCol].Value = 0; |
| | | } |
| | | } |
| | | else |
| | |
| | | grdMain.Rows[sRow].Cells[HEXPPERIODCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HProduceDateCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HExpiryDateCol].Value = ""; |
| | | grdMain.Rows[sRow].Cells[HPackBarQtyCol].Value = 0; |
| | | } |
| | | break; |
| | | |
| | |
| | | grdMain.Rows[i].Cells[HMinQtyCol].Value = oTable.Rows[0]["æå°å
è£
æ°"].ToString(); |
| | | grdMain.Rows[i].Cells[HAuxPropFlagCol].Value = oTable.Rows[0]["HAuxPropFlag"].ToString(); |
| | | |
| | | |
| | | //å¯ç¨è¾
å©å±æ§ |
| | | if (DBUtility.ClsPub.isBool(oTable.Rows[0]["HAuxPropFlag"].ToString())) |
| | | { |
| | |
| | | "," + HBatchNoCol.ToString() + |
| | | "," + HBarCodeTypeCol.ToString() + |
| | | "," + HProduceDateCol.ToString() + |
| | | "," + HPackBarQtyCol.ToString() + |
| | | "," + HRemarkCol.ToString(); |
| | | grdMain.Columns[HBillNoCol].ReadOnly = true; |
| | | //设置å计å |
| | |
| | | grdMain.Rows[row + r].Cells[HBatchNoCol].Value = grdMain.Rows[row].Cells[HBatchNoCol].Value; |
| | | grdMain.Rows[row + r].Cells[HQtyCol].Value = grdMain.Rows[row].Cells[HQtyCol].Value; |
| | | grdMain.Rows[row + r].Cells[HMinQtyCol].Value = 0; |
| | | grdMain.Rows[row + r].Cells[HPackBarQtyCol].Value = 0; |
| | | grdMain.Rows[row + r].Cells[HBQtyCol].Value = grdMain.Rows[row].Cells[HBQtyCol].Value; |
| | | grdMain.Rows[row + r].Cells[HinitQtyCol].Value = grdMain.Rows[row].Cells[HinitQtyCol].Value; |
| | | grdMain.Rows[row + r].Cells[HISKFPERIODCol].Value = grdMain.Rows[row].Cells[HISKFPERIODCol].Value; |