/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <ViewPayLicense> getPageList(int CurrentPage, int PageSize, string strw, out int Count)
{
string Table = "";
Table = Table + "PayLicense p ";
Table = Table + "left join SysUser u on u.UserId=p.DesigneeId ";
Table = Table + "left join Traders t on t.CID=p.CID ";
Table = Table + "left join Area a on a.AreaID=p.CityId ";
Table = Table + "left join SysUser u2 on u2.UserId=p.CreateUID ";
Table = Table + "left join BankAccount b on b.LicenseId=p.LicenseId ";
Table = Table + "left join TradersPaySecretKey k on k.CID=p.CID ";
string Fields = "";
Fields = Fields + "p.Id,u.FullName as DesigneeFullName,p.State,b.State as BankState,k.State as PayState,p.AgentsId,p.CID,t.FullTitle,(select top 1 ContractNo from CompanyAuthorize where Status=1 and CID=p.CID order by Id desc) as ContractNo,a.Title as city,p.SourceType,p.RegisterAddress,p.RegisterNumber,p.BusinessScope, ";
Fields = Fields + "p.Linkman,p.Phone,p.Email,p.Remark,p.CreateDT,u2.FullName as CreateFullName ";
string Where = "1=1 ";
if (strw != "")
{
Where = Where + strw;
}
string OrderBy = "p.Id desc ";
return(CommonDal.getPageList <ViewPayLicense>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <ViewTradersStore> getPageList(int CurrentPage, int PageSize, string strw, out int Count)
{
string Table = "";
Table = Table + "TradersStore s ";
Table = Table + "left join SysUser u on u.UserId=s.AssignUID ";
Table = Table + "left join SysUser u2 on u2.UserId=s.CreateUID ";
Table = Table + "left join SysUser u3 on u3.UserId=s.AuditUID ";
Table = Table + "left join TradersUser e on e.TUserId=s.MainAccount ";
string Fields = "";
Fields = Fields + "s.Id,u.FullName as Assign,s.State,s.CID,s.StoreNum,s.StoreName,e.LoginName,s.StoreNum3,s.QRCode,s.CreateDT,u2.FullName as CreatePerson,S.AuditDT,u3.FullName as AuditPerson ";
string Where = "1=1 ";
if (strw != "")
{
Where = Where + strw;
}
string OrderBy = "s.Id desc ";
return(CommonDal.getPageList <ViewTradersStore>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <ViewBankAccount> getPageList(int CurrentPage, int PageSize, string strw, out int Count)
{
string Table = "";
Table = Table + "BankAccount b ";
Table = Table + "left join PayLicense p on p.LicenseId=b.LicenseId ";
Table = Table + "left join SysUser u on u.UserId=p.DesigneeId ";
Table = Table + "left join SysUser u2 on u2.UserId=b.CreateUID ";
Table = Table + "left join SysUser u3 on u3.UserId=b.AuditUID ";
Table = Table + "left join Traders t on t.CID=b.CID ";
string Fields = "";
Fields = Fields + "b.Id,u.FullName,b.State,b.CID,t.FullTitle as TradersFullTitle,b.AccountType,b.AccountNumber,b.AccountName,b.BankName,b.LinkMan,b.Phone, ";
Fields = Fields + "p.AgentsId,t.Status as TradersStatus,p.SourceType,b.CreateDT,u2.FullName as CreatePerson,b.AuditDT,u3.FullName as AuditPerson ";
string Where = "1=1 ";
if (strw != "")
{
Where = Where + strw;
}
string OrderBy = "b.Id desc ";
return(CommonDal.getPageList <ViewBankAccount>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <ViewAgentsInfo> getPageList(int CurrentPage, int PageSize, string strw, out int Count)
{
string Table = "";
Table = Table + "AgentsInfo a ";
Table = Table + "left join SysDataDictionary d on d.DicSN=a.Type ";
Table = Table + "left join BankCardInfo b on b.AgentsId=a.AgentsId ";
Table = Table + "left join AgentPay y on y.AgentsId=a.AgentsId ";
Table = Table + "left join PayApis i on i.ApiNo=y.ApiNo ";
Table = Table + "left join SysUser u1 on u1.UserId=a.CreateUid ";
Table = Table + "left join SysUser u2 on u2.UserId=a.AssignUid ";
Table = Table + "left join AgentsUsers u3 on u3.AgentsLoginId=a.CreateUid ";
Table = Table + "left join AgentsUsers u4 on u4.AgentsLoginId=a.AssignUid ";
string Fields = "";
Fields = Fields + "a.Id,d.Title,a.AgentsId,a.FullName,a.Name,a.Status,a.PAgentsId,a.EndTime,a.AgentAreaNames,i.Title as ApiTitle,y.Cost,y.Lower,i.State as apiState,a.Contract, ";
Fields = Fields + "a.CorporateName,a.IdCard,a.CompanyPhone,a.Address,a.LinkMan,a.Phone1,a.Phone2,a.QQ,a.Email,a.Weixin,a.CreateTime,u1.FullName as sysCreFullName, ";
Fields = Fields + "u2.FullName as sysAssFullName,u3.FullName as AgenCreFullName,u4.FullName as AgenAssFullName ";
string Where = "1=1 ";
if (strw != "")
{
Where = Where + strw;
}
string OrderBy = "a.Id desc ";
return(CommonDal.getPageList <ViewAgentsInfo>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <ViewTradersPaySecretKey> getPageList(int CurrentPage, int PageSize, string strw, out int Count, string OrderBy)
{
string Table = "";
Table = Table + "TradersPaySecretKey p ";
Table = Table + "left join TradersPayChannel p2 on p2.TPaySecrectId=p.TPaySecrectId ";
Table = Table + "left join SysUser u on u.UserId=p.AssignUID ";
Table = Table + "left join SysUser u2 on u2.UserId=p.CreateUID ";
Table = Table + "left join SysUser u3 on u3.UserId=p.AuditUID ";
Table = Table + "left join Traders t on t.CID=p.CID ";
Table = Table + "left join PayChannelManages c on c.ChannelNo=p.ChannelNo ";
string Fields = "";
Fields = Fields + "p.Id,p.TPaySecrectId,u.FullName as Assign,p.State,p.CID,t.FullTitle as TradersFullTitle,p.SecretKey,p.MchId3,p.SecretKey3,c.ChannelCode,p2.ChannelPayMode,p2.PayNotifyUrl,p2.RfdNotifyUrl,p.CreateDT, ";
Fields = Fields + "u2.FullName as CreateFullName,p.AuditDT,u3.FullName as AuditFullName ";
string Where = "1=1 ";
if (strw != "")
{
Where = Where + strw;
}
if (string.IsNullOrEmpty(OrderBy))
{
OrderBy = "p.CreateDT desc ";
}
return(CommonDal.getPageList <ViewTradersPaySecretKey>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <AgentsUsers> getPageList(int CurrentPage, int PageSize, string strw, out int Count)
{
string Table = "";
Table = Table + "AgentsUsers u ";
string Fields = "";
Fields = Fields + "u.* ";
string Where = "1=1 ";
if (strw != "")
{
Where = Where + strw;
}
string OrderBy = "u.Id desc ";
return(CommonDal.getPageList <AgentsUsers>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
/// <summary>
/// 分页获取
/// </summary>
/// <param name="CurrentPage">当前页,从1开始,不是0</param>
/// <param name="PageSize">每页显示多少条数据</param>
/// <param name="strw">where条件</param>
/// <param name="Count">总数</param>
/// <returns></returns>
public List <ViewTradersUser> getPageList(int CurrentPage, int PageSize, string strw, out int Count)
{
string Table = "";
Table = Table + "TradersUser u ";
Table = Table + "left join TradersStore s on s.TStoreInfoId=u.TStoreInfoId ";
Table = Table + "left join SysUser i on i.UserId=u.SysCreateUID ";
string Fields = "";
Fields = Fields + "u.Id,u.State,u.CID,u.LoginName,u.AccountType,s.StoreNum,s.StoreName,u.FullName,u.Phone,u.Memo,u.CreateDT,i.FullName as SFullName ";
string Where = "u.IsHide=0 ";
if (strw != "")
{
Where = Where + strw;
}
string OrderBy = "u.CreateDT desc ";
return(CommonDal.getPageList <ViewTradersUser>(Table, Fields, Where, OrderBy, CurrentPage, PageSize, 0, out Count));
}
