message_yes.aspx.cs

企业网站前台后台源程序,用于大中小型企业网站后台程序开发

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using BLL;
using Socut.Data;
namespace Websystem.admin
{
	/// <summary>
	/// message_yes 的摘要说明。
	/// </summary>
	public class message_yes : System.Web.UI.Page
	{
			protected user us=new user();
		protected other ot=new other();
		protected System.Web.UI.WebControls.DataGrid MyDataGrid;
		protected System.Web.UI.WebControls.Label lblPageCount;
		protected System.Web.UI.WebControls.Label lblCurrentIndex;
		protected System.Web.UI.WebControls.LinkButton btnFirst1;
		protected System.Web.UI.WebControls.LinkButton btnPrev1;
		protected System.Web.UI.WebControls.LinkButton btnNext1;
		protected System.Web.UI.WebControls.LinkButton btnLast1;
		protected messages mes=new messages();
		private void Page_Load(object sender, System.EventArgs e)
		{
				
			ot.chk_user();
			btnFirst1.Text = "最首页";
			btnPrev1.Text = "前一页";
			btnNext1.Text = "下一页";
			btnLast1.Text = "最后页";
			if(!this.IsPostBack)
				BindGrid();
			if(ot.isDefined("delid"))
			{
				string[] rowid=Request.Form["delid"].ToString().Split(new char[]{','});
				for(int i=0;i<rowid.Length;i++)
				{
			
					delrow(Convert.ToInt32(rowid[i]));
				}
				Response.Redirect("message.aspx",true);

			}

	
			
		}
		//删除记录
		protected void delrow(int id)
		{
				CData myData=new CData();

			string sql="delete from MESSAGE where ID="+id;
			myData.GetExecuteNonQuery(sql);
			sql="delete from MESSAGE_again where  MESSAGE_id="+id;
			try
			{
				myData.GetExecuteNonQuery(sql);
			}
			catch
			{

			}

		}
		protected void BindGrid()
		{
			DataSet ds=new DataSet();
			CData myData=new CData();
			string sql = "";
//			sql = "select id,title,inputtime,user_name,user_EMAIL,USER_TEL from MESSAGE order by id desc";
			sql = "select id,title,inputtime,user_name,user_EMAIL,USER_TEL from MESSAGE,MESSAGE_again where id=MESSAGE_id order by id desc";
			ds = myData.GetDataSet(sql, 0, 0, "Document");
			this.MyDataGrid.DataSource = ds.Tables["Document"].DefaultView;
			MyDataGrid.DataBind();
					ShowStats();

		}
		/// <summary>
		/// 判断已经/没有回复数据刷选,1表示被回复,0表示没有被回复
		/// </summary>
		/// <param name="flog"></param>
		protected void BindGrid(int flog)
		{
			DataSet ds=new DataSet();
			CData myData=new CData();
			string sql = "";
			if(flog==0)
				sql = "select id,title,inputtime,user_name,user_EMAIL,USER_TEL from MESSAGE where (id NOT IN (Select MESSAGE_id From MESSAGE_again))  order by id desc";
			else
				sql = "select id,title,inputtime,user_name,user_EMAIL,USER_TEL from MESSAGE,MESSAGE_again where id=MESSAGE_id order by id desc";
			ds = myData.GetDataSet(sql, 0, 0, "Document");
			this.MyDataGrid.DataSource = ds.Tables["Document"].DefaultView;
			MyDataGrid.DataBind();
					ShowStats();

		}

	
		private void ShowStats()
		{
			lblCurrentIndex.Text = "第 " + (MyDataGrid.CurrentPageIndex + 1).ToString() + " 页";
			lblPageCount.Text = "总共 " + MyDataGrid.PageCount.ToString() + " 页";
		}

		public void PagerButtonClick(object sender, EventArgs e)
		{
			string arg = ((LinkButton)sender).CommandArgument.ToString();
			switch(arg)
			{
				case "next":
					if (MyDataGrid.CurrentPageIndex < (MyDataGrid.PageCount - 1))
					{
						MyDataGrid.CurrentPageIndex += 1;
					}
					break;
				case "prev":
					if (MyDataGrid.CurrentPageIndex > 0)
					{
						MyDataGrid.CurrentPageIndex -= 1;
					}
					break;
				case "last":
					MyDataGrid.CurrentPageIndex = (MyDataGrid.PageCount - 1);
					break;
				default:
					MyDataGrid.CurrentPageIndex = System.Convert.ToInt32(arg);
					break;
			}
			BindGrid();
			ShowStats();
		}


		public void MyDataGrid_Page(object sender, DataGridPageChangedEventArgs e)
		{
			int startIndex ;
			startIndex = MyDataGrid.CurrentPageIndex * MyDataGrid.PageSize;
			MyDataGrid.CurrentPageIndex = e.NewPageIndex;
			BindGrid();
			ShowStats();
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void MyDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

	
		//已经回复


		private void Button1_Click(object sender, System.EventArgs e)
		{
			BindGrid(1);
		}
		//没有回复
		private void Button2_Click(object sender, System.EventArgs e)
		{
			BindGrid(0);
		}
		//全部回复
		private void Button3_Click(object sender, System.EventArgs e)
		{
			BindGrid();
		}


		//全部回复
		private void RadioButton3_CheckedChanged(object sender, System.EventArgs e)
		{
			Response.Redirect("message.aspx");
		}
		//没有回复
		private void RadioButton2_CheckedChanged(object sender, System.EventArgs e)
		{
			Response.Redirect("message_no.aspx");
		}
		//已经回复
		private void RadioButton1_CheckedChanged(object sender, System.EventArgs e)
		{
			Response.Redirect("message_yes.aspx");
		}

	

	
	

	}
}