检验方案 表头增加字段 生产资源HSoucID

zrg

2025-02-17 4848a8724265619a07ff6ef5370988556dba2efc

 WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs

@@ -238,7 +238,22 @@
                //得到信息
                {
                    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");