派生自 MES-WEB-API
WebAPI/Controllers/Éú²ú¹ÜÀí/±¨¹¤Ì¨¹¤Ðò/Sc_MESBeginStepWorkBillController.cs
@@ -1,4 +1,5 @@ using Newtonsoft.Json.Linq; using Newtonsoft.Json; using Newtonsoft.Json.Linq; using NPOI.HSSF.UserModel; using NPOI.SS.UserModel; using Pub_Class; @@ -40,12 +41,23 @@ [Route("Sc_MESBeginStepWorkBill/GetMESBeginStepWorkBill")] [HttpGet] public object GetMESBeginStepWorkBill(string sWhere) public object GetMESBeginStepWorkBill(string sWhere, string user) { try { LogService.Write("æ§è¡äº0"); //å¤ææ¯å¦ææ¥è¯¢æé if (!DBUtility.ClsPub.Security_Log("MES_MESBeginWorkBill_Query", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ æ¥è¯¢æé!"; objJsonResult.data = null; return objJsonResult; } LogService.Write("æ§è¡äº"); ds = Sc_GetMESBeginStepWorkBill(sWhere); objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è¿åè®°å½æåï¼"; @@ -66,12 +78,13 @@ { if (sWhere == null || sWhere.Equals("")) { return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESBeginWorkBillList_NEW ", "h_v_Sc_MESBeginWorkBillList_NEW"); return new SQLHelper.ClsCN().RunProcReturn("select * from h_v_Sc_MESBeginWorkBillList_NEW order by hmainid desc ", "h_v_Sc_MESBeginWorkBillList_NEW"); } else { LogService.Write("æ§è¡äº1"); string sql1 = "select * from h_v_Sc_MESBeginWorkBillList_NEW where 1 = 1 "; string sql = sql1 + sWhere; string sql = sql1 + sWhere + " order by hmainid desc "; return new SQLHelper.ClsCN().RunProcReturn(sql, "h_v_Sc_MESBeginWorkBillList_NEW"); } @@ -107,7 +120,7 @@ { DBUtility.ClsPub.CurUserName = UserName; //ç¼è¾æé if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Delete", 1, false, DBUtility.ClsPub.CurUserName)) if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Drop", 1, false, DBUtility.ClsPub.CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -789,7 +802,7 @@ oItemSub.HOtherItem4 = ""; oItemSub.HOtherItem5 = ""; oItemSub.HPackType = ""; oItemSub.HBatchNo=""; oItemSub.HBatchNo = ""; //oItemSub.HRelationMoney = 0; //å ³èéé¢ //oItemSub.HRepairID = 0; //ç»´ä¿®é¡¹ç® //oItemSub.HRepairExplanation =""; //ç»´ä¿®è¦æ± @@ -1015,7 +1028,7 @@ oCN.BeginTran(); //å é¤å·¥åºæ±æ¥å表 string sql1 = string.Format(@"delete Sc_ProcessReportSub where HInterID='"+HInterID+"' and HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'"); string sql1 = string.Format(@"delete Sc_ProcessReportSub where HInterID='" + HInterID + "' and HICMOInterID='" + HICMOInterID + "' and HICMOEntryID='" + HICMOEntryID + "'"); oCN.RunProc(sql1); //å é¤å·¥åºæ±æ¥ä¸»è¡¨ string sql = string.Format(@"delete Sc_ProcessReportMain where HInterID='" + HInterID + "'"); @@ -1044,7 +1057,7 @@ #region æ¥å·¥å¹³å°æ¥æ£ç³è¯·ä¿å [Route("Sc_MESBeginStepWorkBill/SaveGetMESProductReportBillList")] [HttpGet] public object SaveGetMESProductReportBillList(string ScMaxWork, string HSourceBillType, string workcode, int HSourceID, int HICMOInterID, int HICMOEntryID, string HMaker, string Czybm,string HProcID) public object SaveGetMESProductReportBillList(string ScMaxWork, string HSourceBillType, string workcode, int HSourceID, int HICMOInterID, int HICMOEntryID, string HMaker, string Czybm, string HProcID) { ListModels oListModels = new ListModels(); try @@ -1112,7 +1125,7 @@ //model.HPRDORGID = DBUtility.ClsPub.isLong(ds0.Tables[0].Rows[0]["HPRDORGID"]); model.HMainSourceInterID = HICMOInterID; model.HMainSourceEntryID = HICMOEntryID; //oWebs.Timeout = 30000; bool flag = oWebs.set_SaveICMOProductReportBill_LayuiYqn(model, workcode, HSourceID, sHSourceType, HProcID, ref DBUtility.ClsPub.sErrInfo); @@ -1169,7 +1182,7 @@ try { //å¤ææ¯å¦æç¼è¾æé if (!DBUtility.ClsPub.Security_Log("MES_ProcExchReport_Edit",1,false,user)) if (!DBUtility.ClsPub.Security_Log("MES_ProcExchReport_Edit", 1, false, user)) { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -1445,5 +1458,201 @@ } } #endregion #region æ¥å·¥å¹³å°å¼å·¥åæ«äºç»´ç æ¥è¯¢ [Route("Sc_MESBeginStepWorkBill/GetMESBeginStepWorkBillByEWM")] [HttpGet] public object GetMESBeginStepWorkBillByEWM(string sBillBarCode) { try { //æ ¹æ®éæ©èµæºIDè·åå½åç产工åã责任人 ds = oCN.RunProcReturn("select f1.F_YQN_XSDD éå®è®¢åç¼å·, f1.F_zzzz_Text4 éå®ç©æå称,* from h_v_IF_ICMOBillList a left join AIS20200908101915zs..T_PRD_MOENTRY f1 on a.HERPEntryID=f1.FENTRYID where convert(varchar(50),a.hmainid)+'-'+convert(varchar(50),a.HEntryID)='" + sBillBarCode + "'", "h_v_IF_ICMOBillList"); if (ds.Tables[0].Rows.Count > 0) { objJsonResult.code = "1"; objJsonResult.count = 1; objJsonResult.Message = "è¿åæºåæåï¼"; objJsonResult.data = ds; return objJsonResult; } else { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ææ èµæºç»å®ï¼"; objJsonResult.data = null; return objJsonResult; } } catch (Exception e) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message.ToString(); objJsonResult.data = null; } return objJsonResult; } #endregion #region æ¥å·¥å¹³å°å¼å·¥åæ æºåä¿å [Route("Sc_MESBeginStepWorkBill/SaveGetMESBeginStepWorkBillByEWM")] [HttpPost] public object SaveGetMESBeginStepWorkBillByEWM([FromBody] JObject msg) { var _value = msg["msg"].ToString(); string msg1 = _value.ToString(); string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); string msg2 = sArray[0].ToString(); string UserName = sArray[1].ToString(); string refSav = sArray[2].ToString(); DBUtility.ClsPub.CurUserName = UserName; //ä¿åæé if (!DBUtility.ClsPub.Security_Log_second("MES_MESBeginWorkBill_Edit", 1, false, DBUtility.ClsPub.CurUserName)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "æ ä¿åæéï¼"; objJsonResult.data = null; return objJsonResult; } //å¤æä¼è®¡ææ¯å¦åç string s = ""; int sYear = 0; int sPeriod = 0; string BillNo = ""; long MainId = 0; string EntyID = ""; if (DBUtility.Xt_BaseBillFun.Fun_AllowYearPeriod(DateTime.Now, ref sYear, ref sPeriod, ref s) == false) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = s; objJsonResult.data = null; return objJsonResult; } ListModels oListModels = new ListModels(); try { DLL.ClsSc_MESBeginWorkBill oBill = new DLL.ClsSc_MESBeginWorkBill(); List<Models.ClsSc_MESBeginWorkBillMain> lsmain = new List<Models.ClsSc_MESBeginWorkBillMain>(); msg2 = msg2.Replace("\\", ""); msg2 = msg2.Replace("\n", ""); //\n lsmain = oListModels.getObjectByJson_Gy_MESBeginWorkFrom(msg2); foreach (Models.ClsSc_MESBeginWorkBillMain oItem in lsmain) { if (refSav == "Add") { //åæ®å·æ¯å¦éå¤ if (BillNew.IsExistBillNo(ref ClsPub.sExeReturnInfo, oItem.HBillNo, BillStatus, BillOld.omodel.HInterID)) { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "åæ®å·éå¤ï¼ä¸å 许ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } } BillNo = oItem.HMainSourceBillNo; MainId = oItem.HMainSourceInterID; EntyID = oItem.HMainSourceEntryID; DBUtility.ClsPub.CurUserName = oItem.HMaker; oItem.HBillType = "3787"; oItem.HBillSubType = "3787"; oItem.HBillStatus = 1; //åæ®ç¶æï¼1æªå®¡ï¼2å®¡æ ¸éè¿ï¼3å ³éï¼4ä½åºï¼5å®¡æ ¸éå,6å®¡æ ¸ä¸,7å·²é ï¼8å·²åå¤ï¼9ç»æ¡ï¼10éªè¯,11ä¸è¾¾ï¼12å¼å·¥,13ç³è¯·å®¡æ¹,15ç³è¯·æ£éªï¼16 å¤å®åæ ¼ï¼17å¤å®ä¸åæ ¼ï¼ oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); oItem.HBarCodeMakeDate = Convert.ToDateTime(DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd"))); //æ«ææ¥æï¼å¹´-æ-æ¥-æ¶-å-ç§ï¼ if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") { objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = "ä¿å失败ï¼æ²¡æåæ®æ¥æï¼æ æ³ä¿åï¼"; objJsonResult.data = 1; return objJsonResult; } oBill.omodel = oItem; } //ä¿å //ä¿åå®æ¯åå¤ç bool bResult; if (oBill.omodel.HInterID == 0) { oCN.BeginTran(); //ä¿®æ¹éè¶ç产åçç¶æ oCN.RunProc("update AIS20200908101915zs..T_PRD_MOENTRY_A set FSTATUS=4,FPLANCONFIRMDATE=getdate() where FENTRYID=" + (EntyID).Split('-')[1]); //访é®éè¶ //var loginRet = InvokeHelper.Login(); //var isSuccess = JObject.Parse(loginRet)["LoginResultType"].Value<int>(); //if (isSuccess == 0) //{ // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "æä½å¤±è´¥,éè¶è´¦å·ç»å½å¼å¸¸ã" + loginRet; // objJsonResult.data = null; // return objJsonResult; //} //var json = new //{ // //CreateOrgId = 0, // Numbers = BillNo, // //Ids = (EntyID).Split('-')[0], // PkEntryIds = (EntyID).Split('-')[1] //}; //Console.Write("json=" + json); //var result = InvokeHelper.ExcuteOperation("PRD_MO", "ToStart", JsonConvert.SerializeObject(json)); //if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") //{ // oCN.RollBack(); // objJsonResult.code = "0"; // objJsonResult.count = 0; // objJsonResult.Message = "对åºéè¶äºç产订åæ´æ¹å¼å·¥ç¶æ失败ï¼" + result; // objJsonResult.data = null; // return objJsonResult; //} ////æ§è¡ä¿å bResult = oBill.AddBill(ref DBUtility.ClsPub.sExeReturnInfo); if (bResult) { objJsonResult.HInterID = DBUtility.ClsPub.sExeReturnInfo; //è¿å主ID //ç³»ç»åæ° èªå¨å®¡æ ¸ string sReturn = ""; if (oSystemParameter.ShowBill(ref sReturn) == true) { if (oSystemParameter.omodel.Sc_ICMOBillWorkQtyStatus_AutoCheck == "Y") //ç³»ç»åæ° èªå¨å®¡æ ¸ { objJsonResult.Verify = "Y"; } else { objJsonResult.Verify = "N"; } } } } oCN.Commit(); objJsonResult.code = "0"; objJsonResult.count = 1; objJsonResult.Message = "ä¿åæåï¼"; objJsonResult.data = 1; return objJsonResult; } catch (Exception e) { oCN.RollBack(); objJsonResult.code = "0"; objJsonResult.count = 0; objJsonResult.Message = e.Message; objJsonResult.data = 1; return objJsonResult; } } #endregion } } }
