zxjlq.aspx.cs

人才交流的页面 适合人才网的后台试用哦！！！

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using NetCMS.Config;
using NetCMS.Model;
using NetCMS.DALProfile;

namespace NetCMS.Web.manage.news
{
    public partial class zxjlq : System.Web.UI.Page
    {
        public int pages=20;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                Cop_IsNotPass();
            }
        }
        void Cop_IsNotPass()
        {
            int curpage = Convert.ToInt32(this.labPage.Text);
            string keywords = this.TextBox1.Text.ToString();
            if (keywords!="")
            {
                keywords = "topic like '%" + keywords + "%'";
            } 
            else
            {
                keywords = "1=1";
            }
            string cop_usersql = @"SELECT DS_News.id,DS_News.Topic, DS_User.User_Name, DS_News.Flag, DS_News.AddTime
FROM DS_News inner JOIN
      DS_User ON DS_News.User_Id = DS_User.User_Id
WHERE (DS_News.From_Id = 0) and " +keywords+" ORDER BY DS_News.AddTime DESC";
            string sql = "";
            if (curpage == 1)
            {
                sql = "SELECT top "+pages+" DS_News.id,DS_News.Topic, DS_News.Flag, DS_News.AddTime FROM DS_News WHERE (DS_News.From_Id = -1) and " + keywords + " ORDER BY DS_News.AddTime DESC";
            }
            else
            {
                int tops = (curpage - 1) * pages;
                sql = "SELECT top " + pages + " DS_News.id,DS_News.Topic, DS_User.User_Name, DS_News.Flag, DS_News.AddTime FROM DS_News  WHERE DS_News.id<(select min(id) from (SELECT top " + tops + " DS_News.id FROM DS_News LEFT OUTER JOIN DS_User ON DS_News.User_Id = DS_User.User_Id WHERE (DS_News.From_Id = -1) and " + keywords + " ORDER BY DS_News.AddTime DESC) as t) and (DS_News.From_Id = -1) and " + keywords + " ORDER BY DS_News.AddTime DESC";
            }
            CommandType test = CommandType.Text;
            DataTable cop_usertable = DbHelper.ExecuteTable(DBConfig.CmsConString, test, cop_usersql);
            DataTable newslisttable = DbHelper.ExecuteTable(DBConfig.CmsConString, test, sql);
            this.DataList1.DataSource = newslisttable;
            this.DataList1.DataBind();
            
            PagedDataSource ps = new PagedDataSource();
            //DataSet dss = new DataSet();
            //dss.Tables.Add(cop_usertable);

            ps.DataSource = cop_usertable.DataSet.Tables[0].DefaultView;
            ps.AllowPaging = true;
            ps.PageSize = pages;//每页显示数量
            ps.CurrentPageIndex = curpage - 1;
            this.lnkbtnUp.Enabled = true;
            this.lnkbtnNext.Enabled = true;
            this.lnkbtnBack.Enabled = true;
            this.lnkbtnOne.Enabled = true;
            if (curpage == 1)
            {
                this.lnkbtnOne.Enabled = false;//不显示第一页按钮
                this.lnkbtnUp.Enabled = false;//不显示上一页按钮
            }
            if (curpage == ps.PageCount)
            {
                this.lnkbtnNext.Enabled = false;//不显示下一页
                this.lnkbtnBack.Enabled = false;//不显示最后一页
            }
            this.labBackPage.Text = Convert.ToString(ps.PageCount);
            if (this.labBackPage.Text == "")
            {
                this.lnkbtnUp.Enabled = false;
                this.lnkbtnNext.Enabled = false;
                this.lnkbtnBack.Enabled = false;
                this.lnkbtnOne.Enabled = false;
            }
        }

        protected void lnkbtnOne_Click(object sender, EventArgs e)
        {
            this.labPage.Text = "1";
             Cop_IsNotPass();
        }
        protected void lnkbtnUp_Click(object sender, EventArgs e)
        {
            this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) - 1);
            Cop_IsNotPass();

        }
        protected void lnkbtnNext_Click(object sender, EventArgs e)
        {
            this.labPage.Text = Convert.ToString(Convert.ToInt32(this.labPage.Text) + 1);
            Cop_IsNotPass();
            
        }
        protected void lnkbtnBack_Click(object sender, EventArgs e)
        {
            this.labPage.Text = this.labBackPage.Text;
            Cop_IsNotPass();
        }

        protected void Button2_Click(object sender, EventArgs e)
        {
            this.labPage.Text = "1";
            string keywords = this.TextBox1.Text == null ? "" : this.TextBox1.Text.ToString();
            if (keywords == "")
            {
                Response.Write("<script>alert('请输入关键字！');history.go(-1);</script>");
            }
            else
            {
                Cop_IsNotPass();
            } 
        }

        protected void DelP_Click(object sender, EventArgs e)
        {
            string dxs_copid = Request.Form["vote_checkbox"] == null ? "" : Request.Form["vote_checkbox"].ToString();
            if (dxs_copid == "")
            {
                Response.Write("<script>alert('请选择删除项！');history.back();</script>");
            }
            else
            {
                string delsql = "delete from ds_news where id in (" + dxs_copid + ")";
                int row = DbHelper.ExecuteNonQuery(DBConfig.CmsConString, CommandType.Text, delsql);
                if (row > 0)
                {
                    Response.Write("<script>alert('删除成功！');location.href='zxjlq.aspx';</script>");
                }
                else
                {
                    Response.Write("<script>alert('删除失败！');history.back();</script>");
                }
            }

        }

        public string checkan(string flag)
        {
            string types = "";
            if(flag=="0")
            {
                types = "未回复";
            }
            else if(flag=="1")
            {
                types = "已回复";
            }
            else if (flag == "2")
            {
                types="已推荐";
            }
            else
            {
                types = "未回复";
            }
            return types;

        }

        public string checkhit(string flag)
        {
            string types = "";
            if (flag == "0" || flag == "1")
            {
                types = "推荐";
            }

            else if (flag == "2")
            {
                types = "取消推荐";
            }
            return types;

        }

        public string checkaction(string flag)
        {
            string types = "";
            if (flag == "0" || flag == "1")
            {
                types = "tj";
            }

            else if (flag == "2")
            {
                types = "qxtj";
            }
            return types;

        }
    }
}