| WarM/条码打印/Gy_BarCodeBill_Rework.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WarM/条码打印/Kf_WeighToBarCode.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
| WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WarM/ÌõÂë´òÓ¡/Gy_BarCodeBill_Rework.cs
@@ -702,8 +702,30 @@ Int32 HModelLen = grdMain.Rows[j].Cells[HMaterModelCol].Value.ToString().Length; string HModelLeft = HModelLen >= 4 ? grdMain.Rows[j].Cells[HMaterModelCol].Value.ToString() : ""; string HSubjoin2 = grdMain.Rows[j].Cells[HSubjoin2Col].Value.ToString(); //æ¡ç ç¼å· = å·¥å代ç ï¼1ï¼ + 车é´ä»£ç ï¼060113ï¼+ æºåå· + å¹´ + æ + æ¥ + æµæ°´å· TM = "1" + "060113" + HSubjoin2 + sYear + sPeriod + sDay + LSH.ToString("D5"); //çæç©ææ¡ç æ¶ï¼æºåç ä¸å 许为空,å¦è¥ç©æä»£ç åç¼ä¸ä¸ºGæLçï¼å¯è·³è¿æ§å¶ if (oSystemParameter.omodel.Gy_BarCodeBill_Rework_Ctrl != "") { string[] HMaterNumberPrefix = oSystemParameter.omodel.Gy_BarCodeBill_Rework_Ctrl.Split(','); char HMaterfirstChar = grdMain.Rows[j].Cells[HMaterNumberCol].Value.ToString()[0]; if (HMaterNumberPrefix.Contains(HMaterfirstChar.ToString())) { //æ¡ç ç¼å· = å·¥å代ç ï¼1ï¼ + 车é´ä»£ç ï¼060113ï¼+ æºåå· + å¹´ + æ + æ¥ + æµæ°´å· TM = "1" + "060113" + HSubjoin2 + sYear + sPeriod + sDay + LSH.ToString("D5"); } else { //æ¡ç ç¼å· = å·¥å代ç ï¼1ï¼ + 车é´ä»£ç ï¼060113ï¼+ ç©æä»£ç é¦åæ¯ + å¹´ + æ + æ¥ + æµæ°´å· TM = "1" + "060113" + HMaterfirstChar.ToString() + sYear + sPeriod + sDay + LSH.ToString("D5"); } } else { //æ¡ç ç¼å· = å·¥å代ç ï¼1ï¼ + 车é´ä»£ç ï¼060113ï¼+ æºåå· + å¹´ + æ + æ¥ + æµæ°´å· TM = "1" + "060113" + HSubjoin2 + sYear + sPeriod + sDay + LSH.ToString("D5"); } } HEntryID = j + 1; WarM/ÌõÂë´òÓ¡/Kf_WeighToBarCode.cs
@@ -1232,29 +1232,29 @@ HBarCode_Pack = DBUtility.ClsPub.isStrNull(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("æ¡ç ç¼å·")].Value); cmdHBPack.Enabled = false; sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); //èªå¨æå° //if (chkHDYFlag.Checked == true) //sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); ////èªå¨æå° ////if (chkHDYFlag.Checked == true) ////{ //// //æå°æ¡ç //// Sub_SetReport("æçæ¡ç "); //// Report.Print(false); //// Thread.Sleep(1000); ////} ////else //{ // //æå°æ¡ç // Sub_SetReport("æçæ¡ç "); // Report.Print(false); // Thread.Sleep(1000); // //éæ©æå°æ¨¡æ¿ // 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(false); // Thread.Sleep(1000); // } //} //else { //éæ©æå°æ¨¡æ¿ 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(false); Thread.Sleep(1000); } } } //æ¡ç çæå夿 @@ -1443,8 +1443,8 @@ " from Gy_BarCodeBill with(nolock) where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0 and HBarCodeType='å¯ä¸æ¡ç ' " ); //åå¡«æ¡ç æ¡£æ¡ç»ææ è®° oCn.RunProc("update Gy_BarCodeBill set HPackflag=1 where HInterID=" + HInterID.ToString() + " and HBarCode_Pack='" + HBarCode_Pack + "' and HStopflag=0", ref DBUtility.ClsPub.sExeReturnInfo); //åå¡«æ¡ç 表ä¸å¯¹åºææ¡ç ç¸å ³ç»ææ è®°ãç»ææ»æ°éãç»æä»¶æ°ç oCn.RunProc("exec h_p_Kf_WeighToBarCode_UpdateBarCode " + HInterID.ToString() + ",'" + HBarCode_Pack + "'"); MessageBox.Show("çæçäº§ç»æåï¼" + HPUBillNo + " æåï¼", "æç¤º"); @@ -1453,7 +1453,32 @@ cmdHBPack.Enabled = true; HSNo = 0; this.lblSNo.Text = ""; BarCode_Display(); BarCode_Display_EndPack(); grdMain.Rows[0].Selected = true; sBarCodeItemID = DBUtility.ClsPub.isLong(grdMain.Rows[grdMain.SelectedRows[0].Index].Cells[Fun_GetCol("HItemID")].Value).ToString(); //èªå¨æå° //if (chkHDYFlag.Checked == true) //{ // //æå°æ¡ç // Sub_SetReport("æçæ¡ç "); // Report.Print(false); // Thread.Sleep(1000); //} //else { //éæ©æå°æ¨¡æ¿ 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(false); Thread.Sleep(1000); } } oCn.Commit(); return; } @@ -1465,6 +1490,19 @@ } } //è¿åç§°éè®°å½åè¡¨ä¿¡æ¯ private void BarCode_Display_EndPack() { DataSet DSet = oCn.RunProcReturn("select * from h_v_IF_BarCodeBillList Where HinterID=" + HInterID.ToString() + " order by HEntryID desc,HItemID desc", "h_v_IF_BarCodeBillList", ref DBUtility.ClsPub.sExeReturnInfo); grdMain.DataSource = DSet.Tables[0].DefaultView; //å»ç» int FrCol = DBUtility.ClsPub.isInt(frmCondition.txtFrozenCol.Text); string s = frmCondition.cmbHComplete.Text; DBUtility.Xt_BaseBillFun.DisplayGrid(grdMain, this.Name, s, FrCol); //ç»çº¿ GraphLine(); } #endregion WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs
@@ -67,6 +67,40 @@ return objJsonResult; } } [Route("Cg_POInStockBill/cx1")] [HttpGet] public object cx1(long HInterID,long HSubID) { try { ds = oCN.RunProcReturn("select * from h_v_IF_POInStockBillEdit where hmainid=" + HInterID + " and hsubid=" + HSubID, "h_v_IF_POInStockBillList"); if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "falseï¼"; objJsonResult.data = null; return objJsonResult; } else { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "Sucessï¼"; objJsonResult.data = ds.Tables[0]; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #region æ¶æéç¥åå页å表 [Route("Cg_POInStockBill/page")] WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs
@@ -148,6 +148,9 @@ #endregion #region éè´å ¥åºå ä¿å/ç¼è¾åè½ [Route("Kf_POStockInBill/POStockInBillEdit")] [HttpPost] @@ -313,7 +316,7 @@ } String sql = $@"update Kf_ICStockBillMain set " + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ",HBillNo='" + HBillNo + "'" + "HRemark='" + HRemark + "', HUpDater='" + HMaker + "', HUpDateDate=getdate()" + ",HBillNo='" + HBillNo + "'" + ",HDate='" + HDate + "'" + ",HSupID=" + HSupID + ",HCurID=" + HCurID + ",HSecManagerID=" + HSecManagerID + ", HSTOCKORGID=" + HSTOCKORGID + ",HKeeperID=" + HKeeperID + ",HWHID = " + HWHID + ",HEmpID=" + HEmpID + ",HManagerID=" + HManagerID + ",HDeptID=" + HDeptID + ",HOWNERID=" + HOWNERID + ",HAddress='" + HAddress + "',HInnerBillNo='" + HInnerBillNo + "',HProjectID=" + HProjectID + ",HInvoiceBillNo='" + HInvoiceBillNo + "' where HInterID=" + HInterID; WebAPI/Controllers/MJGL/Sc_MouldProdMoveBillController.cs
@@ -794,7 +794,51 @@ } #endregion #region ææ°åæ´åè½ [Route("Sc_MouldProdMoveBillController/UpdatePallet")] [HttpPost] public object UpdatePallet([FromBody] JObject data) { try { long hmainid = data["hmainid"]?.ToObject<long>() ?? 0; int newPallet = data["newPallet"]?.ToObject<int>() ?? 0; string operatorName = data["operator"]?.ToString() ?? ""; if (hmainid <= 0) return new { code = "0", count = 0, Message = "åæ®IDä¸è½ä¸ºç©ºï¼" }; if (newPallet < 0) return new { code = "0", count = 0, Message = "ææ°ä¸è½ä¸ºè´æ°ï¼" }; string updateSql = $@" UPDATE Sc_MouldStockBillMain SET HPackQtys = {newPallet} WHERE HInterID = {hmainid}"; oCn.RunProc(updateSql); return new { code = "1", count = 1, Message = "ææ°ä¿®æ¹æåï¼" }; } catch (Exception e) { return new { code = "0", count = 0, Message = "ä¿®æ¹å¤±è´¥ï¼" + e.Message }; } } #endregion }