public DataSet QueryProfitLossBillDetail(int pageIndex, int pageSize, string filter, string OrderByFields)
{
using (PersistentManager persistentManager = new PersistentManager())
{
ProfitLossBillDetailDao dao = new ProfitLossBillDetailDao();
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())
{
ProfitLossBillDetailDao dao = new ProfitLossBillDetailDao();
return(dao.Query(sql, strTableView, pageIndex, pageSize));
}
}