recordfilelistmodify.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 OI.recordFile
{
	/// <summary>
	/// recordFileListModify 的摘要说明。
	/// </summary>
	public class recordFileListModify : OI.PageBase
	{
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator8;
		protected System.Web.UI.WebControls.TextBox TextBoxTopicWord;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
		protected System.Web.UI.WebControls.TextBox TextBox1DocumentNumber;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
		protected System.Web.UI.WebControls.TextBox TextBoxDocumentHead;
		protected System.Web.UI.WebControls.DropDownList DropDownListExigenceDegreeID;
		protected System.Web.UI.WebControls.DropDownList DropDownListDocumentTypeID;
		protected System.Web.UI.WebControls.DropDownList SecretGreadID;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.TextBox TextBoxCopySendComp;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox TextBoxMainSendComp;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.TextBox TextBoxSendComp;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.Button BtnOpen;
	    protected OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		protected int RecordFileID;
		protected OI.UserControls .DateOper DateReceive ;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.ImageButton ImageButton2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.Label errorType;
		protected System.Web.UI.WebControls.Label errorSecret;
		protected System.Web.UI.WebControls.Label errorExige; 
		protected OI.Modules.String Opstring=new OI.Modules.String ();
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

			if (!Page.IsPostBack )
			{
				try
				{   
					RecordFileID=int.Parse(Request.QueryString ["id"].ToString ());
					ViewState["RecordFileID"]=RecordFileID.ToString ();
				}
				catch
				{
					Response.Redirect ("recordFileList.aspx");
				}
				
				DropdownlistBind(ref SecretGreadID,"select SecretGreadID,SecretGreadName from SecretGread","SecretGreadName","SecretGreadID");
				DropdownlistBind(ref DropDownListDocumentTypeID,"select DocumentTypeID,DocumentTypeName from VIEW_DocumentType","DocumentTypeName","DocumentTypeID");
				DropdownlistBind(ref DropDownListExigenceDegreeID,"select ExigenceDegreeID,ExigenceDegreeName from ExigenceDegree","ExigenceDegreeName","ExigenceDegreeID");
			    BindDefaultData();
			}
           
		}
		private void BindDefaultData()
		{
			string sql=" select * from  recordfile where RecordFileID="+RecordFileID;
			DataSet ds=new DataSet ();
			ds=Dbc.getBinding (sql,"t");
			DataRow dr=ds.Tables[0].Rows[0];

		    TextBoxSendComp.Text= dr["SendComp"].ToString ();
			TextBoxMainSendComp.Text =dr["MainSendComp"].ToString ();
			TextBoxCopySendComp.Text =dr["CopySendComp"].ToString ();
			TextBoxTitle.Text =dr["Title"].ToString ();
			TextBoxContent.Text =dr["Content"].ToString ();
			TextBoxDocumentHead.Text =dr["DocumentHead"].ToString ();
			TextBox1DocumentNumber.Text =dr["DocumentNumber"].ToString ();
			TextBoxTopicWord.Text =dr["TopicWord"].ToString ();
			DateReceive.Date =dr["RecordDate"].ToString ();
			SecretGreadID.Items .FindByValue (SecretGreadID.SelectedValue ).Selected =false;
			SecretGreadID.Items .FindByValue (dr["SecretGreadID"].ToString ()).Selected =true;
			DropDownListDocumentTypeID.Items .FindByValue (DropDownListDocumentTypeID.SelectedValue ).Selected =false;
			DropDownListDocumentTypeID.Items .FindByValue (dr["DocumentTypeID"].ToString () ).Selected =true;
			DropDownListExigenceDegreeID.Items .FindByValue (DropDownListExigenceDegreeID.SelectedValue ).Selected =false;
			DropDownListExigenceDegreeID.Items .FindByValue (dr["ExigenceDegreeID"].ToString () ).Selected =true;

			if (dr["filepath"].ToString () !="")
			{
				string path=OI.Modules.Config.GetSetting("ReadDocuments")+"/"+ dr["FilePath"].ToString ();
				//path =Request.ServerVariables["REMOTE_HOST"].ToString ()+path+"/"+ dr["FilePath"].ToString ();				
				BtnOpen.Attributes["onclick"]="return openit('"+path+"');";
			}
			else
			{
				BtnOpen.Enabled =false;
			}

		}
		private void ButtonOK_Click(object sender, System.EventArgs e)
		{
			if (SecretGreadID.SelectedValue =="000")
			{
				Page.RegisterStartupScript ("","<script>alert('请选择密级');</script>");
				return ;
			}
			if (DropDownListDocumentTypeID.SelectedValue =="000")
			{
				Page.RegisterStartupScript ("","<script>alert('请选择公文类别');</script>");
				return ;
			}
			if (DropDownListExigenceDegreeID.SelectedValue =="000")
			{
				Page.RegisterStartupScript ("","<script>alert('请选择紧急程度');</script>");
				return ;
			}
			//for (int i=0; i<Request.Params.Count ;i++)
		//	{
		//		Request.Params[i].=Request.Params[i].Replace ("'","''");
		//	}
			string sql=" update recordfile set SendComp='" +TextBoxSendComp.Text +"',";
		    sql    +=  " MainSendComp='"+  TextBoxMainSendComp.Text.Replace ("'","''") +"'," ;
			sql    +=  " CopySendComp='"+TextBoxCopySendComp.Text.Replace ("'","''") +"',";
			sql    +=  " userid="+ Session["userid"].ToString () + ",";
			sql    +=  " Title='"+ TextBoxTitle.Text.Replace ("'","''") +"',";
			sql    +=  " Content='"+TextBoxContent.Text.Replace ("'","''") +"'," ;
			sql    +=  " RecordDate='"+DateReceive.DATE  +"',";
			sql    +=  " InputDate ='" + System.DateTime .Now +"'," ;
			sql    +=  " SecretGreadID="+SecretGreadID.SelectedValue +"," ;
			sql    +=  " DocumentTypeID=" +DropDownListDocumentTypeID.SelectedValue +","  ;
			sql    +=  " ExigenceDegreeID =" +DropDownListExigenceDegreeID.SelectedValue +",";
			sql    +=  " DocumentHead='"+ TextBoxDocumentHead.Text.Replace ("'","''") +"'," ;
			sql    +=  " DocumentNumber='" +TextBox1DocumentNumber.Text.Replace ("'","''") +"',";
			sql    +=  " TopicWord ='" +TextBoxTopicWord.Text.Replace ("'","''") +"'";
			sql    +=  " where RecordFileID="+ViewState["RecordFileID"].ToString (); ;
            Dbc.ExecuteSQL (sql);
    		Response.Redirect ("recordFileList.aspx");
		}
		public void DropdownlistBind (ref DropDownList dst,string sql,string TextField,string Values)
		{
			DataSet ds=new DataSet ();
			ds=Dbc.getBinding (sql,"T");
			if (ds.Tables[0].Rows.Count >0)
			{
				dst.DataSource =ds.Tables[0].DefaultView;
				dst.DataTextField=ds.Tables[0].Columns[TextField].ToString () ;
				dst.DataValueField =ds.Tables[0].Columns [Values].ToString ();
				dst.DataBind ();
			}
			ListItem li=new ListItem ("请选择","000");
			dst.Items.Insert (0,li);
			//dst.Items.i
		}

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

		}
		#endregion

		private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			Response.Redirect ("recordFileList.aspx");
		}

		private void ImageButton2_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			if (SecretGreadID.SelectedValue =="000")
			{
				errorSecret.Visible =true;
				return ;
			}
			else
				errorSecret.Visible =false;
			if (DropDownListDocumentTypeID.SelectedValue =="000")
			{
				errorType.Visible =true;
				return ;
			}
			else
				errorType.Visible =false;
			if (DropDownListExigenceDegreeID.SelectedValue =="000")
			{
				errorExige.Visible =true;
				return ;
			}
			else
				errorExige.Visible =false;
			//for (int i=0; i<Request.Params.Count ;i++)
			//	{
			//		Request.Params[i].=Request.Params[i].Replace ("'","''");
			//	}
			string sql=" update recordfile set SendComp='" +TextBoxSendComp.Text +"',";
			sql    +=  " MainSendComp='"+  TextBoxMainSendComp.Text.Replace ("'","''") +"'," ;
			sql    +=  " CopySendComp='"+TextBoxCopySendComp.Text.Replace ("'","''") +"',";
			sql    +=  " userid="+ Session["userid"].ToString () + ",";
			sql    +=  " Title='"+ TextBoxTitle.Text.Replace ("'","''") +"',";
			sql    +=  " Content='"+TextBoxContent.Text.Replace ("'","''") +"'," ;
			sql    +=  " RecordDate='"+DateReceive.DATE  +"',";
			sql    +=  " InputDate ='" + System.DateTime .Now +"'," ;
			sql    +=  " SecretGreadID="+SecretGreadID.SelectedValue +"," ;
			sql    +=  " DocumentTypeID=" +DropDownListDocumentTypeID.SelectedValue +","  ;
			sql    +=  " ExigenceDegreeID =" +DropDownListExigenceDegreeID.SelectedValue +",";
			sql    +=  " DocumentHead='"+ TextBoxDocumentHead.Text.Replace ("'","''") +"'," ;
			sql    +=  " DocumentNumber='" +TextBox1DocumentNumber.Text.Replace ("'","''") +"',";
			sql    +=  " TopicWord ='" +TextBoxTopicWord.Text.Replace ("'","''") +"'";
			sql    +=  " where RecordFileID="+ViewState["RecordFileID"].ToString (); ;
			Dbc.ExecuteSQL (sql);
			Response.Redirect ("recordFileList.aspx");
		}

		
	}
}