documentregistert.aspx.cs

很不错的公文流转系统

/**************************************************************************************
作者：蒲丰. 
创建日期：2004-2-14
修改者：
修改日期：
修改部分：
类功能： 内部文档登记
****************************/
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.ReceivDocument
{
	/// <summary>
	/// documentRegisterT 的摘要说明。
	/// </summary>
	public class documentRegisterT :OI.PageBase
	{
		protected System.Web.UI.WebControls.TextBox txtReceiveFileNumber;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.TextBox txtSendDepartment;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator5;
		protected System.Web.UI.WebControls.TextBox txtDocumentTitle;
		protected System.Web.UI.WebControls.TextBox txtDocumentCount;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator7;
		protected System.Web.UI.WebControls.DropDownList dstExigenceDegreeID;
		protected System.Web.UI.WebControls.TextBox txtBackDate;
		protected System.Web.UI.WebControls.TextBox txtReceivedeclare;
		protected System.Web.UI.WebControls.ImageButton imgbtnSave;
	    protected OI.DatabaseOper.DatabaseConnect Dbc=new OI.DatabaseOper.DatabaseConnect ();
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator9;
		protected System.Web.UI.WebControls.TextBox txtworkDepartment;
		protected System.Web.UI.WebControls.DropDownList SecretGreadid;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3; 
		protected OI.UserControls .DateOper DateReceiveDate ;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			
			if (Session["userid"]==null)
			{
				Response.Write  ("<script>top.location.href='../userpass.aspx'</script>");
				if (Session["userid"].ToString().IndexOf ("收文人员") <1)
				{
					Page.RegisterStartupScript ("","<script>alert('本模块只能由收文人员使用')</script>");
					Response.End ();
				}
			}
			if (ViewState["waitid"]==null)
			{
				ViewState["waitid"]=Request.Params ["waitid"].ToString ();
			}
			
			dafaultData_Bind();
		}
		private void dafaultData_Bind()
		{
			string str;
			try
			{
				int waitid=int.Parse (ViewState["waitid"].ToString ());
				str="select rw.*,sr.documentid,sr.documentTitle,d.Departmentname,sr.ExigenceDegreeID,sr.SecretGreadid " ;
				str += "from   receivewait rw , documentSendR  sr ,departments d " ;
				str +="  where rw.RegisterID=sr.RegisterID " ;
				str +="  and d.DepartmentID=sr.DepartmentID " ;
				str += "  and rw.waitid="+waitid.ToString ();
				DataSet ds=new DataSet ();
				ds=Dbc.getBinding (str,"t");
				if (ds.Tables[0].Rows.Count >0)
				{
					DataRow dr=ds.Tables[0].Rows[0];
                    txtSendDepartment.Text =dr["Departmentname"].ToString ();
					txtDocumentTitle.Text =dr["documentTitle"].ToString ();
					dstExigenceDegreeID_Bind(dr["ExigenceDegreeID"].ToString ());
					SecretGreadid_bind(dr["SecretGreadid"].ToString ());
					ViewState["documentid"]=dr["documentid"].ToString ();
				}
			}
			catch (Exception er)
			{
				Dbc.DataBaseClose();
				Response.Write (er.Message );
				Response.End ();
			}

		}

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

		}
		#endregion
		private void SecretGreadid_bind(string id)
		{
			string sql1=" select * from SecretGread ";
			DataSet ds1=Dbc.getBinding(sql1,"t1");
			SecretGreadid.DataSource=ds1.Tables["t1"];
			SecretGreadid.DataTextField="SecretGreadName";
			SecretGreadid.DataValueField="SecretGreadID";
			SecretGreadid.DataBind();
			SecretGreadid.Items .FindByValue (SecretGreadid.SelectedValue).Selected =false; 
			SecretGreadid.Items .FindByValue (id).Selected =true;
		}
		private void dstExigenceDegreeID_Bind(string id)
		{
			string sql=" select * from exigencedegree ";
			System.Data.DataSet ds=new DataSet ();
			ds=Dbc.getBinding (sql,"t");
			dstExigenceDegreeID.DataSource =ds.Tables[0];
			dstExigenceDegreeID.DataTextField =ds.Tables[0].Columns ["ExigenceDegreeName"].ToString ();
			dstExigenceDegreeID.DataValueField  =ds.Tables[0].Columns ["ExigenceDegreeid"].ToString ();
			dstExigenceDegreeID.DataBind ();
			dstExigenceDegreeID.Items .FindByValue (dstExigenceDegreeID.SelectedValue).Selected =false; 
			dstExigenceDegreeID.Items .FindByValue (id).Selected =true;
			
		}
//		private bool Check()
//		{
//			string  ruser= txtReceiveUser.Text .Trim ().Replace ("'","''");
//			if (int.Parse(Dbc.GetValueBySql ("select count(*) from Accounts_Users where UserName ='"+ruser+"'" ))>0) 
//			{
//				return true;
//			}
//			else
//			{
//				Response.Write ("收文用户不存在!<a href=\"#\" onclick=javascript:history.back()>返回</a> ");
//				Response.End ();
//				return false;
//			}
//		}
//		private int getuser()
//		{
//			string  ruser= txtReceiveUser.Text .Trim ().Replace ("'","''");
//			int userid=int.Parse(Dbc.GetValueBySql ("select userid from Accounts_Users where UserName ='"+ruser+"'" ));
//			if (userid >0) 
//			{
//				return userid ;
//			}
//			else
//			{
//				Response.Write ("收文用户不存在!<a href=\"#\" onclick=javascript:history.back()>返回</a> ");
//				Response.End ();
//				return 0;
//			}
//		}
		/// <summary>
		/// 新增
		/// </summary>
		private void Register()
		{
			string ReceiveFileNumber =txtReceiveFileNumber.Text.Trim().Replace ("'","''");
			string SendDepartment =txtSendDepartment.Text .Trim ().Replace ("'","''");
			string DocumentTitle =txtDocumentTitle.Text .Trim ().Replace ("'","''");
			string DocumentCount =txtDocumentCount.Text .Trim ().Replace ("'","''");
			//string ReceiveUser =txtReceiveUser.Text .Trim ().Replace ("'","''");
			string workDepartment =txtworkDepartment.Text .Trim ().Replace ("'","''");
			string Receivedeclare =txtReceivedeclare.Text .Replace ("'","''");
			string BackDate =txtBackDate.Text .Trim ().Replace ("'","''");
			string UpfilePath="" ;//UPFile().Trim ();
			string instr=" insert into receiveDocument    values('"+ReceiveFileNumber +"'" ;
			instr +=",'"+ DateReceiveDate.DATE +"'"; //
			instr +=",'"+ SendDepartment +"'";
			instr +=",'"+ DocumentTitle+"'";
			instr +=",'"+ DocumentCount +"'"; //份数
			instr +=",'"+ dstExigenceDegreeID.SelectedValue  +"'";
			instr +=",'"+ workDepartment +"'"; 
			instr +=","  +Session["userid"].ToString () ;   //收文用户;
			instr +=",'" + BackDate+"'";
			instr +=",'" + Receivedeclare+"'";
			instr +=",'" + UpfilePath +"'"; //上传路径
			instr +=",0 "; //还没完成
			instr +=","+int.Parse (ViewState["waitid"].ToString ());
			instr +=","+SecretGreadid.SelectedValue;
			instr +=" ) ";
			try
			{
				Dbc.ExecuteSQL (instr);
				cs.Message message=new OI.cs.Message ();
				message.finishOprate (int.Parse (Session["userid"].ToString ()),int.Parse (ViewState["documentid"].ToString() ),"末收文");
			}
			catch(Exception er)
			{
				//DelFile(UpfilePath);
				Response.Write ( er.Message +"<a href=\"#\" onclick=javascript:history.back()>返回</a> ");
				Response.End ();
			}
			Response.Redirect ("transmitNo.aspx");
		}

		private void imgbtnSave_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			
			//Check();
			Register();
			
		}
		/// <summary>
		/// 上传文件
		/// </summary>


	}
}