예제 #1
0
        private string getPrintContentCode(string OQCCheckId, string YBBQ)
        {
            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];

                PrintCodeConvert pc  = new PrintCodeConvert();
                string           Msg = pc.GetPrintOQCPackCodeConvertStr(
                    Convert.ToString(dr["BillNo"]),
                    Convert.ToString(dr["CustomerName"]),
                    Convert.ToString(dr["ProductShortName"]),
                    Convert.ToString(dr["ProductDescription"]),
                    Convert.ToString(dr["YBBQ"]),
                    Convert.ToInt32(dr["Qty"])
                    );
                return("{\"result\":1,\"msg\":\"" + Msg + "\"}");
            }
            else
            {
                return("{\"result\":-1,\"msg\":\"获取失败\"}");
            }
        }
예제 #2
0
        /// <summary>
        /// 获取待完成首检数据
        /// </summary>
        /// <returns></returns>
        private string getOQCCheckTodo(string keyWork)
        {
            int            pageCount, recCount;
            OQCCheckHelper ipqc = new OQCCheckHelper();
            StringBuilder  sb   = new StringBuilder();

            result.RetStr = ipqc.GetOQCCheckTodo(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];
                    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);
                    if (i != outDataSet.Tables[0].Rows.Count - 1)
                    {
                        sb.Append(",");
                    }
                }
                sb.Append("]}");
            }
            return(sb.ToString());
        }
예제 #3
0
        /// <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\":\"扫描信息不存在\"}");
            }
        }
예제 #4
0
        /// <summary>
        /// 打印样本标签
        /// </summary>
        /// <param name="OQCCheckId"></param>
        /// <returns></returns>
        private string printLabel(string SEOutStockEntryId)
        {
            OQCCheckHelper oqc = new OQCCheckHelper();
            string         msg = "";

            if (oqc.PrintLabel(SEOutStockEntryId, out msg))
            {
                return("{\"result\":1,\"msg\":\"" + msg + "\"}");
            }
            else
            {
                return("{\"result\":-1,\"msg\":\"打印样本标签失败:" + msg + "\"}");
            }
        }
예제 #5
0
        /// <summary>
        /// 保存临时数据
        /// </summary>
        /// <param name="OQCCheckId"></param>
        /// <returns></returns>
        private string checkResultTempSubmit(string OQCCheckId)
        {
            OQCCheckHelper ipqc    = new OQCCheckHelper();
            string         XMLData = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["OQCData"])).ToString();
            OQCCheckModel  model   = new OQCCheckModel();

            model.Describe   = Describe;
            model.OQCCheckId = OQCCheckId;
            model.XMLData    = XMLData;

            string msg = "";

            if (ipqc.SaveTempData(model, out msg))
            {
                return("{\"result\":1,\"msg\":\"" + msg + "\"}");
            }
            else
            {
                return("{\"result\":-1,\"msg\":\"保存数据失败:" + msg + "\"}");
            }
        }
예제 #6
0
        /// <summary>
        /// 提交数据
        /// </summary>
        /// <param name="OQCCheckId"></param>
        /// <returns></returns>
        private string checkResultSubmit(string OQCCheckId)
        {
            OQCCheckHelper ipqc     = new OQCCheckHelper();
            string         XMLData  = CommHelper.ConvertXmlToString(Convert.ToString(Request.Form["OQCData"])).ToString();
            string         Describe = Convert.ToString(Request.Form["Describe"]);
            string         QCResult = Convert.ToString(Request.Form["QCResult"]);
            OQCCheckModel  model    = new OQCCheckModel();

            model.Describe   = Describe;
            model.QCResult   = int.Parse(QCResult);
            model.OQCCheckId = OQCCheckId;
            model.XMLData    = XMLData;
            string msg = "";

            if (ipqc.CheckResultSubmit(model, out msg))
            {
                return("{\"result\":0,\"msg\":\"" + msg + "\"}");
            }
            else
            {
                return("{\"result\":-1,\"msg\":\"数据提交失败:" + msg + "\"}");
            }
        }