| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from PM_WorkTaskBillMain order by HBillNo ", "PM_WorkTaskBillMain"); |
| | | ds = oCN.RunProcReturn("select * from h_v_PM_WorkTaskBillList order by åæ®å· ", "h_v_PM_WorkTaskBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from PM_WorkTaskBillMain where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by HBillNo "; |
| | | ds = oCN.RunProcReturn(sql, "PM_WorkTaskBillMain"); |
| | | string sql1 = "select * from h_v_PM_WorkTaskBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by åæ®å· "; |
| | | ds = oCN.RunProcReturn(sql, "h_v_PM_WorkTaskBillList"); |
| | | } |
| | | |
| | | //æ·»å åå |
| | |
| | | |
| | | if (sWhere == null || sWhere.Equals("")) |
| | | { |
| | | ds = oCN.RunProcReturn("select * from PM_WorkTaskReportBillMain order by HBillNo desc ", "PM_ProjectStageBillMain"); |
| | | ds = oCN.RunProcReturn("select * from h_v_PM_WorkTaskReportBillList order by åæ®å·", "h_v_PM_ProjectStageBillList"); |
| | | } |
| | | else |
| | | { |
| | | string sql1 = "select * from PM_WorkTaskReportBillMain where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by HBillNo desc "; |
| | | ds = oCN.RunProcReturn(sql, "PM_WorkTaskReportBillMain"); |
| | | string sql1 = "select * from h_v_PM_WorkTaskReportBillList where 1 = 1 "; |
| | | string sql = sql1 + sWhere + " order by åæ®å·"; |
| | | ds = oCN.RunProcReturn(sql, "h_v_PM_WorkTaskReportBillList"); |
| | | } |
| | | |
| | | //æ·»å åå |