/// <summary>
/// 使用sql查询
/// </summary>
/// <param name="enCode"></param>
/// <returns></returns>
public List <ItemsDetailEntity> FildSql(string enCode)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(enCode);
return(service.FindList(strSql.ToString()).ToList());
}
public List <ItemsDetailEntity> GetList(string itemId, string keyword, Pagination pagination)
{
var expression = ExtLinq.True <ItemsDetailEntity>();
expression = expression.And(t => t.ItemId == itemId);
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.ItemName.Contains(keyword));
expression = expression.Or(t => t.ItemCode.Contains(keyword));
}
expression = expression.And(t => t.DeleteMark != true);
return(service.FindList(expression, pagination));
}
public IEnumerable <ItemsDetailEntity> GetList(Pagination pagination, string keyword = "", string itemId = "")
{
var expression = ExtLinq.True <ItemsDetailEntity>();
if (!string.IsNullOrEmpty(itemId))
{
expression = expression.And(t => t.F_ItemId == itemId);
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.F_ItemName.Contains(keyword));
expression = expression.Or(t => t.F_ItemCode.Contains(keyword));
}
return(service.FindList(expression, pagination));
}
/// <summary>
/// 获得数据字典列表信息【分页】
/// </summary>
/// <param name="itemId"></param>
/// <param name="keyword"></param>
/// <returns></returns>
public List <ItemsDetailEntity> GetList(Pagination pagination, string itemId = "", string keyword = "")
{
var expression = ExtLinq.True <ItemsDetailEntity>();
if (!string.IsNullOrEmpty(itemId))
{
expression = expression.And(t => t.F_ItemId == itemId);
}
if (!string.IsNullOrEmpty(keyword))
{
expression = expression.And(t => t.F_ItemName.Contains(keyword));
expression = expression.Or(t => t.F_ItemCode.Contains(keyword));
}
ResultClass <List <ItemsDetailEntity> > _ret = service.FindList(expression, pagination);
if (_ret.Result)
{
return(_ret.ResultData.ToList());
}
return(new List <ItemsDetailEntity>());
}