recordfilelistadd.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 System.IO ;
using System.Diagnostics;
using OI;

namespace OI.recordFile
{
	/// <summary>
	/// recordFileListAdd 的摘要说明。
	/// </summary>
	public class recordFileListAdd : OI.PageBase
	{
		protected System.Web.UI.HtmlControls.HtmlInputFile upfile;
		protected System.Web.UI.WebControls.TextBox TextBoxTitle;
		protected System.Web.UI.WebControls.TextBox TextBoxSendComp;
		protected System.Web.UI.WebControls.TextBox TextBoxMainSendComp;
		protected System.Web.UI.WebControls.DropDownList SecretGreadID;
		protected System.Web.UI.WebControls.DropDownList DropDownListDocumentTypeID;
		protected System.Web.UI.WebControls.DropDownList DropDownListExigenceDegreeID;
		protected System.Web.UI.WebControls.TextBox TextBoxDocumentHead;
		protected System.Web.UI.WebControls.TextBox TextBox1DocumentNumber;
		protected System.Web.UI.WebControls.TextBox TextBoxTopicWord;
		protected System.Web.UI.WebControls.TextBox TextBoxContent;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator4;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator6;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator8;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
		protected System.Web.UI.WebControls.TextBox TextBoxCopySendComp;
	    protected OI.DatabaseOper .DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		protected System.Web.UI.WebControls.ImageButton ButtonOK;
		protected System.Web.UI.WebControls.Label errorType;
		protected System.Web.UI.WebControls.Label errorSecret;
		protected System.Web.UI.WebControls.Label errorExige;
		protected System.Web.UI.WebControls.Label errorUpfile;
        protected OI.UserControls.DateOper DateResend;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if (Session["userid"]==null)
			{
				Response.Redirect ("userpass.aspx");
			}
			if (!Page.IsPostBack )
			{
				//string str=" select SecretGreadID,SecretGreadName from secretgread  ";
				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");
			}
		}

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

		}
		#endregion

	/*	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 ;
			}

			string filename=UPFile();
			if (filename=="false")
			{
				Page.RegisterStartupScript ("",@"<script>alert ('附件上传失败!\r\n请检查是否正确配置路径,权限是否正确')</script>");
				return ;
			}
			string sql =  " insert into recordfile values ('"+TextBoxSendComp.Text + "','" ;
                   sql +=  TextBoxMainSendComp.Text.Replace ("'","''") + "','" ;
                   sql +=  TextBoxCopySendComp.Text.Replace ("'","''") + "',";
                   sql +=  Session["userid"].ToString () + ",'";
                   sql +=  TextBoxTitle.Text.Replace ("'","''") +"','" ;
                   sql +=  TextBoxContent.Text.Replace ("'","''") +"','";
			       sql +=  DateResend.DATE  +"','";
                 //  sql +=  DateResend.Text +"','";
                   sql +=  System.DateTime .Now +"',";
                   sql +=  SecretGreadID.SelectedValue   +",";
                   sql +=  DropDownListDocumentTypeID.SelectedValue  +",";
                   sql +=  DropDownListExigenceDegreeID.SelectedValue  +",'";
                   sql +=  TextBoxDocumentHead.Text.Replace ("'","''") +"','";
                   sql +=  TextBox1DocumentNumber.Text.Replace ("'","''") +"','";
                   sql +=  TextBoxTopicWord.Text.Replace ("'","''") +"','";
                   sql +=  filename+ "')"; 
			 Dbc.ExecuteSQL (sql);
			Response.Redirect ("recordFileList.aspx");
 	}*/
		private string UPFile()
		{
			HttpPostedFile upfiles=upfile.PostedFile ;
			if (upfiles.ContentLength >0)
			{
			    string fileName;
				string path =Server.MapPath(OI.Modules.Config.GetSetting("documents")); //reportAccessories
				try
				{
					
					fileName=OI.Modules.FileName.NewFileName(upfiles.FileName);
			    	upfiles.SaveAs (path+"\\"+fileName) ;
				}
				catch(System.Exception e)
				{
					fileName="false";
					throw new AppException("路径错误:"+path, e);
					
				}
				return fileName;
			}
			else
			{
				return "";
			}
		}
		
		private 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);
			
		}

		private void ButtonOK_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;

			string filename=UPFile();
			if (filename=="false")
			{
				errorUpfile.Visible =true;
				return ;
			}
			else
				errorUpfile.Visible =false;
			string sql =  " insert into recordfile values ('"+TextBoxSendComp.Text + "','" ;
			sql +=  TextBoxMainSendComp.Text.Replace ("'","''") + "','" ;
			sql +=  TextBoxCopySendComp.Text.Replace ("'","''") + "',";
			sql +=  Session["userid"].ToString () + ",'";
			sql +=  TextBoxTitle.Text.Replace ("'","''") +"','" ;
			sql +=  TextBoxContent.Text.Replace ("'","''") +"','";
			sql +=  DateResend.DATE  +"','";
			//  sql +=  DateResend.Text +"','";
			sql +=  System.DateTime .Now +"',";
			sql +=  SecretGreadID.SelectedValue   +",";
			sql +=  DropDownListDocumentTypeID.SelectedValue  +",";
			sql +=  DropDownListExigenceDegreeID.SelectedValue  +",'";
			sql +=  TextBoxDocumentHead.Text.Replace ("'","''") +"','";
			sql +=  TextBox1DocumentNumber.Text.Replace ("'","''") +"','";
			sql +=  TextBoxTopicWord.Text.Replace ("'","''") +"','";
			sql +=  filename+ "',0)"; 
			Dbc.ExecuteSQL (sql);
			Response.Redirect ("recordFileList.aspx");
		}
	}
}