| | |
|---|
| | | } |
|---|
| | | else |
|---|
| | | { |
|---|
| | | bResult = BillNew.ModifyByID(DBUtility.ClsPub.isLong(mainList[0].HItemID)); |
|---|
| | | bResult = BillNew.ModifyByID(DBUtility.ClsPub.isLong(subList[0].HItemID)); |
|---|
| | | } |
|---|
| | | //提示 |
|---|
| | | if (bResult == true) |
|---|
| | |
|---|
| | | // " left join Gy_Material c on a.HMaterID = c.HItemID " + |
|---|
| | | // " left join Gy_Unit d on a.HUnitID = d.HItemID where a.HItemID = " + HItemID, "Gy_MateMouldInfo"); |
|---|
| | | ds = oCN.RunProcReturn("select " + |
|---|
| | | "a.HItemID,a.模具产品对应表代码,a.HUnitID,b.HName 模具名称" + |
|---|
| | | ",b.HNumber 模具代码,a.HMaterID HMaterIDCol,c.HNumber 物料代码,c.HName 物料名称,c.HModel 规格型号" + |
|---|
| | | "a.HItemID,a.模具产品对应表代码,a.HUnitID,b.hitemid HMouldIDCol,b.HNumber 模具代码" + |
|---|
| | | ",b.HName 模具名称,a.HMaterID HMaterIDCol,c.HNumber 物料代码,c.HName 物料名称,c.HModel 规格型号" + |
|---|
| | | ",a.HRelationID HRelationIDCol,d.HNumber 单位代码,d.HName 单位名称" + |
|---|
| | | ",a.HUnitID HUnitIDCol" + |
|---|
| | | ",a.开始日期,a.结束日期" + |
|---|
