| | |
|---|
| | | Where a.HInterID={HProcExchInterID} and b.HEntryID={HProcExchEntryID} |
|---|
| | | ) a |
|---|
| | | inner join ( |
|---|
| | | select a.HICMOInterID,a.HICMOEntryID, b.HProcID |
|---|
| | | select a.HICMOInterID,a.HICMOEntryID,isnull(c.HItemID,0) HProcID |
|---|
| | | from Sc_PPBomBillMain a with(nolock) |
|---|
| | | inner join Sc_PPBomBillSub b with(nolock) on a.HInterID=b.HInterID |
|---|
| | | Where b.HKeyMaterID_Line<>0 |
|---|
| | | left join Gy_Process c on b.HProcName = c.HName |
|---|
| | | )b on a.HICMOInterID=b.HICMOInterID and a.HICMOEntryID=b.HICMOEntryID and a.HProcID=b.HProcID", "Sc_ProcessExchangeBillMain"); |
|---|
| | | |
|---|
| | | if (ds.Tables[0].Rows.Count > 0) { |
|---|
