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