/// <summary>
/// 商铺信息下拉刷新
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Dictionary <string, object> GetMerchantList(wy_houseinfo model, string userID, URole role)
{
Dictionary <string, object> dic = new Dictionary <string, object>();
try
{
var list = _Db.Db().Queryable <wy_houseinfo>().Where(a => a.IS_DELETE == 0);
if (role == URole.Admin)
{
list = _Db.Db().Queryable <wy_houseinfo, ts_uidp_org, ts_uidp_org_user>((a, b, c) => new object[] {
JoinType.Inner, a.ORG_CODE.StartsWith(b.ORG_CODE),
JoinType.Inner, b.ORG_ID == c.ORG_ID && c.USER_ID == userID
}).Where((a, b, c) => a.IS_DELETE == 0);
}
else if (role == URole.Inspector)
{
list = _Db.Db().Queryable <wy_houseinfo, wy_region_director>((a, b) => new object[] {
JoinType.Inner, a.SSQY == b.SSQY && b.RD_ID == userID,
}).Where((a, b) => a.IS_DELETE == 0);
}
if (!string.IsNullOrWhiteSpace(model.FWBH))
{
list = list.Where(a => a.FWBH.Contains(model.FWBH));
}
if (model.FWSX != null && model.FWSX != -1)
{
list = list.Where(a => a.FWSX == model.FWSX);
}
if (!string.IsNullOrWhiteSpace(model.SSQY))
{
list = list.Where(a => a.SSQY == model.SSQY);
}
if (!string.IsNullOrWhiteSpace(model.LSFGS))
{
list = list.Where(a => a.LSFGS == model.LSFGS);
}
var _list = list.ToList();
var count = from p in _list where p.FWSX == 2 select p;
var greenCount = (from p in _list where p.FWSX == 2 select p).Count();
var grayCount = (from p in _list where p.FWSX == 0 select p).Count();
var yellowCount = (from p in _list where p.FWSX == 1 select p).Count();
var listNnew = list.Select(a => new { a.FWBH, a.FWMC, a.FWID, a.FWSX }).OrderBy(a => a.FWBH).Take(20).ToList();
dic.Add("list", listNnew);
dic.Add("greenCount", greenCount);
dic.Add("grayCount", grayCount);
dic.Add("yellowCount", yellowCount);
}
catch (Exception ex)
{
dic.Add("list", null);
dic.Add("greenCount", 0);
dic.Add("grayCount", 0);
dic.Add("yellowCount", 0);
}
return(dic);
}
public IActionResult GetMerchantList(wy_houseinfo model)
{
Dictionary <string, object> dic = _machantSvc.GetMerchantList(model, UserID, URoleE.Value);
return(Json(dic));
}
