public IHttpActionResult GetDataList([FromUri] OutputStoreArchiveModel model)
{
string name = model.SearchKey == null?"": model.SearchKey.ToString();
int id = 0;
if (model.SearchKey != null)
{
int.TryParse(model.SearchKey.ToString(), out id);
}
Expression <Func <v_KsType, bool> > where = p => (string.IsNullOrEmpty(name) || p.Name.Contains(name)) ||
(string.IsNullOrEmpty(name) || p.ParentName.Contains(name)) ||
(string.IsNullOrEmpty(name) || p.Memo.Contains(name)) ||
(string.IsNullOrEmpty(name) || p.Id == id);
var list = dbContext.v_KsType.Where(where).Where(where).ToList().Select(p => new
{
p.Id,
p.Name,
p.IdParent,
p.ParentName,
p.Memo
}).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(list));
}
public IHttpActionResult GetDataList2(OutputStoreArchiveModel model)
{
try
{
Expression <Func <ST_Store, bool> > where = p => (string.IsNullOrEmpty(model.Name) || p.Name.Contains(model.Name));
var data = dbContext.ST_Store.Where(where);
//类型
var enType = dbContext.BA_SysEnType.ToList();
//人员
var person = dbContext.OR_Person.ToList();
var list = data.ToList().Select(p => new
{
p.Id,
p.Name, //门店mingcheng
Supervisor = person.FirstOrDefault(x => x.Id == p.IdSupervisor) == null ? "" : person.FirstOrDefault(x => x.Id == p.IdSupervisor).Name, //督导人
p.Address, //门店详情地址
RegionArea = enType.FirstOrDefault(s => s.Id == p.RegionId) == null ? "" : enType.FirstOrDefault(s => s.Id == p.RegionId).Name, //所属大区
PersonRegion = person.FirstOrDefault(s => s.Id == p.IdPersonRegion) == null ? "" : person.FirstOrDefault(s => s.Id == p.IdPersonRegion).Name //所属区域负责人
}).ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(list));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult GetDataList([FromUri] OutputStoreArchiveModel model)
{
try
{
string name = model.SearchKey == null ? "" : model.SearchKey.ToString();
Expression <Func <v_StoreArchives, bool> > where = p => (string.IsNullOrEmpty(name) || p.Name.Contains(name) ||
p.PersonRegion.Contains(name) || p.RegionArea.Contains(name) || p.Address.Contains(name) || p.Supervisor.Contains(name) || p.Code.Contains(name));
var data = dbContext.v_StoreArchives.Where(where);
var list = data.ToList().Select(p => new
{
p.Id,
p.Name, //门店mingcheng
p.Supervisor, //督导人
p.Address, //门店详情地址
p.RegionArea, //所属大区
p.PersonRegion, //所属区域负责人
p.Code, //门店代码
}).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(list));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex.ToString());
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult RegionList([FromUri] OutputStoreArchiveModel model)
{
Expression <Func <OR_Person, bool> > where = p => (string.IsNullOrEmpty(model.Name) || p.Name.Contains(model.Name));
var list = dbContext.OR_Person.Where(where).Select(p => new
{
p.Id,
p.Name
}).OrderByDescending(p => p.Id).ToPagedList(model.PageIndex, model.PageSize);
return(JsonResultHelper.JsonResult(list));
}
