| | |
|---|
| | | try |
|---|
| | | { |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POOrderBillList where hmainid =" + HInterID, "h_v_IF_POOrderBillList"); |
|---|
| | | ds = oCN.RunProcReturn("select * from h_v_IF_POOrderBillEdit where hmainid =" + HInterID, "h_v_IF_POOrderBillList"); |
|---|
| | | if (ds == null || ds.Tables[0].Rows.Count == 0) |
|---|
| | | { |
|---|
| | | objJsonResult.code = "0"; |
|---|
| | |
|---|
| | | } |
|---|
| | | string sql = "select * from h_v_Cg_POOrderBillQuerySub where hmainid = "+ hmainid; |
|---|
| | | |
|---|
| | | ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Cg_POOrderBillQuerySub"); |
|---|
| | | ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Cg_POOrderBillQuerySub"); |
|---|
| | | |
|---|
| | | |
|---|
| | | foreach (DataColumn col in ds.Tables[0].Columns) |
|---|
