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