/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select a.*,(case when b.[SignName] is null or b.[SignName]='' then '无' else b.[SignName] end) UserFullName ,c.[SupplierName] from [BWJSDB].[dbo].[Machine] a left join [BWJSDB].[dbo].[SupplierInfo] b on b.[SId]=a.[SId] left join [BWJSDB].[dbo].[MachineSupplier] c on c.[MachineSupplierId]=a.[MachineSupplierId]");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
//public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
//{
// return BWJSHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount);
//}
#endregion
#region ExtensionMethod
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("SELECT f.*,f2.FunctionName AS ParentName,u.UserName AS lastName FROM dbo.[Function] f LEFT JOIN dbo.[Function] f2 ON f.ParentId=f2.FunctionId AND f2.IsDeleted=0 LEFT JOIN dbo.Users u ON u.UserID=f.EditId ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select * from dbo.[UserBank] a ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 获得前几行数据
/// </summary>
//public DataSet GetList(int Top, string strWhere, string filedOrder)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select ");
// if (Top > 0)
// {
// strSql.Append(" top " + Top.ToString());
// }
// strSql.Append(" * ");
// strSql.Append(" FROM dbo.[IdentityCardLibrary] ");
// if (strWhere.Trim() != "")
// {
// strSql.Append(" where " + strWhere);
// }
// strSql.Append(" order by " + filedOrder);
// return BWJSHelperSQL.Query(strSql.ToString());
//}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
//public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
//{
// return BWJSHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount);
//}
#endregion
#region ExtensionMethod
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select a.*,b.[CompanyName] from dbo.[IdentityCardLibrary] a left join [dbo].[Company] b on b.[CompanyId] = a.[CompanyId] ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select * ");
tablesql.Append(" FROM dbo.[OrderRebateSettlementDetails] ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"select r.*,r1.RoleName as ParentRoleName FROM [Role] r left join [Role] r1 on r.ParentId=r1.RoleId and r1.IsDeleted=0");
//tablesql.Append(" FROM [Role] ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"select r.*,r1.DepartmentName as ParentDepartmentInfoName FROM [DepartmentInfo]
r left join [DepartmentInfo] r1 on r.ParentId=r1.DepartmentID and r1.RecordIsDelete=0");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select * ");
tablesql.Append(" FROM dbo.[NL_ConsultStatusChangeLog] ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
public DataTable GetNameList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"SELECT c.*,cc.CompanyCategoryName FROM dbo.Company c
LEFT JOIN dbo.CompanyCategory cc ON cc.CompanyCategoryId = c.CompanyCategoryId AND cc.IsDeleted = 0 ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@" SELECT ort.*,moa.InsureNum,u.UserName as MerchantName,u.RecordIsDelete as uIsDeleted,dinfo.DepartmentName FROM [dbo].OrderRebate ort
LEFT JOIN MofangDB.dbo.OrderApply moa ON moa.OrderApplyID = ort.OrderApplyId AND moa.RecordIsDelete = 0
LEFT JOIN dbo.Users u ON moa.UserID=u.UserID
LEFT JOIN dbo.DepartmentInfo dinfo ON dinfo.DepartmentID = moa.DepartmentID AND dinfo.RecordIsDelete = 0");
return BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount);
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
//tablesql.Append("select * ");
//tablesql.Append(" FROM dbo.[CompanyRelation] a");
//tablesql.Append(@"select a.*,a2.CompanyName,a3.UserName from [BWJSDB].[dbo].[CompanyRelation] a inner join [BWJSDB].[dbo].[Company] a2 on a.CompanyId = a2.CompanyId inner join [BWJSDB].[dbo].[Users] a3 on a.UserId = a3.UserID");
tablesql.Append(@"select a.*,a2.CompanyName,a2.MainBusiness,a3.UserName,a4.DepartmentName from [BWJSDB].[dbo].[CompanyRelation] a left join [BWJSDB].[dbo].[Company] a2 on a.CompanyId = a2.CompanyId left join [BWJSDB].[dbo].[Users] a3 on a.UserId = a3.UserID left join [BWJSDB].[dbo].[DepartmentInfo] a4 on a.DepartmentId = a4.DepartmentId");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 获得前几行数据
/// </summary>
//public DataSet GetList(int Top, string strWhere, string filedOrder)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select ");
// if (Top > 0)
// {
// strSql.Append(" top " + Top.ToString());
// }
// strSql.Append(" * ");
// strSql.Append(" FROM dbo.[OrderRebateSettlementApply] ");
// if (strWhere.Trim() != "")
// {
// strSql.Append(" where " + strWhere);
// }
// strSql.Append(" order by " + filedOrder);
// return BWJSHelperSQL.Query(strSql.ToString());
//}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
//public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
//{
// return BWJSHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount);
//}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"select a.*,b.UserName MerchantName,c.UserName CreateName
from [dbo].[OrderRebateSettlementApply] a
left join [dbo].[Users] b on b.[UserId]=a.[UserId]
left join [dbo].[Users] c on c.[UserId]=a.[CreateId]");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetAllList()
//{
// return GetList("");
//}
/// <summary>
/// 获得数据列表
/// </summary>
//public DataSet GetList(string strWhere)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select * ");
// strSql.Append(" FROM dbo.[NetLoanApply] ");
// if (strWhere.Trim() != "")
// {
// strSql.Append(" where " + strWhere);
// }
// return BWJSHelperSQL.Query(strSql.ToString());
//}
/// <summary>
/// 获得前几行数据
/// </summary>
//public DataSet GetList(int Top, string strWhere, string filedOrder)
//{
// StringBuilder strSql = new StringBuilder();
// strSql.Append("select ");
// if (Top > 0)
// {
// strSql.Append(" top " + Top.ToString());
// }
// strSql.Append(" * ");
// strSql.Append(" FROM dbo.[NetLoanApply] ");
// if (strWhere.Trim() != "")
// {
// strSql.Append(" where " + strWhere);
// }
// strSql.Append(" order by " + filedOrder);
// return BWJSHelperSQL.Query(strSql.ToString());
//}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
//public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
//{
// return BWJSHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount);
//}
#endregion
#region ExtensionMethod
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"
select a.*,b.UserName MerchantName,c.Name IdCardTypeName,d.[CompanyName],d.[MainBusiness],d.CompanyCategoryId,e.[CompanyCategoryName]
from [BWJSDB].[dbo].[NetLoanApply] a
left join [BWJSDB].[dbo].[Users] b on b.UserId = a.UserId
left join MofangDB.[dbo].CardType c on c.Value = a.IdCardType AND a.IsDeleted = 0
left join [BWJSDB].[dbo].[Company] d on d.[CompanyId] = a.[CompanyId] AND d.IsDeleted = 0
left join [dbo].[CompanyCategory] e on e.[CompanyCategoryId]=d.CompanyCategoryId");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetNameList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"SELECT u.*,
(ISNULL(ca.name,'') + ISNULL(ca1.Name,'') + ISNULL(ca2.Name,'')+ISNULL(u.Address,'')) AS CityData, d.DepartmentName,re.RoleName FROM dbo.Users u
LEFT JOIN dbo.CityArea ca ON u.ProvinceID = ca.ID
LEFT JOIN dbo.CityArea ca1 ON u.CityID = ca1.ID
LEFT JOIN dbo.CityArea ca2 ON u.CountyID = ca2.ID
LEFT JOIN[DepartmentInfo] d ON u.DepartmentID = d.DepartmentID AND d.RecordIsDelete = 0
LEFT JOIN dbo.UserRole uri ON uri.UserId=u.UserID AND uri.IsDeleted=0
LEFT JOIN dbo.[Role] re ON re.RoleId=uri.RoleId AND re.IsDeleted=0");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append(@"
select c.OrderApplyId,
a.OrderPayApplyId, a.OrderRebateId, c.InsureNum, a.PayStatus, a.PayPlatform, a.CreateDate,
a.PayDate, a.Remark,a.OrderMoney,b.IsSettled,b.IsCancel, d.CName TBName, e.CName BBName,
b.TransNo,u.UserName AS MerchantName,u.RecordIsDelete AS uIsDeleted,c.DepartmentId,dinfo.DepartmentName ,c.UserID
from BWJSDB.dbo.OrderPayApply a
LEFT JOIN BWJSDB.dbo.OrderRebate b on b.OrderRebateId = a.OrderRebateId AND b.IsDeleted=0
LEFT JOIN MofangDB.dbo.OrderApply c on c.OrderApplyID = b.OrderApplyId AND c.RecordIsDelete=0
LEFT JOIN MofangDB.dbo.ApplicantInfo d on d.OrderApplyId = c.OrderApplyId AND d.RecordIsDelete=0
LEFT JOIN MofangDB.dbo.InsurantInfo e on e.OrderApplyId = c.OrderApplyId AND e.RecordIsDelete=0
LEFT JOIN dbo.Users u ON u.UserID=c.UserID
LEFT JOIN dbo.DepartmentInfo dinfo ON dinfo.DepartmentID = c.DepartmentID AND dinfo.RecordIsDelete = 0 ");
return(BWJSHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
return(BWJSHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
