contractcontrol.aspx.cs

用ASP.NET做的合同管理系统,该系统包括合同进展控制模块,员工管理模块,客户管理模块,项目管理模块,合同管理模块和合同统计模块等.

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.Configuration ;
using System.Data .SqlClient;


namespace TMS
{
	/// <summary>
	/// ContractControl 的摘要说明。
	/// </summary>
	public class ContractControl : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox tbx_cemail;
		protected System.Web.UI.WebControls.TextBox tbx_ctax;
		protected System.Web.UI.WebControls.TextBox tbx_caccount;
		protected System.Web.UI.WebControls.TextBox tbx_cbank;
		protected System.Web.UI.WebControls.TextBox tbx_ctel;
		protected System.Web.UI.WebControls.TextBox tbx_ccontactperson;
		protected System.Web.UI.WebControls.TextBox tbx_caddress;
		protected System.Web.UI.WebControls.TextBox tbx_cname;
		protected System.Web.UI.WebControls.TextBox tbx_pmanager;
		protected System.Web.UI.WebControls.TextBox tbx_psumofmoney;
		protected System.Web.UI.WebControls.TextBox tbx_pcharacter;
		protected System.Web.UI.WebControls.TextBox tbx_pname;
		protected System.Web.UI.WebControls.TextBox tbx_pid;
		protected System.Web.UI.WebControls.TextBox tbx_ttotalmoney;
		protected System.Web.UI.WebControls.TextBox tbx_tenddate;
		protected System.Web.UI.WebControls.TextBox tbx_tbegindate;
		protected System.Web.UI.WebControls.TextBox tbx_tid;
		protected System.Web.UI.WebControls.RadioButton rtn_finished;
		protected System.Web.UI.WebControls.RadioButton rtn_moneygetted;
		protected System.Web.UI.WebControls.RadioButton rtn_interruptted;
		protected System.Web.UI.WebControls.Button btn_submit;
		protected System.Web.UI.WebControls.TextBox tbx_treadymoney;
		protected System.Web.UI.WebControls.TextBox tbx_getmoney;
		protected System.Web.UI.WebControls.TextBox tbx_describe;
		protected System.Web.UI.WebControls.TextBox tbx_tstate;
		protected System.Web.UI.WebControls.RangeValidator rv_getmoney;
		protected System.Web.UI.WebControls.HyperLink hlk_contractlist;
		protected System.Web.UI.WebControls.TextBox tbx_cid;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			//绑定各TextBox数据
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的TMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			cn.Open ();
			SqlCommand cm=new SqlCommand  ("contractdetailforcontrol",cn);
			cm.CommandType =CommandType .StoredProcedure ;
			cm.Parameters .Add ("@TID",SqlDbType.VarChar );
			cm.Parameters ["@TID"].Value =Request.QueryString ["tid"].ToString ();
			SqlDataReader dr=cm.ExecuteReader ();
			if(dr.Read ())//存在对应项
			{//绑定客户信息
				tbx_cid.Text =dr["cid"].ToString ();
				tbx_cname.Text =dr["cname"].ToString ();
				tbx_caddress.Text =dr["caddress"].ToString ();
				tbx_ctel.Text =dr["ctel"].ToString ();
				tbx_ccontactperson.Text=dr["ccontactperson"].ToString ();
				tbx_cbank.Text=dr["cbank"].ToString ();
				tbx_caccount.Text=dr["caccount"].ToString ();
				tbx_cemail.Text=dr["cemail"].ToString ();
				tbx_ctax.Text=dr["ctax"].ToString ();
			//绑定项目信息
				tbx_pid.Text =dr["pid"].ToString ();
				tbx_pname.Text =dr["pname"].ToString ();
				tbx_pcharacter.Text =dr["pcharacter"].ToString ();
				tbx_psumofmoney.Text =dr["psumofmoney"].ToString ();
				tbx_pmanager.Text=dr["pmanager"].ToString ();
			////绑定合同信息
				tbx_tid.Text =dr["tid"].ToString ();
				if(dr["tstate"].ToString ()=="1") tbx_tstate.Text ="生效中";
				else if(dr["tstate"].ToString ()=="2") 
				{
					tbx_tstate.Text ="已完成";
					btn_submit.Enabled =false;//状态不可再修改
				}
				else if(dr["tstate"].ToString ()=="3")
				{
					tbx_tstate.Text ="被终止";
					btn_submit.Enabled =false;//状态不可再修改
				}
				//只要日期信息的年+月+日
				tbx_tbegindate.Text =Convert.ToDateTime (dr["tbegindate"].ToString ()).Year.ToString ()+"-"+Convert.ToDateTime (dr["tbegindate"].ToString ()).Month.ToString ()+"-"+Convert.ToDateTime (dr["tbegindate"].ToString ()).Day .ToString ();
				tbx_tenddate.Text =Convert.ToDateTime (dr["tenddate"].ToString ()).Year .ToString ()+"-"+Convert.ToDateTime (dr["tenddate"].ToString ()).Month.ToString ()+"-"+Convert.ToDateTime (dr["tenddate"].ToString ()).Day.ToString () ;
				tbx_ttotalmoney.Text =dr["ttotalmoney"].ToString ();
				tbx_treadymoney.Text =dr["treadymoney"].ToString ();
			}
			else
			{
				Response.Write ("对不起，没有该合同信息");
				Response.End ();
			}
		}
	//进行控制操作
		private void btn_submit_Click(object sender, System.EventArgs e)
		{
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的TMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			cn.Open ();
			SqlCommand cm=new SqlCommand  ("ContractModifyForControl",cn);
			cm.CommandType =CommandType .StoredProcedure ;
			cm.Parameters .Add ("@TID",SqlDbType.VarChar );
			cm.Parameters ["@TID"].Value =tbx_tid.Text.ToString ();
			SqlCommand cm1=new SqlCommand  ("ContractProgressInforAdd",cn);
			cm1.CommandType =CommandType .StoredProcedure ;
			cm1.Parameters .Add ("@ITID",SqlDbType.VarChar );
			cm1.Parameters .Add ("@IDate",SqlDbType.VarChar );
			cm1.Parameters ["@ITID"].Value =tbx_tid.Text.ToString ();
			cm1.Parameters ["@IDate"].Value =System.DateTime .Now ;
			if(rtn_finished.Checked ==true)
			{	
				cm.Parameters .Add ("@TReadyMoney",SqlDbType.Money );
				cm.Parameters .Add ("@TState",SqlDbType.Int );
				cm.Parameters ["@TReadyMoney"].Value =Convert.ToDouble (tbx_ttotalmoney.Text.ToString ());//金额全部到位
				cm.Parameters ["@TState"].Value =2;//状态标志设为完成
				cm1.Parameters .Add ("@IPay",SqlDbType.Money);
				cm1.Parameters .Add ("@IDescribe",SqlDbType.VarChar );
				cm1.Parameters ["@IPay"].Value =Convert.ToDouble (tbx_ttotalmoney.Text.ToString ())-Convert.ToDouble (tbx_treadymoney.Text.ToString ());//所付金额=总金额-已付金额
				cm1.Parameters ["@IDescribe"].Value =tbx_describe.Text .ToString ();
				cm.ExecuteNonQuery ();
				cm1.ExecuteNonQuery ();
			}
			else if(rtn_moneygetted.Checked ==true)
			{	
				cm.Parameters .Add ("@TReadyMoney",SqlDbType.Money );
				cm.Parameters .Add ("@TState",SqlDbType.Int );
				cm.Parameters ["@TReadyMoney"].Value =Convert.ToDouble (tbx_treadymoney.Text.ToString ())+Convert.ToDouble (tbx_getmoney.Text.ToString ());//总到位金额=原到位+刚到位
				cm.Parameters ["@TState"].Value =1;//状态标志设为生效
				cm1.Parameters .Add ("@IPay",SqlDbType.Money);
				cm1.Parameters .Add ("@IDescribe",SqlDbType.VarChar  );
				cm1.Parameters ["@IPay"].Value =tbx_getmoney.Text.ToString ();//所付金额设值
				cm1.Parameters ["@IDescribe"].Value =tbx_describe.Text .ToString ();
				cm.ExecuteNonQuery ();
				cm1.ExecuteNonQuery ();
			}
			else if(rtn_interruptted.Checked ==true)
			{
				cm.Parameters .Add ("@TReadyMoney",SqlDbType.Money );
				cm.Parameters .Add ("@TState",SqlDbType.Int );
				cm.Parameters ["@TReadyMoney"].Value =Convert.ToDouble (tbx_treadymoney.Text.ToString ());//总到位金额=原到位
				cm.Parameters ["@TState"].Value =3;//状态标志设为被终止
				cm1.Parameters .Add ("@IPay",SqlDbType.Money );
				cm1.Parameters .Add ("@IDescribe",SqlDbType.VarChar );
				cm1.Parameters ["@IPay"].Value =0;//所付金额设0
				cm1.Parameters ["@IDescribe"].Value =tbx_describe.Text .ToString ();
				cm.ExecuteNonQuery ();
				cm1.ExecuteNonQuery ();
			}
			Response.Redirect("ContractList.aspx");
		}

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

		}
		#endregion
	}
}