📄 t_rtcy_add.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.Data.SqlClient;
using System.Configuration;
using gyit.Data;
namespace itcrm.jxcManager
{
/// <summary>
/// t_rtcy_add 的摘要说明。
/// </summary>
public class t_rtcy_add : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox txtRemark;
protected System.Web.UI.WebControls.TextBox txtrtcy_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.Button btnAdd;
protected System.Web.UI.WebControls.Button btnClear;
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.TextBox txtSex;
protected System.Web.UI.WebControls.TextBox txtJob;
protected System.Web.UI.WebControls.TextBox txtAge;
protected System.Web.UI.WebControls.TextBox txtHair;
protected System.Web.UI.WebControls.TextBox txtStale;
protected System.Web.UI.WebControls.TextBox txtBlood;
protected System.Web.UI.WebControls.TextBox txtCymene;
protected System.Web.UI.WebControls.TextBox txtBound;
protected System.Web.UI.WebControls.TextBox txtState;
protected System.Web.UI.WebControls.TextBox txtNumber;
protected System.Web.UI.WebControls.TextBox txtPer;
protected System.Web.UI.WebControls.Button btnReturn;
protected System.Web.UI.WebControls.Label Label1;
DBOperator db;
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.RegularExpressionValidator RegularExpressionValidator4;
string vid;
private void Page_Load(object sender, System.EventArgs e)
{
vid=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);
txtrtcy_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
private void btnReturn_Click(object sender, System.EventArgs e)
{
Response.Redirect("t_rtcy.aspx");
}
/// <summary>
/// 增加或修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, System.EventArgs e)
{
string[] strPara =new string[22];
object[] strValues=new object[22];
strPara[0]="@rtcy_ID";
strPara[1]="@dq_ID";
strPara[2]="@dq_Name";
strPara[3]="@PlaceID";
strPara[4]="@hy_ID";
strPara[5]="@hy_Name";
strPara[6]="@bz_ID";
strPara[7]="@BM";
strPara[8]="@Place";
strPara[9]="@Time";
strPara[10]="@Sex";
strPara[11]="@Job";
strPara[12]="@Age";
strPara[13]="@Hair";
strPara[14]="@Stale";
strPara[15]="@Blood";
strPara[16]="@Cymene";
strPara[17]="@State";
strPara[18]="@Value";
strPara[19]="@Number";
strPara[20]="@Per";
strPara[21]="@Remark";
strValues[0]=txtrtcy_ID.Text;
strValues[1]=ddldq_ID.SelectedItem.Value;
strValues[2]=ddldq_ID.SelectedItem.Text;
strValues[3]=txtPlaceID.Text;
strValues[4]=ddlhy_ID.SelectedItem.Value;
strValues[5]=ddlhy_ID.SelectedItem.Text;
strValues[6]=ddlbz_ID.SelectedItem.Value;
strValues[7]=ddlbz_ID.SelectedItem.Text;
strValues[8]=txtPlace.Text;
strValues[9]=txtTime.Text;
strValues[10]=txtSex.Text;
strValues[11]=txtJob.Text;
strValues[12]=txtAge.Text;
strValues[13]=txtHair.Text;
strValues[14]=txtStale.Text;
strValues[15]=txtBlood.Text;
strValues[16]=txtCymene.Text;
strValues[17]=txtState.Text;
strValues[18]=txtBound.Text;
strValues[19]=txtNumber.Text;
strValues[20]=txtPer.Text;
strValues[21]=txtRemark.Text;
try
{
if(txtrtcy_ID.Text!="")
{
if(txtPlaceID.Text!="")
{
if(txtCymene.Text!="")
{
if(vid!=null)
{
db.Open();
db.exeProc("Update_t_rtcy",strPara,strValues);
db.Close();
Page.RegisterStartupScript("script","<script>alert('修改记录成功！')</script>");
}
else
{
db.Open();
db.exeProc("Add_t_rtcy",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="sender"></param>
/// <param name="e"></param>
private void btnClear_Click(object sender, System.EventArgs e)
{
txtrtcy_ID.Text="";
txtPlaceID.Text="";
txtPlace.Text="";
//txtTime.Text="";
txtSex.Text="";
txtJob.Text="";
txtAge.Text="";
txtHair.Text="";
txtStale.Text="";
txtBlood.Text="";
txtCymene.Text="";
txtState.Text="";
txtBound.Text="";
txtNumber.Text="";
txtPer.Text="";
txtRemark.Text="";
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="who"></param>
public void QueryEdit(string who)
{
string strSql="select * from t_rtcy where rtcy_ID='"+who+"'";
DataSet ds=null;
DataRow row=null;
db.Open();
ds=db.exeSqlForDataSet(strSql);
db.Close();
row=ds.Tables[0].Rows[0];
if(ds.Tables[0].Rows.Count>0)
{
txtrtcy_ID.Text=row["rtcy_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();
txtSex.Text=row["Sex"].ToString();
txtJob.Text=row["Job"].ToString();
txtAge.Text=row["Age"].ToString();
txtHair.Text=row["Hair"].ToString();
txtStale.Text=row["Stale"].ToString();
txtBlood.Text=row["Blood"].ToString();
txtCymene.Text=row["Cymene"].ToString();
txtState.Text=row["State"].ToString();
txtBound.Text=row["Value"].ToString();
txtNumber.Text=row["Number"].ToString();
txtPer.Text=row["Per"].ToString();
txtRemark.Text=row["Remark"].ToString();
ds.Dispose();
}
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -