reread(); } else {
MessageBox.Show(\退票失败!\ } }
catch (Exception ex) {
MessageBox.Show(ex.Message); } } //管理员增加车票
private void btnluru_Click(object sender, EventArgs e) {
if (txtcheci.Text == string.Empty) {
MessageBox.Show(this, \ 请输入车次 ！MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtstartzhan.Text == string.Empty) {
MessageBox.Show(this, \ 请输入出发地 ！MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtsfshijian.Text == string.Empty) {
MessageBox.Show(this, \ 请输入出发时间！MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtendzhan.Text == string.Empty) {
MessageBox.Show(this, \ 请输入目的地 ！MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtdaodashijian.Text == string.Empty) {
MessageBox.Show(this, \ 请输入到达时间 ！MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
27
\\Information:\\\Information:\
\\Information:\
\\Information:\
\\Information:\
return; }
if (txtyingzuoshu.Text == string.Empty) {
MessageBox.Show(this, \ 请输入车票数量 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtyingzuopiaojia.Text == string.Empty) {
MessageBox.Show(this, \ 请输入车票价格！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; } try {
string strSql = \车票信息表 values ('\ + txtcheci.Text + \ + txtstartzhan.Text + \ + txtsfshijian.Text + \ + txtendzhan.Text + \ + txtdaodashijian.Text + \ + txtyingzuoshu.Text + \
+ txtyingzuopiaojia.Text + \ //连接字符串
string conn = \Source=2013-20141011IV;Initial Catalog=火车票管理系统;User
ID=sa;Password=123456\
//执行语句
if (ExecuteNonQuery(strSql, conn) > 0) {
MessageBox.Show(\添加成功!\ return; } else {
MessageBox.Show(\添加失败!\ } }
catch (Exception ex) {
MessageBox.Show(ex.Message); } }
28
//公用执行函数ExecuteNonQuery
public int ExecuteNonQuery(string sql, string conStr) {
using (SqlConnection con = new SqlConnection(conStr)) {
con.Open();
SqlCommand cmd = new SqlCommand(sql, con); return cmd.ExecuteNonQuery(); } } //查看订单
private void mytrian_Load(object sender, EventArgs e) {
this.车票预订表TableAdapter.Fill(this.火车票管理系统DataSet2我的火车票.车票预订表);
SqlConnection conn = new SqlConnection();
conn.ConnectionString = \Source=2013-20141011IV;Initial Catalog=火车票管理系统;User
ID=sa;Password=123456\
conn.Open();
String cmdStr = \车票预订表 where 用户号= '\ SqlCommand sqlCom = new SqlCommand(cmdStr, conn); SqlDataAdapter myadap = new SqlDataAdapter(); myadap.SelectCommand = sqlCom; DataSet myset = new DataSet(); myadap.Fill(myset, \车票预订表\
this.dataGridView1.DataSource = myset.Tables[\车票预订表\
}
//用户修改密码
public partial class updatemima : Form {
public updatemima() {
InitializeComponent(); }
private bool check() {
string str = this.txtzhanghao.Text;
SqlConnection conn = new SqlConnection();
conn.ConnectionString = \Source=2013-20141011IV;Initial Catalog=火车票管理系统;User
ID=sa;Password=123456\
conn.Open();
String commstring = \密码 from 用户表 where 用户号='\ SqlCommand change_comm = new SqlCommand(commstring, conn); SqlDataReader reader = change_comm.ExecuteReader();
29
if (reader.Read() == true) {
if (reader[\密码\ {
MessageBox.Show(this, \ 您输入的原密码不正确 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
reader.Close(); conn.Close(); return false; } else {
reader.Close(); conn.Close(); return true; } } else {
MessageBox.Show(this, \ 不存在您输入的登录帐号 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
reader.Close(); conn.Close(); return false; } }
private void change_code() {
string str1 = this.txtxinmima.Text;
string connstring1 = \Source=2013-20141011IV;Initial Catalog=火车票管理系统;User
ID=sa;Password=123456\
SqlConnection conn1 = new SqlConnection(connstring1); conn1.Open();
string commstring1 = \用户表 set 密码='\ SqlCommand comm1 = new SqlCommand(commstring1, conn1); comm1.ExecuteNonQuery(); conn1.Close();
MessageBox.Show(\登录密码修改成功！\提示\ }
private void btnconfim_Click(object sender, EventArgs e) {
bool str;
if (txtzhanghao.Text == string.Empty)
30
{
MessageBox.Show(this, \ 请输登录帐号 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtyuanmima.Text == string.Empty) {
MessageBox.Show(this, \ 请输原登录密码 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtxinmima.Text == string.Empty) {
MessageBox.Show(this, \ 请输入新登录密码 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
if (txtxinmimaagain.Text == string.Empty) {
MessageBox.Show(this, \ 请再次输入新登录密码 ！ \\Information:\
MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
return; }
str = check(); if (str == false) {
return; } else {
if (this.txtxinmima.Text != this.txtxinmimaagain.Text) {
MessageBox.Show(this, \ 您两次输入的心密码不一致 ！ \\
Information:\
} else {
change_code(); } } } //查看用户信息
private void userxinxi_Load(object sender, EventArgs e)
31