| | |
|---|
| | | using System.Data; |
|---|
| | | using System.Data.SqlClient; |
|---|
| | | using System.Web.Http; |
|---|
| | | using ViewAPI; |
|---|
| | | using WebAPI.Models; |
|---|
| | | |
|---|
| | | namespace WebAPI.Controllers |
|---|
| | |
|---|
| | | ds = oCN.RunProcReturn |
|---|
| | | ("select a.HInterID,a.HBillType,a.HICMOBillNo,a.HICMOInterID,a.HMaterID" + |
|---|
| | | ",m.HNumber HMaterNumber,m.HName HMaterName,m.HModel HMaterModel,a.HICMOEntryID " + |
|---|
| | | ",a.HProcID,p.HNumber HProcNo,p.HName HProcName,a.HSourceID,s.HNumber HSourceNumber,s.HName HSourceName " + |
|---|
| | | " from Sc_ICMOBillStatus_Tmp a " + |
|---|
| | | " left join Gy_Material m on a.HMaterID=m.HItemID " + |
|---|
| | | " left join Gy_Process p on a.HProcID=p.HItemID " + |
|---|
| | | " left join Gy_Source s on a.HSourceID=s.HItemID " + |
|---|
| | | " Where a.HInterID=" + HInterID + " and a.HBillType="+ HBillType, "Sc_ICMOBillStatus_Tmp"); |
|---|
| | | } |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
|---|
