public List <Agents> GetAgentsList(String strWhere) { String sql = @"select Id,Name ,[Province] ,[City] ,[Village] ,[Birthday] ,[CareerStatus] ,[JoinDate] ,[Rank] ,[RefereeId] ,[RefereeName] ,[AgencyId] ,[AgencyName] ,[AccountBank] ,[AccountBankBranch] ,[Account] ,[Address] ,[ZipCode] ,[Phone] ,[CreateTime] ,[CreatePerson] ,[UpdateTime] ,[UpdatePerson] ,[State] ,[AgentsStatus] from Agents where 1=1" + strWhere; return(DataBase.Base_list <Agents>(sql)); }
public List <LogMonthCreate> getLogMonthCreateList(String sqlWhere) { String sql = "select * from LogMonthCreate where 1=1 " + sqlWhere; return(DataBase.Base_list <LogMonthCreate>(sql)); }