Exemple #1
0
    protected void Page_Load(object sender, EventArgs e)
    {
        View_News condition = new View_News();
        View_News value     = new View_News();
        string    title     = GetstringKey("name");

        PCID = GetIntKey("pcid");
        if (title != "")
        {
            condition.Title = "%" + title + "%";
            condition.AddAttach("Title", "like");
        }
        if (PCID != 0)
        {
            condition.PcID = PCID;
        }
        condition.ExhibitionID = AdminMethod.ExhibitionID;
        condition.TypeID       = 0;
        m_tableManageList      = TableOperate <View_News> .SelectByPage(value, condition, "order by  OrderID asc", PageSize, PageIndex, ref Count);

        Counts = TableOperate <View_News> .GetCountValue(condition);

        DataBind();
        name.Value = title;
    }
    protected void Page_Load(object sender, EventArgs e)
    {
        string action = GetstringKey("action");

        bool isUp = false;


        string ID = Request["ID"];

        View_News condition = new View_News();
        View_News v         = new View_News();

        if (string.IsNullOrEmpty(ID))
        {
            Response.Write("");
            return;
        }

        condition.ID = Convert.ToInt32(ID);
        View_News myView = TableOperate <View_News> .GetRowData(v, condition);

        if (myView.ID == 0)
        {
            Response.Write("");
            return;
        }

        View_News condition2 = new View_News();
        View_News V2         = new View_News();

        condition2.AddConditon(" and ID<>'" + condition.ID + "'");
        condition2.PcID = myView.PcID;
        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_News> desOrderMdl = TableOperate <View_News> .Select(V2, condition2, 1, strOrder);

        if (desOrderMdl.Count != 1)
        {
            Response.Write("");
            return;
        }


        News conditionU = new News();

        conditionU.ID      = myView.ID;
        conditionU.OrderID = desOrderMdl[0].OrderID;
        TableOperate <News> .Update(conditionU);

        News conditionU2 = new News();

        conditionU2.ID      = desOrderMdl[0].ID;
        conditionU2.OrderID = myView.OrderID;
        TableOperate <News> .Update(conditionU2);

        CloudSQL.UpdataVesion(myView.PcID);
        Response.StatusCode = 200;
        Response.Write(conditionU2.ID);
    }