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

namespace itcrm.jxcManager
{
	/// <summary>
	/// t_scy_add 的摘要说明。
	/// </summary>
	public class t_scy_add : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtscy_ID;
		protected System.Web.UI.WebControls.TextBox txtPlaceID;
		protected System.Web.UI.WebControls.TextBox txtPlace;
		protected System.Web.UI.WebControls.TextBox txtTime;
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.TextBox txtXfw;
		protected System.Web.UI.WebControls.TextBox txtPH;
		protected System.Web.UI.WebControls.TextBox txtDdl;
		protected System.Web.UI.WebControls.TextBox txtTemperature;
		protected System.Web.UI.WebControls.TextBox txtDiaphaneity;
		protected System.Web.UI.WebControls.TextBox txtValue;
		protected System.Web.UI.WebControls.DropDownList ddldq_ID;
		protected System.Web.UI.WebControls.DropDownList ddlhy_ID;
		protected System.Web.UI.WebControls.DropDownList ddlbz_ID;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.Button btnClear;
		protected System.Web.UI.WebControls.TextBox txtMhg;
		protected System.Web.UI.WebControls.TextBox txtBound;
		protected System.Web.UI.WebControls.TextBox txtRemark;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Button btnReturn;
		DBOperator db;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator1;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator2;
		protected System.Web.UI.WebControls.RegularExpressionValidator RegularExpressionValidator3;
		string vid;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
		    vid=Page.Request["id"];
			db =DBOperator.CreateObject((string)ConfigurationSettings.AppSettings["DSN"]);
			if(!Page.IsPostBack)
			{
				txtTime.Text=System.DateTime.Now.ToShortDateString();
				BindDdlDq();
				BindDdlBz();
				BindDdlHy();
				if(vid!=null)
				{
					QueryEdit(vid);
					txtscy_ID.Enabled=false;
				}

			}
		}
/// <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.btnClear.Click += new System.EventHandler(this.btnClear_Click);
			this.btnReturn.Click += new System.EventHandler(this.btnReturn_Click);
			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)
		{  
			
				string[] strPara =new string[20];
				object[] strValues=new object[20];

				strPara[0]="@scy_ID";
				strPara[1]="@dq_ID";
				strPara[2]="@dq_Name";
				strPara[3]="@hy_ID";
				strPara[4]="@hy_Name";
				strPara[5]="@bz_ID";
				strPara[6]="@BM";
				strPara[7]="@PlaceID";
				strPara[8]="@Place";
				strPara[9]="@Time";               
				strPara[10]="@Name";
				strPara[11]="@Xfw";
				strPara[12]="@PH";
				strPara[13]="@Ddl";
				strPara[14]="@Temperature";
				strPara[15]="@Diaphaneity";
				strPara[16]="@Value";
				strPara[17]="@Mhg";
				strPara[18]="@Bound";
				strPara[19]="@Remark";
				

				strValues[0]=txtscy_ID.Text;
				strValues[1]=ddldq_ID.SelectedItem.Value;
				strValues[2]=ddldq_ID.SelectedItem.Text;
				strValues[3]=ddlhy_ID.SelectedItem.Value;
				strValues[4]=ddlhy_ID.SelectedItem.Text;
				strValues[5]=ddlbz_ID.SelectedItem.Value;
				strValues[6]=ddlbz_ID.SelectedItem.Text;
				strValues[7]=txtPlaceID.Text;
				strValues[8]=txtPlace.Text;
				strValues[9]=txtTime.Text;
				strValues[10]=txtName.Text;
				strValues[11]=txtXfw.Text;
				strValues[12]=txtPH.Text;
				strValues[13]=txtDdl.Text;
				strValues[14]=txtTemperature.Text;
				strValues[15]=txtDiaphaneity.Text;
				strValues[16]=txtValue.Text;
				strValues[17]=txtMhg.Text;
				strValues[18]=txtBound.Text;
				strValues[19]=txtRemark.Text;
				
			try
			{
				if(txtscy_ID.Text!="")
				{
					if(txtPlaceID.Text!="")
					{
						if(txtValue.Text!="")
						{
							if(vid!=null)
							{
								db.Open();
								db.exeProc("Update_t_scy",strPara,strValues);
								db.Close();
								Page.RegisterStartupScript("script","<script>alert('修改记录成功！')</script>");
							}
								
							else
							{
								db.Open();
								db.exeProc("Add_t_scy",strPara,strValues);
								db.Close();
								Page.RegisterStartupScript("script","<script>alert('增加记录成功！')</script>");
								btnClear_Click(sender,e);
							}
									
						}
						else{Page.RegisterStartupScript("script","<script>alert('汞含量不能为空！')</script>");}
								
							
					}
					else{Page.RegisterStartupScript("script","<script>alert('地点编号不能为空！')</script>");}
							
				}
				else{Page.RegisterStartupScript("script","<script>alert('采样编号不能为空！')</script>");}
			}
									
			catch(System.Exception ee)
			{
						
				Page.RegisterStartupScript("script","<script>alert('"+ee.Message+"')</script>");
			}
				
		}
/// <summary>
/// 编辑
/// </summary>
/// <param name="who"></param>
		private void QueryEdit(string who)
		{
			string strSql="select * from t_scy where scy_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];
				txtscy_ID.Text=row["scy_ID"].ToString();
				ddldq_ID.SelectedItem.Value=row["dq_ID"].ToString();
				ddldq_ID.SelectedItem.Text=row["dq_Name"].ToString();
				txtPlaceID.Text=row["PlaceID"].ToString();
				ddlhy_ID.SelectedItem.Value=row["hy_ID"].ToString();
				ddlhy_ID.SelectedItem.Text=row["hy_Name"].ToString();
				ddlbz_ID.SelectedItem.Value=row["bz_ID"].ToString();
				ddlbz_ID.SelectedItem.Text=row["BM"].ToString();
				txtPlace.Text=row["Place"].ToString();
				txtTime.Text=row["Time"].ToString();
				txtName.Text=row["Name"].ToString();
				txtXfw.Text=row["Xfw"].ToString();
				txtPH.Text=row["PH"].ToString();
				txtDdl.Text=row["Ddl"].ToString();
				txtTemperature.Text=row["Temperature"].ToString();
				txtDiaphaneity.Text=row["Diaphaneity"].ToString();
				txtValue.Text=row["Value"].ToString();
				txtMhg.Text=row["Mhg"].ToString();
				txtBound.Text=row["Bound"].ToString();
				txtRemark.Text=row["Remark"].ToString();
				ds.Dispose();
			}
			
			
				

		}
/// <summary>
///  清 除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnClear_Click(object sender, System.EventArgs e)
		{
		    txtscy_ID.Text="";			
			txtPlaceID.Text="";
			txtPlace.Text="";
			//txtTime.Text="";
			txtName.Text="";
			txtXfw.Text="";
			txtPH.Text="";
			txtDdl.Text="";		
			txtValue.Text="";
			txtMhg.Text="";
			txtBound.Text="";
			txtRemark.Text="";
			txtTemperature.Text="";
			txtDiaphaneity.Text="";
		}
		

		private void btnReturn_Click(object sender, System.EventArgs e)
		{
			Page.Response.Redirect("t_scy.aspx");
		}
	}
}
⌨️ 快捷键说明

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