private string getPrintContentCode(string wFSteptId, string YBBQ) { IPQCFirstCheckHelper ipqc = new IPQCFirstCheckHelper(); DataTable dt = ipqc.GetSteptInfo(wFSteptId); if (dt.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); sb.Append("{\"result\":0,\"msg\":\"获取成功\",\"data\":"); DataRow dr = dt.Rows[0]; IPQCCheckPrintModel model = new IPQCCheckPrintModel(); model.ProductDescribe = Convert.ToString(dr["ProductDescription"]); model.ProductShortName = Convert.ToString(dr["ProductShortName"]); model.POName = Convert.ToString(dr["BillNo"]); model.YBBQ = YBBQ; model.MOName = Convert.ToString(dr["MOName"]); model.SteptName = Convert.ToString(dr["SpecificationName"]); PrintCodeConvert pc = new PrintCodeConvert(); string Msg = pc.GetPrintIPQCCodeConvertStr(model); return("{\"result\":1,\"msg\":\"" + Msg + "\"}"); } else { return("{\"result\":-1,\"msg\":\"获取失败\"}"); } }
/// <summary> /// 获取待完成首检数据 /// </summary> /// <returns></returns> private string getIPQCFirstCheckTodo(string keyWork) { int pageCount, recCount; IPQCFirstCheckHelper ipqc = new IPQCFirstCheckHelper(); StringBuilder sb = new StringBuilder(); result.RetStr = ipqc.GetIPQCFirstCheckTodo(keyWork, "", 20, curPage, out pageCount, out recCount, out outDataSet); if (result.Code == 0) { sb.Append("{\"result\":0,\"msg\":\"获取成功\",\"data\":["); for (int i = 0; i < outDataSet.Tables[0].Rows.Count; i++) { DataRow dr = outDataSet.Tables[0].Rows[i]; int MOQtyRequired = Convert.IsDBNull(dr["MOQtyRequired"]) ? 0 : Convert.ToInt32(dr["MOQtyRequired"]); string json = "{" + String.Format("\"SpecificationName\":\"{0}\",\"WFSteptId\":\"{1}\",\"BillNo\":\"{2}\"," + "\"MOName\":\"{3}\",\"ProductId\":\"{4}\",\"MOQtyRequired\":\"{5}\",\"ProductDescription\":\"{6}\",\"ProductShortName\":\"{7}\",\"CustomerName\":\"{8}\",\"IsDone\":\"{9}\",\"SOEntry\":\"{10}\"", dr["SpecificationName"], dr["MFPlansEntryId"], dr["BillNo"], dr["MOName"], dr["ProductId"], MOQtyRequired.ToString(), dr["ProductDescription"], dr["ProductShortName"], dr["CustomerName"], Convert.ToString(dr["IsDone"]), dr["SOEntry"]) + "}"; sb.Append(json); if (i != outDataSet.Tables[0].Rows.Count - 1) { sb.Append(","); } } sb.Append("]}"); } return(sb.ToString()); }
/// <summary> /// 打印样本标签 /// </summary> /// <param name="wFSteptId"></param> /// <returns></returns> private string printLabel(string MFPlansId) { IPQCFirstCheckHelper ipqc = new IPQCFirstCheckHelper(); string msg = ""; if (ipqc.PrintLabel(MFPlansId, out msg)) { return("{\"result\":1,\"msg\":\"" + msg + "\"}"); } else { return("{\"result\":-1,\"msg\":\"打印样本标签失败:" + msg + "\"}"); } }
/// <summary> /// 保存临时数据 /// </summary> /// <param name="wFSteptId"></param> /// <returns></returns> private string checkResultTempSubmit(string MFPlansId) { IPQCFirstCheckHelper ipqc = new IPQCFirstCheckHelper(); string XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["IPQCData"])).ToString(); IPQCFirstCheckModel model = new IPQCFirstCheckModel(); model.Describe = Describe; model.MFPlansId = MFPlansId; model.XMLData = XMLData; string msg = ""; if (ipqc.SaveTempData(model, out msg)) { return("{\"result\":1,\"msg\":\"" + msg + "\"}"); } else { return("{\"result\":-1,\"msg\":\"保存数据失败:" + msg + "\"}"); } }
/// <summary> /// 提交数据 /// </summary> /// <param name="wFSteptId"></param> /// <returns></returns> private string checkResultSubmit(string MFPlansId) { IPQCFirstCheckHelper ipqc = new IPQCFirstCheckHelper(); string XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["IPQCData"])).ToString(); string Describe = Convert.ToString(Request.Form["Describe"]); string QCResult = Convert.ToString(Request.Form["QCResult"]); IPQCFirstCheckModel model = new IPQCFirstCheckModel(); model.Describe = Describe; model.QCResult = int.Parse(QCResult); model.MFPlansId = MFPlansId; model.XMLData = XMLData; string msg = ""; if (ipqc.CheckResultSubmit(model, out msg)) { return("{\"result\":0,\"msg\":\"" + msg + "\"}"); } else { return("{\"result\":-1,\"msg\":\"数据提交失败:" + msg + "\"}"); } }
/// <summary> /// 根据工序ID获取信息 /// </summary> /// <param name="wFSteptId"></param> /// <returns></returns> private string getStepInfo(string wFSteptId, string ScanLotSN) { if (!string.IsNullOrEmpty(ScanLotSN)) { if (wFSteptId != ScanLotSN) { return("{\"result\":-1,\"msg\":\"扫描信息与" + wFSteptId + "不匹配\"}"); } } IPQCFirstCheckHelper ipqc = new IPQCFirstCheckHelper(); DataTable dt = ipqc.GetSteptInfo(wFSteptId); if (dt.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); sb.Append("{\"result\":0,\"msg\":\"获取成功\",\"data\":"); DataRow dr = dt.Rows[0]; string XMLData = Convert.ToString(dr["XMLData"]); if (!string.IsNullOrEmpty(XMLData)) { string jsonData = CommHelper.XMLToJson(XMLData); JObject o = JObject.Parse(jsonData); JToken Token = o["IQCdata"]; Token["Describe"].Parent.AddAfterSelf(new JProperty("SpecificationName", Convert.ToString(dr["SpecificationName"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("WFSteptId", Convert.ToString(dr["WFSteptId"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("BillNo", Convert.ToString(dr["BillNo"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("MOName", Convert.ToString(dr["MOName"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductId", Convert.ToString(dr["ProductId"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductShortName", Convert.ToString(dr["ProductShortName"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductName", Convert.ToString(dr["ProductName"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductDescription", Convert.ToString(dr["ProductDescription"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("QCResult", Convert.ToString(dr["QCResult"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("CustomerName", Convert.ToString(dr["CustomerName"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("IsDone", Convert.ToString(dr["IsDone"]))); Token["Describe"].Parent.AddAfterSelf(new JProperty("MOQtyRequired", Convert.ToString(dr["MOQtyRequired"]))); sb.Append(CommHelper.JsonTOStr(Token)); sb.Append("}"); return(sb.ToString()); } else { string json = "{" + String.Format("\"SpecificationName\":\"{0}\",\"WFSteptId\":\"{1}\",\"BillNo\":\"{2}\"," + "\"MOName\":\"{3}\",\"ProductId\":\"{4}\",\"QCResult\":\"{5}\",\"ProductDescription\":\"{6}\",\"ProductName\":\"{7}\",\"CustomerName\":\"{8}\",\"IsDone\":\"{9}\",\"MOQtyRequired\":\"{10}\",\"ProductShortName\":\"{11}\"", dr["SpecificationName"], dr["MFPlansEntryId"], dr["BillNo"], dr["MOName"], dr["ProductId"], dr["QCResult"], dr["ProductDescription"], dr["ProductName"], dr["CustomerName"], Convert.ToString(dr["IsDone"]), Convert.ToString(dr["MOQtyRequired"]), dr["ProductShortName"]) + "}"; sb.Append(json); sb.Append("}"); return(sb.ToString()); } } else { return("{\"result\":-1,\"msg\":\"扫描信息不存在\"}"); } }