/// <summary>
///
/// </summary>
/// <param name="whereStr">以where 开始</param>
/// <returns></returns>
public static IList <PersonBill> Select(string whereStr)
{
try
{
using (var access = new PersonBillAccess())
{
return(access.Select(whereStr));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static PersonBill SelectObject(int id)
{
try
{
using (var access = new PersonBillAccess())
{
return(access.SelectObject(id));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Update(PersonBill obj)
{
try
{
using (var access = new PersonBillAccess())
{
return(access.Update(obj));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int Delete(int id)
{
try
{
using (var access = new PersonBillAccess())
{
return(access.Delete(id));
}
}
catch (Exception ex)
{
throw ex;
}
}
public static int SqlBulkCopyBatchInsert(List <PersonBill> list, int count)
{
try
{
using (var access = new PersonBillAccess())
{
return(access.SqlBulkCopyBatchInsert(list, count));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="order">列名，分页排序字段，可支持多字段，多顺序</param>
/// <param name="whereStr">以 where 开头</param>
/// <returns></returns>
public static IList <PersonBill> SelectPage(string cloumns, string order, string whereStr, int pageIndex, int pageSize, out int rowCount)
{
try
{
using (var access = new PersonBillAccess())
{
return(access.SelectPage(cloumns, order, whereStr, pageIndex, pageSize, out rowCount));
}
}
catch (Exception ex)
{
throw ex;
}
}