多人刷卡开工 保存子表

yangle

2024-11-29 f76084c29964fb0bd45c7fd8da2d1837ae995608

 WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs

@@ -226,12 +226,34 @@
                            }
                        }
                        break;
                    case "P202"://流转卡
                    case "P203"://流转卡
                    case "P204"://流转卡
                    case "P205"://流转卡
                    case "P201"://流转卡
                        ds = oCN.RunProcReturn("select top 1 * from h_v_Sc_ProcessExchangeBillList  where 单据号= '" + BillNo_PGD + "'", "h_v_Sc_ProcessExchangeBillList");
                        break;
                }
                switch (BillNoType)
                //得到信息
                {
                    case "HCX"://生产资源码
                        ds = oCN.RunProcReturn("select * from h_v_Gy_SourceList  where 条码编号 = '" + BillNo + "'", "h_v_Gy_SourceList");
                    case "htt"://生产资源码

                        string sErr = "";
                        if (oSystemParameter.ShowBill(ref sErr))
                        {
                            if (oSystemParameter.omodel.WMS_CampanyName == "杭州斯莫尔")
                            {
                                ds = oCN.RunProcReturn(@"select  s.HItemID,s.HName 生产资源名称,s.HNumber  from Gy_EquipFileBillMain a
                                        left join Gy_Source s on a.HSourceID = s.HItemID
                                        where HBarCode = '" + BillNo_PGD + "'", "Gy_EquipFileBillMain");
                            }
                            else {
                                ds = oCN.RunProcReturn("select * from h_v_Gy_SourceList  where 条码编号 = '" + BillNo + "'", "h_v_Gy_SourceList");
                            }
                        }
                     
                        break;
                    case "SBM"://设备码
                        ds = oCN.RunProcReturn("select * from h_v_Gy_EquipMentList  where HItemID = '" + BillNo + "'", "h_v_Gy_EquipMentList");
@@ -332,6 +354,51 @@
        }
        #endregion

        #region 工序出站汇报单PDA扫操作员
        [Route("Cj_StationBill/txtHBarCode_KeyDown_Operator")]
        [HttpGet]
        public object txtHBarCode_KeyDown_Operator(string HBarCode, string HInterID, string UserID, string HBillType)
        {
            try
            {
                if (HBarCode == null || HBarCode.Equals(""))
                {
                    objJsonResult.code = "0";
                    objJsonResult.count = 0;
                    objJsonResult.Message = "空白码,条形码不能为空！";
                    objJsonResult.data = null;
                    return objJsonResult;
                }

                ds = oCN.RunProcReturn("select * from h_v_Gy_EmployeeList_New  where 职员代码 = '" + HBarCode + "'", "h_v_Gy_EmployeeList_New");

                //写入信息
                if (ds == null || 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("Cj_StationBill/txtHBarCode_Mater_KeyDown")]
        [HttpGet]