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

namespace TMS
{
	/// <summary>
	/// ContractCount 的摘要说明。
	/// </summary>
	public class ContractCount : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink hlk_goodsmanage;
		protected System.Web.UI.WebControls.HyperLink hlk_clientsmanage;
		protected System.Web.UI.WebControls.HyperLink hlk_projectsmanage;
		protected System.Web.UI.WebControls.HyperLink hlk_contractmanage;
		protected System.Web.UI.WebControls.HyperLink hlk_contractcontrol;
		protected System.Web.UI.WebControls.HyperLink hlk_contractcount;
		protected System.Web.UI.WebControls.HyperLink hlk_passwordmodifyforadmin;
		protected System.Web.UI.WebControls.DropDownList ddl_tcid;
		protected System.Web.UI.WebControls.DropDownList ddl_tpid;
		protected System.Web.UI.WebControls.DropDownList ddl_tstate;
		protected System.Web.UI.WebControls.Button btn_search;
		protected System.Web.UI.WebControls.Label lbl_totalmoney;
		protected System.Web.UI.WebControls.Label lbl_readymoney;
		protected System.Web.UI.WebControls.Label lbl_tcount;
		protected System.Web.UI.WebControls.DataGrid dgd_contractlist;
		protected System.Web.UI.WebControls.HyperLink hlk_default;
	
		private void Page_Load(object sender, System.EventArgs e)
		{	//判断用户是否为合法用户
			try
			{
				if(Session["UPower"].ToString ()=="1") ;
			}
			catch
			{
				Response.Write ("您不是合法用户，请登入后再操作，<a href='default.aspx'>返回</a>");
				Response.End ();
			}
			//绑定客户信息及项目信息下拉列表框
			if(!IsPostBack)
			{//客户信息下拉列表框绑定
				string strconn= ConfigurationSettings.AppSettings["dsn"];
				//连接本地计算机的HMS数据库
				SqlConnection cn0= new SqlConnection (strconn);
				cn0.Open ();
				string mysql="select * from Clients ";
				SqlCommand cm=new SqlCommand  (mysql,cn0);
				SqlDataReader dr=cm.ExecuteReader ();
				while(dr.Read ())
				{
					ddl_tcid.Items .Add (new ListItem(dr["cname"].ToString(),dr["cid"].ToString()) );
				}
				cn0.Close ();
				//项目信息下拉列表框绑定
				cn0.Open ();
				string mysql1="select * from Projects";
				SqlCommand cm1=new SqlCommand  (mysql1,cn0);
				SqlDataReader dr1=cm1.ExecuteReader ();
				while(dr1.Read ())
				{
					ddl_tpid.Items .Add (new ListItem(dr1["pname"].ToString(),dr1["pid"].ToString()) );
				}
				cn0.Close ();
				//绑定列表框
				BindGrid();
				//绑定标签栏
				BindLabel();
			}
		}
		public void DataGrid_Page(Object sender,DataGridPageChangedEventArgs E)
		{
			dgd_contractlist.CurrentPageIndex =E.NewPageIndex ;
			BindGrid();
		}
		//绑定合同信息到dgd_contractlist
		public void BindGrid()
		{	//从文件Web.config中读取连接字符串
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的TMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			//创建带筛子的SQL语句
			string mysql="SELECT * FROM Projects,Clients,Contract WHERE	TCID=CID AND TPID=PID ";
			//对控建进行筛选
			if (ddl_tcid.SelectedItem .Value .ToString ()!="0")//如果“客户信息”有输入,0为未选
			{
				mysql=mysql+" and tcid='"+ddl_tcid.SelectedItem .Value .ToString ()+"'";
			}
			if (ddl_tpid.SelectedItem .Value .ToString ()!="0")//如果“项目信息”有输入,0为未选
			{
				mysql=mysql+" and tpid='"+ddl_tpid.SelectedItem .Value .ToString ()+"'";
			}
			if (ddl_tstate.SelectedItem .Value .ToString ()!="0")//如果“当前状态”有输入,0为未选
			{
				mysql=mysql+" and tstate='"+ddl_tstate.SelectedItem .Value .ToString ()+"'";
			}
			mysql=mysql+" ORDER BY TState,TEndDate";//增加排序
			//创建SqlDataAdapter对象,调用视图
			SqlDataAdapter da=new SqlDataAdapter (mysql,cn);
			//创建并填充DataSet
			DataSet ds=new DataSet ();
			da.Fill (ds);
			dgd_contractlist.DataSource =ds;
			dgd_contractlist.DataBind ();
			cn.Close ();
		}
		//绑定合同金额到lbl_readymoney,lbl_totalmoney上
		public void BindLabel()
		{	//从文件Web.config中读取连接字符串
			string strconn= ConfigurationSettings.AppSettings["dsn"];
			//连接本地计算机的BMS数据库
			SqlConnection cn= new SqlConnection (strconn);
			cn.Open ();
			//创建读取当前合同涉及各金额总和
			string sqlsum="SELECT count(*) tcount,sum(treadymoney) readymoney,sum(ttotalmoney) totalmoney FROM Projects,Clients,Contract WHERE	TCID=CID AND TPID=PID ";
			//对控建进行筛选
			if (ddl_tcid.SelectedItem .Value .ToString ()!="0")//如果“客户信息”有输入,0为未选
			{
				sqlsum=sqlsum+" and tcid='"+ddl_tcid.SelectedItem .Value .ToString ()+"'";
			}
			if (ddl_tpid.SelectedItem .Value .ToString ()!="0")//如果“项目信息”有输入,0为未选
			{
				sqlsum=sqlsum+" and tpid='"+ddl_tpid.SelectedItem .Value .ToString ()+"'";
			}
			if (ddl_tstate.SelectedItem .Value .ToString ()!="0")//如果“当前状态”有输入,0为未选
			{
				sqlsum=sqlsum+" and tstate='"+ddl_tstate.SelectedItem .Value .ToString ()+"'";
			}
			SqlCommand cm=new SqlCommand (sqlsum,cn);
			SqlDataReader dr =cm.ExecuteReader ();
			dr.Read ();
			if (dr["readymoney"].ToString ()=="")
				lbl_readymoney.Text ="0";
			else 
				lbl_readymoney.Text=dr["readymoney"].ToString ();
			if (dr["totalmoney"].ToString ()=="")
				lbl_totalmoney.Text ="0";
			else 
				lbl_totalmoney.Text=dr["totalmoney"].ToString ();
			lbl_tcount.Text=dr["tcount"].ToString ();
			cn.Close ();
		}
		private void btn_search_Click(object sender, System.EventArgs e)
		{
			BindGrid();
			BindLabel();
		}

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

		}
		#endregion
	}
}