📄 t_swcy.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_swcy 的摘要说明。
/// </summary>
public class t_swcy : System.Web.UI.Page
{
protected System.Web.UI.WebControls.Button cmdClear;
protected System.Web.UI.WebControls.Button cmdAdd;
protected System.Web.UI.WebControls.TextBox txtRemark;
protected System.Web.UI.WebControls.TextBox txtswcy_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 txtValue;
protected System.Web.UI.WebControls.TextBox txtBound;
protected System.Web.UI.WebControls.TextBox txtThg;
protected System.Web.UI.WebControls.TextBox txtMhg;
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.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);
txtswcy_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();
}
}
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();
}
}
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.cmdAdd.Click += new System.EventHandler(this.cmdAdd_Click);
this.cmdClear.Click += new System.EventHandler(this.cmdClear_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 cmdAdd_Click(object sender, System.EventArgs e)
{
string[] strPara =new string[16];
object[] strValues=new object[16];
strPara[0]="@swcy_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]="@Name";
strPara[11]="@Value";
strPara[12]="@Thg";
strPara[13]="@Bound";
strPara[14]="@Mhg";
strPara[15]="@Remark";
strValues[0]=txtswcy_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]=txtName.Text;
strValues[11]=txtValue.Text;
strValues[12]=txtThg.Text;
strValues[13]=txtBound.Text;
strValues[14]=txtMhg.Text;
strValues[15]=txtRemark.Text;
try
{
if(txtswcy_ID.Text!="")
{
if(txtPlaceID.Text!="")
{
if(txtName.Text!="")
{
if(txtValue.Text!="")
{
if(vid!=null)
{
db.Open();
db.exeProc("Update_t_swcy",strPara,strValues);
db.Close();
Page.RegisterStartupScript("script","<script>alert('修改记录成功！')</script>");
}
else
{
db.Open();
db.exeProc("Add_t_swcy",strPara,strValues);
db.Close();
Page.RegisterStartupScript("script","<script>alert('增加记录成功！')</script>");
cmdClear_Click(sender,e);
}
}
else{Page.RegisterStartupScript("script","<script>alert('汞含量不能为空！')</script>");}
}
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 cmdClear_Click(object sender, System.EventArgs e)
{
txtswcy_ID.Text="";
txtPlaceID.Text="";
txtPlace.Text="";
//txtTime.Text="";
txtName.Text="";
txtValue.Text="";
txtThg.Text="";
txtBound.Text="";
txtMhg.Text="";
txtRemark.Text="";
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="who"></param>
private void QueryEdit(string who)
{
string strSql="select * from t_swcy where swcy_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];
txtswcy_ID.Text=row["swcy_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();
txtValue.Text=row["Value"].ToString();
txtThg.Text=row["Thg"].ToString();
txtBound.Text=row["Bound"].ToString();
txtMhg.Text=row["Mhg"].ToString();
txtRemark.Text=row["Remark"].ToString();
ds.Dispose();
}
}
private void btnReturn_Click(object sender, System.EventArgs e)
{
Page.Response.Redirect("t_swcyAdd.aspx");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -