protected void Page_Load(object sender, EventArgs e) { View_Device condition = new View_Device(); View_Device value = new View_Device(); TypeID = GetIntKey("tid"); AreaID = GetIntKey("AreaID"); if (AreaID != 0) { condition.AreaID = AreaID; } string title = GetstringKey("name"); if (title != "") { condition.Name = "%" + title + "%"; condition.AddAttach("Name", "like"); } condition.ExhibitionID = AdminMethod.ExhibitionID; condition.TypeID = TypeID; m_tableManageList = TableOperate <View_Device> .SelectByPage(value, condition, "order by OrderID asc", PageSize, PageIndex, ref Count); tid.Value = TypeID + ""; name.Value = title; DataBind(); }
private void editDevice(int ID, string X, string Y) { try { View_Device condition = new View_Device(); condition.ID = ID; View_Device hot = TableOperate <View_Device> .GetRowData(condition);//查询是否存在 if (hot.ID > 0) { if (Request.Params["X"] == null) { X = null; } else { X = HttpUtility.UrlDecode(Request.Params["X"]); condition.X = double.Parse(X); } if (Request.Params["Y"] == null) { Y = null; } else { Y = HttpUtility.UrlDecode(Request.Params["Y"]); condition.Y = double.Parse(Y); } int mes = TableOperate <View_Device> .Update(condition); if (mes > 0) { Response.Write("\"errcode\":\"0\",\"msg\":\"ok\""); } else { Response.Write("\"errcode\":\"1\",\"msg\":\"false\""); } } else { Response.Write("\"errcode\":\"1\",\"msg\":\"无效参数\""); } } catch (Exception) { throw; } Response.End(); }
private void getDevice(int AreaID) { View_Device value = new View_Device(); View_Device condition = new View_Device(); if (!string.IsNullOrEmpty(this.Request["AreaID"])) { AreaID = Convert.ToInt32(Request["AreaID"]); condition.ID = AreaID; } List <View_Device> list = TableOperate <View_Device> .SelectByIdDesc(value, condition); string json = "{\"list\":["; for (int i = 0; i < list.Count; i++) { json += "{\"ID\":" + list[i].AreaID + ", \"X\":\"" + list[i].X + "\", \"Y\":\"" + list[i].Y + "\", \"AreaID\":" + list[i].AreaID + "},"; } json = json.Trim(','); json += "]}"; Response.Write(json); }
protected void Page_Load(object sender, EventArgs e) { string action = GetstringKey("action"); int ID = GetIntKey("ID"); int Tid = GetIntKey("tid"); int areaid = GetIntKey("areaid"); View_Device condition = new View_Device(); View_Device v = new View_Device(); if (ID == 0) { Response.Write(""); return; } condition.ID = ID; View_Device myView = TableOperate <View_Device> .GetRowData(v, condition); if (myView.ID == 0) { Response.Write(""); return; } View_Device condition2 = new View_Device(); View_Device V2 = new View_Device(); condition2.AddConditon(" and ID<>'" + condition.ID + "'"); condition2.ExhibitionID = AdminMethod.ExhibitionID; condition2.TypeID = Tid; if (areaid != 0) { condition2.AreaID = areaid; } string strOrder = string.Empty; condition2.OrderID = myView.OrderID; if (action == "up") { //向上,现在是时间越早越在上面 condition2.AddAttach("OrderID", "<"); strOrder = " order by OrderID DESC"; //时间从大到小 } else { condition2.AddAttach("OrderID", ">"); strOrder = " order by OrderID ASC"; } List <View_Device> desOrderMdl = TableOperate <View_Device> .Select(V2, condition2, 1, strOrder); if (desOrderMdl.Count != 1) { Response.Write(""); return; } Device conditionU = new Device(); conditionU.ID = myView.ID; conditionU.OrderID = desOrderMdl[0].OrderID; TableOperate <Device> .Update(conditionU); Device conditionU2 = new Device(); conditionU2.ID = desOrderMdl[0].ID; conditionU2.OrderID = myView.OrderID; TableOperate <Device> .Update(conditionU2); Response.StatusCode = 200; Response.Write(conditionU2.ID); }