出库条码明细报表：根据日期降序排序

duhe

2024-11-15 9c52280d2d6ab6266d3a12282ccdcac5e58a8063

 WebAPI/Controllers/XSGL/Xs_CusBalanceReportController.cs

@@ -170,12 +170,12 @@

                if (sWhere == null || sWhere.Equals(""))
                {
                    ds = oCN.RunProcReturn("select * from h_v_Xs_SellOutCompareToProductReport order by 生产单号 desc", "h_v_Xs_SellOutCompareToProductReport");
                    ds = oCN.RunProcReturn("select * from h_v_Xs_SellOutCompareToProductReport order by 日期 desc", "h_v_Xs_SellOutCompareToProductReport");
                }
                else
                {
                    string sql1 = "select * from h_v_Xs_SellOutCompareToProductReport where 1 = 1 ";
                    string sql = sql1 + sWhere + " order by 生产单号 desc";
                    string sql = sql1 + sWhere + " order by 日期 desc";
                    ds = oCN.RunProcReturn(sql, "h_v_Xs_SellOutCompareToProductReport");
                }