/// <summary>
/// 人数统计
/// </summary>
private void AddCount()
{
UserVistCount condition = new UserVistCount();
condition.ID = 1;
UserVistCount user = TableOperate <UserVistCount> .GetRowData(condition);
if (user.ID > 0)
{
if (user.AddTime.Date == DateTime.Now.Date)
{
condition.NowDayCount = user.NowDayCount + 1;
}
else
{
condition.NowDayCount = 1;
}
condition.AddTime = DateTime.Now;
condition.Count = user.Count + 1;
condition.ID = user.ID;
TableOperate <UserVistCount> .Update(condition);
}
else
{
condition.AddTime = DateTime.Now;
condition.NowDayCount = 1;
condition.Count = 1;
TableOperate <UserVistCount> .Insert(condition);
}
}
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 void Page_Load(object sender, EventArgs e)
{
string act = "";
string msg = "";
if (!string.IsNullOrEmpty(Request["act"]))
{
act = Convert.ToString(Request["act"]);
act = RequestString.NoHTML(act);
if (act == "insert")
{
string name = Convert.ToString(RequestString.NoHTML(Request["name"]));
string nickname = Convert.ToString(RequestString.NoHTML(Request["nickname"]));
string phone = Convert.ToString(RequestString.NoHTML(Request["phone"]));
int sex = Convert.ToInt32(Request["sex"]);
int hy = Convert.ToInt32(Request["hy"]);
int faceid = Convert.ToInt32(Request["faceid"]);
if (IsHave(phone))
{
msg = "{\"state\":\"false\", \"msg\":\"手机号已被注册\"}";
}
else
{
Userinfo condition = new Userinfo();
condition.Name = name;
condition.NickName = nickname;
condition.Gender = sex;
condition.TradeID = hy;
condition.Phone = phone;
int id = TableOperate <Userinfo> .InsertReturnID(condition);
if (id > 0)
{
Face face = new Face();
face.ID = faceid;
face.UserinfoID = id;
TableOperate <Face> .Update(face);
msg = "{\"state\":\"true\", \"msg\":\"注册成功\"}";
}
else
{
msg = "{\"state\":\"false\", \"msg\":\"注册失败\"}";
}
}
}
else if (act == "add")
{
UserVistCount condition = new UserVistCount();
condition.ID = 1;
UserVistCount user = TableOperate <UserVistCount> .GetRowData(condition);
if (user.ID > 0)
{
if (user.AddTime.Date == DateTime.Now.Date)
{
condition.NowDayCount = user.NowDayCount + 1;
}
else
{
condition.NowDayCount = 0;
}
condition.AddTime = DateTime.Now;
condition.Count = user.Count + 1;
condition.ID = user.ID;
TableOperate <UserVistCount> .Update(condition);
}
else
{
condition.AddTime = DateTime.Now;
condition.NowDayCount = 1;
condition.Count = 1;
TableOperate <UserVistCount> .Insert(condition);
}
}
}
Response.Write(msg);
}
protected void Page_Load(object sender, EventArgs e)
{
string act = "";
if (!string.IsNullOrEmpty(this.Request["act"]))
{
act = Convert.ToString(Request["act"]);
}
string json = "";
if (act == "getcount")
{
UserVistCount condition = new UserVistCount();
condition.ID = 1;
UserVistCount value = TableOperate <UserVistCount> .GetRowData(condition);
int nowcount = 0;
if (value.AddTime.Date == DateTime.Now.Date)
{
nowcount = value.NowDayCount;
}
else
{
nowcount = 0;
}
json += "{\"ID\":" + value.ID + ", \"AllCount\":\"" + value.Count + "\", \"NowDayCount\":\"" + nowcount + "\", \"StopTime\":\"" + value.StopTime + "\"}";
}
else if (act == "now")
{
#region MyRegion
// json = "{\"list\":[";
// List<IBeaconGateWay> list = TableOperate<IBeaconGateWay>.Select();
// View_iBeaconNow condition = new View_iBeaconNow();
// View_iBeaconNow value = new View_iBeaconNow();
//// condition.AddConditon(" and DateDiff(dd,LastTime,getdate())=0");//今天
// condition.AddConditon("and UserID!=0");//排除非绑定
// List<View_iBeaconNow> ibeaconlist = TableOperate<View_iBeaconNow>.Select(value, condition);
// for (int i = 0; i < list.Count; i++)
// {
// json += "{\"ID\":" + list[i].ID + ", \"name\":\"" + list[i].DevName + "\", \"Count\":\"" + GetCount(ibeaconlist, list[i].ID) + "\"},";
// }
// json = json.Trim(',');
// json += "]}";
// json = StortJson(json);
#endregion
json = "{\"list\":[";
List <IBeaconGateWay> list = TableOperate <IBeaconGateWay> .Select();
for (int i = 0; i < list.Count; i++)
{
json += "{\"ID\":" + list[i].ID + ", \"name\":\"" + list[i].DevName + "\", \"Count\":\"" + list[i].X + "\"},";
}
json = json.Trim(',');
json += "]}";
}
else if (act == "data")
{
json = "{\"list\":[";
List <IBeaconGateWay> list = TableOperate <IBeaconGateWay> .Select();
IBeaconData condition = new IBeaconData();
IBeaconData value = new IBeaconData();
if (!string.IsNullOrEmpty(Request["now"]))
{
condition.AddConditon(" and DateDiff(dd,LastTime,getdate())=0"); //今天
}
if (!string.IsNullOrEmpty(Request["userid"])) //获取用户的
{
int userID = Convert.ToInt32(Request["userid"]);
condition.UserID = userID;
}
condition.AddConditon("and UserID!=0");//排除非绑定
List <IBeaconData> ibeaconlist = TableOperate <IBeaconData> .Select(value, condition);
for (int i = 0; i < list.Count; i++)
{
json += "{\"ID\":" + list[i].ID + ", \"name\":\"" + list[i].DevName + "\", \"stopTime\":\"" + GetStopTime(ibeaconlist, list[i].ID) + "\", \"Count\":\"" + list[i].X + "\"},";
}
json = json.Trim(',');
json += "]}";
}
else if (act == "rest")
{
string sql = "UPDATE IBeaconDev SET UserID = 0 WHERE ID >0";
TableOperate <IBeaconDev> .Execute(sql);
}
Response.Write(json);
}
