📄 careditform.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 CarControl
{
/// <summary>
/// careditForm 的摘要说明。
/// </summary>
public class careditForm : System.Web.UI.Page
{
protected System.Web.UI.WebControls.ImageButton ImageButton1;
protected System.Web.UI.WebControls.TextBox car_code;
protected System.Web.UI.WebControls.TextBox car_type;
protected System.Web.UI.WebControls.DropDownList car_user;
protected System.Web.UI.WebControls.TextBox car_usermobile;
protected System.Web.UI.WebControls.TextBox car_usertel;
protected System.Web.UI.WebControls.DropDownList car_state;
protected System.Web.UI.WebControls.TextBox car_stateuser;
protected System.Web.UI.WebControls.DropDownList car_company2;
protected System.Web.UI.WebControls.TextBox car_statecause;
protected System.Web.UI.WebControls.TextBox car_statestart;
protected System.Web.UI.WebControls.TextBox car_stateend;
protected System.Web.UI.WebControls.TextBox car_xingcheng;
protected System.Web.UI.WebControls.TextBox car_gongli;
protected System.Web.UI.WebControls.ImageButton ImageButton2;
protected System.Web.UI.WebControls.TextBox car_beizhu;
protected System.Web.UI.WebControls.DropDownList car_company3;
protected System.Web.UI.WebControls.DropDownList car_company4;
protected System.Web.UI.WebControls.DropDownList car_company5;
protected System.Web.UI.WebControls.DropDownList car_company6;
protected System.Web.UI.WebControls.TextBox car_shiyonguser;
private void Page_Load(object sender, System.EventArgs e)
{
if(!Page.IsPostBack)
{
string S_car_code=Session["car_code"].ToString();
string SqlConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
SqlConnection Conn=new SqlConnection(SqlConn);
Conn.Open();
//下面初始化选择设置车辆的信息
string SqlStr1="select car_code,car_type,car_usermobile,car_usertel from [car] where car_code='"+S_car_code+"'";
SqlCommand Comm1=new SqlCommand(SqlStr1,Conn);
SqlDataReader read1=Comm1.ExecuteReader();
if(read1.Read())
{
car_code.Text=read1.GetValue(0).ToString();
car_type.Text=read1.GetValue(1).ToString();
car_usermobile.Text=read1.GetValue(2).ToString();
car_usertel.Text=read1.GetValue(3).ToString();
read1.Close();
}
//下面初始化车辆司机
string SqlStr2="select car_user from [car] where car_code='"+S_car_code+"'";
SqlDataAdapter myadapter0 =new SqlDataAdapter(SqlStr2,Conn);
DataSet ds0=new DataSet();
myadapter0.Fill(ds0,"car");
string car_user_name=ds0.Tables["car"].Rows[0]["car_user"].ToString();
//car_user.Items.Add(new ListItem(car_user_name,car_user_name));
//car_user.DataBind();
string SqlStr_2="select car_username from [caruser]";
SqlDataAdapter myadpter_0=new SqlDataAdapter(SqlStr_2,Conn);
myadpter_0.Fill(ds0,"car_user");
car_user.DataSource=ds0.Tables["car_user"].DefaultView;
car_user.DataTextField="car_username";
car_user.DataValueField="car_username";
//int Index=car_user.SelectedIndex;
//car_user.SelectedIndex=Index-1;
car_user.DataBind();
car_user.Items.Add(new ListItem(car_user_name,car_user_name));
car_user.SelectedIndex=this.car_user.Items.Count-1;
//下面初始化车辆状态信息
car_state.Items.Add(new ListItem("空闲","0"));
car_state.Items.Add(new ListItem("外出","1"));
car_state.Items.Add(new ListItem("预定","2"));
car_state.Items.Add(new ListItem("维修","3"));
car_state.Items.Add(new ListItem("待定","4"));
//下面初始使用部门
string SqlStr4="select * from bumen";
SqlDataAdapter myadapter =new SqlDataAdapter(SqlStr4,Conn);
DataSet ds=new DataSet();
myadapter.Fill(ds,"bumen");
car_company2.DataSource=ds;
car_company2.DataTextField="type";
car_company2.DataValueField="type";
car_company2.DataBind();
car_company2.Items.Add("暂无");
car_company2.Items[car_company2.Items.Count-1].Value="";
car_company2.SelectedIndex=car_company2.Items.Count - 1;
//附加拼车实用部门
car_company3.DataSource=ds;
car_company3.DataTextField="type";
car_company3.DataValueField="type";
car_company3.DataBind();
car_company3.Items.Add("暂无");
car_company3.Items[car_company3.Items.Count-1].Value="";
car_company3.SelectedIndex=car_company3.Items.Count - 1;
car_company4.DataSource=ds;
car_company4.DataTextField="type";
car_company4.DataValueField="type";
car_company4.DataBind();
car_company4.Items.Add("暂无");
car_company4.Items[car_company4.Items.Count-1].Value="";
car_company4.SelectedIndex=car_company4.Items.Count - 1;
car_company5.DataSource=ds;
car_company5.DataTextField="type";
car_company5.DataValueField="type";
car_company5.DataBind();
car_company5.Items.Add("暂无");
car_company5.Items[car_company5.Items.Count-1].Value="";
car_company5.SelectedIndex=car_company5.Items.Count - 1;
car_company6.DataSource=ds;
car_company6.DataTextField="type";
car_company6.DataValueField="type";
car_company6.DataBind();
car_company6.Items.Add("暂无");
car_company6.Items[car_company6.Items.Count-1].Value="";
car_company6.SelectedIndex=car_company6.Items.Count - 1;
//关闭连接
Conn.Close();
}// 在此处放置用户代码以初始化页面
}
#region Web 窗体设计器生成的代码
override protected void OnInit(EventArgs e)
{
//
// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
/// <summary>
/// 设计器支持所需的方法 - 不要使用代码编辑器修改
/// 此方法的内容。
/// </summary>
private void InitializeComponent()
{
this.car_user.SelectedIndexChanged += new System.EventHandler(this.car_user_SelectedIndexChanged);
this.car_state.SelectedIndexChanged += new System.EventHandler(this.car_state_SelectedIndexChanged);
this.car_company2.SelectedIndexChanged += new System.EventHandler(this.car_company2_SelectedIndexChanged);
this.ImageButton1.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton1_Click);
this.ImageButton2.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton2_Click);
this.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private void car_state_SelectedIndexChanged(object sender, System.EventArgs e)
{
string S_carstate=car_state.SelectedItem.Text;
}
private void car_company2_SelectedIndexChanged(object sender, System.EventArgs e)
{
string S_company=car_company2.SelectedItem.Text;
}
private void car_user_SelectedIndexChanged(object sender, System.EventArgs e)
{
string S_caruser=car_user.SelectedItem.Text;
}
private void ImageButton1_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
string S_carcode=Session["car_code"].ToString();
string code=car_code.Text;
string type=car_type.Text;
string user=car_user.SelectedItem.Text;
string mobile=car_usermobile.Text;
string tel=car_usertel.Text;
string state=car_state.SelectedItem.Text;
string xingcheng=car_xingcheng.Text;
string gongli=car_gongli.Text;
string start=car_statestart.Text;
string end=car_stateend.Text;
string stateuser=car_stateuser.Text;
string company_1=car_company2.SelectedItem.Text;
string company_more=car_company3.SelectedItem.Text+" "+car_company4.SelectedItem.Text+" "+car_company5.SelectedItem.Text+" "+car_company6.SelectedItem.Text;
string company=company_1+" "+company_more.Replace("暂无","");
string shiyonguser=car_shiyonguser.Text;
string cause=car_statecause.Text;
string beizhu=car_beizhu.Text;
string SqlConn=System.Configuration.ConfigurationSettings.AppSettings["ConnString"];
SqlConnection conn=new SqlConnection(SqlConn);
conn.Open();
SqlCommand cmd=new SqlCommand();
cmd.Connection=conn;
cmd.CommandText="update [car] set [car_code]='"+code+"',[car_type]='"+type+"',[car_user]='"+user+"',[car_usermobile]='"+mobile+"',[car_usertel]='"+tel+"',[car_state]='"+state+"',[car_xingcheng]='"+xingcheng+"',[car_gongli]='"+gongli+"',[car_statestart]='"+start+"',[car_stateend]='"+end+"',[car_stateuser]='"+stateuser+"',[car_company]='"+company+"',[car_shiyonguser]='"+shiyonguser+"',[car_statecause]='"+cause+"',[car_beizhu]='"+beizhu+"' where car_code='"+S_carcode+"'";
cmd.ExecuteNonQuery();
cmd.Dispose();
conn.Close();
Response.Redirect("car_manage.aspx");
}
private void ImageButton2_Click(object sender, System.Web.UI.ImageClickEventArgs e)
{
Response.Redirect("car_manage.aspx");
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -