messagelist.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;

namespace HTMS.Web.SysManage.MessaeManage
{
	/// <summary>
	/// MessageList 的摘要说明。
	/// </summary>
	public class MessageList : HTMS.Web.CompanySysMange.BasePage
	{
		protected System.Web.UI.WebControls.DropDownList state;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit3;
		protected HTMS.Web.AspNetPager.AspNetPager AspNetPager1;
		protected System.Web.UI.WebControls.DropDownList messageclass;
		protected System.Web.UI.HtmlControls.HtmlInputText title;
		protected System.Web.UI.HtmlControls.HtmlInputText Requestor;
		protected System.Web.UI.HtmlControls.HtmlInputText receivor;
		protected System.Web.UI.HtmlControls.HtmlInputText MessageContent;
		protected System.Web.UI.HtmlControls.HtmlInputHidden RequestorID;
		protected System.Web.UI.HtmlControls.HtmlInputHidden receivorID;
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
	
		private string MyCompanyID
		{
			get{return Convert.ToString(this.ViewState["MyCompanyID"]);}
			set{this.ViewState["MyCompanyID"]=value;}
		}

		private string Identity
		{
			get{return Convert.ToString(this.ViewState["Identity"]);}
			set{this.ViewState["Identity"]=value;}
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			base.ClearCache();
			if(!base.UserPageCheck())
			{return;}
			if(!Page.IsPostBack)
			{
			//	this.ShowData();
				this.Label1.Visible=true;
				this.MyCompanyID=Convert.ToString(this.Session["CompanyID"]);
				this.Label1.Text=this.GetWhereString();	
				this.ShowData();
			}
		}

		private void ShowData()
		{
			this.AspNetPager1.RecordCount=Common.DataPager.GetPageCount("Sys_Message",this.GetWhereString());
			//System.Data.DataTable mytable=new System.Data.DataTable();//Common.DataPager.GetPageData("Sys_Message","*","MessageID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,1,this.GetWhereString());
			System.Data.DataTable mytable=Common.DataPager.GetPageData("Sys_Message","*","MessageID",this.AspNetPager1.PageSize,this.AspNetPager1.CurrentPageIndex,0,this.GetWhereString());
			this.DataGrid1.DataSource=mytable;
			this.DataGrid1.DataBind();
			AspNetPager1.CustomInfoText = "记录总数：<font color=\"blue\"><b>" + AspNetPager1.RecordCount.ToString() + "</b></font>";
			AspNetPager1.CustomInfoText += " 总页数：<font color=\"blue\"><b>" + AspNetPager1.PageCount.ToString() + "</b></font>";
			AspNetPager1.CustomInfoText += " 当前页：<font color=\"red\"><b>" + AspNetPager1.CurrentPageIndex.ToString() + "</b></font>";
		}
		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.DataGrid1.PreRender += new System.EventHandler(this.DataGrid1_PreRender);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.AspNetPager1.PageChanged += new HTMS.Web.AspNetPager.PageChangedEventHandler(this.AspNetPager1_PageChanged);
			this.Submit3.ServerClick += new System.EventHandler(this.Submit3_ServerClick);
			this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void AspNetPager1_PageChanged(object src, HTMS.Web.AspNetPager.PageChangedEventArgs e)
		{
			this.AspNetPager1.CurrentPageIndex=e.NewPageIndex;
			this.AspNetPager1.PageSize=e.NewPageSize;
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string MessageID=e.Item.Cells[0].Text;
			if(e.CommandName=="view")
			{
				Common.Windows.OpenModalWindow(this,"MsgDetails.aspx?MessageID="+e.Item.Cells[0].Text,500,500);return;
			}

			if(e.CommandName=="sendback")
			{
				this.Response.Redirect("sendBack.aspx?MessageID="+MessageID);return;
			}

			if(e.CommandName=="delete")
			{
				string isme="";
				if(e.Item.Cells[9].Text==this.MyCompanyID)
				{
					isme=" IsRequestDelete = '1'";   //发送方的操作
				}
				else
				{isme=" IsReponseDelete = '1' ";}     //接收方的操作
				
				string sqlstring="";
				if(e.Item.Cells[11].Text=="1" || e.Item.Cells[12].Text=="1")  //不论是那一方的操作，只要已经有一方删除了，消息那么就要删除这个数据
				{
					sqlstring="delete Sys_Message where MessageID = '"+MessageID+"'";
				}
				else
				{															//没有删除的操作,就更新数据库状态
					sqlstring="update Sys_Message set "+isme+" where MessageID = '"+MessageID+"'";
				}
				HTMS.SQLServerDAL.DAL.DAI.RunSqlNonQuery(sqlstring);
				this.ShowData();
			}
		}
		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==System.Web.UI.WebControls.ListItemType.Item)
			{
				((System.Web.UI.WebControls.LinkButton)e.Item.Cells[8].Controls[3]).Attributes.Add("onclick","return confirm('确定要删除吗?')");
			}
	}

		private void Submit3_ServerClick(object sender, System.EventArgs e)
		{
			this.Response.Redirect("SendingMessage.aspx");
		}

		private string GetWhereString()
		{
			System.Text.StringBuilder mybuilder=new System.Text.StringBuilder();
			if(this.title.Value!="")
			{
				mybuilder.Append(" MessageTitle like '%"+this.title.Value.Replace(" ","%")+"%' and ");
			}
			if(this.state.SelectedValue!="-1")
			{
				if(this.state.SelectedValue!="2")
					mybuilder.Append(" IsReponse = '"+this.state.SelectedValue+"' and ");
				else
					mybuilder.Append(" Param = '0' and IsReponse = '1' and");
			}
			if(this.messageclass.SelectedValue!="-1")
			{
				string myvalue=this.messageclass.SelectedValue;				
				switch(myvalue)
				{
					case "0":
						myvalue=" (ToCompanyID ='0' or RequestUserID = '0') and";break;
					case "1":
						myvalue=" (ToCompanyID ='"+this.MyCompanyID+"') and";break;
					case "2":
						myvalue=" (RequestUser ='"+this.MyCompanyID+"') and";break;
					default:
						myvalue="";break;
				}
				mybuilder.Append(myvalue);
			}
			if(this.Requestor.Value!="")
			{
				mybuilder.Append(" RequestUser = '"+this.RequestorID.Value+"' and");
			}
			if(this.receivor.Value!="")
			{
				mybuilder.Append(" ToCompanyName = '"+this.receivorID.Value+"' and");
			}
			if(this.MessageContent.Value!="")
			{
				mybuilder.Append(" (RequestContent like '%"+this.MessageContent.Value.Replace(" ","%")+"%' or ResponseContent like '%"+this.MessageContent.Value.Replace(" ","%")+"%') and");
			}
			mybuilder.Append(" (RequestUserID='"+this.MyCompanyID+"'or ToCompanyID ='"+this.MyCompanyID+"') and ((RequestUserID='"+this.MyCompanyID+"' and IsRequestDelete ='0' ) or ToCompanyID ='"+this.MyCompanyID+"' and IsReponseDelete ='0' )");
			return mybuilder.ToString();
		}		

		private void Submit1_ServerClick(object sender, System.EventArgs e)
		{
			this.Label1.Text=this.GetWhereString();
		 	this.ShowData();
		}

		private void DataGrid1_PreRender(object sender, System.EventArgs ee)
		{
			//Common.Common.ShowMessageBox(this.DataGrid1.Items.Count.ToString());
			for(int i=0;i<this.DataGrid1.Items.Count;i++)
			{	System.Web.UI.WebControls.DataGridItem e=this.DataGrid1.Items[i];					
				string mvyalues=e.Cells[0].Text;
				//if(e.ItemType == System.Web.UI.WebControls.ListItemType.Item)
				{

					System.Web.UI.WebControls.LinkButton mybutton=(System.Web.UI.WebControls.LinkButton)e.Cells[8].Controls[1];
					System.Web.UI.WebControls.Label mylabel=(System.Web.UI.WebControls.Label)e.Cells[7].Controls[3];
				
					string myvalue1=e.Cells[13].Text;
					string myvalue2=e.Cells[9].Text;
					string myvalue3=this.MyCompanyID;
				
					if(e.Cells[13].Text=="0" && e.Cells[9].Text==this.MyCompanyID)
					{
						mylabel.Text=" 待回复";
					}
					else if(e.Cells[13].Text =="1" && e.Cells[9].Text==this.MyCompanyID)
					{	
						mylabel.Text=" 已回复";
					}
				
					mybutton.Visible=false;
					string myvalue4=e.Cells[10].Text;
					myvalue3=this.MyCompanyID;
					if(e.Cells[13].Text=="0" && e.Cells[10].Text==this.MyCompanyID)
					{
						mybutton.Visible=true;
					}
				}
			}
		}
	}
}