public Object UpdatePrint([FromBody] Completed_Request OrderNo) { using (SqlConnection con = new SqlConnection(_connectionString)) { Completed_Reuslt result = new Completed_Reuslt(); try { FeedbackBaseService BllBase = new FeedbackBaseService(con); if (BllBase.UpdatePrint(OrderNo.OrderNo)) { result.Result = true; result.ResultMsg = ""; } else { result.Result = false; result.ResultMsg = "系统输入失败"; } return(result); } catch (Exception ex) { result.Result = false; result.ResultMsg = ex.Message; return(result); } } }
public Object Get(string OrderNo, string WorkProcedure, string BatchNo, string Model, string EquipmentNo, string FeedbackMan, string StartTime, string EndTime, string HPrint, string Status) { OrderNo = IsNull(OrderNo); WorkProcedure = IsNull(WorkProcedure); BatchNo = IsNull(BatchNo); Model = IsNull(Model); EquipmentNo = IsNull(EquipmentNo); FeedbackMan = IsNull(FeedbackMan); StartTime = IsNull(StartTime); EndTime = IsNull(EndTime); HPrint = IsNull(HPrint); Status = IsNull(Status); string strWhere = @" where OrderNo like '%{0}%' and WorkProcedure like '%{1}%' and BatchNo like '%{2}%' and Model like '%{3}%' and EquipmentNo like '%{4}%' and FeedbackMan like '%{5}%' "; strWhere = string.Format(strWhere, OrderNo, WorkProcedure, BatchNo, Model, EquipmentNo, FeedbackMan); if (StartTime != "" && StartTime != null & EndTime != "" && EndTime != null) { strWhere += " and FeedbackTime between '" + StartTime + "' and '" + EndTime + " 23:59:59'"; } if (HPrint == "0") { strWhere += " and (HPrint=0 or HPrint is null)"; } else if (HPrint == "1") { strWhere += " and HPrint=1 "; } if (Status == "T1") { //待处理 strWhere += " and Status!='P' "; } else if (Status == "P") { //已完成 strWhere += " and Status='P' "; } else if (Status == "2") { //待审批 strWhere += " and Status!='P'"; } strWhere += " order by FeedbackTime desc"; using (SqlConnection con = new SqlConnection(_connectionString)) { try { BllApprovalStream Bll = new BllApprovalStream(con); FeedbackBaseService BllBase = new FeedbackBaseService(con); FeedbackExReasonService BllReason = new FeedbackExReasonService(con); FeedbackExProblemService BllPro = new FeedbackExProblemService(con); FeedbackExHandleService BllHandle = new FeedbackExHandleService(con); List <FeedbackBase> BaseList = BllBase.GetOrderInfoByWhere(strWhere); List <Completed_Request> RequestList = new List <Completed_Request>(); if (BaseList != null && BaseList.Count > 0) { foreach (var node in BaseList) { Completed_Request Request = new Completed_Request(); //①基础信息 string Request_OrderNo = node.OrderNo; Request.OrderNo = Request_OrderNo; Request.BatchNo = node.BatchNo; Request.WorkProcedure = node.WorkProcedure; Request.Model = node.Model; Request.FeedbackMan = node.FeedbackMan; Request.FeedbackTime = node.FeedbackTime.ToString("yyyy-MM-dd HH:mm"); Request.EquipmentName = node.EquipmentName; Request.EquipmentNo = node.EquipmentNo; Request.Qty = node.Qty; Request.Status = node.Status; //②原因信息 Request.ReasonList = BllReason.GetReasonByWhere(" where OrderNo='" + Request_OrderNo + "'"); //③问题 List <FeedbackExProblem> ProList = BllPro.GetProblemByWhere(" where OrderNo = '" + Request_OrderNo + "'"); Request.ProblemList = GetProblemList(ProList, con); //④处理 FeedbackExHandle feedbackExHandle = BllHandle.GetHandler(" where OrderNo='" + Request_OrderNo + "'").FirstOrDefault(); ExHandle ExHandle = new ExHandle(); if (feedbackExHandle != null) { ExHandle.HandleMan = feedbackExHandle.HandleMan; ExHandle.HandleTime = feedbackExHandle.HandleTime.ToString("yyyy-MM-dd HH:mm"); ExHandle.HandleSuggestion = feedbackExHandle.HandleSuggestion; ExHandle.QualityClass = feedbackExHandle.QualityClass; ExHandle.HandleNote = feedbackExHandle.HandleNote; } Request.Handler = ExHandle; Request.ApStream = Bll.GetStream(" where OrderNo='" + node.OrderNo + "'"); //⑤关联 //循环找出最顶层的批号 string Loop = node.BatchNo; bool flag = true; while (flag) { string strsql = "select ParentNo from ZL_ParentTable where ChildNo='" + Loop + "' "; Parent parent = con.Query <Parent>(strsql).FirstOrDefault(); if (parent != null) { Loop = parent.ParentNo; } else { flag = false; } } //根据最顶层批号进行递归算法,查找相关的批号 string strJson = "{\"ParentNo\":\"" + Loop + "\",\"ChildNo\":[" + GetJson(Loop, con) + "]}"; Request.Relate = strJson; RequestList.Add(Request); } } return(RequestList); } catch (Exception ex) { string ErrMsg = ex.Message; return(""); } finally { if (con.State != ConnectionState.Closed) { con.Close(); } } } }