public DataSet QueryCheckBillDetail(int pageIndex, int pageSize, string filter, string OrderByFields) { using (PersistentManager persistentManager = new PersistentManager()) { CheckBillDetailDao dao = new CheckBillDetailDao(); return(dao.Query(strTableView, strPrimaryKey, strQueryFields, pageIndex, pageSize, OrderByFields, filter, strTableView)); } }
public DataSet QueryByBillNo(string BillNo, int pageIndex, int pageSize) { string[] aryBillNo = BillNo.Split(','); string BillNoList = "''"; for (int i = 0; i < aryBillNo.Length; i++) { BillNoList += ",'" + aryBillNo[i] + "'"; } string sql = string.Format("SELECT {0} from {1} where BILLNO in ({2}) ORDER BY BILLNO DESC", strQueryFields, strTableView, BillNoList); using (PersistentManager persistentManager = new PersistentManager()) { CheckBillDetailDao dao = new CheckBillDetailDao(); return(dao.Query(sql, strTableView, pageIndex, pageSize)); } }