tb_dqadd.aspx.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 gyit.Data;

namespace itcrm.jxcManager
{
	/// <summary>
	/// tb_dqAdd 的摘要说明。
	/// </summary>
	public class tb_dqAdd : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.TextBox txtName;
		protected System.Web.UI.WebControls.Button btnAdd;
		protected System.Web.UI.WebControls.Button btnReturn;
		protected System.Web.UI.WebControls.TextBox txtdq_ID;
	    DBOperator db;
		protected System.Web.UI.WebControls.Button btnClear;
		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)
			{
				if(vid!=null)
				{
					QueryEdit(vid);
					txtdq_ID.Enabled=false;
				}
				else
				{
					Refresh();
				}
			}

		}

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

		}
		#endregion

		private void btnAdd_Click(object sender, System.EventArgs e)
		{
			
			string[] strPara =new string[2];
			object[] strValues=new object[2];
			
			strPara[0]="@dq_ID";
			strPara[1]="@dq_Name";
			
			strValues[0]=txtdq_ID.Text;
			strValues[1]=txtName.Text;
			
			try	 
			{
				if(txtdq_ID.Text!="")
				{
					if(txtName.Text!="")
					{
						if(vid!=null)
						{
							string strSql="Update tb_dq Set dq_Name='"+txtName.Text+"' where dq_ID='"+txtdq_ID.Text+"'";
							db.Open();
							db.exeSql(strSql);
							db.Close();
							Page.RegisterStartupScript("script","<script>alert('修改记录成功！')</script>");
							Refresh();
						}
						else
						{
							db.Open();
							db.exeProc("Add_tb_dq",strPara,strValues);
							db.Close();
							Page.RegisterStartupScript("script","<script>alert('增加记录成功！')</script>");
							txtName.Text="";
							Refresh();
							
						}
					}
					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>");
		       // txtdq_ID.Text=Convert.ToInt32(txtdq_ID.Text)+1;
			}
		
		}
/// <summary>
/// 清除
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnClear_Click(object sender, System.EventArgs e)
		{
			//txtdq_ID.Text="";
			txtName.Text="";
		}
/// <summary>
/// 编辑
/// </summary>
/// <param name="who"></param>
		private void QueryEdit(string who)
		{
			string strSql="select * from tb_dq where dq_ID='"+who+"'";
			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];
				txtdq_ID.Text=row["dq_ID"].ToString();
				txtName.Text=row["dq_Name"].ToString();
				ds.Dispose();
			}
			
		}
/// <summary>
/// 自动获得编号
/// </summary>
		private void Refresh()
		{
			string dq_ID=txtdq_ID.Text;
           
			string strSql="select dq_ID from tb_dq order by ID";
			DataSet ds=null;
			db.Open();
			ds=db.exeSqlForDataSet(strSql);
			db.Close();
            int count=ds.Tables[0].Rows.Count;
			if(count==0)
			{  
				txtdq_ID.Text="100001";     
			}
			else
			{
				
				count=ds.Tables[0].Rows.Count;
				DataRow row=ds.Tables[0].Rows[count-1];
				int len=row["dq_ID"].ToString().Length;
				string str=(row["dq_ID"].ToString()).Substring(len-2,1);
				if(str=="0")
				{
					string str1=(row["dq_ID"].ToString()).Substring(0,len-1);
					string str2=(row["dq_ID"].ToString()).Substring(len-1,1);
					int ID=Convert.ToInt32(str2)+1;
					string Value=str1+ID.ToString();
					txtdq_ID.Text=Value;
				}
				else
				{
					string str1=(row["dq_ID"].ToString()).Substring(0,len-2);
					string str2=(row["dq_ID"].ToString()).Substring(len-2,2);					
					int ID=Convert.ToInt32(str2)+1;
					string Value=str1+ID.ToString();
					txtdq_ID.Text=Value;  
				}
			}
	}  		
/// <summary>
/// 返回
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
		private void btnReturn_Click(object sender, System.EventArgs e)
		{
			Page.Response.Redirect("tb_dq.aspx");
		}
	}
}