WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/CJGL/Cj_StationInBillController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
WebAPI/Controllers/仓存管理/条码生成/Sc_BarCodeController.cs | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 |
WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs
@@ -316,6 +316,82 @@ } #endregion #region å·¥åºè¿ç«æ«é ä»¶ç [Route("Cj_StationBill/txtHBarCode_Mater_KeyDown")] [HttpGet] public object txtHBarCode_Mater_KeyDown(string HBarCode, string HInterID) { try { if (HBarCode == null || HBarCode.Equals("")) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "空ç½ç ,æ¡å½¢ç ä¸è½ä¸ºç©ºï¼"; objJsonResult.data = null; return objJsonResult; } //夿æ¡å½¢ç æ¯å¦å¨æ¡ç æ¡£æ¡ä¸ï¼å¤ææ¡å½¢ç æ¯å¦åç //å 夿 临æ¶è¡¨ä¸æ¯å¦ææ°æ®ï¼æ¡å½¢ç çç©ææ¯å¦å¨æ¸ åä¸ï¼åå ¥ æ«ç è®°å½è¡¨ //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("exec h_p_MES_StationInBillSub_BindBarCode " + HInterID.ToString() + " ,'" + HBarCode + "'", "h_p_MES_StationInBillSub_BindBarCode"); //åå ¥ä¿¡æ¯ if (ds == null || ds.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æªæ¥è¯¢å°æ¡å½¢ç ä¿¡æ¯ï¼"; objJsonResult.data = null; return objJsonResult; } else if (DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0][0]) == 2) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "é误ï¼" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0][1]); objJsonResult.data = null; return objJsonResult; } DataSet Dsplay = oCN.RunProcReturn("exec h_p_MES_StationInBillSub_BindDisplay " + HInterID.ToString() + " ", "h_p_MES_StationInBillSub_BindDisplay"); //åå ¥ä¿¡æ¯ if (Dsplay == null) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "å·æ°å¤±è´¥,æ æ°æ®æ¾ç¤ºï¼"; objJsonResult.data = null; return objJsonResult; } else if (Dsplay.Tables[0].Rows.Count == 0) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ¥æ æ°æ®!"; objJsonResult.data = null; return objJsonResult; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "ç»å®æåï¼"; objJsonResult.data = null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region æå¼å¡æ«ç è·åä¿¡æ¯ [Route("MES_SampleRecordBill_PDA/SampleRecordBillHBarCode_KeyDown")] [HttpGet] WebAPI/Controllers/CJGL/Cj_StationInBillController.cs
@@ -468,6 +468,63 @@ } #endregion #region å·¥åºè¿ç«æ¥æ¶åæµæ°´å·å车 ç³»ç»åæ°å¤ææ¯å¦ç»å®é ä»¶æ¸ å [Route("Cj_StationInBill/MES_StationInBillSubBindSource")] [HttpGet] public object MES_StationInBillSubBindSource(string HInterID, string HProcExchInterID,string HProcExchEntryID) { try { //å¦æç³»ç»åæ°å¯ç¨äº è¿ç«åç»å®é ä»¶æ¸ åå ä»çäº§ç¨ææ¸ åä¸è·åå·¥åºBOMåå ¥ 临æ¶è¡¨ï¼å¹¶å è½½è¡¨æ ¼ Pub_Class.ClsXt_SystemParameter oParam = new ClsXt_SystemParameter(); string sIsBingLine = oParam.GetSingleSystemParameter("MES_StationInBill_LineBindCtl", ref DBUtility.ClsPub.sExeReturnInfo); if (sIsBingLine.Trim() == "Y") { oCN.RunProc("exec h_p_MES_StationInBillSubBindSource_Insert " + HProcExchInterID.ToString() + " , " + HProcExchEntryID.ToString() + "," + HInterID.ToString() + " "); ds = oCN.RunProcReturn($@"select * from ( select a.HICMOInterID,a.HICMOEntryID,b.HProcID from Sc_ProcessExchangeBillMain a with(nolock) inner join Sc_ProcessExchangeBillSub b with(nolock) on a.HInterID=b.HinterID Where a.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID} ) a inner join ( select a.HICMOInterID,a.HICMOEntryID, b.HProcID from Sc_PPBomBillMain a with(nolock) inner join Sc_PPBomBillSub b with(nolock) on a.HInterID=b.HInterID Where b.HKeyMaterID_Line<>0 )b on a.HICMOInterID=b.HICMOInterID and a.HICMOEntryID=b.HICMOEntryID and a.HProcID=b.HProcID", "Sc_ProcessExchangeBillMain"); if (ds.Tables[0].Rows.Count > 0) { objJsonResult.Message = "éè¦ç»å®é ä»¶ï¼"; } else { objJsonResult.Message = "ä¸éè¦ç»å®é ä»¶ï¼"; } } else { objJsonResult.Message = "ä¸éè¦ç»å®é ä»¶ï¼"; } objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.data =null; return objJsonResult; } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "Exceptionï¼" + e.ToString(); objJsonResult.data = null; return objJsonResult; } } #endregion #region å·¥åºè¿ç«æ¥æ¶åæµæ°´å·å车è·åå·¥åºä¿¡æ¯ [Route("Cj_StationInBill/txtHProcNo_KeyDown_qiaoyi")] WebAPI/Controllers/²Ö´æ¹ÜÀí/ÌõÂëÉú³É/Sc_BarCodeController.cs
@@ -228,6 +228,11 @@ count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_MateOutBackBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_MateOutBackBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; case "å·¥åºæµè½¬å¡": tabname = "h_v_IF_ProcessExchangeBillList_Source"; count = new SQLHelper.ClsCN().RunProcReturn("select * from h_v_IF_ProcessExchangeBillList_Source " + sWhere + " order by åæ®å· desc,hsubid", tabname).Tables[0].Rows.Count; sql = string.Format(@"select top " + pageSize + " * from(select row_number() over (order by åæ®å· desc,hsubid) as HRowNumber,* from h_v_IF_ProcessExchangeBillList_Source " + sWhere + ") as A where HRowNumber >" + pageSize + " *(" + pageNum + "-1)"); break; default: break; } @@ -396,6 +401,12 @@ break; case "1255": //ç»è£ æå¸å break; case "3772": //å·¥åºæµè½¬å¡ //å¾å°ä¿¡æ¯ ds = oCN.RunProcReturn("select * from h_v_IF_ProcessExchangeList where HMainID=" + oSelectRow.BillMainID + " and HSubID=" + oSelectRow.BillSubID, "h_v_IF_ProcessExchangeList", ref DBUtility.ClsPub.sExeReturnInfo); //åå ¥ä¿¡æ¯ ListRows.Add(HSourceOrderList1(ds.Tables[0], ordrlist, HBarCodeType, HSourceBillType)); break; default: break; }