| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProjectStage order by é¶æ®µç¼ç ", "h_v_Gy_ProjectStage"); |
| | | ds = oCN.RunProcReturn("select * from h_v_Gy_ProjectStage order by é¶æ®µç¼ç desc", "h_v_Gy_ProjectStage"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_Gy_ProjectStage where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by é¶æ®µç¼ç "; |
| | | string sql = sql1 + sWhere + " order by é¶æ®µç¼ç desc"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_Gy_ProjectStage"); |
| | | } |
| | | |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from h_v_PM_ProjectReportBillList order by åæ®å· ", "h_v_PM_ProjectReportBillList"); |
| | | ds = oCN.RunProcReturn("select * from h_v_PM_ProjectReportBillList order by åæ®å· desc ", "h_v_PM_ProjectReportBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from h_v_PM_ProjectReportBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by åæ®å· "; |
| | | string sql = sql1 + sWhere + " order by åæ®å· desc "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_PM_ProjectReportBillList"); |
| | | } |
| | | |