private string getCheckData(string FQCCheckId)
{
FQCCheckHelper ipqc = new FQCCheckHelper();
StringBuilder sb = new StringBuilder();
if (string.IsNullOrEmpty(FQCCheckId))
{
return("{\"result\":-1,\"msg\":\"扫描信息不存在\"}");
}
DataTable dt = ipqc.getFQCCheckDataByFQCCheckId(FQCCheckId);
if (dt.Rows.Count > 0)
{
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["FQCdata"];
Token["Describe"].Parent.AddAfterSelf(new JProperty("CheckType", Convert.ToString(dr["CheckType"])));
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("\"ProductName\":\"{0}\",\"SpecimentId\":\"{1}\",\"BillNo\":\"{2}\","
+ "\"MOName\":\"{3}\",\"ProductId\":\"{4}\",\"MOQtyRequired\":\"{5}\",\"ProductDescription\":\"{6}\",\"ProductShortName\":\"{7}\",\"CustomerName\":\"{8}\",\"FQCQCResult\":\"{9}\",\"FQCCheckId\":\"{10}\"",
dr["ProductName"], dr["SpecimentId"], dr["BillNo"], dr["MOName"],
dr["ProductId"], dr["MOQtyRequired"], dr["ProductDescription"], dr["ProductShortName"], dr["CustomerName"], Convert.ToString(dr["FQCQCResult"]), dr["FQCCheckId"]) + "}";
sb.Append(json);
sb.Append("}");
return(sb.ToString());
}
}
else
{
return("{\"result\":-1,\"msg\":\"扫描信息不存在\"}");
}
}
/// <summary>
/// 根据工序ID获取信息
/// </summary>
/// <param name="OQCCheckId"></param>
/// <returns></returns>
private string getCheckInfo(string OQCCheckId)
{
//if (!string.IsNullOrEmpty(ScanLotSN))
// if (OQCCheckId != ScanLotSN) return "{\"result\":-1,\"msg\":\"扫描信息与" + OQCCheckId + "不匹配\"}";
//根据用户去
OQCCheckHelper ipqc = new OQCCheckHelper();
DataTable dt = ipqc.GetCheckInfo(OQCCheckId);
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("FBillNo", Convert.ToString(dr["FBillNo"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductId", Convert.ToString(dr["ProductId"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("Qty", Convert.ToString(dr["Qty"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("OQCReportId", Convert.ToString(dr["OQCReportId"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("SourceBillNo", Convert.ToString(dr["SourceBillNo"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductDescription", Convert.ToString(dr["ProductDescription"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("ProductShortName", Convert.ToString(dr["ProductShortName"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("CustomerName", Convert.ToString(dr["CustomerName"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("OQCCheckId", Convert.ToString(dr["OQCCheckId"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("QCResult", Convert.ToString(dr["QCResult"])));
Token["Describe"].Parent.AddAfterSelf(new JProperty("SEOutStockEntryId", Convert.ToString(dr["SEOutStockEntryId"])));
sb.Append(CommHelper.JsonTOStr(Token));
sb.Append("}");
return(sb.ToString());
}
else
{
string json = "{" + String.Format("\"FBillNo\":\"{0}\",\"ProductId\":\"{1}\",\"Qty\":\"{2}\","
+ "\"SourceBillNo\":\"{3}\",\"ProductDescription\":\"{4}\",\"ProductShortName\":\"{5}\",\"CustomerName\":\"{6}\",\"OQCCheckId\":\"{7}\",\"QCResult\":\"{8}\",\"SEOutStockEntryId\":\"{9}\"",
dr["FBillNo"], dr["ProductId"], dr["Qty"], dr["SourceBillNo"],
dr["ProductDescription"], dr["ProductShortName"], dr["CustomerName"], dr["OQCCheckId"], dr["QCResult"], dr["SEOutStockEntryId"]) + "}";
sb.Append(json);
sb.Append("}");
return(sb.ToString());
}
}
else
{
return("{\"result\":-1,\"msg\":\"扫描信息不存在\"}");
}
}
/// <summary>
/// 根据工序ID获取信息
/// </summary>
/// <param name="wFSteptId"></param>
/// <returns></returns>
private string getStepInfo(string MFPlansId, string ScanLotSN)
{
if (!string.IsNullOrEmpty(ScanLotSN))
{
if (MFPlansId != ScanLotSN)
{
return("{\"result\":-1,\"msg\":\"扫描信息与" + MFPlansId + "不匹配\"}");
}
}
IPQCRouteCheckHelper ipqc = new IPQCRouteCheckHelper();
DataTable dt = ipqc.GetSteptInfo(MFPlansId);
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\":\"扫描信息不存在\"}");
}
}