//特别注意，如果是可空类型，建议以如下方式使用：
// var data = reader["field"];
// entity.stringData = data == null ? data : data.ToString();
//如需要手工映射，请反注释如下代码，并注意转换类型
/*
* /// <summary>
* /// 手工映射，建议使用1.2.0.5版本以上的VisitDataReader
* /// </summary>
* /// <returns>结果</returns>
* public AgentGen OrmByHand(string sql)
* {
* try
* {
* return baseDao.VisitDataReader<AgentGen>(sql, (reader) =>
* {
* AgentGen entity = new AgentGen();
* if(reader.Read())
* {
* entity.Id = reader["Id"];
* entity.Name = reader["Name"];
* }
* return entity;
* });
*
* //AgentGen entity = new AgentGen();
* //using(var reader = baseDao.SelectDataReader(sql))
* //{
* //if(reader.Read())
* //{
* //entity.Id = reader["Id"];
* //entity.Name = reader["Name"];
* //}
* //}
* //return entity;
* }
* catch (Exception ex)
* {
* throw new DalException("调用AgentGenDao时，访问OrmByHand时出错", ex);
* }
* }
*/
/// <summary>
/// 插入AgentGen
/// </summary>
/// <param name="agentGen">AgentGen实体对象</param>
/// <returns>新增的主键,如果有多个主键则返回第一个主键</returns>
public int InsertAgentGen(AgentGen agentGen)
{
try
{
Object result = baseDao.Insert <AgentGen>(agentGen);
int iReturn = Convert.ToInt32(result);
return(iReturn);
}
catch (Exception ex)
{
throw new DalException("调用AgentGen时，访问Insert时出错", ex);
}
}
/// <summary>
/// 检索AgentGen，带翻页
/// </summary>
/// <param name="obj">AgentGen实体对象检索条件</param>
/// <param name="pagesize">每页记录数</param>
/// <param name="pageNo">页码</param>
/// <returns>检索结果</returns>
public IList <AgentGen> GetListByPage(AgentGen obj, int pagesize, int pageNo)
{
try
{
StringBuilder sbSql = new StringBuilder(200);
sbSql.Append(@"select Id, Name from agent ");
sbSql.Append(" order by Id desc ");
sbSql.Append(string.Format("limit {0}, {1} ", (pageNo - 1) * pagesize, pagesize));
IList <AgentGen> list = baseDao.SelectList <AgentGen>(sbSql.ToString());
return(list);
}
catch (Exception ex)
{
throw new DalException("调用AgentGenDao时，访问GetListByPage时出错", ex);
}
}
