/// <summary>
/// 分页查询
/// </summary>
/// <param name="search">查询条件</param>
/// <returns></returns>
public PagedResult <SEG> GetListByPage(SEG search)
{
string where = " WHERE 1=1";
if (!string.IsNullOrWhiteSpace(search.SEGCODE))
{
where += " AND SEGCODE=:SEGCODE";
}
if (!string.IsNullOrWhiteSpace(search.SEGDESC))
{
where += " AND SEGDESC=:SEGDESC";
}
//if (!string.IsNullOrWhiteSpace(search.Language))
//{
// where += " AND (LanguageA=:Language or LanguageB=:Language or LanguageC=:Language or LanguageD=:Language)";
//}
var sql = @"BEGIN OPEN :rslt1 FOR SELECT COUNT(1) FROM tblseg" + where + ";" +
"OPEN :rslt2 FOR SELECT * FROM tblseg" + where + ";" +
" END;";
OracleDynamicParameters dynParams = new OracleDynamicParameters();
dynParams.Add(":rslt1", OracleDbType.RefCursor, ParameterDirection.Output);
dynParams.Add(":rslt2", OracleDbType.RefCursor, ParameterDirection.Output);
if (!string.IsNullOrWhiteSpace(search.SEGCODE))
{
dynParams.Add(":SEGCODE", OracleDbType.Varchar2, ParameterDirection.Input, search.SEGCODE);
}
if (!string.IsNullOrWhiteSpace(search.SEGDESC))
{
dynParams.Add(":SEGDESC", OracleDbType.Varchar2, ParameterDirection.Input, search.SEGDESC);
}
//if (!string.IsNullOrWhiteSpace(search.Language))
//{
// dynParams.Add(":Language", OracleDbType.Varchar2, ParameterDirection.Input, search.Language);
//}
using (IDbConnection dbConn = new OracleConnection(connectionString))
{
var queryResult = dbConn.QueryMultiple(sql, param: dynParams);
return(new PagedResult <SEG>
{
Total = queryResult.Read <int>().Single(),
Rows = queryResult.Read <SEG>().Skip <SEG>(search.Skip).Take <SEG>(search.Count).ToList()
});
}
}
public Segment(SEG _seg, String name, int code) : base(name, code)
{
seg = _seg;
size = OPSIZE.DWord;
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="search">查询条件</param>
/// <returns></returns>
public PagedResult <SEG> GetListByPage(SEG search)
{
return(segDAL.GetListByPage(search));
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public PagedResult <SEG> Get([FromUri] SEG search)
{
return(segBLL.GetListByPage(search));
}
public Segment(SEG _seg, String _name)
{
seg = _seg;
name = _name;
}
