/// <summary>
/// 地图上显示设备，获取信息
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public string GetDeviceOnMap(DeviceMapReq req)
{
var user = JsonConvert.DeserializeObject <AllInOne_UserInfo>(Session["user"].ToString());
var r = AllFunc.Instance.GetDeviceOnMap(req, user);
return(JsonConvert.SerializeObject(r));
}
///// <summary>
/////获取展示在地图上的设备信息
///// </summary>
///// <param name="req"></param>
///// <param name="lastCId"></param>
///// <returns></returns>
public List <OneFLMeterDataView> GetDeviceOnMap(DeviceMapReq req, string lastCId)
{
var search = req.search ?? "";
var dict = new Dictionary <string, string>
{
{ "@lastcid", lastCId },
{ "@search", $"%{search}%" },
{ "@search2", search },
};
var condition = " 1=1 and (cid1=@lastcid or cid2=@lastcid or cid3=@lastcid or cid4=@lastcid ) ";
if (!search.IsNullOrEmpty())
{
condition += " and (customerName like @search or address like @search or deviceNo=@search2 or communicateNo=@search2 ";
int temp;
if (int.TryParse(search, out temp))
{
condition += " or FLMeterNo=@search2 ";
}
condition += " )";
}
if (req.sonId != "0")
{
var user = AllInOne_UserInfoOper.Instance.GetById(Convert.ToInt32(req.sonId));
//var lastCId2 = AllInOne_UserInfoOper.Instance.GetLastCId(user);
var ids = GetDeviceIds(user);
if (ids.Count == 0)
{
return(new List <OneFLMeterDataView>());
}
var idsStr = StringHelper.Instance.ArrJoin(ids.ToArray());
condition += $" and FLMeterNo in ({idsStr})";
}
string str = $@"select DISTINCT
Id,
communicateNo,
FLMeterNo,
siteNo,
InstantTime,
ReceivTime,
StdSum,
WorkSum,
StdFlow,
WorkFlow,
Temperature,
Pressure,
FMState,
FMStateMsg,
RTUState,
RTUStateMsg,
SumTotal,
RemainMoney,
RemainVolume,
Overdraft,
RemoteChargeMoney,
RemoteChargeTimes,
Price,
ValveState,
ValveStateMsg,
PowerVoltage,
BatteryVoltage,
Reserve1,
Reserve2,
Reserve3,
Reserve4,
meterNo,
meterTypeNo,
lat,
lng,
deviceNo,
customerName,
address,
LoginState,
LoginStateMsg from OneFLMeterDataView where {condition} order by InstantTime ";
return(SqlHelper.Instance.ExecuteGetDt <OneFLMeterDataView>(str, dict));
}
