| | |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | string sql = "select top(1) " + |
|---|
| | | "a.HICMOInterID,a.HICMOEntryID,a.HICMOBillNo,a.HInterID HProcExchInterID,a.HMaterID,m1.HName HMaterName,a.HMaterModel HModel,a.HMaterModel2 HModel2,a.HCusID,c1.HName HCusName,a.HWeight" + |
|---|
| | | "a.HICMOInterID,a.HICMOEntryID,a.HICMOBillNo,a.HInterID HProcExchInterID,a.HMaterID,m1.HName HMaterName,a.HMaterModel HModel,a.HMaterModel2 HModel2,a.HCusID,c1.HName HCusName,a.HWeight,a.HQty" + |
|---|
| | | " from Sc_ProcessExchangeBillMain AS a " + |
|---|
| | | " LEFT OUTER JOIN Gy_Material AS m1 on a.HMaterID = m1.HItemID " + |
|---|
| | | " LEFT OUTER JOIN Gy_Customer AS c1 on a.HCusID = c1.HItemID " + |
|---|
