private void AddStopTime(int time, int GateWayID)
{
UserVistCount condition = new UserVistCount();
condition.ID = 1;
UserVistCount user = TableOperate <UserVistCount> .GetRowData(condition);
if (user.ID > 0)
{
condition.StopTime = user.StopTime + time;
condition.ID = 1;
TableOperate <UserVistCount> .Update(condition);
}
IBeaconGateWay condition1 = new IBeaconGateWay();//增加展区停留时间
condition1.ID = GateWayID;
IBeaconGateWay ibecont = TableOperate <IBeaconGateWay> .GetRowData(condition1);
if (ibecont.ID > 0)
{
condition1 = new IBeaconGateWay();
condition1.Y = ibecont.Y + 1;
condition1.ID = ibecont.ID;
TableOperate <IBeaconGateWay> .Update(condition1);
}
}
protected int GetDcount(int ID)
{
IBeaconGateWay condition = new IBeaconGateWay();
condition.ID = ID;
IBeaconGateWay way = TableOperate <IBeaconGateWay> .GetRowData(condition);
if (way.ID > 0)
{
return(way.H);
}
return(1);
}
private void IntoGetWay(int DevID)//增加展区参观人数
{
IBeaconGateWay condition = new IBeaconGateWay();
condition.ID = DevID;
IBeaconGateWay ibecont = TableOperate <IBeaconGateWay> .GetRowData(condition);
if (ibecont.ID > 0)
{
condition = new IBeaconGateWay();
condition.X = ibecont.X + 1;
condition.ID = ibecont.ID;
TableOperate <IBeaconGateWay> .Update(condition);
}
}
private void AddJson(string jsonStr)
{
// jsonStr="{ \"v\" : \"1.1.0.26\", \"mid\" : 851, \"time\" : 1748, \"ip\" : \"192.168.60.19\", \"mac\" : \"B4E62DBE9A01\", \"devices\" : [ \"0x001918FC0532D2BF0201061AFF4C000215FDA50693A4E24FB1AFCFC6EB0764782527121458C5\", \"0x03123B6A1B8AF5BF0201061AFF4C000215B5B182C7EAB14988AA99B5C1517008D900010002C5\" ] }";
//SaveExLog(jsonStr);
string mac = "";
if (jsonStr.IndexOf("devices") > -1)
{
JsonData json = JsonMapper.ToObject(jsonStr);
mac = Convert.ToString(json["mac"]);
//0x03
//12 3B 6A 1B 8A F5
//CA 02 01 06 1A FF 4C 00
//02 15 B5 B1 82 C7 EA B1 49 88 AA 99 B5 C1 51 70 08 D9 00 01 00 02 C5
JsonData list = json["devices"];
IBeaconGateWay beacon = gateWay(mac);
if (beacon != null)
{
list = RemoveJson(list);
double maxdistance = beacon.MaxDistance;//设置的最大距离
for (int i = 0; i < list.Count; i++)
{
string blueMac = list[i].ToString().Substring(4, 12);
IBeaconDev blue = Isdev(blueMac);
if (blue != null)
{
if (blue.ID > 0 && blue.UserID > 0)//&&blue.UserID!=0非绑定不做操作
{
string rssi = list[i].ToString().Substring(16, 2);
int NowRssi = toRssi(rssi) - 256;
double distance = getDistance(-59, Convert.ToDouble(NowRssi));
if (distance <= maxdistance)//在设置的最大距离范围内
{
SaveExLog(beacon.ID + "---" + mac + "-----" + blueMac + "信号-" + NowRssi + "预估距离-" + distance);
StopTime(blue.ID, beacon.ID, blue.UserID);
}
}
}
}
}
}
// SaveExLog(jsonStr);
}
protected void Page_Load(object sender, EventArgs e)
{
IBeaconGateWay condition = new IBeaconGateWay();
IBeaconGateWay value = new IBeaconGateWay();
string title = GetstringKey("name");
if (title != "")
{
condition.MAC = "%" + title + "%";
condition.AddAttach("MAC", "like");
}
condition.ExhibitionID = AdminMethod.ExhibitionID;
m_tableManageList = TableOperate <IBeaconGateWay> .SelectByPage(value, condition, "order by id desc", PageSize, PageIndex, ref Count);
DataBind();
name.Value = title;
}
protected void Page_Load(object sender, EventArgs e)
{
string action = GetstringKey("action");
if (action != "save")
{
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
int _iD = Convert.ToInt32(this.Request["iD"]);
IBeaconGateWay condition = new IBeaconGateWay();
condition.ID = _iD;
news = TableOperate <IBeaconGateWay> .GetRowData(condition);
iD.Value = Convert.ToString(news.ID);
}
DataBind();
}
else
{
Result result = new Result();
string logbrief = "";
IBeaconGateWay newChannelNews = new IBeaconGateWay();
newChannelNews.ID = 0;
newChannelNews.AutoForm(this.Page);
string Title = newChannelNews.DevName;
int _iD;
if (!string.IsNullOrEmpty(this.Request["iD"]))
{
_iD = Convert.ToInt32(this.Request["iD"]);
TableOperate <IBeaconGateWay> .Update(newChannelNews);
result.msg = "编辑成功，等待返回列表";
// logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "编辑了为【" + Title + "】的展区";
}
else
{
newChannelNews.AddTime = DateTime.Now;
newChannelNews.AddID = AdminMethod.AdminID;
newChannelNews.ExhibitionID = AdminMethod.ExhibitionID;
_iD = TableOperate <IBeaconGateWay> .InsertReturnID(newChannelNews);
result.msg = "添加成功，等待返回列表";
// logbrief = "管理员:【" + AdminMethod.AdminFullName + "】在" + DateTime.Now.GetDateTimeFormats('f')[0].ToString() + "添加了为【" + Title + "】的展区";
}
if (_iD > 0)
{
result.isOk = true;
Lognet.AddLogin(logbrief);
}
else
{
result.msg = "操作失败";
}
Response.ContentType = "text/json";
Response.Write(new JavaScriptSerializer().Serialize(result));
Response.End();
}
DataBind();
}
