public HttpResponseMessage Export(EmployeeQryInfo qInfo)
{
HttpResponseMessage result = new HttpResponseMessage(HttpStatusCode.OK);
var ret = _us.ListUser(qInfo);
//ExcelMappingUtil mp = new ExcelMappingUtil();
string fileName = _mp.ExportToFile <Employee>(ret);
return(new HttpResponseMessage()
{
Content = new StringContent(fileName)
});
}
public List <Employee> ListUser(EmployeeQryInfo qInfo)
{
Sql sql = new Sql("select badge,name UserName,[compid] Company,[depcname] Department from [users] where status<>'Loff'");
if (!string.IsNullOrEmpty(qInfo.UserName))
{
sql.Append(" and name like @0", "%" + qInfo.UserName + "%");
}
var pageData = _db.Page <Employee>(qInfo.Page, qInfo.ItemsPerPage, sql);
return(_db.Fetch <Employee>(sql));
}
public JsonPager <Employee> PageUser(EmployeeQryInfo qInfo)
{
Sql sql = new Sql("select badge,name UserName,[compid] Company,[depcname] Department from [users] where status<>'Loff'");
if (!string.IsNullOrEmpty(qInfo.UserName))
{
sql.Append(" and name like @0", "%" + qInfo.UserName + "%");
}
if (qInfo.OrderBy != null && qInfo.OrderBy.Length > 0)
{
sql.AddOrderBy(qInfo.OrderBy);
}
;
var pageData = _db.Page <Employee>(qInfo.Page, qInfo.ItemsPerPage, sql);
JsonPager <Employee> ret = new JsonPager <Employee>();
ret.result = pageData.Items;
ret.total = pageData.TotalItems;
return(ret);
}
public JsonPager <Employee> PageUser(EmployeeQryInfo qInfo)
{
var ret = _us.PageUser(qInfo);
return(ret);
}
