/// <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); }