查询列表子表按subid排序

wtt

2024-11-26 fd8f4776bf512f7e3068a5868c3b5af0bd974647

查询列表子表按subid排序

 WebAPI/Controllers/CGGL/Cg_POInStockBillController.cs

@@ -2689,7 +2689,7 @@
                }
                string sql = "select * from h_v_Cg_POInStockBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Cg_POInStockBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Cg_POInStockBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/CGGL/Cg_POOrderBillController.cs

@@ -3117,7 +3117,7 @@
                }
                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)

 WebAPI/Controllers/CGGL/Cg_PayableBillController.cs

@@ -1684,7 +1684,7 @@
                //}
                string sql = "select * from h_v_Cg_PayableBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Cg_PayableBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Cg_PayableBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/CGGL/Kf_POStockInBillController.cs

@@ -2030,7 +2030,7 @@
                }
                string sql = "select * from h_v_Kf_POStockInBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Kf_POStockInBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Kf_POStockInBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/CGGL/YF_PayMentBillController.cs

@@ -1164,7 +1164,7 @@
                
                string sql = "select * from h_v_YF_PayMentBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_YF_PayMentBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_YF_PayMentBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/XSGL/Kf_SellOutBillController.cs

@@ -1971,7 +1971,7 @@
                }
                string sql = "select * from h_v_Kf_SellOutBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Kf_SellOutBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Kf_SellOutBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/XSGL/Xs_ReceivableBillController.cs

@@ -1700,7 +1700,7 @@
                }
                string sql = "select * from h_v_Xs_ReceivableBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Xs_ReceivableBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Xs_ReceivableBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs

@@ -3547,7 +3547,7 @@
                }
                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)

 WebAPI/Controllers/XSGL/Xs_SeOutStockBillController.cs

@@ -2232,7 +2232,7 @@
                }
                string sql = "select * from h_v_Xs_SeOutStockBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_Xs_SeOutStockBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_Xs_SeOutStockBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)

 WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs

@@ -1793,7 +1793,7 @@
                }
                string sql = "select * from h_v_YS_ReceiveBillQuerySub where hmainid =  " + hmainid;

                ds = oCN.RunProcReturn(sql + " order by hsubid desc", "h_v_YS_ReceiveBillQuerySub");
                ds = oCN.RunProcReturn(sql + " order by hsubid ASC", "h_v_YS_ReceiveBillQuerySub");


                foreach (DataColumn col in ds.Tables[0].Columns)