| | |
|---|
| | | { |
|---|
| | | SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); |
|---|
| | | |
|---|
| | | string sql = "select a.HItemID HMaterID,a.HNumber HMaterNumber,a.HName HMaterName,a.HMaterRuleType,a.HModel HMaterModel,a.HUnitID, b.HNumber HUnitNumber, b.HName HUnitName,a.HWHID,w.HName 默认仓库" + |
|---|
| | | string sql = "select a.HItemID HMaterID,a.HNumber HMaterNumber,a.HName HMaterName,a.HMaterRuleType,a.HModel HMaterModel,a.HUnitID, b.HNumber HUnitNumber, b.HName HUnitName,a.HWHID,w.HName 默认仓库,a.HPOUnitID,u.HName HPOUnitName " + |
|---|
| | | " from Gy_Material AS a " + |
|---|
| | | " LEFT OUTER JOIN Gy_Unit AS b on a.HUnitID = b.HItemID " + |
|---|
| | | " left outer join Gy_Warehouse as w on a.HWHID = w.HItemID " + |
|---|
| | | " left outer join Gy_Unit As u on a.HPOUnitID = u.HItemID" + |
|---|
| | | " where a.HItemID =" + HMaterID; |
|---|
| | | |
|---|
| | | var dataSet = oCN.RunProcReturn(sql, "Gy_Material"); |
|---|
