blame | 历史 | 补丁 | 提交 | 提交对比 | show whitespace
jinghz@oceic.com
2023-08-24 c5cfa2df88c6d2e5b31e87e1d5a8fe49d585f0bb 
 WebAPI/Controllers/ÏîÄ¿¹ÜÀí/Òµ¼¨Ö¸±ê/PM_YearEmployeeMoneyBillController.cs


@@ -288,12 +288,12 @@




                if (sWhere == null || sWhere.Equals(""))


                {


                    ds = oCN.RunProcReturn("select * from h_v_PM_YearEmployeeMoneyBillList order by å•æ®å· ", "h_v_PM_YearEmployeeMoneyBillList");


                    ds = oCN.RunProcReturn("select * from h_v_PM_YearEmployeeMoneyBillList order by å•æ®å· desc ", "h_v_PM_YearEmployeeMoneyBillList");


                }


                else


                {


                    string sql1 = "select * from h_v_PM_YearEmployeeMoneyBillList where 1 = 1 ";


                    string sql = sql1 + sWhere + " order by å•æ®å· ";


                    string sql = sql1 + sWhere + " order by å•æ®å· desc ";


                    ds = oCN.RunProcReturn(sql, "h_v_PM_YearEmployeeMoneyBillList");


                }