contractdetailforcount.aspx.cs

本文件夹中的Model目录下包含了系统的数据库模型图和系统建模图

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>
	/// ContractDetailForCount 的摘要说明。
	/// </summary>
	public class ContractDetailForCount : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox tbx_cid;
		protected System.Web.UI.WebControls.TextBox tbx_cname;
		protected System.Web.UI.WebControls.TextBox tbx_caddress;
		protected System.Web.UI.WebControls.TextBox tbx_ccontactperson;
		protected System.Web.UI.WebControls.TextBox tbx_ctel;
		protected System.Web.UI.WebControls.TextBox tbx_cbank;
		protected System.Web.UI.WebControls.TextBox tbx_caccount;
		protected System.Web.UI.WebControls.TextBox tbx_ctax;
		protected System.Web.UI.WebControls.TextBox tbx_cemail;
		protected System.Web.UI.WebControls.TextBox tbx_pid;
		protected System.Web.UI.WebControls.TextBox tbx_pname;
		protected System.Web.UI.WebControls.TextBox tbx_pcharacter;
		protected System.Web.UI.WebControls.TextBox tbx_psumofmoney;
		protected System.Web.UI.WebControls.TextBox tbx_pmanager;
		protected System.Web.UI.WebControls.TextBox tbx_tid;
		protected System.Web.UI.WebControls.TextBox tbx_tstate;
		protected System.Web.UI.WebControls.TextBox tbx_tbegindate;
		protected System.Web.UI.WebControls.TextBox tbx_tenddate;
		protected System.Web.UI.WebControls.TextBox tbx_ttotalmoney;
		protected System.Web.UI.WebControls.DataGrid dgd_contractprogressinforlist;
		protected System.Web.UI.WebControls.TextBox tbx_treadymoney;
	
		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 ="已完成";
				}
				else if(dr["tstate"].ToString ()=="3")
				{
					tbx_tstate.Text ="被终止";
				}
				//只要日期信息的年+月+日
				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 ();
			}
			BindGrid();
		}
		
		public void BindGrid()
		{	//从文件Web.config中读取连接字符串
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的TMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			//创建SqlDataAdapter对象,调用存储过程
			SqlDataAdapter da=new SqlDataAdapter ("ContractProgressInforList",cn);
			da.SelectCommand .Parameters .Add ("@ITID",SqlDbType.VarChar );
			da.SelectCommand .Parameters ["@ITID"].Value =Request.QueryString ["tid"].ToString ();
			da.SelectCommand .CommandType =CommandType .StoredProcedure ;
			//创建并填充DataSet
			DataSet ds=new DataSet ();
			da.Fill (ds);
			dgd_contractprogressinforlist.DataSource =ds;
			dgd_contractprogressinforlist.DataBind ();
			cn.Close ();
		}

		#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.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}