| | |
| | | |
| | | private json objJsonResult = new json(); |
| | | |
| | | |
| | | |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | DataSet ds; |
| | | |
| | |
| | | objJsonResult.Message = "Sucessï¼"; |
| | | objJsonResult.data = ds.Tables[0]; |
| | | return objJsonResult; |
| | | |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | DataRow dr1 = ds1.Tables[0].Rows[0]; |
| | | |
| | | JObject model = new JObject(); |
| | | model.Add("FBillType", "50fa7c2eda7947b89fab5431bf25d48e"); //åæ®ç±»å1 |
| | | model.Add("FBillType", new JObject() { ["Fnumber"] = "SCHBD01_SYS" }); //åæ®ç±»åçäº§æ±æ¥âSCHBD02_SYSâ å
¥åºæ±æ¥SCHBD01_SYS |
| | | model.Add("FPrdOrgId", new JObject() { ["Fnumber"] = dr1["FPrdOrgNUMBER"].ToString() }); //ç产ç»ç»1 |
| | | model.Add("FDate", DateTime.Now.ToString("yyyy-MM-dd")); //åæ®æ¥æ1 |
| | | JArray Fentity = new JArray(); |
| | | foreach (DataRow item in ds.Tables[0].Rows) |
| | | { |
| | | JObject FentityModel = new JObject(); |
| | | FentityModel.Add("FReportType", "103852");//çäº§æ±æ¥ç±»å |
| | | FentityModel.Add("FReportType", new JObject() { ["Fnumber"] = "1" });//çäº§æ±æ¥ç±»å |
| | | FentityModel.Add("FSrcBillType", "PRD_MO");// æºåç±»å |
| | | FentityModel.Add("FProductType", "1");// 产åç±»å |
| | | FentityModel.Add("FSrcBillNo", item["ä»»å¡å"].ToString());// æºåç¼å· |
| | | FentityModel.Add("FSrcInterId", dr1["FMOID"].ToString());// æºåå
ç |
| | | FentityModel.Add("FSrcEntryId", dr1["FMOENTRYID"].ToString());// æºååå½å
ç ã |
| | | FentityModel.Add("FSRCENTRYSEQ", dr1["FMOENTRYSEQ"].ToString());// æºååå½è¡å· |
| | | FentityModel.Add("FUNITID", new JObject() { ["Fnumber"] = dr1["FUNITNUMBER"].ToString() });//åä½ |
| | | FentityModel.Add("FTimeUnitId", "1");//æ¶é´åä½ |
| | | FentityModel.Add("FWorkshipId", new JObject() { ["Fnumber"] = dr1["FWorkShopNUM"].ToString() }); // çäº§è½¦é´ |
| | | FentityModel.Add("FStandHourUnitId", "3600"); // å使 åå·¥æ¶åä½ |
| | |
| | | FentityModel.Add("FMoEntrySeq", dr1["HICMOEntryID"].ToString());//ç产订åè¡å· |
| | | FentityModel.Add("FMoId", dr1["HICMOInterID"].ToString());//ç产订åå
ç |
| | | FentityModel.Add("FFinishQty", item["æ¥æ¶æ°é"].ToString());//宿æ°é1 |
| | | FentityModel.Add("FQuaQty", item["åæ ¼æ°é"].ToString());//åæ ¼æ°é1 |
| | | FentityModel.Add("FStockInOrgId ", OrganizationNUM);// å
¥åºç»ç» |
| | | FentityModel.Add("FQuaQty", item["åæ ¼æ°é"].ToString());//åæ ¼æ°é1FFailQty |
| | | FentityModel.Add("FFailQty", item["ä¸è¯æ°é"].ToString());//ä¸åæ ¼æ°é |
| | | FentityModel.Add("FStockInOrgId ", new JObject() { ["Fnumber"] = OrganizationNUM });// å
¥åºç»ç» |
| | | FentityModel.Add("FStockId", new JObject() { ["Fnumber"] = dr1["FStockNUM"].ToString() }); // ä»åº |
| | | FentityModel.Add("FSrcBillType", "PRD_MO");// æºåç±»å |
| | | FentityModel.Add("FSrcBillNo", item["ä»»å¡å"].ToString());// æºåç¼å· |
| | | FentityModel.Add("FSrcInterId", dr1["HICMOInterID"].ToString());// æºåå
ç |
| | | FentityModel.Add("FSrcEntryId", dr1["HICMOEntryID"].ToString());// æºååå½å
ç |
| | | FentityModel.Add("FMOID", dr1["FMOID"].ToString());// |
| | | FentityModel.Add("FMOBILLNO", dr1["FMOBILLNO"].ToString());// |
| | | FentityModel.Add("FMOENTRYID", dr1["FMOENTRYID"].ToString());// |
| | | FentityModel.Add("FMOENTRYSEQ", dr1["FMOENTRYSEQ"].ToString());// |
| | | FentityModel.Add("FOwnerTypeId", dr1["FOWNERTYPEID"].ToString()); //货主类åï¼FOwnerTypeId(å¿
填项) |
| | | FentityModel.Add("FOwnerId", new JObject() { ["Fnumber"] = dr1["FOwnerNumber"].ToString() }); //货主ï¼FOwnerId(å¿
填项) |
| | | FentityModel.Add("FBomId", new JObject() { ["Fnumber"] = dr1["FBOMNUM"].ToString() }); //BOMçæ¬ï¼FBomId(å¿
填项) |
| | | FentityModel.Add("FCostRate", dr1["FCostRate"].ToString());// ææ¬æé |
| | | FentityModel.Add("FISBACKFLUSH", dr1["FISBACKFLUSH"].ToString() == "1" ? true : false);// åå²é¢æ |
| | | //FFLOWID FFLOWLINEID FRULEID FSTABLENAME |
| | | //f6e6eec3 - 5267 - 4f02 - 8593 - b633da508a72 3 PRD_MO2MORPT T_PRD_MOENTRY |
| | | //ä¸å¡æµç¨å¾ï¼FEntity_Link_FFlowId |
| | | //æ¨è¿è·¯çº¿ï¼FEntity_Link_FFlowLineId |
| | | //转æ¢è§åï¼FEntity_Link_FRuleId |
| | | //æºå表å
ç ï¼FEntity_Link_FSTableId |
| | | //æºå表ï¼FEntity_Link_FSTableName |
| | | //æºåå
ç ï¼FEntity_Link_FSBillId |
| | | //æºååå½å
ç ï¼FEntity_Link_FSId |
| | | //åå§æºå¸¦éï¼FEntity_Link_FBaseQuaQtyOld |
| | | //ä¿®æ¹æºå¸¦éï¼FEntity_Link_FBaseQuaQty |
| | | |
| | | //JArray Fentity2 = new JArray(); |
| | | //JObject FentityModel2 = new JObject(); |
| | | //FentityModel2.Add("FDetailEntity_Link_FRULEID", "PUR_PurchaseOrder-PUR_ReceiveBill"); |
| | | //FentityModel2.Add("FDetailEntity_Link_FSTableName", "t_PUR_POOrderEntry"); |
| | | //FentityModel2.Add("FDetailEntity_Link_FSBillId", item["FID"].ToString()); |
| | | //FentityModel2.Add("FDetailEntity_Link_FSId", item["FEntryID"].ToString()); |
| | | //Fentity2.Add(FentityModel2); |
| | | //FentityModel.Add("FDetailEntity_Link", Fentity2); |
| | | //Fentity.Add(FentityModel); |
| | | JArray Fentity2 = new JArray(); |
| | | JObject FentityModel2 = new JObject(); |
| | | FentityModel2.Add("FEntity_Link_FFlowId", "f6e6eec3-5267-4f02-8593-b633da508a72"); |
| | | FentityModel2.Add("FEntity_Link_FFlowLineId", "PRD_MO2MORPT"); |
| | | FentityModel2.Add("FEntity_Link_FRuleId", "3"); |
| | | FentityModel2.Add("FEntity_Link_FSTableId", "0"); |
| | | FentityModel2.Add("FEntity_Link_FSTableName", "T_PRD_MOENTRY"); |
| | | FentityModel2.Add("FEntity_Link_FSBillId", dr1["FMOID"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FSId", dr1["FMOENTRYID"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FBaseQuaQtyOld", item["åæ ¼æ°é"].ToString()); |
| | | FentityModel2.Add("FEntity_Link_FBaseQuaQty", item["åæ ¼æ°é"].ToString()); |
| | | Fentity2.Add(FentityModel2); |
| | | FentityModel.Add("FEntity_Link", Fentity2); |
| | | FentityModel.Add("FBFLowId", new JObject() { ["FID"] = "f6e6eec3-5267-4f02-8593-b633da508a72" }); // |
| | | Fentity.Add(FentityModel); |
| | | } |
| | | model.Add("FDetailEntity", Fentity); //æç»ä¿¡æ¯ |
| | | model.Add("FEntity", Fentity); //æç»ä¿¡æ¯ |
| | | JObject jsonRoot = new JObject() |
| | | { |
| | | ["Creator"] = "", |
| | |
| | | //["IsAutoSubmitAndAudit"] = true,//èªå¨è°ç¨æäº¤åå®¡æ ¸åè½ |
| | | ["Model"] = model |
| | | }; |
| | | string result = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot)); |
| | | //å¤æå®¡æ ¸æ¯å¦æå |
| | | LogService.Write("jsonRoot:" + jsonRoot); |
| | | string result = InvokeHelper.Save("PRD_MORPT", JsonConvert.SerializeObject(jsonRoot));//ä¿å |
| | | //夿ä¿åæ¯å¦æå |
| | | if (JObject.Parse(result)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"å·¥åºæ±æ¥å
¥åºå忥éè¶äºå¤±è´¥ï¼åå·:{dr["åæ®å·"].ToString()}" + result; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | //æäº¤å®¡æ ¸ |
| | | string result1 = string.Empty; |
| | | string result2 = string.Empty; |
| | | var fID = JObject.Parse(result)["Result"]["Id"].ToString(); |
| | | var fBillNo = JObject.Parse(result)["Result"]["Number"].ToString(); |
| | | var json = new |
| | | { |
| | | Ids = fID, |
| | | }; |
| | | result1 = InvokeHelper.Submit("PRD_MORPT", JsonConvert.SerializeObject(json));//æäº¤ |
| | | //result2 = InvokeHelper.Audit("PRD_MORPT", JsonConvert.SerializeObject(json));//å®¡æ ¸ |
| | | if (JObject.Parse(result1)["Result"]["ResponseStatus"]["IsSuccess"].ToString().ToUpper() != "TRUE") |
| | | { |
| | | oCN.RollBack(); |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = $"çäº§æ±æ¥ååå·ï¼{fBillNo}ï¼æäº¤å¤±è´¥" + result; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | /// </summary> |
| | | [Route("Sc_ProcessMangement/MES_Sc_ProcessReportList_Json")] |
| | | [HttpGet] |
| | | public object MES_Sc_ProcessReportList_Json(string sWhere,string user) |
| | | public object MES_Sc_ProcessReportList_Json(string sWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_ProcessReportList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc"; |
| | | string sql = sql1 + sWhere + " order by hmainid desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessReportList"); |
| | | } |
| | | } |
| | |
| | | try |
| | | { |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (HInterID<=0) |
| | | if (HInterID <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "HInterIDå°äº0ï¼" ; |
| | | objJsonResult.Message = "HInterIDå°äº0ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | inner join Gy_Department s2 on s1.HDeptID=s2.HItemID and s1.HInterID=" + HInterID; |
| | | |
| | | ds = oCN.RunProcReturn(sql1, "Sc_ProcessReportMain"); |
| | | |
| | | |
| | | } |
| | | |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | else |
| | | { |
| | | |
| | | string sql1 =@"select [hmainid], [æ¥æ], [åæ®å·], [HDeptID], [é¨é¨ä»£ç ], [é¨é¨], [HMaterID], [ç©æä»£ç ], [ç©æåç§°], [è§æ ¼åå·], [HUnitID], [计éåä½ä»£ç ], [计éåä½], [HprocID], |
| | | string sql1 = @"select [hmainid], [æ¥æ], [åæ®å·], [HDeptID], [é¨é¨ä»£ç ], [é¨é¨], [HMaterID], [ç©æä»£ç ], [ç©æåç§°], [è§æ ¼åå·], [HUnitID], [计éåä½ä»£ç ], [计éåä½], [HprocID], |
| | | [å·¥åºä»£ç ], [å·¥åº], [HGroupID], [çç»ä»£ç ], [çç»åç§°], [HSourceID], [èµæºä»£ç ], [çäº§èµæº], [HWorkerID], [èå代ç ], [èå], [hsubid], [æ°é], [计åå¼å·¥æ¥æ], |
| | | [计åå®å·¥æ¥æ], [计åå·¥æ¶], [表ä½å¤æ³¨], [HICMOInterID], [ç产任å¡åå·], [HSeOrderInterID], [éå®è®¢åå·], [è¡¨å¤´å¤æ³¨], [å¶å人], [å¶åæ¥æ], [å®¡æ ¸äºº], [å®¡æ ¸æ¥æ], [ä¿®æ¹äºº], |
| | | [ä¿®æ¹æ¥æ], [å
³é人], [å
³éæ¥æ], [ä½åºäºº], [ä½åºæ¥æ], [æºå主å
ç ], [æºååå
ç ], [æºååå·], [æºåç±»å], [è¡å
³é人], [HBillType], [HQtyDecimal], [HPriceDecimal] |
| | | from h_v_Sc_ProcessSendWorkList |
| | | where hmainid=(select HSourceID from Sc_ProcessReportSub where HInterID="+HInterID+")"; |
| | | where hmainid=(select HSourceID from Sc_ProcessReportSub where HInterID=" + HInterID + ")"; |
| | | |
| | | ds = oCN.RunProcReturn(sql1, "h_v_Sc_ProcessSendWorkList"); |
| | | |
| | |
| | | /// </summary> |
| | | [Route("Sc_ProcessMangement/MES_Sc_ProcessPlanMain_Json")] |
| | | [HttpGet] |
| | | public object MES_Sc_ProcessPlanMain_Json(string sWhere,string user) |
| | | public object MES_Sc_ProcessPlanMain_Json(string sWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_ProcessPlanList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessPlanList"); |
| | | } |
| | | } |
| | |
| | | ",HRemark,HInnerBillNo,HMaker,HMakeDate" + |
| | | ") " + |
| | | " values(" + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + BillType + "','" + BillType + "'," + omodel.HInterID.ToString() + |
| | | ",'" + omodel.HDate.ToShortDateString() + "','" + omodel.HBillNo + "'," + (omodel.HBillStatus=1) + "," + omodel.HCheckItemNowID.ToString() + "," + omodel.HCheckItemNextID.ToString() + |
| | | ",'" + omodel.HDate.ToShortDateString() + "','" + omodel.HBillNo + "'," + (omodel.HBillStatus = 1) + "," + omodel.HCheckItemNowID.ToString() + "," + omodel.HCheckItemNextID.ToString() + |
| | | "," + omodel.HICMOInterID.ToString() + ",'" + omodel.HICMOBillNo + "'," + omodel.HMaterID.ToString() + ",'" + omodel.HMaterNumber + "'," + omodel.HUnitID.ToString() + |
| | | ",'" + omodel.HUnitNumber + "'," + omodel.HPlanQty.ToString() + ",'" + omodel.HPlanBeginDate.ToShortDateString() + "','" + omodel.HPlanEndDate.ToShortDateString() + "','" + omodel.HExplanation + "'" + |
| | | ",'" + omodel.HRemark + "','" + omodel.HInnerBillNo + "','" + omodel.HMaker + "',getdate()" + |
| | |
| | | " where HInterID=" + omodel.HInterID.ToString()); |
| | | |
| | | //å é¤å表 |
| | | oCN.RunProc("Delete From Sc_ProcessPlanSub where HInterID = " + omodel.HInterID.ToString()+ " and hentryid="+ hentryid); |
| | | oCN.RunProc("Delete From Sc_ProcessPlanSub where HInterID = " + omodel.HInterID.ToString() + " and hentryid=" + hentryid); |
| | | } |
| | | //ä¿åå表 |
| | | objJsonResult = AddBillSub(msg3, hentryid); |
| | |
| | | ",HBeginDayQty,HBeginFixQty,HFixWorkDays,HTrunWorkDays,HReadyTimes" + |
| | | ",HReadyTime,HQueueTime,HMoveTime,HBatchNo" + |
| | | ") values(" |
| | | + omodel.HInterID.ToString() + "," +(hentryid==-1?i: hentryid) + ",'" + oSub.HBillNo + "'," + oSub.HProcNo.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HWorkingQty.ToString() + |
| | | + omodel.HInterID.ToString() + "," + (hentryid == -1 ? i : hentryid) + ",'" + oSub.HBillNo + "'," + oSub.HProcNo.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HWorkingQty.ToString() + |
| | | ",'" + oSub.HProcNumber + "','" + oSub.HWorkRemark + "'," + oSub.HCenterID.ToString() + "," + oSub.HDeptID.ToString() + ",'" + oSub.HDeptNumber + "'" + |
| | | "," + oSub.HGroupID.ToString() + ",'" + oSub.HGroupNumber + "'," + oSub.HWorkerID.ToString() + ",'" + oSub.HWorkerNumber + "'," + oSub.HSourceID.ToString() + |
| | | "," + oSub.HQty.ToString() + ",'" + oSub.HTimeUnit + "'," + oSub.HPlanWorkTimes.ToString() + ",'" + oSub.HPlanBeginDate.ToString() + "','" + oSub.HPlanEndDate.ToString() + "'" + |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®ä¸åå¨;åå :"+DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.Message = "åæ®ä¸åå¨;åå :" + DBUtility.ClsPub.sExeReturnInfo; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | else { |
| | | else |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥,åå :" + DBUtility.ClsPub.sExeReturnInfo; |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | } |
| | | //å®¡æ ¸ |
| | | public bool CheckBill(Int64 lngBillKey, ref string sReturn) |
| | |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | if (oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo)) |
| | | { |
| | | objJsonResult.code = "1"; |
| | |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/MES_Sc_ProcessSendWorkMain_Json")] |
| | | [HttpGet] |
| | | public object MES_Sc_ProcessSendWorkMain_Json(string sWhere,string user) |
| | | public object MES_Sc_ProcessSendWorkMain_Json(string sWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Sc_ProcessSendWorkList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Sc_ProcessSendWorkList"); |
| | | } |
| | | } |
| | |
| | | /// <returns></returns> |
| | | [Route("SaveProcessSendWork")] |
| | | [HttpPost] |
| | | public object SaveProcessSendWork([FromBody]JObject msg) |
| | | public object SaveProcessSendWork([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | msg2 = msg2.Replace("\\", ""); |
| | | msg2 = msg2.Replace("\n", ""); |
| | | lsmain = oListModels.getObjectByJson_SendWorkMain(msg2); |
| | | foreach ( Model.ClsSc_ProcessSendWorkMain oItem in lsmain) |
| | | foreach (Model.ClsSc_ProcessSendWorkMain oItem in lsmain) |
| | | { |
| | | UserName = oItem.HMaker; |
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if (Convert.ToInt32( sendworksub.HQty) > Convert.ToInt32( oItemSub.è®¡åæ°é)) |
| | | if (Convert.ToInt32(sendworksub.HQty) > Convert.ToInt32(oItemSub.è®¡åæ°é)) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | sendworksub.HCloseType = false; |
| | | sendworksub.HSourceBillType = oItemSub.HBillType; |
| | | lss.Add(sendworksub);//å
ææ°æ®åæ¾å°æ´¾å·¥åå表éåé |
| | | |
| | | |
| | | |
| | | } |
| | | if (lss.Count > 0) |
| | |
| | | sendworksub.HWorkerNumber = ""; //--æä½å·¥ä»£ç |
| | | sendworksub.HWorkerID = 0; //--æä½å·¥ID |
| | | sendworksub.HGroupNumber = ""; //çç»ä»£ç |
| | | sendworksub.HGroupID =0; //--çç»ID |
| | | sendworksub.HGroupID = 0; //--çç»ID |
| | | sendworksub.HSourceNumber = ""; //--çäº§èµæºä»£ç |
| | | //--çäº§èµæºID |
| | | sendworksub.HProcNumber = ""; //--å·¥åºä»£ç |
| | |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/MES_QC_NoPassProdCheckBill_Json")] |
| | | [HttpGet] |
| | | public object MES_QC_NoPassProdCheckBill_Json(string sWhere,string user) |
| | | public object MES_QC_NoPassProdCheckBill_Json(string sWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_QC_NoPassProdCheckBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sWhere + " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_QC_NoPassProdCheckBillList"); |
| | | } |
| | | } |
| | |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å é¤å¤±è´¥!"+e.ToString(); |
| | | objJsonResult.Message = "å é¤å¤±è´¥!" + e.ToString(); |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | } |
| | |
| | | /// <returns></returns> |
| | | [Route("SaveProcessReport")] |
| | | [HttpPost] |
| | | public object SaveProcessReport([FromBody] JObject msg) |
| | | public object SaveProcessReport([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | List<WebAPI.Models.Sc_ProcessReportViewModel> ls = new List<WebAPI.Models.Sc_ProcessReportViewModel>(); |
| | | ls = oListModels.getObjectByJson_Report(msg1); |
| | | int i = 0; |
| | | |
| | | |
| | | foreach (Models.Sc_ProcessReportViewModel ItemView in ls) |
| | | { |
| | | i++; |
| | |
| | | //å·¥åºæ±æ¥å主表ä¿å |
| | | ReportMain.HBillType = "3714"; |
| | | ReportMain.HBillNo = ItemView.HBillNo; |
| | | ReportMain.HMakeDate=DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | ReportMain.HYear=DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | ReportMain.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | ReportMain.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | ReportMain.HDate = DateTime.Now; |
| | | ReportMain.HMaker = ItemView.HEmp; |
| | | ReportMain.HCloseType = false; |
| | | ReportMain.HPlanQty = (double)ItemView.HQty; |
| | | ReportMain.HMainSourceInterID = ItemView.HInterID; |
| | | ReportMain.HInterID =0; |
| | | ReportMain.HInterID = 0; |
| | | ReportMain.HPeriod = 1; |
| | | ReportMain.HBillSubType = "3714"; |
| | | ReportMain.HBillStatus = 0; |
| | | ReportMain.HCheckItemNowID = 0; |
| | | ReportMain.HCheckItemNextID = 0; |
| | | ReportMain.HICMOInterID= (long)ItemView.HICMOInterID; |
| | | ReportMain.HICMOBillNo=ItemView.HICMOBillNo; |
| | | ReportMain.HICMOInterID = (long)ItemView.HICMOInterID; |
| | | ReportMain.HICMOBillNo = ItemView.HICMOBillNo; |
| | | ReportMain.HDeptID = (long)ItemView.HDeptID; |
| | | ReportMain.HDeptNumber =ItemView.HDeptNumber; |
| | | ReportMain.HDeptNumber = ItemView.HDeptNumber; |
| | | ReportMain.HGroupID = (long)ItemView.HGroupID; |
| | | ReportMain.HGroupNumber = ItemView.HGroupNumber; |
| | | ReportMain.HMaterID = (long)ItemView.HMaterID; |
| | |
| | | ReportMain.HExplanation = ""; |
| | | ReportMain.HInnerBillNo = ""; |
| | | ReportMain.HSupID = 0; |
| | | |
| | | |
| | | |
| | | |
| | | //ä¿åå°æ±æ¥å主表 |
| | |
| | | ReportSub.HQty = (double)ItemView.HQty; |
| | | ReportSub.HProcID = ItemView.HProcID; |
| | | ReportSub.HProcNumber = ItemView.HProcNumber; |
| | | ReportSub.HOutPrice =0; |
| | | ReportSub.HOutPrice = 0; |
| | | ReportSub.HOutMoney = 0; |
| | | ReportSub.HSourceID = (long)ItemView.HSourceID; |
| | | ReportSub.HEmpNumber = ""; |
| | | ReportSub.HRelBeginDate = DateTime.Now; |
| | | ReportSub.HRelEndDate = DateTime.Now; |
| | | ReportSub.HTimes =3; |
| | | ReportSub.HTimes = 3; |
| | | ReportSub.HSeOrderInterID = 0; |
| | | ReportSub.HSeOrderEntryID =0; |
| | | ReportSub.HSeOrderEntryID = 0; |
| | | ReportSub.HSeOrderBillNo = ""; |
| | | ReportSub.HProcPlanInterID = 0; |
| | | ReportSub.HProcPlanBillNo = ""; |
| | |
| | | ReportSub.HRelationMoney = 0; |
| | | ReportSub.HMaterID = (long)ItemView.HMaterID; |
| | | ReportSub.HMaterNumber = ItemView.HMaterNumber; |
| | | ReportSub.HCheckQty =0; |
| | | ReportSub.HBadCount =0; |
| | | ReportSub.HWasterQty =0; |
| | | ReportSub.HWasterQty2 =0; |
| | | ReportSub.HPrice =0; |
| | | ReportSub.HMoney =0; |
| | | ReportSub.HProcPlanInterID =0; |
| | | ReportSub.HProcPlanEntryID =0; |
| | | ReportSub.HProcPlanBillNo =""; |
| | | ReportSub.HSourceEntryID =0; |
| | | ReportSub.HSourceBillType =""; |
| | | ReportSub.HRelationQty =0; |
| | | ReportSub.HRelationMoney =0; |
| | | ReportSub.HBadPrirce =0; |
| | | ReportSub.HBadMoney =0; |
| | | ReportSub.HWasterPrice =0; |
| | | ReportSub.HWasterMoney =0; |
| | | ReportSub.HQualityRate =0; |
| | | ReportSub.HSecUnitQty1 =0; |
| | | ReportSub.HSecUnitRate1=0; |
| | | ReportSub.HSecUnitQty2=0; |
| | | ReportSub.HSecUnitRate2=0; |
| | | ReportSub.HUsingQty=0; |
| | | ReportSub.HSelfBadCount=0; |
| | | ReportSub.HPreBadCount=0; |
| | | ReportSub.HPayMentQty=0; |
| | | ReportSub.HOtherDeduct=0; |
| | | ReportSub.HRelPay=0; |
| | | ReportSub.HOtherItem1=""; |
| | | ReportSub.HOtherItem2=""; |
| | | ReportSub.HOtherItem3=""; |
| | | ReportSub.HOtherItem4=""; |
| | | ReportSub.HOtherItem5=""; |
| | | ReportSub.HPackType=""; |
| | | ReportSub.HCheckEmpID=0; |
| | | ReportSub.HWeight=0; |
| | | ReportSub.HBatchNo=""; |
| | | |
| | | ReportSub.HCheckQty = 0; |
| | | ReportSub.HBadCount = 0; |
| | | ReportSub.HWasterQty = 0; |
| | | ReportSub.HWasterQty2 = 0; |
| | | ReportSub.HPrice = 0; |
| | | ReportSub.HMoney = 0; |
| | | ReportSub.HProcPlanInterID = 0; |
| | | ReportSub.HProcPlanEntryID = 0; |
| | | ReportSub.HProcPlanBillNo = ""; |
| | | ReportSub.HSourceEntryID = 0; |
| | | ReportSub.HSourceBillType = ""; |
| | | ReportSub.HRelationQty = 0; |
| | | ReportSub.HRelationMoney = 0; |
| | | ReportSub.HBadPrirce = 0; |
| | | ReportSub.HBadMoney = 0; |
| | | ReportSub.HWasterPrice = 0; |
| | | ReportSub.HWasterMoney = 0; |
| | | ReportSub.HQualityRate = 0; |
| | | ReportSub.HSecUnitQty1 = 0; |
| | | ReportSub.HSecUnitRate1 = 0; |
| | | ReportSub.HSecUnitQty2 = 0; |
| | | ReportSub.HSecUnitRate2 = 0; |
| | | ReportSub.HUsingQty = 0; |
| | | ReportSub.HSelfBadCount = 0; |
| | | ReportSub.HPreBadCount = 0; |
| | | ReportSub.HPayMentQty = 0; |
| | | ReportSub.HOtherDeduct = 0; |
| | | ReportSub.HRelPay = 0; |
| | | ReportSub.HOtherItem1 = ""; |
| | | ReportSub.HOtherItem2 = ""; |
| | | ReportSub.HOtherItem3 = ""; |
| | | ReportSub.HOtherItem4 = ""; |
| | | ReportSub.HOtherItem5 = ""; |
| | | ReportSub.HPackType = ""; |
| | | ReportSub.HCheckEmpID = 0; |
| | | ReportSub.HWeight = 0; |
| | | ReportSub.HBatchNo = ""; |
| | | |
| | | //ä¿åå°æ±æ¥åå表 |
| | | ReportModel.DetailColl.Add(ReportSub); |
| | | } |
| | |
| | | /// <returns></returns> |
| | | [Route("SaveProcessReportList")] |
| | | [HttpPost] |
| | | public object SaveProcessReportList([FromBody] JObject msg) |
| | | public object SaveProcessReportList([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | List<Model.ClsSc_ProcessReportSub> lsReportSub = new List<Model.ClsSc_ProcessReportSub>(); |
| | | foreach (WebAPI.Models.Sc_ProcessSendWorkViewModel ItemView in ls) |
| | | { |
| | | |
| | | |
| | | i++; |
| | | Model.ClsSc_ProcessReportSub reportSub = new Model.ClsSc_ProcessReportSub(); |
| | | if (ItemView.æ°é <= 0) |
| | |
| | | reportSub.HRemark = ""; |
| | | reportSub.HCloseMan = ReportModel.omodel.HCloseMan; |
| | | reportSub.HCloseType = false; |
| | | reportSub.HEmpID =0; |
| | | reportSub.HICMOBillNo =""; |
| | | reportSub.HEmpID = 0; |
| | | reportSub.HICMOBillNo = ""; |
| | | reportSub.HICMOInterID = (long)ItemView.HICMOInterID; |
| | | reportSub.HRemark = ""; |
| | | reportSub.HSourceBillType = "3712"; |
| | |
| | | lsReportSub.Add(reportSub); |
| | | |
| | | } |
| | | if (lsReportSub.Count>0) |
| | | if (lsReportSub.Count > 0) |
| | | { |
| | | //ç¶åå¨å¾ªç¯ä¿åå°æ±æ¥ä½å表 |
| | | foreach (Model.ClsSc_ProcessReportSub item in lsReportSub) |
| | |
| | | /// <returns></returns> |
| | | [Route("SaveBadReasonList")] |
| | | [HttpPost] |
| | | public object SaveBadReasonList([FromBody] JObject msg) |
| | | public object SaveBadReasonList([FromBody] JObject msg) |
| | | { |
| | | var _value = msg["msg"].ToString(); |
| | | string msg1 = _value.ToString(); |
| | |
| | | string user = sArray[2].ToString(); |
| | | |
| | | |
| | | string UserName=""; |
| | | string UserName = ""; |
| | | ListModels oListModels = new ListModels(); |
| | | try |
| | | { |
| | |
| | | foreach (Model.ClsQC_NoPassProdCheckBillMain oItem in lsmain) |
| | | { |
| | | //oItem.HMaker = ""; |
| | | UserName=oItem.HMaker; |
| | | UserName = oItem.HMaker; |
| | | oItem.HMakeDate = DBUtility.ClsPub.isStrNull(DateTime.Now.ToString("yyyy-MM-dd")); |
| | | oItem.HYear = DBUtility.ClsPub.isLong(DateTime.Now.Year); |
| | | oItem.HDate = DBUtility.ClsPub.isDate(DateTime.Now.ToString("yyyy-MM-dd")); |
| | |
| | | oItem.HBillSubType = "7509"; |
| | | oItem.HBillStatus = 1; |
| | | oItem.HPeriod = 0; |
| | | oItem.HGroupName =""; |
| | | oItem.HGroupName = ""; |
| | | oItem.HSourceID = 0; |
| | | oItem.HICMOInterID = 0; |
| | | oItem.HICMOBillNo = ""; |
| | |
| | | oItem.HMainSourceInterID = oItem.HInterID; |
| | | oItem.HInterID = 0; |
| | | //oItem.HInterID = DBUtility.ClsPub.CreateBillID_SRMProd("1103", ref DBUtility.ClsPub.sExeReturnInfo); |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate)=="") |
| | | if (DBUtility.ClsPub.isStrNull(oItem.HDate) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | return objJsonResult; |
| | | } |
| | | oBill.omodel = oItem; |
| | | } |
| | | } |
| | | //è¡¨ä½æ°æ® |
| | | //æ },{æ¥æåæ°ç» //廿ãåã |
| | | msg3 = msg3.Substring(1, msg3.Length - 2); |
| | |
| | | break; |
| | | } |
| | | //å°åå°ä¸´æ¶åæ¾çå¼ä¼ è¿æ¥çå¼èµç»å¯¹åºçä¸è¯æ°éåæ®µ |
| | | oItemSub.HBadQty = Convert.ToDecimal( oItemSub.HMRBChecker); |
| | | if (oItemSub.HBadQty<=0) |
| | | oItemSub.HBadQty = Convert.ToDecimal(oItemSub.HMRBChecker); |
| | | if (oItemSub.HBadQty <= 0) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if ((double)oItemSub.HBadQty >oBill.omodel.HPlanQty ) |
| | | if ((double)oItemSub.HBadQty > oBill.omodel.HPlanQty) |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | if (DBUtility.ClsPub.isStrNull(oItemSub.HWasterReasonName)=="") |
| | | if (DBUtility.ClsPub.isStrNull(oItemSub.HWasterReasonName) == "") |
| | | { |
| | | objJsonResult.code = "0"; |
| | | objJsonResult.count = 0; |
| | |
| | | oItemSub.HBadPCSQty = 0; |
| | | oItemSub.HQCResultID = 0; |
| | | oBill.DetailColl.Add(oItemSub); |
| | | |
| | | |
| | | } |
| | | //ä¿åå夿(åæ®å·éå¤ï¼ç¬å½é¡¹ç®) |
| | | //ä¿å |
| | |
| | | /// <returns></returns> |
| | | [Route("CloseProcessReportList")] |
| | | [HttpGet] |
| | | public object CloseProcessReportList(int HInterID,int IsClose,string CurUserName) |
| | | public object CloseProcessReportList(int HInterID, int IsClose, string CurUserName) |
| | | { |
| | | DataSet ds; |
| | | string ModRightNameCheck = "Sc_ProcessReport_check"; |
| | | string ModRightNameCheck = "Sc_ProcessReport_check"; |
| | | try |
| | | { |
| | | //å®¡æ ¸æé |
| | |
| | | } |
| | | var HChecker = ds.Tables[0].Rows[0]["HChecker"].ToString(); |
| | | var HCloseMan = ds.Tables[0].Rows[0]["HCloseMan"].ToString(); |
| | | |
| | | |
| | | if (IsClose == 0) |
| | | { |
| | | if (HCloseMan.Trim() != "" || HChecker.Trim() == "") |
| | |
| | | objJsonResult.Message = "* åæ®å
³éæåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; ; |
| | | } |
| | | else if(IsClose==1) |
| | | } |
| | | else if (IsClose == 1) |
| | | { |
| | | if (HCloseMan.Trim() == "" || HChecker.Trim() == "") |
| | | { |
| | |
| | | return objJsonResult; ; |
| | | } |
| | | |
| | | |
| | | |
| | | } |
| | | catch (Exception e) |
| | | { |
| | |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "å®¡æ ¸å¤±è´¥ï¼æ æéï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | return objJsonResult; |
| | | } |
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
| | | if (HInterID <= 0) |
| | |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "没æè¿ä¸ªåæ®ï¼æ æ³å®¡æ ¸ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | return objJsonResult; |
| | | } |
| | | var HChecker = ds.Tables[0].Rows[0]["HChecker"].ToString();//åå®¡æ ¸äºº |
| | | var HMaker=ds.Tables[0].Rows[0]["HMaker"].ToString();//åå¶å人 |
| | | var HCloseMan=ds.Tables[0].Rows[0]["HCloseMan"].ToString();//åå
³é人 |
| | | var HMaker = ds.Tables[0].Rows[0]["HMaker"].ToString();//åå¶å人 |
| | | var HCloseMan = ds.Tables[0].Rows[0]["HCloseMan"].ToString();//åå
³é人 |
| | | if (IsAudit == 0) |
| | | { |
| | | if (HChecker.Trim() != "" || HChecker.Trim() == HMaker || HCloseMan != "") |
| | |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* åæ®å®¡æ ¸æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | return objJsonResult; |
| | | } |
| | | else if (IsAudit == 1) |
| | | { |
| | |
| | | objJsonResult.count = 1; |
| | | objJsonResult.Message = "* åæ®åå®¡æ ¸æåï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | return objJsonResult; |
| | | } |
| | | else |
| | | { |
| | |
| | | objJsonResult.count = 0; |
| | | objJsonResult.Message = "åæ®æ æ³å®¡æ ¸ï¼"; |
| | | objJsonResult.data = null; |
| | | return objJsonResult; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/MES_WW_EntrustProcSendWorkBill_Json")] |
| | | [HttpGet] |
| | | public object MES_WW_EntrustProcSendWorkBill_Json(string sqlWhere,string user) |
| | | public object MES_WW_EntrustProcSendWorkBill_Json(string sqlWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_WW_EntrustProcSendWorkBillList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sqlWhere + " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcSendWorkBillList"); |
| | | } |
| | | } |
| | |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/MES_WW_EntrustProcessReportBill_Json")] |
| | | [HttpGet] |
| | | public object MES_WW_EntrustProcessReportBill_Json(string sqlWhere,string user) |
| | | public object MES_WW_EntrustProcessReportBill_Json(string sqlWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | /// <param name="sqlWhere"></param> |
| | | /// <returns></returns> |
| | | [Route("Sc_ProcessMangement/MES_WW_EntrustProcessSendOutBillList_Json")] |
| | | [HttpGet] |
| | | public object MES_WW_EntrustProcessSendOutBillList_Json(string sqlWhere,string user) |
| | | [HttpGet] |
| | | public object MES_WW_EntrustProcessSendOutBillList_Json(string sqlWhere, string user) |
| | | { |
| | | DataSet ds; |
| | | try |
| | |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_WW_EntrustProcessSendOutBillList where 1 = 1 "; |
| | | string sql = sql1 + sqlWhere+ " order by hmainid desc "; |
| | | string sql = sql1 + sqlWhere + " order by hmainid desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_WW_EntrustProcessSendOutBillList"); |
| | | } |
| | | } |
| | |
| | | objJsonResult.data = 1; |
| | | return objJsonResult; |
| | | } |
| | | |
| | | |
| | | |
| | | sendworksub.HEntryID = i; |
| | | sendworksub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now); |
| | |
| | | ReportMain.HCloseType = false; |
| | | ReportMain.HPrintQty = 0; |
| | | ReportMain.HMainSourceBillType = "3740"; |
| | | ReportMain.HMainSourceInterID =0; |
| | | ReportMain.HMainSourceInterID = 0; |
| | | ReportMain.HMainSourceBillNo = ItemView.HWW_BillNo; |
| | | ReportMain.HInterID = 0; |
| | | ReportMain.HPeriod = 1; |
| | |
| | | ReportMain.HDeptID = Convert.ToInt32(ItemView.HDeptID); |
| | | ReportMain.HExplanation = ""; |
| | | ReportMain.HInnerBillNo = ""; |
| | | ReportMain.HSupID =Convert.ToInt32( ItemView.HSupID); |
| | | ReportMain.HSupID = Convert.ToInt32(ItemView.HSupID); |
| | | |
| | | |
| | | //ä¿åå°æ±æ¥å主表 |
| | |
| | | ReportSub.HCloseType = false; |
| | | ReportSub.HSourceBillType = "3740"; |
| | | ReportSub.HQty = Convert.ToDecimal(ItemView.HQty); |
| | | ReportSub.HProcID =Convert.ToInt32( ItemView.HProcID); |
| | | ReportSub.HProcID = Convert.ToInt32(ItemView.HProcID); |
| | | ReportSub.HTimes = 0; |
| | | ReportSub.HSeOrderInterID = 0; |
| | | ReportSub.HSeOrderEntryID = 0; |
| | |
| | | WorkOrdersub.HSourceInterID = oItemSub.hmainid.Value; //--æºåid |
| | | WorkOrdersub.HSourceEntryID = oItemSub.hsubid.Value; //--æºååID |
| | | WorkOrdersub.HSourceBillNo = oItemSub.åæ®å·; //--æºååå· |
| | | WorkOrdersub.HSourceBillType= oItemSub.HBillType; //--æºåç±»å |
| | | WorkOrdersub.HSourceBillType = oItemSub.HBillType; //--æºåç±»å |
| | | WorkOrdersub.HRelationQty = 0; //--å
³èæ°é |
| | | WorkOrdersub.HRelationMoney = 0; //--å
³èéé¢ |
| | | WorkOrdersub.HOrderBillNo = ""; //--éå®è®¢åå· |
| | |
| | | WorkOrdersub.HQty = (double)oItemSub.è®¡åæ°é; //--è®¢åæ°é |
| | | WorkOrdersub.HEntrustType = "3739"; //--å§å¤ç±»å |
| | | WorkOrdersub.HNextProcName = ""; //--ä¸éå·¥åº |
| | | WorkOrdersub.HPrice =0; //å 工费 |
| | | WorkOrdersub.HPrice = 0; //å 工费 |
| | | WorkOrdersub.HOutQty = 0; //--å
³èååºæ°é |
| | | WorkOrdersub.HInQty =0; //--å
³èæ¥æ¶æ°é |
| | | WorkOrdersub.HInQty = 0; //--å
³èæ¥æ¶æ°é |
| | | WorkOrdersub.HBackSupDate = DateTime.Now; //--å®é
äº¤è´§æ¥æ |
| | | WorkOrdersub.HInDate = DateTime.Now; //--äº¤è´§æ¥æ |
| | | WorkOrdersub.HWorkProcFlow = ""; //--å·¥èºæµ |