该页面引用了一个简单的CSS,放在同级目录中的css文件夹内,文件为:css.css
.style_1 {
font-family: "宋体";
font-size: 12px;
font-weight: bold;
color: #FFFFFF;
text-decoration: none;
}
.style_2 {
font-family: "宋体";
font-size: 14px;
font-weight: normal;
color: #333333;
}
.style_3 {
font-family: "宋体";
font-size: 12px;
font-weight: normal;
color: #333333;
}
.style_4 {
font-family: "宋体";
font-size: 12px;
font-weight: normal;
color: #FFFFFF;
}
.style_5 {
font-family: "宋体";
font-size: 12px;
font-weight: normal;
color: #333333;
}
.style6 {
font-family: "宋体";
font-size: 12px;
color: #005BA7;
text-decoration: none;
}
.style_7 {
font-family: "宋体";
font-size: 14px;
font-weight: normal;
color: #FFFFFF;
}
.style_8 {
font-family: "宋体";
color: #FF0000;
text-decoration: none;
font-size: 14px;
}
.style_9 {
font-family: "宋体";
font-size: 18px;
color: #FFFFFF;
}
.style_10 {
font-family: "宋体";
font-size: 24px;
font-weight: bold;
color: #FFFFFF;
}
.tizi_1 {
font-family: "宋体";
font-size: 12px;
line-height: normal;
color: #3A3A3A;
}
.input {
background-color: #FFFFFF;
margin: 1px;
padding: 1px;
border: 1px solid #686868;
}
.ziti_2 {
font-family: "宋体";
font-size: 12px;
color: #FF4800;
}
.tizi_3 {
font-family: "宋体";
font-size: 12px;
color: #003C72;
}
.ks_1 {
font-family: "宋体";
font-size: 14px;
font-weight: bold;
color: #0154A0;
}
.ks_2 {
font-family: "宋体";
font-size: 14px;
font-weight: bold;
color: #000000;
}
.ks_3 {
font-family: "宋体";
font-size: 14px;
font-weight: bold;
color: #FF0000;
}
.ks_4 {
font-family: "宋体";
font-size: 16px;
font-weight: bold;
font-variant: normal;
color: #FFFFFF;
}
.ks_5 {
font-family: "宋体";
font-size: 16px;
font-weight: bold;
color: #FFFF00;
}
.ks_6 {
font-family: "宋体";
font-size: 16px;
font-weight: normal;
color: #FEEED7;
}
.ks_7 {
font-family: "宋体";
font-size: 24px;
color: #0067BD;
}
.ks_8 {
font-family: "宋体";
font-size: 14px;
font-style: normal;
line-height: 20px;
color: #000000;
}
.ks_9 {
font-family: "宋体";
font-size: 36px;
color: #FFFFFF;
}
.xtdl_1 {
font-family: "宋体";
font-size: 12px;
color: #000000;
}
.xtdl_2 {
font-family: "宋体";
font-size: 12px;
font-weight: bold;
color: #0024FF;
}
.xtdl_3 {
font-family: "宋体";
font-size: 12px;
font-weight: bold;
color: #FF4701;
}
.jt-9 {
font-size: 12px;
line-height: 20px;
color: #000000;
}
.input {
font-family: "宋体";
font-size: 12px;
font-style: normal;
font-weight: normal;
margin: 1px;
padding: 1px;
border: 1px solid #336699;
background-color: #EFFAFE;
list-style-type: disc;
}
.ziti {
font-family: "宋体";
font-size: 12px;
font-style: normal;
line-height: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
.contentpanel
{ text-align: left; margin: 0 auto!important; margin: 0px;}
.Ptitle{ height: 18px; text-align: left; margin: 0px 9px 0px 9px; padding: 3px 0px 0px 13px; font-weight: bold; font-size: 12px; font-family: Arial; color: #000; border: 1px solid #FF8C00; border-left: 5px solid #FF8C00;}
.Pcontent{ text-align: left; padding-left: 15px; padding-top: 3px; font-size: 12px;}
.Pfoot{ margin: 10px 20px 0px 0px; text-align: right; font-size: 12px; a: link,a:visited{text-decoration:none; color: #FF8C00;} }
font-family: "宋体";
font-size: 12px;
font-weight: bold;
color: #FFFFFF;
text-decoration: none;
}
.style_2 {
font-family: "宋体";
font-size: 14px;
font-weight: normal;
color: #333333;
}
.style_3 {
font-family: "宋体";
font-size: 12px;
font-weight: normal;
color: #333333;
}
.style_4 {
font-family: "宋体";
font-size: 12px;
font-weight: normal;
color: #FFFFFF;
}
.style_5 {
font-family: "宋体";
font-size: 12px;
font-weight: normal;
color: #333333;
}
.style6 {
font-family: "宋体";
font-size: 12px;
color: #005BA7;
text-decoration: none;
}
.style_7 {
font-family: "宋体";
font-size: 14px;
font-weight: normal;
color: #FFFFFF;
}
.style_8 {
font-family: "宋体";
color: #FF0000;
text-decoration: none;
font-size: 14px;
}
.style_9 {
font-family: "宋体";
font-size: 18px;
color: #FFFFFF;
}
.style_10 {
font-family: "宋体";
font-size: 24px;
font-weight: bold;
color: #FFFFFF;
}
.tizi_1 {
font-family: "宋体";
font-size: 12px;
line-height: normal;
color: #3A3A3A;
}
.input {
background-color: #FFFFFF;
margin: 1px;
padding: 1px;
border: 1px solid #686868;
}
.ziti_2 {
font-family: "宋体";
font-size: 12px;
color: #FF4800;
}
.tizi_3 {
font-family: "宋体";
font-size: 12px;
color: #003C72;
}
.ks_1 {
font-family: "宋体";
font-size: 14px;
font-weight: bold;
color: #0154A0;
}
.ks_2 {
font-family: "宋体";
font-size: 14px;
font-weight: bold;
color: #000000;
}
.ks_3 {
font-family: "宋体";
font-size: 14px;
font-weight: bold;
color: #FF0000;
}
.ks_4 {
font-family: "宋体";
font-size: 16px;
font-weight: bold;
font-variant: normal;
color: #FFFFFF;
}
.ks_5 {
font-family: "宋体";
font-size: 16px;
font-weight: bold;
color: #FFFF00;
}
.ks_6 {
font-family: "宋体";
font-size: 16px;
font-weight: normal;
color: #FEEED7;
}
.ks_7 {
font-family: "宋体";
font-size: 24px;
color: #0067BD;
}
.ks_8 {
font-family: "宋体";
font-size: 14px;
font-style: normal;
line-height: 20px;
color: #000000;
}
.ks_9 {
font-family: "宋体";
font-size: 36px;
color: #FFFFFF;
}
.xtdl_1 {
font-family: "宋体";
font-size: 12px;
color: #000000;
}
.xtdl_2 {
font-family: "宋体";
font-size: 12px;
font-weight: bold;
color: #0024FF;
}
.xtdl_3 {
font-family: "宋体";
font-size: 12px;
font-weight: bold;
color: #FF4701;
}
.jt-9 {
font-size: 12px;
line-height: 20px;
color: #000000;
}
.input {
font-family: "宋体";
font-size: 12px;
font-style: normal;
font-weight: normal;
margin: 1px;
padding: 1px;
border: 1px solid #336699;
background-color: #EFFAFE;
list-style-type: disc;
}
.ziti {
font-family: "宋体";
font-size: 12px;
font-style: normal;
line-height: normal;
font-weight: normal;
color: #000000;
text-decoration: none;
}
.contentpanel
{ text-align: left; margin: 0 auto!important; margin: 0px;}
.Ptitle{ height: 18px; text-align: left; margin: 0px 9px 0px 9px; padding: 3px 0px 0px 13px; font-weight: bold; font-size: 12px; font-family: Arial; color: #000; border: 1px solid #FF8C00; border-left: 5px solid #FF8C00;}
.Pcontent{ text-align: left; padding-left: 15px; padding-top: 3px; font-size: 12px;}
.Pfoot{ margin: 10px 20px 0px 0px; text-align: right; font-size: 12px; a: link,a:visited{text-decoration:none; color: #FF8C00;} }
DWBMset.aspx
<%
@ Page language
=
"
c#
"
Codebehind
=
"
DWBMset.aspx.cs
"
AutoEventWireup
=
"
false
"
Inherits
=
"
FineYYWeb.Competence.DWBMset
"
%>
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
< HTML >
< HEAD >
< title >DWBMset </ title >
< meta content ="Microsoft Visual Studio .NET 7.1" name ="GENERATOR" >
< meta content ="C#" name ="CODE_LANGUAGE" >
< meta content ="JavaScript" name ="vs_defaultClientScript" >
< meta content ="http://schemas.microsoft.com/intellisense/ie5" name ="vs_targetSchema" >
< LINK href ="css/css.css" type ="text/css" rel ="Stylesheet" >
</ HEAD >
< body topMargin ="0" MS_POSITIONING ="GridLayout" >
< form id ="Form1" style ="TEXT-ALIGN: center" method ="post" runat ="server" >
< TABLE class ="style_3" id ="Table1" style ="HEIGHT: 253px" cellSpacing ="0" cellPadding ="0"
width ="300" border ="0" >
< TR >
< TD class ="style_3" style ="BACKGROUND-IMAGE: url(../images/you_zlbg.gif); HEIGHT: 36px; colSpan: "
colSpan ="2" >
< P align ="center" >< font color ="white" >< b >精细化管理考核用户注册 </ b ></ font ></ P >
</ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >辖区编码 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="user_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text1"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >单位名称 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="name_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text1"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >单位部门编码 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="number_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text2"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; HEIGHT: 25px; TEXT-ALIGN: right" >
< P >< FONT face ="宋体" >部门名称 </ FONT ></ P >
</ TD >
< TD style ="HEIGHT: 25px" >< FONT face ="宋体" > < INPUT id ="Password1" style ="WIDTH: 133px; HEIGHT: 22px" type ="text" size ="16" name ="Text1"
runat ="server" > </ FONT >
</ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; HEIGHT: 25px; TEXT-ALIGN: right" >
< P >< FONT face ="宋体" >机关代码 </ FONT ></ P >
</ TD >
< TD style ="HEIGHT: 25px" >< FONT face ="宋体" > < INPUT id ="JGDM_Text" style ="WIDTH: 133px; HEIGHT: 22px" type ="text" size ="16" name ="Text1"
runat ="server" > </ FONT >
</ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >单位中队编码 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="DWZDBM_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text6"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >中队名称 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="auditNum_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px" >< FONT face ="宋体" ></ FONT ></ TD >
< TD >< FONT face ="宋体" >
</ FONT >
< asp:button class ="jt-9" id ="submitButton" runat ="server" Text ="增 加" ></ asp:button ></ TD >
</ TR >
< TR >
< TD colSpan ="2" >< FONT face ="宋体" >< asp:datagrid id ="myDataGrid" runat ="server" Width ="824px" AllowPaging ="True" CssClass ="jt-9"
AutoGenerateColumns ="False" DataKeyField ="ID" >
< Columns >
< asp:EditCommandColumn ButtonType ="LinkButton" UpdateText ="确定" HeaderText ="修改" CancelText ="取消" EditText ="修改" ></ asp:EditCommandColumn >
< asp:ButtonColumn Text ="删除" HeaderText ="删除" CommandName ="Delete" ></ asp:ButtonColumn >
< asp:BoundColumn Visible ="False" DataField ="ID" HeaderText ="ID" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="XQBM" HeaderText ="辖区编码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="DW" HeaderText ="单位名称" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="DWBMBM" HeaderText ="单位部门编码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="BM" HeaderText ="部门名称" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="JGDM" HeaderText ="机关代码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="DWZDBM" HeaderText ="单位中队编码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="ZD" HeaderText ="中队名称" ></ asp:BoundColumn >
</ Columns >
< PagerStyle HorizontalAlign ="Center" Mode ="NumericPages" ></ PagerStyle >
</ asp:datagrid ></ FONT ></ TD >
</ TR >
</ TABLE >
</ form >
</ body >
</ HTML >
<! DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
< HTML >
< HEAD >
< title >DWBMset </ title >
< meta content ="Microsoft Visual Studio .NET 7.1" name ="GENERATOR" >
< meta content ="C#" name ="CODE_LANGUAGE" >
< meta content ="JavaScript" name ="vs_defaultClientScript" >
< meta content ="http://schemas.microsoft.com/intellisense/ie5" name ="vs_targetSchema" >
< LINK href ="css/css.css" type ="text/css" rel ="Stylesheet" >
</ HEAD >
< body topMargin ="0" MS_POSITIONING ="GridLayout" >
< form id ="Form1" style ="TEXT-ALIGN: center" method ="post" runat ="server" >
< TABLE class ="style_3" id ="Table1" style ="HEIGHT: 253px" cellSpacing ="0" cellPadding ="0"
width ="300" border ="0" >
< TR >
< TD class ="style_3" style ="BACKGROUND-IMAGE: url(../images/you_zlbg.gif); HEIGHT: 36px; colSpan: "
colSpan ="2" >
< P align ="center" >< font color ="white" >< b >精细化管理考核用户注册 </ b ></ font ></ P >
</ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >辖区编码 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="user_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text1"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >单位名称 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="name_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text1"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >单位部门编码 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="number_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text2"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; HEIGHT: 25px; TEXT-ALIGN: right" >
< P >< FONT face ="宋体" >部门名称 </ FONT ></ P >
</ TD >
< TD style ="HEIGHT: 25px" >< FONT face ="宋体" > < INPUT id ="Password1" style ="WIDTH: 133px; HEIGHT: 22px" type ="text" size ="16" name ="Text1"
runat ="server" > </ FONT >
</ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; HEIGHT: 25px; TEXT-ALIGN: right" >
< P >< FONT face ="宋体" >机关代码 </ FONT ></ P >
</ TD >
< TD style ="HEIGHT: 25px" >< FONT face ="宋体" > < INPUT id ="JGDM_Text" style ="WIDTH: 133px; HEIGHT: 22px" type ="text" size ="16" name ="Text1"
runat ="server" > </ FONT >
</ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >单位中队编码 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="DWZDBM_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" name ="Text6"
runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px; TEXT-ALIGN: right" >< FONT face ="宋体" >中队名称 </ FONT ></ TD >
< TD >< FONT face ="宋体" > </ FONT >< INPUT class ="jt-9" id ="auditNum_Text" style ="WIDTH: 133px; HEIGHT: 21px" type ="text" runat ="server" ></ TD >
</ TR >
< TR >
< TD style ="WIDTH: 149px" >< FONT face ="宋体" ></ FONT ></ TD >
< TD >< FONT face ="宋体" >
</ FONT >
< asp:button class ="jt-9" id ="submitButton" runat ="server" Text ="增 加" ></ asp:button ></ TD >
</ TR >
< TR >
< TD colSpan ="2" >< FONT face ="宋体" >< asp:datagrid id ="myDataGrid" runat ="server" Width ="824px" AllowPaging ="True" CssClass ="jt-9"
AutoGenerateColumns ="False" DataKeyField ="ID" >
< Columns >
< asp:EditCommandColumn ButtonType ="LinkButton" UpdateText ="确定" HeaderText ="修改" CancelText ="取消" EditText ="修改" ></ asp:EditCommandColumn >
< asp:ButtonColumn Text ="删除" HeaderText ="删除" CommandName ="Delete" ></ asp:ButtonColumn >
< asp:BoundColumn Visible ="False" DataField ="ID" HeaderText ="ID" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="XQBM" HeaderText ="辖区编码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="DW" HeaderText ="单位名称" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="DWBMBM" HeaderText ="单位部门编码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="BM" HeaderText ="部门名称" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="JGDM" HeaderText ="机关代码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="DWZDBM" HeaderText ="单位中队编码" ></ asp:BoundColumn >
< asp:BoundColumn DataField ="ZD" HeaderText ="中队名称" ></ asp:BoundColumn >
</ Columns >
< PagerStyle HorizontalAlign ="Center" Mode ="NumericPages" ></ PagerStyle >
</ asp:datagrid ></ FONT ></ TD >
</ TR >
</ TABLE >
</ form >
</ body >
</ HTML >
DWBMset.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;
namespace FineYYWeb.Competence
{
/// <summary>
/// DWBMset 的摘要说明。
/// </summary>
public class DWBMset : System.Web.UI.Page
{
public SqlConnection conn;
public SqlCommand comm;
public SqlDataAdapter dap;
public DataSet myDataSet;
protected System.Web.UI.HtmlControls.HtmlInputText user_Text;
protected System.Web.UI.HtmlControls.HtmlInputText number_Text;
protected System.Web.UI.HtmlControls.HtmlInputText audit_Text;
protected System.Web.UI.WebControls.Button submitButton;
protected System.Web.UI.HtmlControls.HtmlInputText name_Text;
protected System.Web.UI.HtmlControls.HtmlInputText auditNum_Text;
protected System.Web.UI.WebControls.DataGrid myDataGrid;
public string m_connString= " user id=sa;password=5518008;initial catalog=jxhpt;data source=127.0.0.1;Connect Timeout=30 ";
string str_qxbm= null;
string loginName= null;
string str_UPName= null;
protected System.Web.UI.HtmlControls.HtmlInputText Password1;
protected System.Web.UI.HtmlControls.HtmlInputText DWZDBM_Text;
protected System.Web.UI.HtmlControls.HtmlInputText JGDM_Text;
string str_UPJH= null;
private void Page_Load( object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
// myHashtable(); // 判断是否登陆,并传递用户的相关信息
Grid_Bind(); // myDataGrid数据源
}
}
public void myHashtable() // 登陆_数据源
{
if(Session[ " ht_user_msg "]!= null)
{
Hashtable myHT = null;
myHT = (Hashtable)Session[ " ht_user_msg "];
loginName = myHT[ " DLNAME "].ToString(); // 用户名
str_UPName = myHT[ " TRUENAME "].ToString(); // 用户_姓名
str_UPJH = myHT[ " DWZDBM "].ToString(); // 用户_单位中队编码
str_qxbm=myHT[ " QXBM "].ToString();
if(str_qxbm!= " 002 ")
{ Response.Redirect( " ../Error.aspx?ID=2 "); }
}
else
{ Response.Redirect( " ../Error.aspx?ID=1 "); }
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.submitButton.Click += new System.EventHandler( this.submitButton_Click);
this.myDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler( this.myDataGrid_PageIndexChanged);
this.myDataGrid.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_CancelCommand);
this.myDataGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_EditCommand);
this.myDataGrid.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_UpdateCommand);
this.myDataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_DeleteCommand);
this.myDataGrid.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler( this.myDataGrid_ItemDataBound);
this.Load += new System.EventHandler( this.Page_Load);
}
#endregion
public void Grid_Bind() // myDataGrid数据源
{
string sqlString= " select * from SP_JJH_DICT_DWBM ";
dap= new SqlDataAdapter(sqlString,m_connString);
myDataSet= new DataSet();
dap.Fill(myDataSet);
myDataGrid.DataSource=myDataSet.Tables[ 0].DefaultView;
myDataGrid.DataBind();
}
private void submitButton_Click( object sender, System.EventArgs e)
{
string user = user_Text.Value.Trim(); // 辖区编码
string name = name_Text.Value.Trim(); // 单位名称
string number = number_Text.Value.Trim(); // 单位部门编码
string password = Password1.Value.Trim(); // Password1
string strJGDM = JGDM_Text.Value.Trim();
string strDWZDBM = DWZDBM_Text.Value.Trim(); // 单位中队编码
string auditNum = auditNum_Text.Value.Trim(); // 中队名称
if(user== "" || name== "" || number== "" || password== ""|| auditNum== "" ||strJGDM== "" ||strDWZDBM== "")
{
this.RegisterStartupScript( " js ", " <script>alert('请输入完整的信息!');</script> ");
return;
}
// 查询 单位名称 是否存在
string sqlString = " select XQBM from SP_JJH_DICT_DWBM where JGDM=' "+strJGDM+ " ' ";
dap= new SqlDataAdapter(sqlString,m_connString);
myDataSet= new DataSet();
dap.Fill(myDataSet);
if (myDataSet.Tables[ 0].Rows.Count == 0) // 用户不存在
{
sqlString = " insert into SP_JJH_DICT_DWBM (XQBM,DW,DWBMBM,BM,JGDM,DWZDBM,ZD) ";
sqlString += " values(' "+user+ " ',' "+name+ " ',' "+number+ " ',' "+password+ " ',' "+strJGDM+ " ',' "+strDWZDBM+ " ',' "+auditNum+ " ') ";
// dap=new SqlDataAdapter(sqlString,m_connString);
// dap.InsertCommand();
conn = new SqlConnection(m_connString);
comm = new SqlCommand(sqlString,conn);
if(conn.State.ToString()== " Closed " )conn.Open();
comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
conn.Dispose();
Grid_Bind(); // myDataGrid数据源
}
else
{
this.RegisterStartupScript( " js ", " <script>alert('机关代码已存在!');</script> ");
}
}
// private void myDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
// {
// user_Text.Value = myDataGrid.SelectedItem.Cells[3].Text.Trim(); // .Replace(" ","");
// name_Text.Value = myDataGrid.SelectedItem.Cells[4].Text.Trim(); // .Replace(" ","");
// number_Text.Value = myDataGrid.SelectedItem.Cells[5].Text.Trim(); // .Replace(" ","");
// // loginNum_Text.Value = myDataGrid.SelectedItem.Cells[4].Text.Trim();
// Password1.Value = myDataGrid.SelectedItem.Cells[6].Text.Trim();
// // departNum_Text.SelectedValue = myDataGrid.SelectedItem.Cells[8].Text.Trim();
// audit_Text.Value = myDataGrid.SelectedItem.Cells[9].Text.Trim();
// auditNum_Text.Value = myDataGrid.SelectedItem.Cells[10].Text.Trim();
// }
private void myDataGrid_PageIndexChanged( object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
myDataGrid.CurrentPageIndex=e.NewPageIndex;
Grid_Bind();
}
// 删除
private void myDataGrid_DeleteCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id=e.Item.Cells[ 2].Text;
string sql= " delete from SP_JJH_DICT_DWBM where ID=' "+id+ " ' ";
SqlConnection co= new SqlConnection(m_connString);
SqlCommand com= new SqlCommand(sql,co);
co.Open();
com.ExecuteNonQuery();
com.Dispose();
co.Close();
co.Dispose();
this.Grid_Bind();
}
// 修改
private void myDataGrid_EditCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
myDataGrid.EditItemIndex = e.Item.ItemIndex;
Grid_Bind();
}
// 取消修改
private void myDataGrid_CancelCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
myDataGrid.EditItemIndex = - 1;
Grid_Bind();
}
// 更新
private void myDataGrid_UpdateCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id=myDataGrid.DataKeys[e.Item.ItemIndex].ToString();
TextBox tbXQBM=(TextBox)e.Item.Cells[ 3].Controls[ 0];
string strXQBM= tbXQBM.Text.Trim();
TextBox tbDW=(TextBox)e.Item.Cells[ 4].Controls[ 0];
string strDW = tbDW.Text.Trim();
TextBox tbDWBMBM=(TextBox)e.Item.Cells[ 5].Controls[ 0];
string strDWBMBM = tbDWBMBM.Text.Trim();
TextBox tbBM=(TextBox)e.Item.Cells[ 6].Controls[ 0];
string strBM = tbBM.Text.Trim();
TextBox tbJGDM=(TextBox)e.Item.Cells[ 7].Controls[ 0];
string strJGDM = tbJGDM.Text.Trim();
TextBox tbDWZDBM=(TextBox)e.Item.Cells[ 8].Controls[ 0];
string strDWZDBM = tbDWZDBM.Text.Trim();
TextBox tbZD=(TextBox)e.Item.Cells[ 9].Controls[ 0];
string strZD = tbZD.Text.Trim();
string MYsqlString = " update SP_JJH_DICT_DWBM set XQBM=' "+strXQBM+ " ',DW=' "+strDW+ " ',DWBMBM=' "+strDWBMBM+ " ',BM=' "+strBM+ " ',JGDM=' "+strJGDM+ " ',DWZDBM=' "+strDWZDBM+ " ',ZD=' "+strZD+ " ' where ID=' "+id+ " ' ";
conn = new SqlConnection(m_connString);
comm = new SqlCommand(MYsqlString,conn);
if(conn.State.ToString()== " Closed " )conn.Open();
comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
conn.Dispose();
myDataGrid.EditItemIndex = - 1;
Grid_Bind();
}
// 设置编辑模式的 TextBox 的宽度
private void myDataGrid_ItemDataBound( object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.EditItem)
{
((TextBox)e.Item.Cells[ 3].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 4].Controls[ 0]).Width= 170;
((TextBox)e.Item.Cells[ 5].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 6].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 7].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 8].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 9].Controls[ 0]).Width= 90;
}
}
}
}
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;
namespace FineYYWeb.Competence
{
/// <summary>
/// DWBMset 的摘要说明。
/// </summary>
public class DWBMset : System.Web.UI.Page
{
public SqlConnection conn;
public SqlCommand comm;
public SqlDataAdapter dap;
public DataSet myDataSet;
protected System.Web.UI.HtmlControls.HtmlInputText user_Text;
protected System.Web.UI.HtmlControls.HtmlInputText number_Text;
protected System.Web.UI.HtmlControls.HtmlInputText audit_Text;
protected System.Web.UI.WebControls.Button submitButton;
protected System.Web.UI.HtmlControls.HtmlInputText name_Text;
protected System.Web.UI.HtmlControls.HtmlInputText auditNum_Text;
protected System.Web.UI.WebControls.DataGrid myDataGrid;
public string m_connString= " user id=sa;password=5518008;initial catalog=jxhpt;data source=127.0.0.1;Connect Timeout=30 ";
string str_qxbm= null;
string loginName= null;
string str_UPName= null;
protected System.Web.UI.HtmlControls.HtmlInputText Password1;
protected System.Web.UI.HtmlControls.HtmlInputText DWZDBM_Text;
protected System.Web.UI.HtmlControls.HtmlInputText JGDM_Text;
string str_UPJH= null;
private void Page_Load( object sender, System.EventArgs e)
{
// 在此处放置用户代码以初始化页面
if(!IsPostBack)
{
// myHashtable(); // 判断是否登陆,并传递用户的相关信息
Grid_Bind(); // myDataGrid数据源
}
}
public void myHashtable() // 登陆_数据源
{
if(Session[ " ht_user_msg "]!= null)
{
Hashtable myHT = null;
myHT = (Hashtable)Session[ " ht_user_msg "];
loginName = myHT[ " DLNAME "].ToString(); // 用户名
str_UPName = myHT[ " TRUENAME "].ToString(); // 用户_姓名
str_UPJH = myHT[ " DWZDBM "].ToString(); // 用户_单位中队编码
str_qxbm=myHT[ " QXBM "].ToString();
if(str_qxbm!= " 002 ")
{ Response.Redirect( " ../Error.aspx?ID=2 "); }
}
else
{ Response.Redirect( " ../Error.aspx?ID=1 "); }
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.submitButton.Click += new System.EventHandler( this.submitButton_Click);
this.myDataGrid.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler( this.myDataGrid_PageIndexChanged);
this.myDataGrid.CancelCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_CancelCommand);
this.myDataGrid.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_EditCommand);
this.myDataGrid.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_UpdateCommand);
this.myDataGrid.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler( this.myDataGrid_DeleteCommand);
this.myDataGrid.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler( this.myDataGrid_ItemDataBound);
this.Load += new System.EventHandler( this.Page_Load);
}
#endregion
public void Grid_Bind() // myDataGrid数据源
{
string sqlString= " select * from SP_JJH_DICT_DWBM ";
dap= new SqlDataAdapter(sqlString,m_connString);
myDataSet= new DataSet();
dap.Fill(myDataSet);
myDataGrid.DataSource=myDataSet.Tables[ 0].DefaultView;
myDataGrid.DataBind();
}
private void submitButton_Click( object sender, System.EventArgs e)
{
string user = user_Text.Value.Trim(); // 辖区编码
string name = name_Text.Value.Trim(); // 单位名称
string number = number_Text.Value.Trim(); // 单位部门编码
string password = Password1.Value.Trim(); // Password1
string strJGDM = JGDM_Text.Value.Trim();
string strDWZDBM = DWZDBM_Text.Value.Trim(); // 单位中队编码
string auditNum = auditNum_Text.Value.Trim(); // 中队名称
if(user== "" || name== "" || number== "" || password== ""|| auditNum== "" ||strJGDM== "" ||strDWZDBM== "")
{
this.RegisterStartupScript( " js ", " <script>alert('请输入完整的信息!');</script> ");
return;
}
// 查询 单位名称 是否存在
string sqlString = " select XQBM from SP_JJH_DICT_DWBM where JGDM=' "+strJGDM+ " ' ";
dap= new SqlDataAdapter(sqlString,m_connString);
myDataSet= new DataSet();
dap.Fill(myDataSet);
if (myDataSet.Tables[ 0].Rows.Count == 0) // 用户不存在
{
sqlString = " insert into SP_JJH_DICT_DWBM (XQBM,DW,DWBMBM,BM,JGDM,DWZDBM,ZD) ";
sqlString += " values(' "+user+ " ',' "+name+ " ',' "+number+ " ',' "+password+ " ',' "+strJGDM+ " ',' "+strDWZDBM+ " ',' "+auditNum+ " ') ";
// dap=new SqlDataAdapter(sqlString,m_connString);
// dap.InsertCommand();
conn = new SqlConnection(m_connString);
comm = new SqlCommand(sqlString,conn);
if(conn.State.ToString()== " Closed " )conn.Open();
comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
conn.Dispose();
Grid_Bind(); // myDataGrid数据源
}
else
{
this.RegisterStartupScript( " js ", " <script>alert('机关代码已存在!');</script> ");
}
}
// private void myDataGrid_SelectedIndexChanged(object sender, System.EventArgs e)
// {
// user_Text.Value = myDataGrid.SelectedItem.Cells[3].Text.Trim(); // .Replace(" ","");
// name_Text.Value = myDataGrid.SelectedItem.Cells[4].Text.Trim(); // .Replace(" ","");
// number_Text.Value = myDataGrid.SelectedItem.Cells[5].Text.Trim(); // .Replace(" ","");
// // loginNum_Text.Value = myDataGrid.SelectedItem.Cells[4].Text.Trim();
// Password1.Value = myDataGrid.SelectedItem.Cells[6].Text.Trim();
// // departNum_Text.SelectedValue = myDataGrid.SelectedItem.Cells[8].Text.Trim();
// audit_Text.Value = myDataGrid.SelectedItem.Cells[9].Text.Trim();
// auditNum_Text.Value = myDataGrid.SelectedItem.Cells[10].Text.Trim();
// }
private void myDataGrid_PageIndexChanged( object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
{
myDataGrid.CurrentPageIndex=e.NewPageIndex;
Grid_Bind();
}
// 删除
private void myDataGrid_DeleteCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id=e.Item.Cells[ 2].Text;
string sql= " delete from SP_JJH_DICT_DWBM where ID=' "+id+ " ' ";
SqlConnection co= new SqlConnection(m_connString);
SqlCommand com= new SqlCommand(sql,co);
co.Open();
com.ExecuteNonQuery();
com.Dispose();
co.Close();
co.Dispose();
this.Grid_Bind();
}
// 修改
private void myDataGrid_EditCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
myDataGrid.EditItemIndex = e.Item.ItemIndex;
Grid_Bind();
}
// 取消修改
private void myDataGrid_CancelCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
myDataGrid.EditItemIndex = - 1;
Grid_Bind();
}
// 更新
private void myDataGrid_UpdateCommand( object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
{
string id=myDataGrid.DataKeys[e.Item.ItemIndex].ToString();
TextBox tbXQBM=(TextBox)e.Item.Cells[ 3].Controls[ 0];
string strXQBM= tbXQBM.Text.Trim();
TextBox tbDW=(TextBox)e.Item.Cells[ 4].Controls[ 0];
string strDW = tbDW.Text.Trim();
TextBox tbDWBMBM=(TextBox)e.Item.Cells[ 5].Controls[ 0];
string strDWBMBM = tbDWBMBM.Text.Trim();
TextBox tbBM=(TextBox)e.Item.Cells[ 6].Controls[ 0];
string strBM = tbBM.Text.Trim();
TextBox tbJGDM=(TextBox)e.Item.Cells[ 7].Controls[ 0];
string strJGDM = tbJGDM.Text.Trim();
TextBox tbDWZDBM=(TextBox)e.Item.Cells[ 8].Controls[ 0];
string strDWZDBM = tbDWZDBM.Text.Trim();
TextBox tbZD=(TextBox)e.Item.Cells[ 9].Controls[ 0];
string strZD = tbZD.Text.Trim();
string MYsqlString = " update SP_JJH_DICT_DWBM set XQBM=' "+strXQBM+ " ',DW=' "+strDW+ " ',DWBMBM=' "+strDWBMBM+ " ',BM=' "+strBM+ " ',JGDM=' "+strJGDM+ " ',DWZDBM=' "+strDWZDBM+ " ',ZD=' "+strZD+ " ' where ID=' "+id+ " ' ";
conn = new SqlConnection(m_connString);
comm = new SqlCommand(MYsqlString,conn);
if(conn.State.ToString()== " Closed " )conn.Open();
comm.ExecuteNonQuery();
comm.Dispose();
conn.Close();
conn.Dispose();
myDataGrid.EditItemIndex = - 1;
Grid_Bind();
}
// 设置编辑模式的 TextBox 的宽度
private void myDataGrid_ItemDataBound( object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
if(e.Item.ItemType == ListItemType.EditItem)
{
((TextBox)e.Item.Cells[ 3].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 4].Controls[ 0]).Width= 170;
((TextBox)e.Item.Cells[ 5].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 6].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 7].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 8].Controls[ 0]).Width= 90;
((TextBox)e.Item.Cells[ 9].Controls[ 0]).Width= 90;
}
}
}
}
本文转自钢钢博客园博客,原文链接:http://www.cnblogs.com/xugang/archive/2007/12/20/1007318.html,如需转载请自行联系原作者