产线器具对应清单

yusijie

2025-02-12 4d1df5bededf90dfa91350e5258cee1e6b5ba010

 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");
                }