报工台点击异常跳转获取,物料,代码,数量,规格型号,登录人的上级,不良采集增加批量保存方法

zrg

2024-07-01 9f5f3f3309827ce6ad816482d1a60b8cea29761e

 WebAPI/Controllers/Éú²ú¹ÜÀí/ÖÊÁ¿»ã±¨µ¥/Sc_QualityReportBillController.cs

@@ -744,6 +744,104 @@
        }
        #endregion

        #region ä¸è‰¯é‡‡é›†æ‰¹é‡æ±‡æŠ¥ æ–°å¢ž
        [Route("Sc_QualityReportBill/SaveSc_QualityReportBillSub")]
        [HttpPost]
        public object SaveSc_QualityReportBillSub([FromBody] JObject msg)
        {
            var _value = msg["msg"].ToString();
            string msg1 = _value.ToString();
            string[] sArray = msg1.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
            string msg2 = sArray[0].ToString();                             //表头数据
            string msg3 = sArray[1].ToString();                             //子表1数据
            string refSav = sArray[2].ToString();                           //操作方式
            string msg4 = sArray[3].ToString();                             //用户

            DBUtility.ClsPub.CurUserName = msg4;                  
            ListModels oListModels = new ListModels();
            try
            {               
                DAL.ClsSc_QualityReportBill oBill = new DAL.ClsSc_QualityReportBill();           
                //表体数据
                //按 },{来拆分数组 //去掉【和】
                msg3 = msg3.Substring(1, msg3.Length - 2);
                msg3 = msg3.Replace("\\", "");
                msg3 = msg3.Replace("\n", "");  //\n

                List<Model.ClsSc_QualityReportBillSub> ls = new List<Model.ClsSc_QualityReportBillSub>();
                ls = oListModels.getObjectByJson_Sc_QualityReportBillSub(msg3);
                int i = 0;
                foreach (Model.ClsSc_QualityReportBillSub oSub in ls)
                {
                  
                   
                    oSub.HMakeDate = DateTime.Now;
                    int qty = Convert.ToInt32(oSub.HQty);
                    for (int j = 0; j < qty; j++)
                    {
                        i++;
                        oSub.HEntryID = i;
                        string subSql = "Insert into Sc_QualityReportBillSub " +
                     " (HInterID,HEntryID,HBillNo_bak,HRemark" +
                     ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                     ",HMaterID,HUnitID,HQty,HResult,HEmpID,HSourceID,HBadReasonID" +
                     ",HICMOInterID,HICMOEntryID,HICMOBillNo,HProcExchInterID,HProcExchEntryID,HProcExchBillNo" +
                     ",HBarCode,HReportType" +
                     ",HAddr,HMaker,HMakeDate" +
                     ") values(" +
                     "" + oSub.HInterID.ToString() + "" +
                     "," + oSub.HEntryID.ToString() + "" +
                     ",'" + oSub.HBillNo_bak + "'" +
                     ",'" + oSub.HRemark + "'" +
                     "," + oSub.HSourceInterID.ToString() + "" +
                     "," + oSub.HSourceEntryID.ToString() + "" +
                     ",'" + oSub.HSourceBillNo + "'" +
                     ",'" + oSub.HSourceBillType + "'" +
                     "," + oSub.HRelationQty.ToString() + "" +
                     "," + oSub.HRelationMoney.ToString() +

                     "," + oSub.HMaterID.ToString() + "" +
                     "," + oSub.HUnitID.ToString() + "" +
                     ",'" + 1 +
                     "','" + oSub.HResult + "'" +
                     "," + oSub.HEmpID.ToString() + "" +
                     "," + oSub.HSourceID.ToString() + "" +
                     "," + oSub.HBadReasonID.ToString() + "" +

                     "," + oSub.HICMOInterID.ToString() + "" +
                     "," + oSub.HICMOEntryID.ToString() + "" +
                     ",'" + oSub.HICMOBillNo + "'" +
                     "," + oSub.HProcExchInterID + "" +
                     "," + oSub.HProcExchEntryID + "" +
                     ",'" + oSub.HProcExchBillNo + "'" +
                     ",'" + oSub.HBarCode + "'" +

                     ",'" + 3 +
                     "','" + oSub.HAddr + "'" +
                     ",'" + msg4 + "'" +
                     ",'" + oSub.HMakeDate.ToShortDateString() + "'" +
                     ") ";
                        oCN.RunProc(subSql);
                    }

                }
                objJsonResult.code = "0";
                objJsonResult.count = 1;
                objJsonResult.Message = "保存成功！";
                objJsonResult.data = 1;
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "保存失败！" + e.ToString();
                objJsonResult.data = 1;
                return objJsonResult;
            }
        }
        #endregion