public Area_t GetAreaByUserUid(Guid useruid)
{
IAreaUserService areauser_service = new AreaUserService();
AreaUser_t areauser = areauser_service.GetAllAreaUser().Where(p => p.AU_UserUId == useruid).SingleOrDefault();
return(FindAll().Where(p => p.Ara_UId == areauser.AU_AreaUId).SingleOrDefault());
}
public static Guid GetAreaByUserUid(Guid useruid)
{
AreaUser_t areauser = areauser_service.GetAllAreaUser().FirstOrDefault(p => p.AU_UserUId == useruid);
if (areauser == null || areauser.AU_UId == new Guid())
{
return(AreaSourceUid);
}
return(areauser.AU_AreaUId);
}
public JsonResult GetMapData()
{
JsonResult result = new JsonResult();
result.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
//Guid uid = Guid.Parse(Session["wp_username"].ToString());
User_t account = UserContext.account;
List <FlowMeterStatusAndArea> fmlist = new List <FlowMeterStatusAndArea>();
List <PressureMeterStatusAndArea> pmlist = new List <PressureMeterStatusAndArea>();
List <QualityMeterStatusAndArea> qmlist = new List <QualityMeterStatusAndArea>();
//Func<List<FlowMeterStatusAndArea>> fmAndStatusArea = () => flowmeterService.GetFlowMeterStatusAndArea();
//List<FlowMeterStatusAndArea> fmstatusAndAreaList = DBHelper.get<FlowMeterStatusAndArea>(fmAndStatusArea,
// ConfigurationManager.AppSettings["allFlowMeterStatusAndArea"]);
//Func<List<PressureMeterStatusAndArea>> pmAndStatusArea = () => pressuremeterService.GetPressureMeterStatusAndArea();
//List<PressureMeterStatusAndArea> pmstatusAndAreaList = DBHelper.get<PressureMeterStatusAndArea>(pmAndStatusArea,
// ConfigurationManager.AppSettings["allPressureMeterStatusAndArea"]).ToList();
//Func<List<QualityMeterStatusAndArea>> qmAndStatusArea = () => qualitymeterService.GetQualityMeterStatusAndArea();
//List<QualityMeterStatusAndArea> qmstatusAndAreaList = DBHelper.get<QualityMeterStatusAndArea>(qmAndStatusArea,
// ConfigurationManager.AppSettings["allQualityMeterStatusAndArea"]);
if (account.Usr_Type == 3)
{
//fmlist = fmstatusAndAreaList.Where(p => p.flowmeter.FM_WaterConsumerUId==account.Usr_UId).ToList();
//qmlist = qmstatusAndAreaList.Where(p=>p.qualitymeter);
//pmlist = pmstatusAndAreaList.Where(p=>p.pressuremeter);
AreaUser_t au = areauserService.GetAreaUserByUser(account.Usr_UId);
Func <List <FlowMeterStatusAndArea> > fmsFunc = () => flowmeterService.GetFlowMeterStatusByArea(au.AU_AreaUId);
fmlist = DBHelper.get <FlowMeterStatusAndArea>(fmsFunc,
ConfigurationManager.AppSettings["FlowMeterStatusByAreaUid"] + au.AU_AreaUId).Where(p => p.flowmeter.FM_WaterConsumerUId == account.Usr_UId).ToList();
}
else
{
List <Area_t> arealist = areaService.GetAllArea();
foreach (var areaitem in arealist)
{
Func <List <FlowMeterStatusAndArea> > fmsFunc = () => flowmeterService.GetFlowMeterStatusByArea(areaitem.Ara_UId);
var fmdata = DBHelper.get <FlowMeterStatusAndArea>(fmsFunc,
ConfigurationManager.AppSettings["FlowMeterStatusByAreaUid"] + areaitem.Ara_UId);
fmlist.AddRange(fmdata);
Func <List <PressureMeterStatusAndArea> > pmsFunc = () => pressuremeterService.GetPressureMeterStatusByArea(areaitem.Ara_UId);
var pmsalist = DBHelper.get <PressureMeterStatusAndArea>(pmsFunc,
ConfigurationManager.AppSettings["PressureMeterStatusByAreaUid"] + areaitem.Ara_UId).ToList();
pmlist.AddRange(pmsalist);
Func <List <QualityMeterStatusAndArea> > qmAndStatusArea = () => qualitymeterService.GetQualityMeterStatusByArea(areaitem.Ara_UId);
var qmslist = DBHelper.get <QualityMeterStatusAndArea>(qmAndStatusArea, ConfigurationManager.AppSettings["QualityMeterStatusByAreaUid"] + areaitem.Ara_UId);
qmlist.AddRange(qmslist);
}
//fmlist = fmstatusAndAreaList;
//pmlist = pmstatusAndAreaList;
//qmlist = qmstatusAndAreaList;
}
result.Data = new
{
fmstatusAndAreaList = fmlist,
pmstatusAndAreaList = pmlist,
qmstatusAndAreaList = qmlist,
};
return(result);
}
