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