派生自 MES-WEB-API
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill.cs
@@ -67,19 +67,20 @@ public const Int16 HInstructNoCol = 46; public const Int16 HSeOrderBillIDCol = 47; public const Int16 HSeOrderBillNoCol = 48; public const Int16 HWhIDCol = 49; public const Int16 HWhNumberCol = 50; public const Int16 HWhNameCol = 51; public const Int16 HSPIDCol = 52; public const Int16 HSPNumberCol = 53; public const Int16 HSPNameCol = 54; public const Int16 HinitQtyCol = 55; public const Int16 HRemarkCol = 56; public const Int16 HPinfanBarCodeCol = 57; public const Int16 HMTONoCol = 58; public const Int16 HShowDateCol = 59; public const Int16 HInnerBillNoCol = 60; public const Int16 HMakerCol = 61; public const Int16 HSeOrderSEQCol = 49; public const Int16 HWhIDCol = 50; public const Int16 HWhNumberCol = 51; public const Int16 HWhNameCol = 52; public const Int16 HSPIDCol = 53; public const Int16 HSPNumberCol = 54; public const Int16 HSPNameCol = 55; public const Int16 HinitQtyCol = 56; public const Int16 HRemarkCol = 57; public const Int16 HPinfanBarCodeCol = 58; public const Int16 HMTONoCol = 59; public const Int16 HShowDateCol = 60; public const Int16 HInnerBillNoCol = 61; public const Int16 HMakerCol = 62; public Int16 HSelectCol = 0; public Int16 HSno2Col = 1; @@ -127,19 +128,20 @@ public Int16 HInstructNo2Col = 43; public Int16 HSeOrderBillID2Col = 44; public Int16 HSeOrderBillNo2Col = 45; public Int16 HWhID2Col = 46; public Int16 HWhNumber2Col = 47; public Int16 HWhName2Col = 48; public Int16 HSPID2Col = 49; public Int16 HSPNumber2Col = 50; public Int16 HSPName2Col = 51; public Int16 HRemark2Col = 52; public Int16 HPinfanBarCode2Col = 53; public Int16 HMTONo2Col = 54; public Int16 HShowDate2Col = 55; public Int16 HInnerBillNo2Col = 56; public Int16 HMaker2Col = 57; public Int16 HEntryID2Col = 58; public Int16 HSeOrderSEQ2Col = 46; public Int16 HWhID2Col = 47; public Int16 HWhNumber2Col = 48; public Int16 HWhName2Col = 49; public Int16 HSPID2Col = 50; public Int16 HSPNumber2Col = 51; public Int16 HSPName2Col = 52; public Int16 HRemark2Col = 53; public Int16 HPinfanBarCode2Col = 54; public Int16 HMTONo2Col = 55; public Int16 HShowDate2Col = 56; public Int16 HInnerBillNo2Col = 57; public Int16 HMaker2Col = 58; public Int16 HEntryID2Col = 59; // public string ModName = "85"; public string ModCaption = "æ¡ç çæ"; @@ -163,7 +165,10 @@ public string ERPMode = ""; //ERP模å¼ï¼WISEãCLOUDï¼ public string CampanyName = ""; //客æ·å®å¶åå称 public string SourceQtyCtl = ""; //è¶ æºåæ°éæ§å¶ //------------------------------------------------------------------------- public long PrintQty = 0; //å 许æ¡ç æå°æ¬¡æ° public string PrintQtyCtl = ""; //æ¡ç æå°æ¬¡æ°æ§å¶ public string UpdatePrintQtyCtl = ""; //æ¡ç æå°æ¬¡æ°æ´æ° //------------------------------------------------------------------------- #region åºå®ä»£ç //æ¸ ç©ºçé¢ @@ -403,6 +408,9 @@ ERPMode = oSystemParameter.omodel.WMS_WMSStockCtl_ERPMode; CampanyName = oSystemParameter.omodel.WMS_CampanyName; SourceQtyCtl = oSystemParameter.omodel.BarCode_SourceQtyCtl; PrintQty = oSystemParameter.omodel.BarCode_PrintQty; PrintQtyCtl = oSystemParameter.omodel.BarCode_PrintQtyCtl; UpdatePrintQtyCtl = oSystemParameter.omodel.BarCode_UpdatePrintQtyCtl; } cmbHWorksNumber.Items.Clear(); @@ -964,6 +972,7 @@ grdSub.Rows[i].Cells[HSourceName2Col].Value = grdMain.Rows[j].Cells[HSourceNameCol].Value; grdSub.Rows[i].Cells[HEndDate2Col].Value = grdMain.Rows[j].Cells[HEndDateCol].Value; grdSub.Rows[i].Cells[HSeOrderBillNo2Col].Value = grdMain.Rows[j].Cells[HSeOrderBillNoCol].Value; grdSub.Rows[i].Cells[HSeOrderSEQ2Col].Value = grdMain.Rows[j].Cells[HSeOrderSEQCol].Value; grdSub.Rows[i].Cells[HInnerBillNo2Col].Value = grdMain.Rows[j].Cells[HInnerBillNoCol].Value; grdSub.Rows[i].Cells[HMaker2Col].Value = grdMain.Rows[j].Cells[HMakerCol].Value; grdSub.Rows[i].Cells[HGiveAwayFlag2Col].Value = grdMain.Rows[j].Cells[HGiveAwayFlagCol].Value; @@ -1009,6 +1018,7 @@ DateTime HEndDate; string HWorkLineName = ""; string HSeOrderBillNo = ""; Int64 HSeOrderSEQ = 0; string HInnerBillNo = ""; bool HGiveAwayFlag = false; Int64 HEntryID = 0; @@ -1054,6 +1064,7 @@ HEndDate = ClsPub.isDate(grdSub.Rows[i].Cells[HEndDate2Col].Value); HWorkLineName = ClsPub.isStrNull(grdSub.Rows[i].Cells[HSourceName2Col].Value); HSeOrderBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[HSeOrderBillNo2Col].Value); HSeOrderSEQ = ClsPub.isLong(grdSub.Rows[i].Cells[HSeOrderSEQ2Col].Value); HInnerBillNo = ClsPub.isStrNull(grdSub.Rows[i].Cells[HInnerBillNo2Col].Value); HGiveAwayFlag = ClsPub.isBool(grdSub.Rows[i].Cells[HGiveAwayFlag2Col].Value); oCn.RunProc("insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" + @@ -1062,7 +1073,7 @@ ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " + ",HCusID,HCusType,HEndDate,HWorkLineName,HBarCodeDate " + ",HSTOCKORGID,HOWNERID,HSeOrderBillNo,HInterID,HEntryID " + ",HGiveAwayFlag " + ",HGiveAwayFlag,HSeOrderSEQ " + ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo,HInnerBillNo " + ") values (" + "'" + HBarCode + "','" + HBarCodeType + "'," + HMaterID.ToString() + "," + HUnitID.ToString() + "," + HQty2.ToString() @@ -1071,7 +1082,7 @@ + ", " + HBarcodeQtys.ToString() + "," + HBarcodeNo.ToString() + "," + HDeptID.ToString() + "," + HWhID.ToString() + "," + HSPID.ToString() + ",'" + HRemark + "'" + ", " + HCusID.ToString() + ",'" + HCusType + "','" + HEndDate.ToShortDateString() + "','" + HWorkLineName + "','" + sDate + "'" + ", " + HOrgID.ToString() + "," + HOrgID.ToString() + ",'" + HSeOrderBillNo + "'," + HInterID.ToString() + "," + HEntryID.ToString() + "" + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + ", " + DBUtility.ClsPub.BoolToString(HGiveAwayFlag) + "," + HSeOrderSEQ.ToString() + ",'" + HMaterName + "','" + HMaterModel + "','" + HPinfan + "'," + HAuxPropID.ToString() + ",'" + HMTONo + "','" + HInnerBillNo + "')"); @@ -1478,7 +1489,7 @@ // grdMain.RowCount = 0; grdSub.RowCount = 0; grdMain.ColumnCount = 62; //æ»åæ° grdMain.ColumnCount = 63; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdMain, this.Name); grdMain.Columns[HSnoCol].HeaderText = "åºå·"; grdMain.Columns[HMainIDCol].HeaderText = "æºå主ID"; @@ -1520,6 +1531,7 @@ grdMain.Columns[HSPNameCol].HeaderText = "ä»ä½"; grdMain.Columns[HInstructNoCol].HeaderText = "æ令åå·"; grdMain.Columns[HSeOrderBillNoCol].HeaderText = "éå®è®¢åå·"; grdMain.Columns[HSeOrderSEQCol].HeaderText = "éå®è®¢åè¡å·"; grdMain.Columns[HDateCol].HeaderText = "è¿ææ¥æ"; grdMain.Columns[HRemarkCol].HeaderText = "å¤æ³¨"; grdMain.Columns[HMTONoCol].HeaderText = "计åè·è¸ªå·"; @@ -1611,7 +1623,7 @@ DBUtility.Xt_BaseBillFun.initGridLast(sAllowCol, sTotalCol,oSumGrid); //---------------------------- grdSub.ColumnCount = 59; //æ»åæ° grdSub.ColumnCount = 60; //æ»åæ° DBUtility.Xt_BaseBillFun.initGridFst(grdSub, this.Name); grdSub.Columns[HSelectCol].HeaderText = "éæ©"; grdSub.Columns[HTMCol].HeaderText = "æ¡ç ç¼å·"; @@ -1640,6 +1652,7 @@ grdSub.Columns[HSourceBillNo2Col].HeaderText = "æºååå·"; grdSub.Columns[HSourceBillType2Col].HeaderText = "æºåç±»å"; grdSub.Columns[HSeOrderBillNo2Col].HeaderText = "éå®è®¢åå·"; grdSub.Columns[HSeOrderSEQ2Col].HeaderText = "éå®è®¢åè¡å·"; grdSub.Columns[HBarcodeNoCol].HeaderText = "æå·"; grdSub.Columns[HBarcodeQtysCol].HeaderText = "æ»ææ°"; grdSub.Columns[HSupID2Col].HeaderText = "ä¾åºåID"; @@ -2459,6 +2472,8 @@ { grdMain.Rows[i].Cells[HGiveAwayFlagCol].Value = 0; } grdMain.Rows[i].Cells[HSeOrderBillNoCol].Value = oTable.Rows[0]["éå®è®¢åå·"].ToString(); grdMain.Rows[i].Cells[HSeOrderSEQCol].Value = oTable.Rows[0]["éå®è®¢åè¡å·"].ToString(); } } @@ -2698,9 +2713,10 @@ #region //æå°è®¾ç½® GridppReport Report; int CurRows = 0; string sBarCodeItemID = ""; //æ¡ç èªå¢å //é¢è§ int CurRows = 0; private void yl_Click(object sender, EventArgs e) { //å¤ææ¯å¦å·²ç»çææ¡ç @@ -2729,32 +2745,68 @@ } } //æå°åå¤ææ¡ç æ¯å¦å·²æå°è¿ //æå° private void dy_Click(object sender, EventArgs e) { //å¤ææ¯å¦å·²ç»çææ¡ç if (DBUtility.ClsPub.isStrNull(grdSub.Rows[0].Cells[HTMCol].Value) == "") { MessageBox.Show("æ¡ç æªçæï¼è¯·å çææ¡ç ååæå°ï¼"); return; } //æå°åå¤ææ¡ç æ¯å¦å·²æå°è¿ if (ReportPrintBegin()) { return; } //éæ©æå°æ¨¡æ¿ BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); oFrm.sBillName = ModName; oFrm.sBillModel = ModCaption; oFrm.ShowDialog(); if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) { //循ç¯éä¸è¡ Sub_SetReport(oFrm.sOpenTmp); Report.Print(true); Thread.Sleep(1000); } } ////æå°åå¤ææ¡ç æ¯å¦å·²æå°è¿ //private bool ReportPrintBegin() //{ // string sRelQty = ""; // if (oBar.Set_BPrintQty(DBUtility.ClsPub.isStrNull(grdSub.Rows[0].Cells[HTMCol].Value), ref sRelQty)) // { // MessageBox.Show("æ¡ç å·²ç»æå°è¿ï¼ä¸å¯éå¤æå°ï¼"); // return true; // } // else // { // return false; // } //} //æå°åå¤ææ¡ç æ¯å¦è¶ è¿å 许å¯æå°æ¬¡æ° private bool ReportPrintBegin() { string sRelQty = ""; if (oBar.Set_BPrintQty(DBUtility.ClsPub.isStrNull(grdSub.Rows[0].Cells[HTMCol].Value), ref sRelQty)) string sHRemark = ""; if (PrintQtyCtl == "Y") { MessageBox.Show("æ¡ç å·²ç»æå°è¿ï¼ä¸å¯éå¤æå°ï¼"); return true; if (oBar.Set_CheckPrintQty_SD(HInterID, PrintQty, ref sHRemark)) { MessageBox.Show(sHRemark); return true; } return false; } else { return false; } } //æå°ç»æååå¡«æ¡ç æå°æ¬¡æ° private void ReportPrintEnd() { try { oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); } catch (Exception e) { MessageBox.Show("æå°å¤±è´¥!æå°ç»æ ï¼" + e.Message); } } @@ -2764,26 +2816,6 @@ for (int i = 0; i < grdList.Rows.Count; i++) { grdList.Rows[i].Cells[0].Value = "*"; } // Report = new GridppReport(); Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here . Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd); } private void Sub_SetReportView(string sOpenTmp) { //å¤æè¡æ° for (int i = 0; i < grdList.Rows.Count; i++) { grdList.Rows[i].Cells[0].Value = ""; } for (int i = 0; i < grdList.SelectedRows.Count; i++) { grdList.Rows[grdList.SelectedRows[i].Index].Cells[0].Value = "*"; } // Report = new GridppReport(); @@ -2815,11 +2847,7 @@ } } private Int32 Fun_GetCol(string sCol) { return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdList); } //å¡«å ¥åæ®è¡¨ä½ä¿¡æ¯ private void ReportFetchRecordByDataTable() { try @@ -2833,17 +2861,40 @@ } } private void dy_Click(object sender, EventArgs e) ////æå°ç»æååå¡«æ¡ç æå°æ¬¡æ° //private void ReportPrintEnd() //{ // try // { // oCn.RunProc("update Gy_BarCodeBill set HPrintQty=isnull(HPrintQty,0)+1 where HInterID=" + HInterID, ref DBUtility.ClsPub.sExeReturnInfo); // } // catch (Exception e) // { // MessageBox.Show("æå°å¤±è´¥!æå°ç»æ ï¼" + e.Message); // } //} //æå°ç»æååå¡«æ¡ç æå°æ¬¡æ° private void ReportPrintEnd() { if (UpdatePrintQtyCtl == "Y") { oBar.Set_UpdatePrintQty_SD(HInterID); } } //è¯æå° private void sdy_Click(object sender, EventArgs e) { //å¤ææ¯å¦å·²ç»çææ¡ç if (DBUtility.ClsPub.isStrNull(grdSub.Rows[0].Cells[HTMCol].Value) == "") { MessageBox.Show("æ¡ç æªçæï¼è¯·å çææ¡ç ååæå°ï¼"); MessageBox.Show("æ¡ç æªçæï¼è¯·å çææ¡ç ååé¢è§ï¼"); return; } //æå°åå¤ææ¡ç æ¯å¦å·²æå°è¿ if (ReportPrintBegin()) if (ReportPrintBegin_SDY()) { return; } @@ -2855,12 +2906,71 @@ oFrm.ShowDialog(); if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) { //循ç¯éä¸è¡ Sub_SetReport(oFrm.sOpenTmp); Report.Print(true); Sub_SetReportView(oFrm.sOpenTmp); Report.PrintPreview(false); Thread.Sleep(1000); } } //æå°åå¤ææ¡ç æ¯å¦è¶ è¿å 许å¯æå°æ¬¡æ° private bool ReportPrintBegin_SDY() { string sHRemark = ""; sBarCodeItemID = ""; for (int i = 0; i < grdList.SelectedRows.Count; i++) { sBarCodeItemID = sBarCodeItemID + "," + DBUtility.ClsPub.isLong(grdList.Rows[grdList.SelectedRows[i].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); } sBarCodeItemID = sBarCodeItemID.Remove(0, 1); if (PrintQtyCtl == "Y") { if (oBar.Set_CheckPrintQty(sBarCodeItemID, PrintQty, ref sHRemark)) { MessageBox.Show(sHRemark); return true; } return false; } else { return false; } } private void Sub_SetReportView(string sOpenTmp) { //å¤æè¡æ° for (int i = 0; i < grdList.Rows.Count; i++) { grdList.Rows[i].Cells[0].Value = ""; } for (int i = 0; i < grdList.SelectedRows.Count; i++) { grdList.Rows[grdList.SelectedRows[i].Index].Cells[0].Value = "*"; } // Report = new GridppReport(); Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + sOpenTmp + ".grf"); //here . Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord); Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable); Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd_SDY); } //æå°ç»æååå¡«æ¡ç æå°æ¬¡æ° private void ReportPrintEnd_SDY() { if (UpdatePrintQtyCtl == "Y") { oBar.Set_UpdatePrintQty(sBarCodeItemID); } } private Int32 Fun_GetCol(string sCol) { return DBUtility.Xt_BaseBillFun.Fun_GetCol(sCol, grdList); } #endregion @@ -3191,33 +3301,6 @@ } } private void sdy_Click(object sender, EventArgs e) { //å¤ææ¯å¦å·²ç»çææ¡ç if (DBUtility.ClsPub.isStrNull(grdSub.Rows[0].Cells[HTMCol].Value) == "") { MessageBox.Show("æ¡ç æªçæï¼è¯·å çææ¡ç ååé¢è§ï¼"); return; } //æå°åå¤ææ¡ç æ¯å¦å·²æå°è¿ if (ReportPrintBegin()) { return; } //éæ©æå°æ¨¡æ¿ BLL.Gy_OpenTmp oFrm = new BLL.Gy_OpenTmp(); oFrm.sBillName = ModName; oFrm.sBillModel = ModCaption; oFrm.ShowDialog(); if (oFrm.OKTag == Pub_Class.ClsPub.Enum_OKTag.OKTag_OK) { Sub_SetReportView(oFrm.sOpenTmp); Report.PrintPreview(false); Thread.Sleep(1000); } } //çæå¤ç®±ç private void wxm_Click(object sender, EventArgs e)
