1

duhe

2024-06-05 c423a61ae9ee84f71a75ac793dac083fbd590eb1

 WebAPI/Controllers/MJGL/Sc_MouldUpperBillController.cs

@@ -198,6 +198,9 @@
                     + HInterID + ",'"+ HBillNo + "'," + i + "," + oSub.HMouldID.ToString() + ",'" + oSub.HQty 
                     + "'," + oSub.HSourceID.ToString() + "," + oSub.HICMOInterID.ToString() + "," + oSub.HICMOEntryID.ToString()+",'"+ oSub.HICMOBillNo.ToString() +
                     "') ");

                //反写模具状态
                oCN.RunProc("update Gy_MouldFileMain set HMouldStatus='领出' where HInterID= " + oSub.HMouldID.ToString());
            }

            objJsonResult.code = "1";
@@ -877,6 +880,9 @@
                     + HInterID + ",'" + HBillNo + "'," + i + "," + oSub.HMouldID.ToString() + ",'" + oSub.HQty
                     + "'," + oSub.HSourceID.ToString() + "," + oSub.HICMOInterID.ToString() + "," + oSub.HICMOEntryID.ToString() + ",'" + oSub.HICMOBillNo.ToString() +
                     "') ");

                //反写模具状态
                oCN.RunProc("update Gy_MouldFileMain set HMouldStatus='在库' where HInterID= " + oSub.HMouldID.ToString());
            }

            objJsonResult.code = "1";
@@ -1375,6 +1381,41 @@
        }
        #endregion

        #region 下模单查询上模单信息 列表查询
        [Route("Sc_MouldLowerBill/Sc_MouldUpperBillList")]
        [HttpGet]
        public object Sc_MouldUpperBillList(string sWhere)
        {
            try
            {

                ds = oCN.RunProcReturn("select * from  h_v_Qj_Sc_MouldUpperBillList where 1=1" + sWhere, "h_v_Qj_Sc_MouldUpperBillList");

                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "查无数据！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "Sucess！";
                objJsonResult.data = ds.Tables[0];
                return objJsonResult;
            }
            catch (Exception e)
            {
                objJsonResult.code = "0";
                objJsonResult.count = 0;
                objJsonResult.Message = "Exception！" + e.ToString();
                objJsonResult.data = null;
                return objJsonResult;
            }
        }
        #endregion

        #region 上/下模单获取条码信息
        [Route("Sc_MouldUpperBill/txtHBarCode_KeyDown")]
@@ -1392,73 +1433,7 @@
                    return objJsonResult;
                }

                //拆分条形码
                string sBillBarCode = HBarCode.Trim();

              
                //截取条码类型 前两位
                string BillNoType2 = sBillBarCode.Substring(0, Math.Min(2, sBillBarCode.Length));
                //截取条码类型 前五位
                string BillNoType3 = sBillBarCode.Substring(0, Math.Min(5, sBillBarCode.Length));
                //截取条码类型3 前四位
                string BillNoType4 = sBillBarCode.Substring(0, Math.Min(4, sBillBarCode.Length));
                //截取条码类型 前八位
                string BillNoType5 = sBillBarCode.Substring(0, Math.Min(8, sBillBarCode.Length));


                switch (BillNoType2)
                {
                    //生产资源
                    case "BM":
                    case "SS":
                        ds = oCN.RunProcReturn("select HItemID,HName,HNumber from Gy_Source where HNumber = '" + HBarCode + "'", "Gy_Source");
                        break;
                    case "MO":
                        ds = oCN.RunProcReturn("select 单据号,hmainid,HEntryID from h_v_IF_ICMOBillList where 单据号 = '" + HBarCode + "'", "h_v_IF_ICMOBillList");
                        break;
                    default:
                        break;
                }


                switch (BillNoType3)
                {
                    //器具档案
                    case "MJD":
                    case "PAK":
                    case "https":
                        HBarCode = HBarCode.Substring(23, HBarCode.Length-23);
                        ds = oCN.RunProcReturn("select * from h_v_Gy_MouldFileList where 条码编号 = '" + HBarCode + "'", "h_v_Gy_MouldFileList");
                        break;
                    default:
                        break;
                }

                switch (BillNoType4)
                {
                    //流转卡
                    case "GXLX":
                        ds = oCN.RunProcReturn("select 任务单号,hicmointerid,HICMOEntryID,单据号,hmainid,HEntryID from h_v_Sc_ProcessExchangeBillQuerySub where 单据号 = '" + HBarCode + "'", "h_v_Sc_ProcessExchangeBillQuerySub");
                        break;
                    //生产订单
                    case "9010":
                        ds = oCN.RunProcReturn("select 单据号,hmainid,HEntryID from h_v_IF_ICMOBillList where 单据号 = '" + HBarCode + "'", "h_v_IF_ICMOBillList");
                        break;
                    default:
                        break;
                }

                DateTime date;
                bool flag = false;
                if (BillNoType5.Length == 8) {
                    BillNoType5 = BillNoType5.Substring(0, 4) + "-" + BillNoType5.Substring(4, 2) + "-" + BillNoType5.Substring(6, 2);
                }
                flag = DateTime.TryParse(BillNoType5, out date);
              

                if (flag) {
                    ds = oCN.RunProcReturn("select 任务单号,hicmointerid,HICMOEntryID,单据号,hmainid,HEntryID from h_v_Sc_ProcessExchangeBillQuerySub where 单据号 = '" + HBarCode + "'", "h_v_Sc_ProcessExchangeBillQuerySub");
                }
                ds = oCN.RunProcReturn("exec h_p_Sc_AllowLoadData '" + HBarCode + "'", "h_p_Sc_AllowLoadData");

                if (ds == null || ds .Tables.Count== 0 || ds.Tables[0].Rows.Count == 0)
                {