/// <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)); }