当前文件路径：TicketOnline/ConfigEstablishment.aspx.cs

		            
  1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Collections;
  5using System.Web;
  6using System.Web.Security;
  7using System.Web.UI;
  8using System.Web.UI.WebControls;
  9using System.Web.UI.WebControls.WebParts;
 10using System.Web.UI.HtmlControls;
 11using System.Data.SqlClient;
 12
 13public partial class ConfigEstablishment : System.Web.UI.Page
 14...{
 15    protected void Page_Load(object sender, EventArgs e)
 16    ...{
 17        Panel1.Visible = false;
 18        Panel2.Visible = false;
 19        Panel3.Visible = false;
 20        Panel4.Visible = false;
 21    }
 22    protected void Linkaddticket_Click(object sender, EventArgs e)
 23    ...{//添加车票
 24      
 25
 26            SqlConnection con = db.ceratcon();
 27            con.Open();
 28            SqlCommand cmd = new SqlCommand();
 29            cmd.Connection = (SqlConnection)con;//对象实例化
 30            cmd.CommandText = "insert into Ticket (Tname,Ttime,Tmoney)values(@Tname,@Ttime,@Tmoney)";
 31
 32
 33            cmd.Parameters.Add("@Tname", SqlDbType.VarChar);
 34            cmd.Parameters.Add("@Ttime", SqlDbType.DateTime);
 35            cmd.Parameters.Add("@Tmoney", SqlDbType.Money);
 36
 37
 38            cmd.Parameters["@Tname"].Value = this.txtaddname.Text;
 39
 40            cmd.Parameters["@Ttime"].Value = Convert.ToString(this.txttime.Text);
 41            cmd.Parameters["@Tmoney"].Value = this.txtmoney.Text;
 42            cmd.ExecuteNonQuery();
 43            con.Close();
 44            Panel1.Visible = false;
 45            Panel2.Visible = true;
 46            Panel3.Visible = false;
 47            Panel4.Visible = false;
 48            Response.Write("<script language='javascript'>alert('添加成功')</script>");
 49            
 50    }
 51    
 52    protected void Linkdel_Click(object sender, EventArgs e)
 53    ...{//删除车票
 54        string name = this.DropDownList1.SelectedItem.Text;
 55        SqlConnection con = db.ceratcon();
 56        con.Open();
 57        SqlCommand cmd = new SqlCommand();
 58        cmd.Connection = (SqlConnection)con;
 59        cmd.CommandText = "delete from  Ticket   where  Tname='" + name + "'";
 60        
 61
 62        cmd.ExecuteNonQuery();
 63        con.Close();
 64        Response.Write("<script language='javascript'>alert('删除成功')</script>");
 65
 66        Panel1.Visible = false;
 67        Panel2.Visible = true;
 68        Panel3.Visible = false;
 69        Panel4.Visible = false;
 70
 71    }
 72    protected void Linkupdata_Click(object sender, EventArgs e)
 73    ...{
 74        
 75        //修改车票
 76        string name = this.DropDownList1.SelectedItem.Text;
 77        SqlConnection con = db.ceratcon();
 78        con.Open();
 79        SqlCommand cmd = new SqlCommand();
 80        cmd.Connection = (SqlConnection)con;
 81        cmd.CommandText = "update   Ticket set Tname=@Tname,Ttime=@Ttime ,Tmoney=@Tmoney  where  Tname='" + name + "'";
 82        cmd.Parameters.Add("@Tname", SqlDbType.VarChar);
 83        cmd.Parameters.Add("@Ttime", SqlDbType.DateTime);
 84        cmd.Parameters.Add("@Tmoney", SqlDbType.Money);
 85
 86        cmd.Parameters["@Tname"].Value = this.txtupname.Text;
 87        cmd.Parameters["@Ttime"].Value = this.txtuptime.Text;
 88        cmd.Parameters["@Tmoney"].Value = this.txtupmoney.Text;
 89      
 90        cmd.ExecuteNonQuery();
 91        con.Close();
 92        Response.Write("<script language='javascript'>alert('修改成功')</script>");
 93        Panel1.Visible = false;
 94        Panel2.Visible = true;
 95        Panel3.Visible = false;
 96        Panel4.Visible = false;
 97
 98
 99    }
100    protected void Linkaddcar_Click(object sender, EventArgs e)
101    ...{//添加车次
102
103        SqlConnection con = db.ceratcon();
104        con.Open();
105        SqlCommand cmd = new SqlCommand();
106        cmd.Connection = (SqlConnection)con;//对象实例化
107        cmd.CommandText = "insert into Car (Carname)values(@Carname)";
108
109
110        cmd.Parameters.Add("@Carname", SqlDbType.VarChar);
111
112
113
114        cmd.Parameters["@Carname"].Value = this.txtcname.Text;
115
116        
117
118        cmd.ExecuteNonQuery();
119        con.Close();
120        Response.Write("<script language='javascript'>alert('添加成功')</script>");
121        Panel1.Visible = false;
122        Panel2.Visible = false;
123        Panel3.Visible = true;
124        Panel4.Visible = false;
125    }
126    protected void DropDownList2_SelectedIndexChanged(object sender, EventArgs e)
127    ...{
128        Panel1.Visible = false;
129        Panel2.Visible = false;
130        Panel3.Visible = true;
131        Panel4.Visible = false;
132        //选择车次信息
133        SqlConnection con = db.ceratcon();
134        con.Open();
135
136        SqlCommand cmd = new SqlCommand("select  * from Car", con);//从数据库中选择数据
137        cmd.Parameters.Add("@Carname", SqlDbType.VarChar);
138        cmd.Parameters["@Carname"].Value = this.DropDownList2.SelectedItem.Text;
139
140        SqlDataReader sdr = cmd.ExecuteReader();//读数据
141        if (sdr.Read())
142        ...{
143            this.txtupcarname.Text = this.DropDownList2.SelectedItem.Text;
144
145            this.txtcdelname.Text = this.DropDownList2.SelectedItem.Text;
146
147        }
148        Panel1.Visible = false;
149        Panel2.Visible = false;
150        Panel3.Visible = true;
151        Panel4.Visible = false;
152        con.Close();
153    }
154    protected void Linkupcar_Click(object sender, EventArgs e)
155    ...{
156        //修改车次
157        string name = this.DropDownList2.SelectedItem.Text;
158        SqlConnection con = db.ceratcon();
159        con.Open();
160        SqlCommand cmd = new SqlCommand();
161        cmd.Connection = (SqlConnection)con;
162        cmd.CommandText = "update   Car set Carname=@Carname where  Carname='"+name+"'";
163        cmd.Parameters.Add("@Carname", SqlDbType.VarChar);
164     
165
166
167        cmd.Parameters["@Carname"].Value = this.txtupcarname.Text;
168      
169      
170        cmd.ExecuteNonQuery();
171        con.Close();
172        Response.Write("<script language='javascript'>alert('修改成功')</script>");
173
174        Panel1.Visible = false;
175        Panel2.Visible = false;
176        Panel3.Visible = true;
177        Panel4.Visible = false;
178    }
179
180    protected void Linkdelcar_Click(object sender, EventArgs e)
181    ...{//删除车次
182        string name = this.DropDownList2.SelectedItem.Text;
183        SqlConnection con = db.ceratcon();
184        con.Open();
185        SqlCommand cmd = new SqlCommand();
186        cmd.Connection = (SqlConnection)con;
187        cmd.CommandText = "delete from  Car   where  Carname='" + name + "'";
188
189
190        cmd.ExecuteNonQuery();
191        con.Close();
192        Response.Write("<script language='javascript'>alert('修改成功')</script>");
193        Panel1.Visible = false;
194        Panel2.Visible = false;
195        Panel3.Visible = true;
196        Panel4.Visible = false;
197
198    }
199    protected void linkjichucanshu_Click(object sender, EventArgs e)
200    ...{
201        Panel1.Visible = true;
202        Panel2.Visible = false;
203        Panel3.Visible = false;
204        Panel4.Visible = false;
205    }
206    protected void Linkchepiao_Click(object sender, EventArgs e)
207    ...{
208        Panel4.Visible = false;
209        Panel1.Visible = false;
210        Panel2.Visible = true;
211        Panel3.Visible = false;
212
213    }
214    protected void Linkcheci_Click(object sender, EventArgs e)
215    ...{
216        Panel3.Visible = true;
217        Panel1.Visible = false;
218        Panel2.Visible = false;
219        Panel4.Visible = false;
220    }
221    protected void Linkdiaodu_Click(object sender, EventArgs e)
222    ...{
223        Panel4.Visible = true;
224        Panel3.Visible = false;
225        Panel2.Visible = false;
226        Panel1.Visible = false;
227    }
228    protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e)
229    ...{
230       
231       
232    }
233    protected void DropDownList4_SelectedIndexChanged(object sender, EventArgs e)
234    ...{
235        Panel4.Visible = true;
236
237        Panel3.Visible = false;
238        Panel2.Visible = false;
239        Panel1.Visible = false;
240        //获取运营中的车次信息
241        SqlConnection con = db.ceratcon();
242        con.Open();
243
244        SqlCommand cmd = new SqlCommand("select  * from Car", con);//从数据库中选择数据
245        cmd.Parameters.Add("@Carname", SqlDbType.VarChar);
246        cmd.Parameters["@Carname"].Value = this.DropDownList4.SelectedItem.Text;
247
248        SqlDataReader sdr = cmd.ExecuteReader();//读数据
249        if (sdr.Read())
250        ...{
251            this.txttinyun.Text = this.DropDownList4.SelectedItem.Text;
252
253           
254
255        }
256
257        con.Close();
258        
259    }
260    protected void Linktingyun_Click(object sender, EventArgs e)
261    ...{//把运营中的车辆设置成停运
262        Panel4.Visible = true;
263
264        Panel3.Visible = false;
265        Panel2.Visible = false;
266        Panel1.Visible = false;
267        string name = this.DropDownList3.SelectedItem.Text;
268        SqlConnection con = db.ceratcon();
269        con.Open();
270        SqlCommand cmd = new SqlCommand();
271        cmd.Connection = (SqlConnection)con;
272        cmd.CommandText = "update   Car set CType=@CType where  Carname='" + name + "'";
273        cmd.Parameters.Add("@CType", SqlDbType.VarChar);
274
275
276
277        cmd.Parameters["@CType"].Value = "是";
278
279
280        cmd.ExecuteNonQuery();
281        con.Close();
282        Response.Write("<script language='javascript'>alert('设置成功')</script>");
283        Panel4.Visible = true;
284
285        Panel3.Visible = false;
286        Panel2.Visible = false;
287        Panel1.Visible = false;
288    }
289    protected void Linkyunying_Click(object sender, EventArgs e)
290    ...{//把停运中的车次设置成运营 
291        Panel4.Visible = true;
292
293        Panel3.Visible = false;
294        Panel2.Visible = false;
295        Panel1.Visible = false;
296        string name = this.DropDownList4.SelectedItem.Text;
297        SqlConnection con = db.ceratcon();
298        con.Open();
299        SqlCommand cmd = new SqlCommand();
300        cmd.Connection = (SqlConnection)con;
301        cmd.CommandText = "update   Car set CType=@CType where  Carname='" + name + "'";
302        cmd.Parameters.Add("@CType", SqlDbType.VarChar);
303
304
305
306        cmd.Parameters["@CType"].Value = "否";
307
308
309        cmd.ExecuteNonQuery();
310        con.Close();
311        Response.Write("<script language='javascript'>alert('设置成功')</script>");
312        Panel4.Visible = true;
313
314        Panel3.Visible = false;
315        Panel2.Visible = false;
316        Panel1.Visible = false;
317    }
318    protected void Linkbuy_Click(object sender, EventArgs e)
319    ...{//添加设置买票时间
320       
321        SqlConnection con = db.ceratcon();
322        con.Open();
323        SqlCommand cmd = new SqlCommand();
324        cmd.Connection = (SqlConnection)con;//对象实例化
325        cmd.CommandText = "update  System set SysBuyTime=@SysBuyTime";
326
327
328        cmd.Parameters.Add("@SysBuyTime", SqlDbType.VarChar);
329
330
331
332        cmd.Parameters["@SysBuyTime"].Value = this.TextBox1.Text;
333
334
335
336        cmd.ExecuteNonQuery();
337        con.Close();
338        Response.Write("<script language='javascript'>alert('设置成功')</script>");
339        Panel4.Visible = false;
340
341        Panel3.Visible = false;
342        Panel2.Visible = false;
343        Panel1.Visible = true;
344
345    }
346    protected void Linklinkding_Click(object sender, EventArgs e)
347    ...{//设置订票时间
348
349        SqlConnection con = db.ceratcon();
350        con.Open();
351        SqlCommand cmd = new SqlCommand();
352        cmd.Connection = (SqlConnection)con;//对象实例化
353        cmd.CommandText = "update  System set SysOrderTime=@SysOrderTime";
354       
355
356        cmd.Parameters.Add("@SysOrderTime", SqlDbType.VarChar);
357
358
359
360        cmd.Parameters["@SysOrderTime"].Value = this.TextBox2.Text;
361
362
363
364        cmd.ExecuteNonQuery();
365        con.Close();
366        Response.Write("<script language='javascript'>alert('设置成功')</script>");
367        Panel4.Visible = false;
368
369        Panel3.Visible = false;
370        Panel2.Visible = false;
371        Panel1.Visible = true;
372    }
373    protected void Linktui_Click(object sender, EventArgs e)
374