📄 t_mcy.aspx.cs

📁 毕业设计时做的,一个管理关于污染管理的, 源代码,呵呵想想当时还真厉害,可以实现污染检测
💻 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 gyit.Data;
using System.Data.SqlClient;
using System.Configuration;

namespace itcrm.jxcManager
{
	/// <summary>
	/// t_mcy 的摘要说明。
	/// </summary>
	public class t_mcy : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		protected System.Web.UI.WebControls.TextBox txtRemark;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.Button btnEdit;
		protected System.Web.UI.WebControls.Button btnClear;
		protected System.Web.UI.WebControls.TextBox txtmcy_ID;
		protected System.Web.UI.WebControls.TextBox txtPlaceID;
		protected System.Web.UI.WebControls.TextBox txtTime;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtBound;
		protected System.Web.UI.WebControls.TextBox txtValue;
		protected System.Web.UI.WebControls.DropDownList ddlbz_ID;
		protected System.Web.UI.WebControls.DropDownList ddldq_ID;
		protected System.Web.UI.WebControls.DropDownList ddlhy_ID;
		protected System.Web.UI.WebControls.TextBox txtPlace;
		protected System.Web.UI.WebControls.Button btnQuery;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
		protected System.Web.UI.WebControls.Label Label1;
		DBOperator db;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			DataGrid1.DataKeyField="mcy_ID";
			string vid=Request["id"];
			db =DBOperator.CreateObject((string)ConfigurationSettings.AppSettings["DSN"]);
			if(!Page.IsPostBack)
			{  
				txtTime.Text=System.DateTime.Now.ToShortDateString();
				DataShow();
				BindDdlDq();
				BindDdlBz();
				BindDdlHy();
				if(vid!=null)
				{
					QueryEdit(vid);
					btnAdd.Enabled=false;
					txtmcy_ID.Enabled=false;
				}
			}
		}
		private void DataShow()
		{
			db.Open();
			DataSet ds=null;
			ds=db.exeSqlForDataSet("select * from t_mcy");
			DataGrid1.DataSource=ds;
			DataGrid1.DataBind();
			db.Close();
			Session["t_mcy"]=ds;

		}
/// <summary>
/// 绑定地区名称
/// </summary>
		private void BindDdlDq()
		{
			string strSql="select dq_ID,dq_Name from tb_dq";
			DataSet ds=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			if(ds!=null)
			{
				ddldq_ID.DataSource=ds;
				ddldq_ID.DataTextField=ds.Tables[0].Columns["dq_Name"].ToString();
				ddldq_ID.DataValueField=ds.Tables[0].Columns["dq_ID"].ToString();
				ddldq_ID.DataBind();
				ds.Dispose();
				ddldq_ID.Dispose();
			}
		
		}
/// <summary>
/// 绑定国家标准
/// </summary>
		private void BindDdlBz()
		{
			string strSql="select bz_ID,BM from tb_gwrbz";
			DataSet ds=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			if(ds!=null)
			{
				ddlbz_ID.DataSource=ds;
				ddlbz_ID.DataTextField=ds.Tables[0].Columns["BM"].ToString();
				ddlbz_ID.DataValueField=ds.Tables[0].Columns["bz_ID"].ToString();
				ddlbz_ID.DataBind();
				ds.Dispose();
				ddlbz_ID.Dispose();
			}
		}
/// <summary>
/// 绑定行业
/// </summary>
		private void BindDdlHy()
		{   
			string strSql="select hy_ID,hy_Name from tb_hy";
			DataSet ds=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			if(ds!=null)  
			{
				ddlhy_ID.DataSource=ds;
				ddlhy_ID.DataTextField=ds.Tables[0].Columns["hy_Name"].ToString();
				ddlhy_ID.DataValueField=ds.Tables[0].Columns["hy_ID"].ToString();
				ddlhy_ID.DataBind();
				ds.Dispose();
				ddlhy_ID.Dispose();
			}
		}


		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
			this.btnEdit.Click += new System.EventHandler(this.btnEdit_Click);
			this.btnClear.Click += new System.EventHandler(this.btnClear_Click);
			this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.DataGrid1.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.DataGrid1_PageIndexChanged);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

/// <summary>
/// ***  增加
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			if(btnAdd.Text=="保 存")
			{
				string[] strPara =new string[14];
				object[] strValues=new object[14];

				strPara[0]="@mcy_ID";
				strPara[1]="@dq_ID";
				strPara[2]="@dq_Name";
				strPara[3]="@bz_ID";
				strPara[4]="@BM";
				strPara[5]="@PlaceID";
				strPara[6]="@hy_ID";
				strPara[7]="@hy_Name";
				strPara[8]="@Place";               
				strPara[9]="@Time";
				strPara[10]="@Name";
				strPara[11]="@Value";
				strPara[12]="@Bound";
				strPara[13]="@Remark";
				

				strValues[0]=txtmcy_ID.Text;
				strValues[1]=ddldq_ID.SelectedItem.Value;
				strValues[2]=ddldq_ID.SelectedItem.Text;
				strValues[3]=ddlbz_ID.SelectedItem.Value;
				strValues[4]=ddlbz_ID.SelectedItem.Text;
				strValues[5]=txtPlaceID.Text;
				strValues[6]=ddlhy_ID.SelectedItem.Value;
				strValues[7]=ddlhy_ID.SelectedItem.Text;
				strValues[8]=txtPlace.Text;
				strValues[9]=txtTime.Text;
				strValues[10]=txtName.Text;
				strValues[11]=txtValue.Text;
				strValues[12]=txtBound.Text;
				strValues[13]=txtRemark.Text;
			
			
				try
				{
					db.Open();
					db.exeProc("Add_t_mcy",strPara,strValues);
					db.Close();
					DataShow();
					btnAdd.Text="增 加";
					Page.RegisterStartupScript("script","<script>alert('增加记录成功！')</script>");
					
				
				}
				catch(System.Exception ee)
				{
					
			       Page.RegisterStartupScript("script","<script>alert('"+ee.Message+"')</script>");
				}
				
			}
			else if( btnAdd.Text=="增 加")
			{
					btnAdd.Text="保 存";
				    btnClear_Click(sender,e);
				   
				
			}
		}
/// <summary>
/// ***  清除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnClear_Click(object sender, System.EventArgs e)
		{
			txtmcy_ID.Text="";
			txtPlaceID.Text="";
			txtPlace.Text="";
			//txtTime.Text="";
			txtName.Text="";
			txtValue.Text="";
			txtBound.Text="";
			txtRemark.Text="";
		
		}
/// <summary>
/// *****  修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnEdit_Click(object sender, System.EventArgs e)
		{
			string[] strPara =new string[14];
			object[] strValues=new object[14];

			strPara[0]="@mcy_ID";
			strPara[1]="@dq_ID";
			strPara[2]="@dq_Name";
			strPara[3]="@bz_ID";
			strPara[4]="@BM";
			strPara[5]="@PlaceID";
			strPara[6]="@hy_ID";
			strPara[7]="@hy_Name";               
			strPara[8]="@Place";
			strPara[9]="@Time";
			strPara[10]="@Name";
			strPara[11]="@Value";
			strPara[12]="@Bound";
			strPara[13]="@Remark";

			strValues[0]=txtmcy_ID.Text;
			strValues[1]=ddldq_ID.SelectedItem.Value;
			strValues[2]=ddldq_ID.SelectedItem.Text;
			strValues[3]=ddlbz_ID.SelectedItem.Value;
			strValues[4]=ddlbz_ID.SelectedItem.Text;
			strValues[5]=txtPlaceID.Text;
			strValues[6]=ddlhy_ID.SelectedItem.Value;
			strValues[7]=ddlhy_ID.SelectedItem.Text;
			strValues[8]=txtPlace.Text;
			strValues[9]=txtTime.Text;
			strValues[10]=txtName.Text;
			strValues[11]=txtValue.Text;
			strValues[12]=txtBound.Text;
			strValues[13]=txtRemark.Text;
			try
			{
				db.Open();
				db.exeProc("Update_t_mcy",strPara,strValues);
				db.Close();
				DataShow();
				Page.RegisterStartupScript("script","<script>alert('修改记录成功！')</script>");
				
				
			}
			catch(System.Exception ee)
			{
				Page.RegisterStartupScript("script","<script>alert('"+ee.Message+"')</script>");
				
			}
		}

		private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			string strSql="select * from t_mcy where mcy_ID='"+DataGrid1.DataKeys[e.Item.ItemIndex]+"'";
			DataSet ds=new DataSet();
			DataRow row=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			if(ds.Tables[0].Rows.Count>0)
			{
				row=ds.Tables[0].Rows[0];
				txtmcy_ID.Text=row["mcy_ID"].ToString();
				ddldq_ID.SelectedItem.Value=row["dq_ID"].ToString();
				txtPlaceID.Text=row["PlaceID"].ToString();
				ddlhy_ID.SelectedItem.Value=row["hy_ID"].ToString();
				ddlbz_ID.SelectedItem.Value=row["bz_ID"].ToString();
				txtPlace.Text=row["Place"].ToString();
				txtTime.Text=row["Time"].ToString();
				txtBound.Text=row["Bound"].ToString();
				txtValue.Text=row["Value"].ToString();
				txtBound.Text=row["Bound"].ToString();
				txtRemark.Text=row["Remark"].ToString();
				ds.Dispose();
				ddldq_ID.Dispose();
				ddlhy_ID.Dispose();
				ddlbz_ID.Dispose();
				btnEdit.Enabled=true;
			}
			
		}
/// <summary>
/// ****  删 除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			switch(e.Item.ItemType)
			{
				case ListItemType.Item:
				case ListItemType.AlternatingItem:
				case ListItemType.EditItem:
				{
					LinkButton btn=(LinkButton)e.Item.FindControl("lbtnDel");
					btn.Attributes.Add("onclick","return confirm('你是否确定删除这条记录？');");
					break;
				}
			}
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName=="lbtnDel")
			{
				if ( DataGrid1.Items.Count==1 && DataGrid1.CurrentPageIndex>0)
				{
					DataGrid1.CurrentPageIndex= DataGrid1.CurrentPageIndex-1;
					DataGrid1.Dispose();
					BindSession();
				}

				db.Open();
				db.exeSql("delete from t_mcy where mcy_ID='"+(DataGrid1.DataKeys[e.Item.ItemIndex])+"'");
				db.Close();
				DataShow();
			}
		}

		private void btnQuery_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("t_mcy_add.aspx");
		}
//**** 查找修改
		private void QueryEdit(string who)
		{
			string strSql="select * from t_mcy where mcy_ID='"+who+"'";
			DataSet ds=null;
			DataRow row=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
			if(ds.Tables[0].Rows.Count>0)
			{
				row=ds.Tables[0].Rows[0];
				txtmcy_ID.Text=row["mcy_ID"].ToString();
				ddldq_ID.SelectedItem.Value=row["dq_ID"].ToString();
				txtPlaceID.Text=row["PlaceID"].ToString();
				ddlhy_ID.SelectedItem.Value=row["hy_ID"].ToString();
				ddlbz_ID.SelectedItem.Value=row["bz_ID"].ToString();
				txtPlace.Text=row["Place"].ToString();
				txtTime.Text=row["Time"].ToString();
				txtBound.Text=row["Bound"].ToString();
				txtValue.Text=row["Value"].ToString();
				txtBound.Text=row["Bound"].ToString();
				txtRemark.Text=row["Remark"].ToString();
				ds.Dispose();
				ddldq_ID.Dispose();
				ddlhy_ID.Dispose();
				ddlbz_ID.Dispose();
			}
			else 
				Label1.Text="没有相关信息·";
		
		}
/// <summary>
/// ****  分页
/// </summary>
/// <param name="source"></param>
/// <param name="e"></param>
		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			DataGrid1.CurrentPageIndex=e.NewPageIndex;
			BindSession();
		}
		private void BindSession()
		{
			if(Session["t_mcy"]!=null)
			{
				DataGrid1.DataSource=(DataSet)Session["t_mcy"];
				DataGrid1.DataBind();
			}
		}
	}
}
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -