生产计划平台-查询

yangle

2022-05-18 6d033fd71b507e99a1deb935847f7a0e400f13df

 WebAPI/Controllers/生产管理/生产任务单/Sc_ICMOBillController.cs

@@ -90,7 +90,7 @@
                                            left join Gy_Customer c on a.HCusID=c.HItemID
                                            left join Gy_Employee e on a.HEmpID=e.HItemID
                                            left join Gy_Department d on a.HDeptID=d.HItemID
                                            where b.HSeOrderInterID=(select HSeOrderInterID from Sc_PPBomBillMain where HBillNo='" + HBillNo + "')");
                                            where b.HDEPTID='113546' and  b.HSeOrderInterID=(select HSeOrderInterID from Sc_PPBomBillMain where HBillNo='" + HBillNo + "')");
               
                ds = oCN.RunProcReturn(sql, "Sc_ICMOBillMain");
                if (ds.Tables[0].Rows.Count != 0 || ds != null)