自行车在线租赁系统

登录与注册登录注册 用户功能板块主页租赁自行车页面归还自行车页面个人信息页面租赁记录页面 租赁管理员板块显示管理的租赁点正在租赁的自行车信息页面归还自行车管理页面正在维修的自行车页面个人信息页面 系统管理员板块自行车管理页面租赁点管理页面租赁管理员管理页面自行车维修页面 数据库代码用户租赁管理员系统管理员 一些公用方法

登录与注册

登录

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW { public partial class UserLogin : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) //登录 { string username = ""; string psd = ""; if (TextBox1.Text != "" && TextBox2.Text != "") { Session["RoleID"] = 0; username = TextBox1.Text.ToString(); psd = TextBox2.Text.ToString(); UserManager um = new UserManager(); List<M_Users> list = new List<M_Users>(); list = um.Login(username, psd); if (list.Count != 0) { foreach (M_Users m_Users in list) { Session["RoleID"] = m_Users.RoleID; } if (Session["RoleID"].ToString() == "1") { Session["Gongju"] = 0; foreach (M_Users m_Users in list) { Session["UserID"] = m_Users.UserID; Session["UserName"] = m_Users.UserName; Session["Password"] = m_Users.Password; Session["Name"] = m_Users.Name; Session["Telephone"] = m_Users.Telephone; Session["Money"] = m_Users.Money; } Response.Write("<script>alert('登录成功！将自动为您跳转...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=User_HomePage.aspx'>"); } if (Session["RoleID"].ToString() == "2") { Session["Gongju"] = 0; foreach (M_Users m_Users in list) { Session["UserID"] = m_Users.UserID; Session["Account"] = m_Users.UserName; Session["Password"] = m_Users.Password; } Response.Write("<script>alert('登录成功！将自动为您跳转...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=SysMger_Pages/Sysmger_Homepage.aspx'>"); } if (Session["RoleID"].ToString() == "3") { Session["Gongju"] = 0; Session["Name"] = ""; Session["Telephone"] = "0"; foreach (M_Users m_Users in list) { Session["RMID"] = m_Users.UserID; Session["RentName"] = m_Users.UserName; Session["Name"] = m_Users.Name; Session["Telephone"] = m_Users.Telephone; Session["Password"] = m_Users.Password; } Response.Write("<script>alert('登录成功！将自动为您跳转...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=RentMger_Pages/Rentmger_Homepage.aspx'>"); } } else { Response.Write("<script>alert('您输入的用户名或密码错误！')</script>"); TextBox1.Text = "请输入用户名"; TextBox2.Text = "请输入密码"; } } else Response.Write("<script>alert('您输入的内容不能为空！')</script>"); } } }

注册

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW { public partial class User_zhuce : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Btn_zhuce_Click(object sender, EventArgs e) //注册 { M_Users m_Users = new M_Users(); if (TextBox1.Text != "请输入用户名") { if (TextBox2.Text =="请输入密码"||TextBox3.Text=="请输入确认密码"||TextBox2.Text==""||TextBox3.Text=="") { Response.Write("<script>alert('请输入密码！')</script>"); } else if(TextBox2.Text == TextBox3.Text) { UserManager um = new UserManager(); m_Users.UserName = TextBox1.Text.ToString(); m_Users.Password = TextBox2.Text.ToString(); m_Users.Telephone = 0; m_Users.Money = 0; m_Users.RoleID = 1; if(um.IshasName(m_Users.UserName)) { if (um.Zhuce(m_Users.UserName,m_Users.Password,m_Users.Telephone,m_Users.Money,m_Users.RoleID)) { Response.Write("<script>alert('注册成功！将自动为您跳转至登录页面...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=UserLogin.aspx'>"); } else Response.Write("<script>alert('注册失败！')</script>"); } else Response.Write("<script>alert('此用户名已存在！')</script>"); } else Response.Write("<script>alert('两次密码输入不一致！')</script>"); } else{ Response.Write("<script>alert('请输入用户名！')</script>"); } } } }

用户功能板块

主页

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW { public partial class User_HomePage : System.Web.UI.Page { int canrent = 0; protected void Page_Load(object sender, EventArgs e) { Methods ms = new Methods(); int judge = 0; //判断变量 //显示可租自行车信息 UserManager um = new UserManager(); List<M_Bicycle> list = new List<M_Bicycle>(); list=um.BycleCanrent(); if (list.Count != 0) { int i = 0; string IsBad = ""; foreach (M_Bicycle m_Bicycle in list) //显示出可租的自行车 { //judge = 1; if (m_Bicycle.IsBad == 1) { IsBad = "正常"; } //Button btntable = new Button(); //btntable.Text = "选择租赁"; //btntable.Click += Btntable_Click; TableRow r=ms.NewRows(m_Bicycle.RLName, m_Bicycle.RLction, m_Bicycle.Brand, m_Bicycle.RentCount.ToString(),IsBad,"","",null,judge,6); Table1.Rows.Add(r); i++; if (i == 5) { break; } } judge = 1; HyperLink hyperLink = new HyperLink(); hyperLink.NavigateUrl = "User_RentBycle.aspx"; hyperLink.Text = "更多租赁"; TableRow r1 = ms.NewRows("","","","","","","",hyperLink,judge,6); Table1.Rows.Add(r1); } else Response.Write("<script>alert('暂时无可租自行车！')</script>"); //显示已租自行车 M_Bicycle m = new M_Bicycle(); List<M_Bicycle> list1 = new List<M_Bicycle>(); list1 =um.Data_rtrcd(int.Parse(Session["UserID"].ToString())); if (list1!=null) { string t5; string t6; foreach (M_Bicycle m1 in list1) { m.Brand = m1.Brand; m.RLName = m1.RLName; m.RLction = m1.RLction; m.Type = m1.Type; m.UserIdcard = m1.UserIdcard; m.RentTime = m1.RentTime; m.States = m1.States; } if (m.States == "renting") { if (m.UserIdcard == 0) { t5 = "已押金登记"; } else t5 = "已身份证登记"; int date = int.Parse(DateTime.Now.DayOfYear.ToString()); int hour = int.Parse(DateTime.Now.Hour.ToString()); int min = int.Parse(DateTime.Now.Minute.ToString()); M_DateTime mdt1 = new M_DateTime(); mdt1.date = date; mdt1.hour = hour; mdt1.min = min; M_DateTime mdt2 = new M_DateTime(); M_DateTime mdt3 = null; mdt2 = ms.Renttime(m.RentTime); t6 = ms.Alrd_rtime(mdt1, mdt2, out mdt3); judge = 0; TableRow r2 = ms.NewRows(m.Brand, m.RLName, m.RLction, m.Type, t5, t6, "", null, judge, 6); Table2.Rows.Add(r2); } else { judge = 0; TableRow r3 = ms.NewRows("", "", "您还未租任何自行车！", "", "", "", "", null, judge, 6); Table2.Rows.Add(r3); } } else { judge = 0; TableRow r3 = ms.NewRows("", "", "您还未租任何自行车！", "", "", "", "", null, judge, 6); Table2.Rows.Add(r3); } if (um.IsRent(int.Parse(Session["UserID"].ToString()))) { canrent = 1; } } public void Btntable_Click(object sender, EventArgs e) //选择租赁 { Response.Redirect("User_RentBycle.aspx"); } } }

租赁自行车页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW { public partial class User_RentBycle : System.Web.UI.Page { int canrent = 0; //1为可租状态 //public static int gj1 = 0; protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Session["gj1"] = 0; //判断是搜索还是取消状态 GridView1.Visible = true; } UserManager um = new UserManager(); if (um.IsRent(int.Parse(Session["UserID"].ToString()))) { canrent = 1; } } protected void SqlDataSource1_Selecting(object sender, SqlDataSourceSelectingEventArgs e) { } protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { if (GridView1.Visible == true) { Session["RLBID"] = GridView1.SelectedDataKey.Value.ToString(); if (canrent == 1) { if (GridView1.SelectedRow.Cells[4].Text != "0") { Session["RentCount"] = GridView1.SelectedRow.Cells[4].Text; Response.Redirect("User_RtBycleSure.aspx"); } else Response.Write("<script>alert('该自行车已被租完！')</script>"); } else Response.Write("<script>alert('您已有租赁的自行车！')</script>"); } else { Session["RLBID"] = GridView2.SelectedDataKey.Value.ToString(); if (canrent == 1) { if (GridView2.SelectedRow.Cells[4].Text != "0") { Session["RentCount"] = GridView2.SelectedRow.Cells[4].Text; Response.Redirect("User_RtBycleSure.aspx"); } else Response.Write("<script>alert('该自行车已被租完！')</script>"); } else Response.Write("<script>alert('您已有租赁的自行车！')</script>"); } } protected void Button2_Click(object sender, EventArgs e) //搜索 { Session["gj1"]=int.Parse(Session["gj1"].ToString())+1; if (Session["gj1"].ToString() == "1") { GridView2.DataBind(); GridView2.Visible = true; GridView1.Visible = false; Button2.Text = "取消"; if (GridView2.Rows.Count == 0) { Response.Write("<script>alert('未找到该地点！')</script>"); Session["gj1"] = 2; } } if (Session["gj1"].ToString() == "2") { GridView2.Visible = false; GridView1.Visible = true; Session["gj1"] = 0; Button2.Text = "搜索"; TextBox1.Text = ""; } } } }

归还自行车页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Models; using WBDYW.WBDYW_Code.BLL; namespace WBDYW { public partial class User_ReturnBycle : System.Web.UI.Page { UserManager um = new UserManager(); public static string[,] a; protected void Page_Load(object sender, EventArgs e) { Session["Deposit"] = 0; string time = ""; int judge; M_Bicycle m = new M_Bicycle(); Methods ms = new Methods(); List<M_Bicycle> list1 = new List<M_Bicycle>(); M_DateTime mdt1 = new M_DateTime(); M_DateTime mdt2 = new M_DateTime(); M_DateTime mdt3 =null; list1 = um.Data_rtrcd(int.Parse(Session["UserID"].ToString())); if (list1 != null) { string t5; string t6; foreach (M_Bicycle m1 in list1) { m.Brand = m1.Brand; m.RLName = m1.RLName; m.RLction = m1.RLction; m.Type = m1.Type; m.UserIdcard = m1.UserIdcard; m.RentTime = m1.RentTime; m.RetnTime = m1.RetnTime; m.States = m1.States; } if (m.States == "renting" || m.States == "backing") { if (m.UserIdcard == 0) { t5 = "已押金登记"; Session["Deposit"] = 1; } else t5 = "已身份证登记"; int date = int.Parse(DateTime.Now.DayOfYear.ToString()); int hour = int.Parse(DateTime.Now.Hour.ToString()); int min = int.Parse(DateTime.Now.Minute.ToString()); mdt1.date = date; mdt1.hour = hour; mdt1.min = min; mdt2 = ms.Renttime(m.RentTime); judge = 0; if (m.States == "backing") { mdt1 = ms.Renttime(m.RetnTime); } t6 = ms.Alrd_rtime(mdt1, mdt2, out mdt3); time = t6; judge = 0; TableRow r2 = ms.NewRows(m.Brand, m.RLName, m.RLction, m.Type, t5, t6, "", null, judge, 6); Table2.Rows.Add(r2); //计算产生费用 string txtcost = "已产生费用："; double cost = 0; if (mdt3.date > 0) { cost = (mdt3.date - 1) * 10; cost += mdt3.hour * 1; } Session["cost"] = cost; judge = 1; Button btntable = new Button(); if (m.States == "renting") { btntable.Text = "归还自行车"; btntable.Click += Btntable; } if (m.States == "backing") { btntable.Text = "归还处理中"; } TableRow r1 = ms.NewRows(txtcost, (cost).ToString() + "￥", "", "", "", "", "", btntable, judge, 6); Table2.Rows.Add(r1); } else { judge = 0; TableRow r3 = ms.NewRows("", "", "您还未租任何自行车！", "", "", "", "", null, judge, 6); Table2.Rows.Add(r3); } } else { judge = 0; TableRow r3 = ms.NewRows("", "", "您还未租任何自行车！", "", "", "", "", null, judge, 6); Table2.Rows.Add(r3); } } public void Btnfind_Click(object sender, EventArgs e) //搜索 { List<M_Bicycle> list = new List<M_Bicycle>(); list= um.Find_RLction(txtfind.Text); foreach (M_Bicycle m in list) { DropDownList1.Text = m.RLction; } } public void Btncancel_Click(object sender, EventArgs e) //取消 { Response.Redirect("User_ReturnBycle.aspx"); } public void Btnsure_Click(object sender, EventArgs e) //确定归还 { M_Bicycle m = new M_Bicycle(); string retntime = ""; int date = int.Parse(DateTime.Now.DayOfYear.ToString()); int hour = int.Parse(DateTime.Now.Hour.ToString()); int min = int.Parse(DateTime.Now.Minute.ToString()); retntime = date.ToString() +"+"+ hour.ToString()+"+" + min.ToString(); m.UserID = int.Parse(Session["UserID"].ToString()); m.States = "backing"; m.RetnTime = retntime; m.Money = int.Parse(Session["cost"].ToString()); //费用 m.Deposit = int.Parse(Session["Deposit"].ToString()); for (int i = 0; i < 50; i++) { if (a[i, 0] == DropDownList1.SelectedValue) { m.RLID = int.Parse(a[i, 1]); break; } } if (Session["Deposit"].ToString() == "1") { if (int.Parse(Session["Money"].ToString()) >= int.Parse(Session["cost"].ToString())) { if (um.ReturnBycle(m)) { Session["Money"] = int.Parse(Session["Money"].ToString()) - int.Parse(Session["cost"].ToString()); Response.Write("<script>alert('归还成功！')</script>"); Response.Redirect("User_ReturnBycle.aspx"); } else Response.Write("<script>alert('归还失败！')</script>"); } else { Response.Write("<script>alert('您的余额不足,将为您跳转充值页面...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=User_Information.aspx'>"); } } else { if (um.ReturnBycle(m)) { Response.Write("<script>alert('归还成功！')</script>"); Response.Redirect("User_ReturnBycle.aspx"); } else Response.Write("<script>alert('归还失败！')</script>"); } } public void Btntable(object sender, EventArgs e) //显示归还自行车页面 { Table1.Visible = true; List<M_Bicycle> list = new List<M_Bicycle>(); Methods md = new Methods(); list = um.All_RLtion(); int i = 0; a = new string[50, 2]; foreach (M_Bicycle m in list) { a[i, 0] = m.RLction; a[i, 1] = m.RLID.ToString(); DropDownList1.Items.Add(m.RLction); i++; } Table1.Rows.Add(md.NewRows("支付费用：",Session["cost"].ToString(),"","","","","",null,0,2)); } } } ```csharp using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW { public partial class User_RtBycleSure : System.Web.UI.Page { public static int canrent = 0; protected void Page_Load(object sender, EventArgs e) { if (Session["Name"] == null || Session["Telephone"].ToString()=="0") { Response.Write("<script>alert('您的信息尚未完善！将自动为您跳转填写个人信息...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=User_Information.aspx'>"); }else { txtname.ReadOnly = true; txtname.Text = Session["Name"].ToString(); txtphone.ReadOnly = true; txtphone.Text = Session["Telephone"].ToString(); } Session["UserIdcard"] = 0; Session["Deposit"] = 2; } protected void Btnsure_Click(object o, EventArgs e) //提交 { if (txtname.Text != "" && txtphone.Text != "") { if (RadioButton1.Checked) { if (txtsfz.Text != ""&&txtsfz.Text!="0") { Session["UserIdcard"] = txtsfz.Text; canrent = 1; } else Response.Write("<script>alert('您的身份证号有误！')</script>"); } if (RadioButton2.Checked) { if (txtyj.Text == Session["Password"].ToString()) { Session["Deposit"] =1; if (int.Parse(Session["Money"].ToString()) < 50) { Response.Write("<script>alert('您的余额不足，将为您跳到充值页面！')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=User_Information.aspx'>"); } else { canrent = 1; } } else { Response.Write("<script>alert('您的密码有误！')</script>"); txtyj.Text = ""; } } if (canrent==1) { if (Thesure()) { Response.Write("<script>alert('租赁成功！将自动为您跳转到首页...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=User_HomePage.aspx'>"); } else Response.Write("<script>alert('租赁操作失败！')</script>"); } } else Response.Write("<script>alert('您的姓名或电话号码不能为空！')</script>"); } protected void Btnret_Click(object o, EventArgs e) //返回 { Response.Redirect("User_RentBycle.aspx"); } public bool Thesure() { int date = int.Parse(DateTime.Now.DayOfYear.ToString()); int hour = int.Parse(DateTime.Now.Hour.ToString()); int min = int.Parse(DateTime.Now.Minute.ToString()); string rtim = date.ToString() + "+" + hour.ToString() + "+" + min.ToString(); M_Bicycle m = new M_Bicycle(); m.RLBID = int.Parse(Session["RLBID"].ToString()); m.UserID = int.Parse(Session["UserID"].ToString()); m.UserIdcard = int.Parse(Session["UserIdcard"].ToString()); m.Deposit = int.Parse(Session["Deposit"].ToString()); m.RentTime = rtim.ToString(); m.UserID = int.Parse(Session["UserID"].ToString()); m.RentCount = int.Parse(Session["RentCount"].ToString()); m.Money = int.Parse(Session["Money"].ToString()); //目前有的钱 m.States = "renting"; UserManager um = new UserManager(); if (um.RtRcd(m)) { Session["Money"]=int.Parse(Session["Money"].ToString())-50; return true; } else return false; } } }

个人信息页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW { public partial class User_Information : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["Gongju"].ToString() == "1") { Response.Write("<script>alert('充值成功！')</script>"); Session["Gongju"] = 0; } txtusername.Text = Session["UserName"].ToString(); txtname.Text = Session["Name"].ToString(); if (Int32.Parse(Session["Telephone"].ToString())!= 0) { txtphone.Text = Session["Telephone"].ToString(); } lbmoney.Text = Session["Money"].ToString(); } protected void Button1_Click(object sender, EventArgs e) { Response.Redirect("User_UpdateInfor.aspx"); } protected void Button4_Click(object sender, EventArgs e) { Response.Redirect("User_Information.aspx"); } protected void btncancel_Click(object sender, EventArgs e) //取消密码修改 { btnsure.Text = "我要修改"; txtoldpsd.Text = ""; txtnewpsd1.Text = ""; txtnewpsd2.Text = ""; txtoldpsd.ReadOnly = true; txtnewpsd1.ReadOnly = true; txtnewpsd2.ReadOnly = true; btncancel.Visible = false; } protected void btnsure_Click(object sender, EventArgs e) // 修改/保存 { if (btnsure.Text == "保存") { if (txtoldpsd.Text != "" && txtnewpsd1.Text != "" && txtnewpsd1.Text == txtnewpsd2.Text) { if (txtoldpsd.Text == Session["Password"].ToString()) { if (txtnewpsd1.Text != Session["Password"].ToString()) { btnsure.Text = "我要修改"; UserManager um = new UserManager(); M_Users m_Users = new M_Users(); m_Users.UserID = int.Parse(Session["UserID"].ToString()); m_Users.Password = txtnewpsd1.Text; if (um.Update_psd(m_Users)) { Session["Password"] = txtnewpsd1.Text; Response.Write("<script>alert('修改密码成功！您将重新登录账号...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=UserLogin.aspx'>"); } } else Response.Write("<script>alert('您输入的新密码不能与原密码一样！')</script>"); } else Response.Write("<script>alert('您输入的原密码错误！')</script>"); } else Response.Write("<script>alert('您输入的密码不能为空！')</script>"); } if (btnsure.Text == "我要修改") { btncancel.Visible = true; btnsure.Text = "保存"; txtoldpsd.ReadOnly =false; txtnewpsd1.ReadOnly = false; txtnewpsd2.ReadOnly = false; } } protected void Button2_Click(object sender, EventArgs e) //显示充值页面 { Table1.Visible = true; } protected void Btnsure1_Click(object sender, EventArgs e) //确认充值 { if (txtmoney.Text != "") { if (txtpsd.Text == Session["Password"].ToString()) { M_Users m = new M_Users(); UserManager um = new UserManager(); m.UserID = int.Parse(Session["UserID"].ToString()); m.Money = int.Parse(txtmoney.Text); if (um.AddMoney(m)) { Session["Money"] = int.Parse(Session["Money"].ToString()) + int.Parse(txtmoney.Text); Session["Gongju"] = 1; Response.Redirect(Request.Path); } }else Response.Write("<script>alert('您输入的密码有误！')</script>"); } else Response.Write("<script>alert('您输入的金额不能为空！')</script>"); } } } using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Models; using WBDYW.WBDYW_Code.BLL; namespace WBDYW { public partial class User_UpdateInfor : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) //提交 { UserManager um = new UserManager(); M_Users m_Users = new M_Users(); List<M_Users> list = new List<M_Users>(); m_Users.UserID = Int32.Parse(Session["UserID"].ToString()); if (txtusername.Text != "") { m_Users.UserName = txtusername.Text.ToString(); } else m_Users.UserName = Session["UserName"].ToString(); if (txtname.Text != "") { m_Users.Name = txtname.Text.ToString(); } else m_Users.Name = Session["Name"].ToString(); if (txtphone.Text != "") { m_Users.Telephone = int.Parse(txtphone.Text.ToString()); } else m_Users.Telephone =int.Parse(Session["Telephone"].ToString()); list=um.Update_Infor(m_Users); if (list.Count != 0) { foreach (M_Users i in list) { Session["UserName"] = i.UserName; Session["Name"] = i.Name; Session["Telephone"] = i.Telephone; } Response.Write("<script>alert('修改成功！将自动为您返回...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=User_Information.aspx'>"); }else Response.Write("<script>alert('修改失败！')</script>"); } protected void Button1_Click1(object sender, EventArgs e) //返回 { Response.Redirect("User_Information.aspx"); } } }

租赁记录页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WBDYW { public partial class User_RentRecords : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (GridView1.Rows.Count == 0) { Label3.Visible = true; } else Label3.Visible = false; } } }

租赁管理员板块

显示管理的租赁点

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.RentMger_Pages { public partial class Rentmger_HomePage : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if(!IsPostBack) { DropDownList1.Items.Clear(); RtManager rm = new RtManager(); List<M_Bicycle> list = new List<M_Bicycle>(); list = rm.GetRLids(int.Parse(Session["RMID"].ToString())); if (list.Count != 0) { DropDownList1.Visible = true; Table1.Visible = true; foreach (M_Bicycle m in list) { DropDownList1.Items.Add(m.RLName); } string rlname = DropDownList1.SelectedItem.Text; Theall(rlname); } else { Label1.Visible = true; Label1.Text = "您暂时未管理任何租赁点！"; } } } protected void Drp_Click(object o, EventArgs e) { string rlname = DropDownList1.SelectedItem.Text; Theall(rlname); } public void Theall(string rlname) { RtManager rm = new RtManager(); int rlid=0; List<M_Bicycle> list = new List<M_Bicycle>(); list = rm.GetRLids(int.Parse(Session["RMID"].ToString())); foreach (M_Bicycle m in list) { if (m.RLName == rlname) { rlid = m.RLID; } } List<M_Bicycle> list1 = new List<M_Bicycle>(); Methods methods = new Methods(); list1 = rm.Theall(rlid); if (list1.Count != 0) { foreach (M_Bicycle m in list1) { Table1.Rows.Add(methods.NewRows(m.RLction, m.Brand, m.Type, m.RentCount.ToString(), "", "", "", null, 0, 4)); } } else { Table1.Rows.Add(methods.NewRows("", "该租赁点暂时没有空余车辆!", "", "", "", "", "", null, 0, 4)); } } } }

正在租赁的自行车信息页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.RentMger_Pages { public partial class Rentmger_RentingInf : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { RtManager rm = new RtManager(); List<M_Bicycle> list = new List<M_Bicycle>(); list=rm.GetRentInf(int.Parse(Session["RMID"].ToString())); List<M_Users> list1 = new List<M_Users>(); list1 = rm.GetRentUserInf(int.Parse(Session["RMID"].ToString())); List<M_Bicycle> list2 = new List<M_Bicycle>(); list2 = rm.GetRentBycleInf(int.Parse(Session["RMID"].ToString())); string a=""; string time; double cost=0; M_DateTime mdt1 = new M_DateTime(); //当前时间 M_DateTime mdt2 = new M_DateTime(); M_DateTime mdt3 = null; int date = int.Parse(DateTime.Now.DayOfYear.ToString()); int hour = int.Parse(DateTime.Now.Hour.ToString()); int min = int.Parse(DateTime.Now.Minute.ToString()); mdt1.date = date; mdt1.hour = hour; mdt1.min = min; Methods methods = new Methods(); int ishas = 0; //判断是否有数据 if (list.Count != 0) { for (int i = 0; i < list.Count;) { if (list[i].UserIdcard != 0) { a = "已身份证登记"; } if (list[i].Deposit == 1) { a = "已押金登记"; } mdt2 = methods.Renttime(list[i].RentTime); time = methods.Alrd_rtime(mdt1, mdt2, out mdt3); if (mdt3.date > 0) { cost = (mdt3.date - 1) * 10; cost += mdt3.hour * 1; } if(list[i].States=="renting") { ishas = 1; TableRow r = methods.NewRows(list1[i].UserName, list1[i].Name, list2[i].Brand, list2[i].Type, a, time, cost.ToString(), null, 0, 7); Table1.Rows.Add(r); } i++; } } if(ishas==0) { Table1.Rows.Add(methods.NewRows("","","","暂时无租赁车辆","","","",null,0,7)); } } } }

归还自行车管理页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.RentMger_Pages { public partial class Rentmger_ReturnBycles : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (GridView1.Rows.Count == 0) { Label3.Visible = true; Label3.Text = "您暂无需归还处理的自行车"; } else Label3.Visible = false; if (Session["Gongju"].ToString() == "1") { Response.Write("<script>alert('操作成功！')</script>"); Session["Gongju"] = 0; } if (Session["Gongju"].ToString() == "2") { Response.Write("<script>alert('上报成功！')</script>"); Session["Gongju"] = 0; } } protected void Gvselect_Click(object o, EventArgs e) { Session["RRID"]=GridView1.SelectedDataKey[0].ToString(); Session["BycleID"] = GridView1.SelectedDataKey[1].ToString(); Session["RetnRLID"] = GridView1.SelectedDataKey[2].ToString(); Session["Deposit"] = GridView1.SelectedDataKey[3].ToString(); Session["RentTime"] = GridView1.SelectedDataKey[4].ToString(); Session["UserID"] = GridView1.SelectedDataKey[5].ToString(); Session["RetnTime"]= GridView1.SelectedDataKey[6].ToString(); Methods md = new Methods(); M_DateTime mdt1 = new M_DateTime(); M_DateTime mdt2 = new M_DateTime(); M_DateTime mdt3 = new M_DateTime(); mdt1 = md.Renttime(Session["RetnTime"].ToString()); mdt2 = md.Renttime(Session["RentTime"].ToString()); string time = md.Alrd_rtime(mdt1, mdt2, out mdt3); //计算产生费用 string txtcost = "产生费用："; double cost = 0; if (mdt3.date > 0) { cost = (mdt3.date - 1) * 10; cost += mdt3.hour * 1; } Table1.Rows.Add(md.NewRows("租赁时间：",time,"","","","","",null,0,2)); Table1.Rows.Add(md.NewRows(txtcost, cost.ToString(), "", "", "", "", "", null, 0, 2)); if (Session["Deposit"].ToString() == "1") { Table1.Rows.Add(md.NewRows("押金:","50", "", "", "", "", "", null, 0, 2)); } Table1.Visible = true; } protected void BtnSure_Click(object o, EventArgs e) //确认归还 { RtManager rm = new RtManager(); M_Bicycle m = new M_Bicycle(); m.RLID = int.Parse(Session["RetnRLID"].ToString()); m.BycleID = int.Parse(Session["BycleID"].ToString()); m.RRID = int.Parse(Session["RRID"].ToString()); m.UserID = int.Parse(Session["UserID"].ToString()); m.Deposit = int.Parse(Session["Deposit"].ToString()); m.States = "ok"; if (rm.SureRetn(m)) { Session["Gongju"] = 1; Table1.Visible = false; Response.Redirect(Request.Path); } else Response.Write("<script>alert('操作失败！')</script>"); } protected void BtnRepair_Click(object o, EventArgs e) //上报维修 { int RRID=int.Parse(Session["RRID"].ToString()); RtManager rm = new RtManager(); if(rm.Repair(RRID)) { Session["Gongju"] = 2; Table1.Visible = false; Response.Redirect(Request.Path); } else Response.Write("<script>alert('上报失败！')</script>"); } protected void BtnCancel_Click(object o, EventArgs e) //取消 { Table1.Visible=false; } } }

正在维修的自行车页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WBDYW.RentMger_Pages { public partial class Rentmger_Repair : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (GridView1.Rows.Count == 0) { Label3.Visible = true; Label3.Text = "您暂无报修/损坏的车辆"; } else Label3.Visible = false; } } }

个人信息页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.RentMger_Pages { public partial class Rentmger_Information : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { txtrtname.Text= Session["RentName"].ToString(); txtname.Text = Session["Name"].ToString(); if (Session["Telephone"].ToString() != "0") { txtphone.Text = Session["Telephone"].ToString(); } } protected void Button1_Click(object sender, EventArgs e) //修改资料 { Response.Redirect("Rentmger_UpdateInfor.aspx"); } protected void btnsure_Click(object sender, EventArgs e) //保存/修改 { if (btnsure.Text == "保存") { if (txtoldpsd.Text != "" && txtnewpsd1.Text != "" && txtnewpsd1.Text == txtnewpsd2.Text) { if (txtoldpsd.Text == Session["Password"].ToString()) { if (txtnewpsd1.Text != Session["Password"].ToString()) { btnsure.Text = "我要修改"; RtManager rm = new RtManager(); M_RtManager m = new M_RtManager(); m.RMID = int.Parse(Session["RMID"].ToString()); m.Password = txtnewpsd1.Text; if (rm.Update_Psd(m)) { Session["Password"] = txtnewpsd1.Text; Response.Write("<script>alert('修改密码成功！您将重新登录账号...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=/../UserLogin.aspx'>"); } } else Response.Write("<script>alert('您输入的新密码不能与原密码一样！')</script>"); } else Response.Write("<script>alert('您输入的原密码错误！')</script>"); } else Response.Write("<script>alert('您输入的密码不能为空！')</script>"); } if (btnsure.Text == "我要修改") { btncancel.Visible = true; btnsure.Text = "保存"; txtoldpsd.ReadOnly = false; txtnewpsd1.ReadOnly = false; txtnewpsd2.ReadOnly = false; } } protected void btncancel_Click(object sender, EventArgs e) //取消修改 { btnsure.Text = "我要修改"; txtoldpsd.Text = ""; txtnewpsd1.Text = ""; txtnewpsd2.Text = ""; txtoldpsd.ReadOnly = true; txtnewpsd1.ReadOnly = true; txtnewpsd2.ReadOnly = true; btncancel.Visible = false; } } } using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.RentMger_Pages { public partial class Rentmger_UpdateInfor : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { } protected void Button1_Click(object sender, EventArgs e) //提交 { RtManager rm = new RtManager(); M_RtManager m = new M_RtManager(); List<M_RtManager> list = new List<M_RtManager>(); m.RMID = Int32.Parse(Session["RMID"].ToString()); if (txtrtname.Text != "") { m.RentName = txtrtname.Text.ToString(); } else m.RentName = Session["RentName"].ToString(); if (txtname.Text != "") { m.Name = txtname.Text.ToString(); } else m.Name = Session["Name"].ToString(); if (txtphone.Text != "") { m.Telephone = int.Parse(txtphone.Text.ToString()); } else m.Telephone = int.Parse(Session["Telephone"].ToString()); if (rm.Ishadname(m.RentName) || m.RentName == Session["RentName"].ToString()) //新用户名是否已存在，但可以跟自己目前名字相同 { M_RtManager m1 = new M_RtManager(); m1 = rm.UpdateRtMgerInfor(m); Session["RentName"] = m1.RentName; Session["Name"] = m1.Name; Session["Telephone"] = m1.Telephone; Response.Write("<script>alert('修改成功！将自动为您返回...')</script>"); Response.Write("<meta http-equiv='refresh'content='1;URL=Rentmger_Information.aspx'>"); } else Response.Write("<script>alert('此用户名已存在！')</script>"); } protected void Button1_Click1(object sender, EventArgs e) //返回 { Response.Redirect("Rentmger_Information.aspx"); } } }

系统管理员板块

自行车管理页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.SysMger_Pages { public partial class Sysmger_Bycle : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (int.Parse(Session["Gongju"].ToString()) == 1) { Response.Write("<script>alert('删除成功！')</script>"); Session["Gongju"] = 0; } if (Session["Gongju"].ToString() == "2") { Response.Write("<script>alert('添加成功！')</script>"); Session["Gongju"] = 0; } SysManager sm = new SysManager(); List<M_Bicycle> list = new List<M_Bicycle>(); list = sm.Bycle_infors(); if (list.Count != 0) { foreach (M_Bicycle m in list) { ListItem li = new ListItem(); li.Value = m.Brand; if (!dlbrand.Items.Contains(li)) { dlbrand.Items.Add(m.Brand); } li.Value = m.Type; if (!dltype.Items.Contains(li)) { dltype.Items.Add(m.Type); } } } } protected void Btnreduce_Click(object o, EventArgs e) //减 { int a; a = int.Parse(txtcount.Text.ToString()); if (a > 0) { a -= 1; txtcount.Text = a.ToString(); } } protected void Btnadd_Click(object o, EventArgs e) //加 { int a; a = int.Parse(txtcount.Text.ToString()); a += 1; txtcount.Text = a.ToString(); } protected void Btnsure_Click(object sender, EventArgs e) //确定添加 { if (txtbrand.Text != "" && txtcount.Text != "" && txttype.Text != ""&& txtmanudate.Text != "" && txtpurdate.Text != "") { DateTime manufacturedate=new DateTime (); DateTime purchasedate=new DateTime(); M_Bicycle m = new M_Bicycle(); if (txtmanudate.Text != "") { manufacturedate = DateTime.Parse(txtmanudate.Text); } if (txtpurdate.Text != "") { purchasedate = DateTime.Parse(txtpurdate.Text); } m.Brand = txtbrand.Text; m.Type = txttype.Text; m.BycleCount = int.Parse(txtcount.Text.ToString()); if (txtpurdate.Text != "") { m.PurchaseDate = DateTime.Parse(purchasedate.ToShortDateString().ToString()); } if (txtmanudate.Text != "") { m.ManufactureDate = DateTime.Parse(manufacturedate.ToShortDateString().ToString()); } m.IsBad = 1; if (m.ManufactureDate <= m.PurchaseDate) { SysManager sm = new SysManager(); if (sm.AddBycle(m)) { Session["Gongju"] = 2; Table1.Visible = false; Response.Redirect(Request.Path); } else Response.Write("<script>alert('添加失败！')</script>"); } else Response.Write("<script>alert('出厂日期不得早于采购日期！')</script>"); } else Response.Write("<script>alert('输入的内容不能为空！')</script>"); } protected void Button1_Click(object sender, EventArgs e) //添加 { Table1.Visible = true; } protected void Btncancel_Click(object sender, EventArgs e) //取消 { txtbrand.Text = ""; txtcount.Text = ""; txtmanudate.Text = ""; txtpurdate.Text = ""; txttype.Text = ""; Table1.Visible = false; } protected void Button5_Click(object sender, EventArgs e) //返回首页 { Response.Redirect("SysMger_HomePage.aspx"); } protected void Gvselect_Click(object o, EventArgs e) //删除 { string bycleid= GridView1.SelectedDataKey.Value.ToString(); SysManager sm = new SysManager(); if (sm.Isused(bycleid)) //可以直接删除 { if (sm.DeleteBycle(bycleid)) { Session["Gongju"] = 1; Response.Redirect(Request.Path); } else Response.Write("<script>alert('删除失败！')</script>"); } else { Response.Write("<script>alert('您所选择的自行车正在使用中，请确保租赁点未使用该车辆！')</script>"); } } } }

租赁点管理页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.SysMger_Pages { public partial class Sysmger_RtLction : System.Web.UI.Page { public static int gj=0; protected void Page_Load(object sender, EventArgs e) { if (Session["Gongju"].ToString()== "1") { Response.Write("<script>alert('删除成功！')</script>"); Session["Gongju"] = 0; } //删除租赁点 if (Session["Gongju"].ToString() == "2") { Response.Write("<script>alert('删除成功！')</script>"); GridView3.Visible = true; Button15.Visible = true; Session["Gongju"] = 0; } //删除租赁分配的某个自行车 if (Session["Gongju"].ToString() == "3") { lbchosename.Visible = true; lbchosename.Text = Session["RLction"].ToString(); Table3.Visible = true; Session["Gongju"] = 0; } //因为查看不同租赁点的自行车信息时，GridView表要刷新，就在点击编辑时重新加载页面，但是又要把那个有很多按钮的表刷掉，所以这里专门显示一下 if (Session["Gongju"].ToString() == "4") { Response.Write("<script>alert('添加成功！')</script>"); GridView3.Visible = true; Button15.Visible = true; Session["Gongju"] = 0; } //添加自行车成功 if (GridView3.Rows.Count == 0 && gj == 1) { Table7.Visible = true; } //没有自行车信息时显示的内容 else { Table7.Visible = false; gj = 0; } } protected void Gvselect_Click(object o, EventArgs e) //gridview的select事件 { Session["RMID"] = GridView1.SelectedDataKey.Value.ToString(); Session["RLID"] =GridView1.SelectedRow.Cells[0].Text.ToString(); Session["RLName"] = GridView1.SelectedRow.Cells[1].Text.ToString(); Session["RLction"] = GridView1.SelectedRow.Cells[2].Text.ToString(); if (GridView1.SelectedRow.Cells[4].Text.ToString()== "&nbsp;") { Session["RLmk"] = ""; } else Session["RLmk"] = GridView1.SelectedRow.Cells[4].Text.ToString(); Session["RentName"] = GridView1.SelectedRow.Cells[5].Text.ToString(); Session["Gongju"] = 3; Response.Redirect(Request.Path); } protected void Button1_Click(object sender, EventArgs e) //显示添加租赁点表 { SysManager sm = new SysManager(); List<M_RtManager> list = new List<M_RtManager>(); list = sm.RtmanagerInfor(); foreach (M_RtManager m in list) { dlrtmager.Items.Add(m.RentName); } Table1.Visible = true; } protected void Thetb4Show_Click(object o, EventArgs e) //显示车辆信息表(显示该租赁点拥有的车辆) { Button15.Visible = true; GridView3.Visible = true; Table3.Visible = false; if (GridView3.Rows.Count == 0) { gj = 1; Table7.Visible = true; } else { Table7.Visible = false; gj = 0; } } protected void Thetb2Show_Click(object o, EventArgs e) //显示编辑信息表 { Table2.Visible = true; Table3.Visible = false; txtmark1.Text =Session["RLmk"].ToString(); txtrloction1.Text = Session["RLction"].ToString(); txtrname1.Text = Session["RLName"].ToString(); txtrtmager1.Text = Session["RentName"].ToString(); SysManager sm = new SysManager(); List<M_RtManager> list = new List<M_RtManager>(); list = sm.RtmanagerInfor(); foreach (M_RtManager m in list) { dlrtmager1.Items.Add(m.RentName); } } protected void Thetb5Show_Click(object o, EventArgs e) //显示所有车辆信息(配置车辆按钮) { GridView2.Visible = true; Table3.Visible = false; } protected void Gvselect2_Click(object o, EventArgs e) { GridView2.Visible = false; Session["BycleID"]= GridView2.SelectedRow.Cells[0].Text.ToString(); Session["Brand"]= GridView2.SelectedRow.Cells[1].Text.ToString(); Session["Type"]= GridView2.SelectedRow.Cells[2].Text.ToString(); Session["BycleCount"]= GridView2.SelectedRow.Cells[3].Text.ToString(); Table6.Visible = true; lbbrand.Text = Session["Brand"].ToString(); lbtype.Text = Session["Type"].ToString(); txtcount.Text = Session["BycleCount"].ToString(); } protected void Btnreduce_Click(object o, EventArgs e) { if (int.Parse(txtcount.Text) > 1) { txtcount.Text = (int.Parse(txtcount.Text) - 1).ToString(); } if (int.Parse(txtcount.Text) < int.Parse(Session["BycleCount"].ToString())) { btnadd.Visible = true; } } //减 protected void Btnadd_Click(object o, EventArgs e) { if (int.Parse(txtcount.Text) < int.Parse(Session["BycleCount"].ToString())) { txtcount.Text = (int.Parse(txtcount.Text) + 1).ToString(); } if (int.Parse(txtcount.Text) >= int.Parse(Session["BycleCount"].ToString())) { btnadd.Visible = false; } } //加 protected void Btn_choose_Click(object o, EventArgs e) //选择要配置的车辆 { Table6.Visible = true; SysManager sm = new SysManager(); List<M_Bicycle> list = new List<M_Bicycle>(); Methods md = new Methods(); list = sm.Bycle_infors(); //foreach (M_Bicycle m in list) //{ // if (Table5.) //} } protected void Btncancel_Click(object o, EventArgs e) //取消添加租赁点操作 { txtrname.Text = ""; txtmark.Text = ""; txtrloction.Text = ""; dlrtmager.Items.Clear(); Table1.Visible = false; } protected void Btncancel1_Click(object o, EventArgs e) //取消编辑租赁点信息页面 { txtmark1.Text = ""; txtrloction1.Text = ""; txtrname1.Text = ""; txtrtmager1.Text = ""; Table2.Visible = false; Table3.Visible = true; dlrtmager1.Items.Clear(); } protected void Btncancel2_Click(object o, EventArgs e) //取消编辑操作 { Table2.Visible = false; Table3.Visible =false; } protected void Btncancel3_Click(object o, EventArgs e) //取消车辆信息页面 { Table4.Visible = false; Table3.Visible = true; } protected void Btncancel4_Click(object o, EventArgs e) //取消配置车辆页面 { Table3.Visible = true; GridView2.Visible = false; Table6.Visible = false; } protected void Btnsure_Click(object o, EventArgs e) //确定添加租赁点 { SysManager sm = new SysManager(); List<M_RtManager> list = new List<M_RtManager>(); list = sm.RtmanagerInfor(); int RMID=0; foreach (M_RtManager m in list) { if (m.RentName == dlrtmager.SelectedValue) { RMID = m.RMID; break; } } if (txtrname.Text != "" && txtrloction.Text != "") { DateTime rlcrtime=DateTime.Now; M_Bicycle m1 = new M_Bicycle(); m1.RLName = txtrname.Text; m1.RLction = txtrloction.Text; m1.RLCrtime = DateTime.Parse(rlcrtime.ToLocalTime().ToString()); m1.RLmk = txtmark.Text; m1.RMID = RMID; if (sm.AddRtLction(m1)) { Response.Redirect(Request.Path); Table1.Visible = false; Response.Write("<script>alert('添加成功！')</script>"); } else { Response.Write("<script>alert('此租赁点名称已存在！')</script>"); txtrname.Text = ""; } } else Response.Write("<script>alert('输入的内容不能为空！')</script>"); } protected void Btnsure1_Click(object o, EventArgs e) //确定修改租赁点信息 { SysManager sm = new SysManager(); M_Bicycle m = new M_Bicycle(); m.RLID = int.Parse(Session["RLID"].ToString()); m.RLName = Session["RLName"].ToString(); m.RLction = Session["RLction"].ToString(); m.RLmk = Session["RLmk"].ToString(); m.RMID = sm.RtMager_ID(txtrtmager1.Text); if (txtrname1.Text != "") { m.RLName = txtrname1.Text; } if (txtrloction1.Text != "") { m.RLction = txtrloction1.Text; } if (txtmark1.Text != "") { m.RLmk = txtmark1.Text; } if (sm.UpdateRtLoction(m)) { Response.Write("<script>alert('修改成功！')</script>"); dlrtmager1.Items.Clear(); Table2.Visible = false; Table3.Visible = false; Response.Redirect(Request.Path); } else Response.Write("<script>alert('修改失败！')</script>"); } protected void Btnsure2_Click(object o, EventArgs e) //确定添加此自行车 { M_Bicycle m = new M_Bicycle(); SysManager sm = new SysManager(); m.BycleID = int.Parse(Session["BycleID"].ToString()); m.RLID = int.Parse(Session["RLID"].ToString()); m.BycleCount = int.Parse(Session["BycleCount"].ToString()); m.RentCount = int.Parse(txtcount.Text); if (sm.RL_Bycle3(m)) { Table6.Visible = false; Table3.Visible = true; Session["Gongju"] = 4; Response.Redirect(Request.Path); } else Response.Write("<script>alert('添加失败！')</script>"); } protected void Btndelete_Click(object o, EventArgs e) //删除租赁点 { M_Bicycle m = new M_Bicycle(); SysManager sm = new SysManager(); m.RLID = int.Parse(Session["RLID"].ToString()); if (!sm.IshasBycleinLction(m)) //可以删除 { if (sm.Delete_Lction(m)) { Table3.Visible = false; Session["Gongju"] = 1; Response.Redirect(Request.Path); }else Response.Write("<script>alert('删除失败！')</script>"); } else Response.Write("<script>alert('删除失败！请保证您的租赁点未分配任何车辆')</script>"); } protected void Gv3delete_Click(object o, EventArgs e) //删除自行车 { M_Bicycle m = new M_Bicycle(); m.RLID = int.Parse(Session["RLID"].ToString()); m.RLBID= int.Parse(GridView3.SelectedDataKey[0].ToString()); SysManager sm = new SysManager(); if (sm.Delete_BycleInlc(m)) { Session["Gongju"] = 2; Response.Redirect(Request.Path); } else Response.Write("<script>alert('删除失败！')</script>"); } protected void Button14_Click(object sender, EventArgs e) //返回首页 { Response.Redirect("SysMger_HomePage.aspx"); } protected void Button15_Click(object sender, EventArgs e) //取消自行车信息显示 { gj = 0; GridView3.Visible = false; Button15.Visible = false; Table3.Visible = true; Table7.Visible = false; } } }

租赁管理员管理页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Code.BLL; using WBDYW.WBDYW_Models; namespace WBDYW.SysMger_Pages { public partial class Sysmger_RtMager : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (Session["Gongju"].ToString() == "1") { Response.Write("<script>alert('添加成功,默认密码为123！')</script>"); Session["Gongju"] = 0; } //添加管理员 if (Session["Gongju"].ToString() == "2") { Response.Write("<script>alert('修改成功！')</script>"); Session["Gongju"] = 0; } //修改管理员信息 } protected void Btnsure_Click(object o, EventArgs e) //确定添加管理员 { if (txtrmname.Text != "") { DateTime createtime=DateTime.Now; M_RtManager rm = new M_RtManager(); rm.RentName = txtrmname.Text; rm.Name = txtname.Text; rm.Password = "123"; if (txtphone.Text != "") { rm.Telephone = int.Parse(txtphone.Text); } else rm.Telephone = 0; rm.CreateTime = DateTime.Parse(createtime.ToUniversalTime().ToString()); if (txtmark.Text != "") { rm.Marks = txtmark.Text; } else rm.Marks = ""; rm.RoleID = 3; SysManager sm = new SysManager(); if (sm.AddRtManager(rm)) { txtmark.Text = ""; txtname.Text = ""; txtphone.Text = ""; txtrmname.Text = ""; Table1.Visible = false; Session["Gongju"] = 1; Response.Redirect(Request.Path); } else { txtrmname.Text = ""; Response.Write("<script>alert('该管理员账号名已存在！')</script>"); } } else Response.Write("<script>alert('输入的内容不能为空！')</script>"); } protected void Button1_Click(object sender, EventArgs e) //添加管理员（显示表） { Table1.Visible = true; } protected void Btncancel_Click(object sender, EventArgs e) //取消 { txtmark.Text = ""; txtname.Text = ""; txtphone.Text = ""; txtrmname.Text = ""; Table1.Visible = false; } protected void Gvselect_Click(object sender, EventArgs e) //编辑 { Session["RMID"]=GridView1.SelectedDataKey.Value.ToString(); txtrmname1.Text=GridView1.SelectedRow.Cells[0].Text.ToString(); txtname1.Text = GridView1.SelectedRow.Cells[1].Text.ToString(); txtphone1.Text=GridView1.SelectedRow.Cells[2].Text.ToString(); txtmark1.Text=GridView1.SelectedRow.Cells[5].Text.ToString(); if (txtmark1.Text == "&nbsp;") { txtmark1.Text = ""; } if (txtname1.Text == "&nbsp;") { txtname1.Text = ""; } if (txtphone1.Text == "&nbsp;") { txtphone1.Text = ""; } Session["Name"]= txtname1.Text; Session["Phone"]= txtphone1.Text; Session["Marks"]= txtmark1.Text; Session["RentName"]= txtrmname1.Text; Table2.Visible = true; } protected void Btncancel1_Click(object sender, EventArgs e) //取消编辑 { txtmark1.Text = ""; txtname1.Text = ""; txtphone1.Text = ""; txtrmname1.Text = ""; Table2.Visible = false; } protected void Btnsure1_Click(object o, EventArgs e) //确认修改 { DateTime updatetime = DateTime.Now; M_RtManager m = new M_RtManager(); m.RMID = int.Parse(Session["RMID"].ToString()); m.RentName = txtrmname1.Text; m.Name = txtname1.Text; m.UpdateTime = DateTime.Parse(updatetime.ToUniversalTime().ToString()); m.Marks = txtmark1.Text; if (txtrmname1.Text == "") { m.RentName = Session["RentName"].ToString(); } if (txtname1.Text == "") { m.Name = Session["Name"].ToString(); } if (txtphone1.Text == "") { m.Telephone = int.Parse(Session["Phone"].ToString()); } else m.Telephone = int.Parse(txtphone1.Text.ToString()); if (txtmark1.Text == "") { m.Marks = Session["Marks"].ToString(); } SysManager sm = new SysManager(); if (sm.UpdateRtManager(m)) { txtmark1.Text = ""; txtname1.Text = ""; txtphone1.Text = ""; txtrmname1.Text = ""; Table2.Visible = false; Session["Gongju"] = 2; Response.Redirect(Request.Path); }else Response.Write("<script>alert('修改失败！')</script>"); } protected void Button2_Click(object sender, EventArgs e) //返回首页 { Response.Redirect("SysMger_HomePage.aspx"); } } }

自行车维修页面

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using WBDYW.WBDYW_Models; using WBDYW.WBDYW_Code.BLL; namespace WBDYW.SysMger_Pages { public partial class Sysmger_Repair : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (GridView1.Rows.Count == 0) { Table1.Visible = true; } else Table1.Visible = false; if (Session["Gongju"].ToString() == "1") { Response.Write("<script>alert('操作成功！')</script>"); Session["Gongju"] = 0; } } protected void Gvselect_Click(object o, EventArgs e) { SysManager sm = new SysManager(); M_Bicycle m = new M_Bicycle(); m.RLID=int.Parse(GridView1.SelectedDataKey[0].ToString()); m.RRID = int.Parse(GridView1.SelectedDataKey[1].ToString()); m.BycleID = int.Parse(GridView1.SelectedDataKey[2].ToString()); m.UserID = int.Parse(GridView1.SelectedDataKey[3].ToString()); m.Deposit = int.Parse(GridView1.SelectedDataKey[4].ToString()); if (sm.RepairBycle(m)) { Session["Gongju"] = 1; Response.Redirect(Request.Path); } else Response.Write("<script>alert('操作失败！')</script>"); } protected void Button5_Click(object sender, EventArgs e) //返回首页 { Response.Redirect("SysMger_HomePage.aspx"); } } }

数据库代码

用户

using System; using System.Collections.Generic; using System.Data; using System.Data.SqlClient; using System.Linq; using System.Web; using WBDYW.WBDYW_Models; namespace WBDYW.WBDYW_Code.DAL { public class UserService { public List<M_Users> Login(string name, string psd) //登录 { string sql = "select * from TheUser where (UserName= @UserName) and (Password=@Password)"; //用户表 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName",name), new SqlParameter("@Password",psd) }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Users> list = new List<M_Users>(); if (dt.Rows.Count != 0) { foreach (DataRow r in dt.Rows) { M_Users m_Users = new M_Users(); m_Users.UserID = Int32.Parse(r["UserID"].ToString()); m_Users.UserName = r["UserName"].ToString(); m_Users.Password = r["Password"].ToString(); m_Users.Name = r["Name"].ToString(); m_Users.Telephone = Int16.Parse(r["Telephone"].ToString()); m_Users.Money = Int16.Parse(r["TheMoney"].ToString()); m_Users.RoleID = Int16.Parse(r["RoleID"].ToString()); list.Add(m_Users); } return list; } else { string sql1 = "select * from SystemManager where Account=@Account and Password=@Password"; //系统管理员表 SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@Account",name), new SqlParameter("@Password",psd) }; DataTable dt1 = DBHelper.GetDataTable(sql1, param1); List<M_Users> list1 = new List<M_Users>(); if (dt1.Rows.Count != 0) { foreach (DataRow r in dt1.Rows) { M_Users m_Users = new M_Users(); m_Users.UserID = Int32.Parse(r["SMID"].ToString()); m_Users.UserName = r["Account"].ToString(); m_Users.Password = r["Password"].ToString(); m_Users.RoleID = int.Parse(r["RoleID"].ToString()); list1.Add(m_Users); } return list1; } else { string sql2 = "select * from RentManager where RentName=@RentName and Password=@Password"; //租赁点管理员表 SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@RentName",name), new SqlParameter("@Password",psd) }; DataTable dt2 = DBHelper.GetDataTable(sql2, param2); List<M_Users> list2 = new List<M_Users>(); if (dt2.Rows.Count != 0) { foreach (DataRow r in dt2.Rows) { M_Users m_Users = new M_Users(); m_Users.UserID = Int32.Parse(r["RMID"].ToString()); m_Users.UserName = r["RentName"].ToString(); m_Users.Name = r["Name"].ToString(); m_Users.Password = r["Password"].ToString(); m_Users.RoleID = Int16.Parse(r["RoleID"].ToString()); m_Users.Telephone = int.Parse(r["Telephone"].ToString()); list2.Add(m_Users); } return list2; } } } return list; } public bool Zhuce(string name, string psd,int Telephone,int Money,int RoleID) //注册 { string sql = "insert into TheUser(UserName,Password,Telephone,Money,RoleID) values(@UserName,@Password,@Telephone,@Money,@RoleID)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName",name), new SqlParameter("@Password",psd), new SqlParameter("@Telephone",Telephone), new SqlParameter("@Money",Money), new SqlParameter("@RoleID",RoleID) }; return DBHelper.ExcuteCommand(sql, param); } public bool IshasName(string name) //用户名是否已存在 { string sql = "select * from TheUser where (UserName=@UserName)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName",name) }; DataTable dt = DBHelper.GetDataTable(sql, param); if (dt != null) { if (dt.Rows.Count == 0) //不存在时返回true return true; else return false; } else return false; } public List<M_Users> Update_Infor(M_Users m_Users) //修改个人信息 { string sql = "update TheUser set UserName=@UserName,Name=@Name,Telephone=@Telephone where UserID=@UserID"; //修改 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserName",m_Users.UserName), new SqlParameter("@Name",m_Users.Name), new SqlParameter("@Telephone",m_Users.Telephone), new SqlParameter("@UserID",m_Users.UserID), }; DBHelper.ExcuteCommand(sql, param); string sql2 = "select * from TheUser where UserID=@UserID"; //得到修改后的数据 SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@UserID",m_Users.UserID), }; DataTable dt = DBHelper.GetDataTable(sql2, param1); List<M_Users> list = new List<M_Users>(); if (dt != null) { if (dt.Rows.Count != 0) { M_Users m_Users1 = new M_Users(); foreach (DataRow r in dt.Rows) { m_Users1.UserName = r["UserName"].ToString(); m_Users1.Name = r["Name"].ToString(); m_Users1.Telephone = Int16.Parse(r["Telephone"].ToString()); list.Add(m_Users1); } return list; } return list; } return list; } public bool Update_psd(M_Users m_Users) //修改密码 { string sql = "update TheUser set Password=@Password where UserID=@UserID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Password",m_Users.Password), new SqlParameter("@UserID",m_Users.UserID) }; return DBHelper.ExcuteCommand(sql, param); } public List<M_Bicycle> BycleCanrent() //查询所有地点可租的自行车 { string sql = "select * from RL_Bycle left join Bicycle on RL_Bycle.BycleID=Bicycle.BycleID left join RentLocation on RL_Bycle.RLID=RentLocation.RLID"; DataSet ds = DBHelper.GetDataSet(sql); List<M_Bicycle> list = new List<M_Bicycle>(); DataTable dt = ds.Tables[0]; if (dt != null) { foreach (DataRow r in ds.Tables[0].Rows) { M_Bicycle m_Bicycle = new M_Bicycle(); m_Bicycle.RLBID = int.Parse(r["RLBID"].ToString()); m_Bicycle.RLID = int.Parse(r["RLID"].ToString()); m_Bicycle.BycleID = int.Parse(r["BycleID"].ToString()); m_Bicycle.RLction = r["RLction"].ToString(); m_Bicycle.RLName = r["RLName"].ToString(); m_Bicycle.RentCount = int.Parse(r["RentCount"].ToString()); m_Bicycle.Brand = r["Brand"].ToString(); m_Bicycle.IsBad = int.Parse(r["IsBad"].ToString()); list.Add(m_Bicycle); } return list; }else return list; } public bool RtRcd(M_Bicycle m) //存入租赁记录 { string sql = "insert into RentRecord(RLBID,UserIdcard,Deposit,RentTime,UserID,States) values(@RLBID,@UserIdcard,@Deposit,@RentTime,@UserID,@States)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLBID",m.RLBID), new SqlParameter("@UserIdcard",m.UserIdcard), new SqlParameter("@Deposit",m.Deposit), new SqlParameter("@RentTime",m.RentTime), new SqlParameter("@UserID",m.UserID), new SqlParameter("@States",m.States) }; if (DBHelper.ExcuteCommand(sql, param)) { if(m.Deposit==1) { int money = m.Money - 50; string sql2 = "update TheUser set TheMoney=@TheMoney where UserID=@UserID";//扣除押金 SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), new SqlParameter("@TheMoney",money), }; DBHelper.ExcuteCommand(sql2,param2); } string sql1 = "update RL_Bycle set RentCount=@RentCount where RLBID=@RLBID"; //租出自行车点可租自行车数量减1 m.RentCount -= 1; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RentCount",m.RentCount), new SqlParameter("@RLBID",m.RLBID), }; if (DBHelper.ExcuteCommand(sql1, param1)) { return true; } else return false; } else return false; } public List<M_Bicycle> Data_rtrcd(int UserID) //得到用户租赁的自行车数据 { string sql = "select * from RentRecord where UserID=@UserID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserID",UserID), }; DataTable dt = DBHelper.GetDataTable(sql, param); M_Bicycle m = new M_Bicycle(); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { if (dt.Rows.Count != 0) { foreach (DataRow r in dt.Rows) { m.RetnTime= r["RetnTime"].ToString(); m.RentTime = r["RentTime"].ToString(); m.UserIdcard = int.Parse(r["UserIdcard"].ToString()); m.Deposit = int.Parse(r["Deposit"].ToString()); m.RLBID = int.Parse(r["RLBID"].ToString()); m.States = r["States"].ToString(); list.Add(m); } string sql1 = "select * from RentLocation where RentLocation.RLID in(select RLID from RL_Bycle where RLBID=@RLBID)"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RLBID",m.RLBID), }; DataTable dt1 = DBHelper.GetDataTable(sql1, param1); if (dt1 != null) { foreach (DataRow r in dt1.Rows) { m.RLName = r["RLName"].ToString(); m.RLction = r["RLction"].ToString(); } } string sql2 = "select * from Bicycle where Bicycle.BycleID in(select BycleID from RL_Bycle where RLBID=@RLBID)"; SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@RLBID",m.RLBID), }; DataTable dt2 = DBHelper.GetDataTable(sql2, param2); if (dt2 != null) { foreach (DataRow r in dt2.Rows) { m.Brand = r["Brand"].ToString(); m.Type = r["Type"].ToString(); list.Add(m); } return list; } } } list = null; return list; } public bool IsRent(int UserID) //用户是否已租过自行车 { string sql = "select * from RentRecord where UserID=@UserID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserID",UserID), }; DataTable dt = DBHelper.GetDataTable(sql, param); if (dt != null) { int i = 0; foreach (DataRow r in dt.Rows) { if (r["States"].ToString() == "renting" || r["States"].ToString() == "backing") { i = 1; } } if (i == 0) //不存在时返回true return true; else return false; } else return false; } public List<M_Bicycle> All_RLtion() //得到所有租赁点地址,及其对应的ID { string sql = "select * from RentLocation"; DataTable dt= DBHelper.GetDataTable(sql); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt.Rows.Count != 0) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.RLction = r["RLction"].ToString(); m.RLID = int.Parse(r["RLID"].ToString()); list.Add(m); } } return list; } public bool ReturnBycle(M_Bicycle m) //归还自行车 { string states = "renting"; string sql = "select RRID from RentRecord where UserID=@UserID and States=@States"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), new SqlParameter("@States",states), }; DataTable dt = DBHelper.GetDataTable(sql,param); foreach (DataRow r in dt.Rows) { m.RRID = int.Parse(r["RRID"].ToString()); } string sql1 = "update RentRecord set States=@States,RetnRLID=@RetnRLID,RetnTime=@RetnTime where RRID=@RRID"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RRID",m.RRID), new SqlParameter("@States",m.States), new SqlParameter("@RetnRLID",m.RLID), new SqlParameter("@RetnTime",m.RetnTime) }; if (DBHelper.ExcuteCommand(sql1, param1)) { if (m.Deposit==1) { string sql2 = "select TheMoney from TheUser where UserID=@UserID"; SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), }; DataTable dt2 = DBHelper.GetDataTable(sql2, param2); int money = 0; if (dt2 != null) { foreach (DataRow r in dt2.Rows) { money = int.Parse(r["TheMoney"].ToString()); } } money -=m.Money; string sql5 = "update TheUser set TheMoney=@TheMoney where UserID=@UserID"; SqlParameter[] param5 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), new SqlParameter("@TheMoney",money) }; DBHelper.ExcuteCommand(sql5, param5); } return true; } else return false; } public bool RetBy_delet(int UserID) //删除租车记录的数据 { string sql = "Delete from RentRecord where UserID=@UserID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserID",UserID), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } public int SlcWhichBycle(M_Bicycle m) //首页的选择租赁，获得所选自行车的RLBID { string sql = "select RLBID from RL_Bycle where BycleID=@BycleID and RLID=@RLID"; //查询选择的还车点有没有该自行车 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@BycleID",m.BycleID), new SqlParameter("@RLID",m.RLID), }; DataTable dt = DBHelper.GetDataTable(sql, param); int i=0; if (dt != null) { foreach (DataRow r in dt.Rows) { i = int.Parse(r["RLBID"].ToString()); } return i; } return i; } public bool AddMoney(M_Users m) //充值 { string sql = "select TheMoney from TheUser where UserID=@UserID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), }; DataTable dt = DBHelper.GetDataTable(sql,param); int money = 0; if (dt != null) { foreach (DataRow r in dt.Rows) { money = int.Parse(r["TheMoney"].ToString()); } } money += m.Money; string sql1 = "update TheUser set TheMoney=@TheMoney where UserID=@UserID"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), new SqlParameter("@TheMoney",money) }; if (DBHelper.ExcuteCommand(sql1, param1)) { return true; } else return false; } public List<M_Bicycle> Find_RLction(string RLction) //搜索租赁地址 { string sql = "select RLction from RentLocation where RLction like '%'+@RLction+'%'"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLction",RLction), }; DataTable dt = DBHelper.GetDataTable(sql,param); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.RLction = r["RLction"].ToString(); list.Add(m); } return list; } return list; } } }

租赁管理员

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using WBDYW.WBDYW_Models; namespace WBDYW.WBDYW_Code.DAL { public class RtMagerService { public bool Ishadname(string Rtname) //修改的用户名是否已存在 { string sql = "select * from RentManager where RentName=@RentName"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RentName",Rtname), }; DataTable dt = DBHelper.GetDataTable(sql,param); if (dt.Rows.Count == 0) //不存在时返回真 { return true; } else return false; } public M_RtManager UpdateRtMgerInfor(M_RtManager m) //修改租赁管理员的资料 { string sql = "update RentManager set RentName=@RentName,Name=@Name,Telephone=@Telephone where RMID=@RMID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",m.RMID), new SqlParameter("@RentName",m.RentName), new SqlParameter("@Name",m.Name), new SqlParameter("@Telephone",m.Telephone), }; M_RtManager m1 = new M_RtManager(); if (DBHelper.ExcuteCommand(sql, param)) { string sql1 = "select * from RentManager where RMID=@RMID"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RMID",m.RMID), }; DataTable dt = DBHelper.GetDataTable(sql1, param1); if (dt != null) { if (dt.Rows.Count != 0) { foreach (DataRow r in dt.Rows) { m1.RentName = r["RentName"].ToString(); m1.Name = r["Name"].ToString(); m1.Telephone = int.Parse(r["Telephone"].ToString()); } return m1; } } } return m1; } public bool Update_Psd(M_RtManager m) //修改租赁管理员密码 { string sql = "update RentManager set Password=@Password where RMID=@RMID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",m.RMID), new SqlParameter("@Password",m.Password), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } public List<M_Bicycle> GetRLids(int RMID) //拿到此管理员管理的租赁点 { string sql = "select RLID,RLName from RentLocation where RMID=@RMID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",RMID), }; DataTable dt = DBHelper.GetDataTable(sql,param); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.RLID = int.Parse(r["RLID"].ToString()); m.RLName= r["RLName"].ToString(); list.Add(m); } return list; } return list; } public List<M_Bicycle> Theall(int RLID) //拿到管理员管理的租赁点及其信息 { string sql = "select Brand,Type from Bicycle where BycleID in (select BycleID from RL_Bycle where RLID=@RLID)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLID",RLID), }; DataTable dt = DBHelper.GetDataTable(sql,param); List<M_Bicycle> list = new List<M_Bicycle>(); int i = 0; if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.Brand = r["Brand"].ToString(); m.Type = r["Type"].ToString(); list.Add(m); } string sql1 = "select RentCount from RL_Bycle where RLID=@RLID"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RLID",RLID), }; DataTable dt1 = DBHelper.GetDataTable(sql1, param1); if (dt1 != null) { foreach (DataRow r in dt1.Rows) { M_Bicycle m = new M_Bicycle(); m.RentCount = int.Parse(r["RentCount"].ToString()); list[i].RentCount = m.RentCount; i++; } i = 0; string sql2 = "select RLction from RentLocation where RLID=@RLID"; SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@RLID",RLID), }; DataTable dt2 = DBHelper.GetDataTable(sql2, param2); if (dt2 != null) { string rlction=""; foreach (DataRow r in dt2.Rows) { rlction = r["RLction"].ToString(); } for (; i < list.Count;) { list[i].RLction = rlction; i++; } return list; } } }return list; } public List<M_Bicycle> GetRentInf(int RMID) //根据RMID,来得到租赁自行车的租赁情况 { string states="renting"; string sql = "select RentTime,UserID,UserIdcard,Deposit,States from RentRecord where RLBID in (select RLBID from RL_Bycle where RLID in (select RLID from RentLocation where RMID=@RMID)) and States=@States"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",RMID), new SqlParameter("@States",states), }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.UserIdcard = int.Parse(r["UserIdcard"].ToString()); m.Deposit = int.Parse(r["Deposit"].ToString()); m.RentTime = r["RentTime"].ToString(); m.States = r["States"].ToString(); list.Add(m); } return list; } return list; } public List<M_Users> GetRentUserInf(int RMID) //根据RMID,来得到租赁自行车的用户信息 { string states = "renting"; string sql = "select UserName,Name,Telephone from TheUser where UserID in (select UserID from RentRecord where (RLBID in (select RLBID from RL_Bycle where RLID in (select RLID from RentLocation where RMID=@RMID)) and States=@States))"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",RMID), new SqlParameter("@States",states), }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Users> list = new List<M_Users>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Users m = new M_Users(); m.UserName = r["UserName"].ToString(); m.Name = r["Name"].ToString(); m.Telephone = int.Parse(r["Telephone"].ToString()); list.Add(m); } return list; } return list; } public List<M_Bicycle> GetRentBycleInf(int RMID) //根据RMID,来得到租赁自行车的信息 { string states = "renting"; string sql = "select b.Brand,b.Type from Bicycle as b,RentRecord as rr,RL_Bycle as rlb where (rr.RLBID in (select RLBID from RL_Bycle where RLID in (select RLID from RentLocation where RMID=@RMID)) and rr.States=@States) and rlb.RLBID=rr.RLBID and b.BycleID=rlb.BycleID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",RMID), new SqlParameter("@States",states), }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.Brand = r["Brand"].ToString(); m.Type = r["Type"].ToString(); list.Add(m); } return list; } return list; } public bool SureRetn(M_Bicycle m) //管理员确定自行车归还 { //string sql = "select RLBID from RentRecord where RRID=@RRID"; //拿到RLBID //SqlParameter[] param = new SqlParameter[] // { // new SqlParameter("@RRID",m.RRID), // }; //DataTable dt = DBHelper.GetDataTable(sql,param); //if (dt != null) //{ // foreach (DataRow r in dt.Rows) // { // m.RLBID = int.Parse(r["RLBID"].ToString()); // } //} string sql1 = "select * from RL_Bycle where BycleID=@BycleID and RLID=@RLID"; //查询选择的还车点有没有该自行车 SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@BycleID",m.BycleID), new SqlParameter("@RLID",m.RLID), }; DataTable dt1 = DBHelper.GetDataTable(sql1, param1); if (dt1.Rows.Count != 0) //已有该自行车，就直接数量加一 { foreach (DataRow r in dt1.Rows) { m.RLBID = int.Parse(r["RLBID"].ToString()); m.RentCount = int.Parse(r["RentCount"].ToString()); } m.RentCount += 1; string sql2 = "update RL_Bycle set RentCount=@RentCount where RLBID=@RLBID"; //给该点自行车数量加一 SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@RentCount",m.RentCount), new SqlParameter("@RLBID",m.RLBID), }; DBHelper.ExcuteCommand(sql2, param2); } else //没有的话，就新添一条数据 { string sql3 = "insert into RL_Bycle(BycleID,RLID,RentCount) values(@BycleID,@RLID,@RentCount)"; //新添数据 SqlParameter[] param3 = new SqlParameter[] { new SqlParameter("@RentCount",1), new SqlParameter("@BycleID",m.BycleID), new SqlParameter("@RLID",m.RLID), }; DBHelper.ExcuteCommand(sql3, param3); } //退还押金 if (m.Deposit == 1) { string sql6 = "select TheMoney from TheUser where UserID=@UserID"; SqlParameter[] param6 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), }; DataTable dt = DBHelper.GetDataTable(sql6, param6); int money = 0; if (dt != null) { foreach (DataRow r in dt.Rows) { money = int.Parse(r["TheMoney"].ToString()); } } money += 50; string sql5 = "update TheUser set TheMoney=@TheMoney where UserID=@UserID"; SqlParameter[] param5 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), new SqlParameter("@TheMoney",money) }; DBHelper.ExcuteCommand(sql5,param5); } string sql4 = "update RentRecord set States=@States where RRID=@RRID"; //修改租赁记录中的状态 SqlParameter[] param4 = new SqlParameter[] { new SqlParameter("@States",m.States), new SqlParameter("@RRID",m.RRID) }; if (DBHelper.ExcuteCommand(sql4, param4)) { return true; } else return false; } public bool Repair(int RRID) //令租赁的自行车状态为维修 { string states="bad"; string sql = "update RentRecord set States=@States where RRID=@RRID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RRID",RRID), new SqlParameter("@States",states), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } } }

系统管理员

using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Data; using System.Data.SqlClient; using WBDYW.WBDYW_Models; namespace WBDYW.WBDYW_Code.DAL { public class SysMagerService { public List<M_Bicycle> Bycle_infors() //查询所有的品牌，型号 { string sql = "select * from Bicycle"; DataTable dt = DBHelper.GetDataTable(sql); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt.Rows.Count != 0) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.BycleID = int.Parse(r["BycleID"].ToString()); m.BycleCount = int.Parse(r["BycleCount"].ToString()); m.Brand = r["Brand"].ToString(); m.Type = r["Type"].ToString(); list.Add(m); } return list; }return list; } public List<M_RtManager> RtmanagerInfor() //查询租赁管理员信息 { string sql = "select * from RentManager"; DataTable dt = DBHelper.GetDataTable(sql); List<M_RtManager> list = new List<M_RtManager>(); if (dt.Rows.Count != 0) { foreach (DataRow r in dt.Rows) { M_RtManager m = new M_RtManager(); m.RentName = r["RentName"].ToString(); m.RMID = int.Parse(r["RMID"].ToString()); list.Add(m); } return list; } return list; } public bool AddBycle(M_Bicycle m) //添加自行车 { string sql1 = "select * from Bicycle where Brand=@Brand and Type=@Type"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@Brand",m.Brand), new SqlParameter("@Type",m.Type), }; DataTable dt = DBHelper.GetDataTable(sql1, param1); if (dt.Rows.Count != 0) //已有该自行车，在原有上数量增加 { int rentcount = 0; foreach (DataRow r in dt.Rows) { rentcount = int.Parse(r["BycleCount"].ToString()); } rentcount += m.BycleCount; string sql2 = "update Bicycle set BycleCount=@BycleCount where Brand=@Brand and Type=@Type"; SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@Brand",m.Brand), new SqlParameter("@Type",m.Type), new SqlParameter("@BycleCount",rentcount) }; if (DBHelper.ExcuteCommand(sql2, param2)) { return true; } else return false; } else { string sql = "insert into Bicycle(Brand,Type,ManufactureDate,PurchaseDate,BycleCount,IsBad) values(@Brand,@Type,@ManufactureDate,@PurchaseDate,@BycleCount,@IsBad)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@Brand",m.Brand), new SqlParameter("@Type",m.Type), new SqlParameter("@ManufactureDate",m.ManufactureDate), new SqlParameter("@PurchaseDate",m.PurchaseDate), new SqlParameter("@BycleCount",m.BycleCount), new SqlParameter("@IsBad",m.IsBad), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } } public bool AddRtManager(M_RtManager m) //添加租赁管理员 { string sql1 = "select * from RentManager where RentName=@RentName"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RentName",m.RentName), }; DataTable dt = DBHelper.GetDataTable(sql1,param1); if (dt != null) { if (dt.Rows.Count != 0) { return false; } else { string sql = "insert into RentManager(RentName,Password,Name,Telephone,CreateTime,Marks,RoleID) values(@RentName,@Password,@Name,@Telephone,@CreateTime,@Marks,@RoleID)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RentName",m.RentName), new SqlParameter("@Password",m.Password), new SqlParameter("@Name",m.Name), new SqlParameter("@Telephone",m.Telephone), new SqlParameter("@CreateTime",m.CreateTime), new SqlParameter("@Marks",m.Marks), new SqlParameter("@RoleID",m.RoleID), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } }return false; } public bool AddRtLction(M_Bicycle m) //添加租赁点(未分配自行车) { string sql1 = "select * from RentLocation where RLName=@RLName"; SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RLName",m.RLName), }; DataTable dt = DBHelper.GetDataTable(sql1,param1); if (dt != null) { if (dt.Rows.Count != 0) //已有该租赁点名称 { return false; } else { string sql = "insert into RentLocation(RLName,Rlction,RLCrtime,RLmk,RMID) values(@RLName,@Rlction,@RLCrtime,@RLmk,@RMID)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLName",m.RLName), new SqlParameter("@Rlction",m.RLction), new SqlParameter("@RLCrtime",m.RLCrtime), new SqlParameter("@RLmk",m.RLmk), new SqlParameter("@RMID",m.RMID), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } }return false; } public bool UpdateRtManager(M_RtManager m) //修改租赁管理员 { string sql = "update RentManager set RentName=@RentName,Name=@Name,Telephone=@Telephone,UpdateTime=@UpdateTime,Marks=@Marks where RMID=@RMID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RMID",m.RMID), new SqlParameter("@RentName",m.RentName), new SqlParameter("@Name",m.Name), new SqlParameter("@Telephone",m.Telephone), new SqlParameter("@UpdateTime",m.UpdateTime), new SqlParameter("@Marks",m.Marks), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } public List<M_Bicycle> BycleInfor() //查询自行车信息 { string sql = "select * from Bicycle"; DataTable dt = DBHelper.GetDataTable(sql); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.BycleID = int.Parse(r["BycleID"].ToString()); m.Brand = r["Brand"].ToString(); m.Type = r["Type"].ToString(); m.BycleCount = int.Parse(r["BycleCount"].ToString()); list.Add(m); } return list; } else return list; } public int RtMager_ID(string name) //修改租赁点信息时，根据选择的管理员名称得到相应的id { string sql = "select RMID from RentManager where RentName=@RentName"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RentName",name), }; DataTable dt = DBHelper.GetDataTable(sql,param); int rmid = 0; if (dt != null) { foreach (DataRow r in dt.Rows) { rmid = int.Parse(r["RMID"].ToString()); } return rmid; } return rmid; } public bool UpdateRtLoction(M_Bicycle m) //修改租赁点信息 { string sql = "update RentLocation set RLName=@RLName,RLction=@RLction,RLmk=@RLmk,RMID=@RMID where RLID=@RLID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLName",m.RLName), new SqlParameter("@RLction",m.RLction), new SqlParameter("@RLmk",m.RLmk), new SqlParameter("@RMID",m.RMID), new SqlParameter("@RLID",m.RLID), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } public List<M_Bicycle> RL_Bycle1(int RLID) //查询租赁点拥有的自行车id及数量 { string sql = "select * from RL_Bycle where RLID=@RLID"; //string sql = "SELECT BycleID FROM RL_Bycle WHERE (RLID = @RLID)"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLID",RLID), }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt != null) { foreach (DataRow r in dt.Rows) { M_Bicycle m = new M_Bicycle(); m.BycleID = int.Parse(r["BycleID"].ToString()); m.RentCount = int.Parse(r["RentCount"].ToString()); list.Add(m); } return list; } return list; } public M_Bicycle RL_Bycle2(int BycleID) //查询租赁点拥有的自行车的信息 { string sql = "select * from Bicycle where BycleID=@BycleID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@BycleID",BycleID), }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Bicycle> list = new List<M_Bicycle>(); M_Bicycle m = new M_Bicycle(); if (dt != null) { foreach (DataRow r in dt.Rows) { m.Brand = r["Brand"].ToString(); m.Type = r["Type"].ToString(); } return m; } return m; } public bool RL_Bycle3(M_Bicycle m) //给租赁点添加车辆 { string sql = "select * from RL_Bycle where RLID=@RLID and BycleID=@BycleID"; //查询新添的自行车是否是该租赁点已有的 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLID",m.RLID), new SqlParameter("@BycleID",m.BycleID), }; DataTable dt = DBHelper.GetDataTable(sql, param); List<M_Bicycle> list = new List<M_Bicycle>(); if (dt.Rows.Count == 0) //没有 { string sql1 = "insert into RL_Bycle(RLID,BycleID,RentCount) values(@RLID,@BycleID,@RentCount)"; //直接添加新数据 SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RLID",m.RLID), new SqlParameter("@BycleID",m.BycleID), new SqlParameter("@RentCount",m.RentCount), }; if (DBHelper.ExcuteCommand(sql1, param1)) { return ReduceByclecount(m); } } else //已有 { int rentcount = 0; foreach(DataRow r in dt.Rows) { rentcount = int.Parse(r["RentCount"].ToString()); } rentcount += m.RentCount; string sql3 = "update RL_Bycle set RentCount=@RentCount where RLID=@RLID and BycleID=@BycleID"; //在已有的数据上增加自行车数量 SqlParameter[] param3 = new SqlParameter[] { new SqlParameter("@RentCount",rentcount), new SqlParameter("@RLID",m.RLID), new SqlParameter("@BycleID",m.BycleID), }; if (DBHelper.ExcuteCommand(sql3, param3)) { return ReduceByclecount(m); } } return false; } public bool RepairBycle(M_Bicycle m) //维修自行车 { string states = "ok"; string sql = "update RentRecord set States=@States where RRID=@RRID"; //States改为ok SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RRID",m.RRID), new SqlParameter("@States",states), }; DBHelper.ExcuteCommand(sql,param); string sql1 = "select * from RL_Bycle where BycleID=@BycleID and RLID=@RLID"; //查询选择的还车点有没有该自行车 SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@BycleID",m.BycleID), new SqlParameter("@RLID",m.RLID), }; DataTable dt1 = DBHelper.GetDataTable(sql1, param1); if (dt1.Rows.Count != 0) //已有该自行车，就直接数量加一 { foreach (DataRow r in dt1.Rows) { m.RLBID = int.Parse(r["RLBID"].ToString()); m.RentCount = int.Parse(r["RentCount"].ToString()); } m.RentCount += 1; string sql2 = "update RL_Bycle set RentCount=@RentCount where RLBID=@RLBID"; //给该点自行车数量加一 SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@RentCount",m.RentCount), new SqlParameter("@RLBID",m.RLBID), }; DBHelper.ExcuteCommand(sql2, param2); } else //没有的话，就新添一条数据 { string sql3 = "insert into RL_Bycle(BycleID,RLID,RentCount) values(@BycleID,@RLID,@RentCount)"; //新添数据 SqlParameter[] param3 = new SqlParameter[] { new SqlParameter("@RentCount",1), new SqlParameter("@BycleID",m.BycleID), new SqlParameter("@RLID",m.RLID), }; DBHelper.ExcuteCommand(sql3, param3); } //退还押金 if (m.Deposit == 1) { string sql6 = "select money from TheUser where UserID=@UserID"; //查询用户的钱 SqlParameter[] param6 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), }; DataTable dt = DBHelper.GetDataTable(sql6, param6); int money = 0; if (dt != null) { foreach (DataRow r in dt.Rows) { money = int.Parse(r["money"].ToString()); } } money += 50; string sql5 = "update TheUser set money=@money where UserID=@UserID"; SqlParameter[] param5 = new SqlParameter[] { new SqlParameter("@UserID",m.UserID), new SqlParameter("@money",money) }; if (DBHelper.ExcuteCommand(sql5, param5)) { return true; } else return false; } return true; } public bool Isused(string bycleid) //查询要删除的自行车是否租赁点正在使用 { string sql = "select * from RL_Bycle where BycleID=@BycleID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@BycleID",bycleid), }; DataTable dt = DBHelper.GetDataTable(sql,param); if (dt!=null) { if (dt.Rows.Count == 0) //没被用 { return true; } else return false; } else return false; } public bool DeleteBycle(string bycleid) //删除自行车 { string sql = "delete from Bicycle where BycleID=@BycleID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@BycleID",bycleid), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } public bool IshasBycleinLction(M_Bicycle m) //租赁点是否分配的有自行车 { string sql = "select * from RL_Bycle where RLID=@RLID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLID",m.RLID), }; DataTable dt = DBHelper.GetDataTable(sql,param); if (dt != null) { if (dt.Rows.Count != 0) { return true; } else return false; } else return false; } public bool Delete_Lction(M_Bicycle m)//删除租赁点 { string sql = "delete from RentLocation where RLID=@RLID"; SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLID",m.RLID), }; if (DBHelper.ExcuteCommand(sql, param)) { return true; } else return false; } public bool Delete_BycleInlc(M_Bicycle m) //删除租赁点某个拥有的自行车 { string sql = "select RentCount,BycleID from RL_Bycle where RLBID=@RLBID"; //查询租赁点拥有的自行车数量 SqlParameter[] param = new SqlParameter[] { new SqlParameter("@RLBID",m.RLBID), }; DataTable dt = DBHelper.GetDataTable(sql,param); int count = 0; int byclecount = 0; int bycleid = 0; if (dt != null) { foreach (DataRow r in dt.Rows) { count = int.Parse(r["RentCount"].ToString()); bycleid = int.Parse(r["BycleID"].ToString()); } string sql3 = "select BycleCount from Bicycle where BycleID=@BycleID"; //查询自行车总数量 SqlParameter[] param3 = new SqlParameter[] { new SqlParameter("@BycleID",bycleid), }; DataTable dt1 = DBHelper.GetDataTable(sql3,param3); if (dt1 != null) { foreach (DataRow r in dt1.Rows) { byclecount = int.Parse(r["BycleCount"].ToString()); } } string sql1 = "delete from RL_Bycle where RLBID=@RLBID"; //删除租赁点拥有的该自行车 SqlParameter[] param1 = new SqlParameter[] { new SqlParameter("@RLBID",m.RLBID), }; if (DBHelper.ExcuteCommand(sql1, param1)) { string sql2 = "update Bicycle set BycleCount=@BycleCount where BycleID=@BycleID";//修改总数量 SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@BycleID",bycleid), new SqlParameter("@BycleCount",count+byclecount), }; if(DBHelper.ExcuteCommand(sql2,param2)) { return true; } } else return false; } return false; } //方法们 public bool ReduceByclecount(M_Bicycle m) { string sql2 = "update Bicycle set BycleCount=@BycleCount where BycleID=@BycleID"; //减去相应的自行车数量 int byclecount = 0; byclecount = m.BycleCount - m.RentCount; SqlParameter[] param2 = new SqlParameter[] { new SqlParameter("@BycleCount",byclecount), new SqlParameter("@BycleID",m.BycleID), }; if (DBHelper.ExcuteCommand(sql2, param2)) { return true; } return false; } } }

一些公用方法

using System; using System.Collections.Generic; using System.Linq; using System.Web; using WBDYW.WBDYW_Models; using System.Web.UI; using System.Web.UI.WebControls; namespace WBDYW { public class Methods { public TableRow NewRows(string t1, string t2, string t3, string t4, string t5, string t6,string t7,Control control, int judge,int count) //给tabel新生成一行 { TableRow r = new TableRow(); TableCell c1 = new TableCell(); TableCell c2 = new TableCell(); TableCell c3 = new TableCell(); TableCell c4 = new TableCell(); TableCell c5 = new TableCell(); TableCell c6 = new TableCell(); TableCell c7 = new TableCell(); c1.Text = t1; c2.Text = t2; c3.Text = t3; c4.Text = t4; c5.Text = t5; c6.Text = t6; c7.Text = t7; if (judge == 1) { c6.Controls.Add(control); } List<TableCell> list = new List<TableCell>(); list.Add(c1); list.Add(c2); list.Add(c3); list.Add(c4); list.Add(c5); list.Add(c6); list.Add(c7); int thecount=0; foreach (TableCell tc in list) { if (thecount == count) { if (judge == 1) { tc.Controls.Add(control); r.Cells.Add(tc); }else r.Cells.Add(tc); break; } r.Cells.Add(tc); thecount++; } return r; } public M_DateTime Renttime(string rtim) //时间的提取 { int times = 0; int date = 0; int hour = 0; int min = 0; M_DateTime mdt = new M_DateTime(); for (int i = 0; i < rtim.Length; i++) { if (rtim[i].ToString() == "+") { times+=1; } else { if (times == 0) { date *= 10; date += int.Parse(rtim[i].ToString()); } if (times == 1) { hour *= 10; hour += int.Parse(rtim[i].ToString()); } if (times == 2) { min *= 10; min += int.Parse(rtim[i].ToString()); } } } mdt.date = date; mdt.hour = hour; mdt.min = min; return mdt; } public string Alrd_rtime(M_DateTime mdt1,M_DateTime mdt2,out M_DateTime mdt3) //计算已租时长(mdt1是当前时间) { string time = ""; int day=0; int hour=0; int min=0; if (mdt1.date > mdt2.date) { if (mdt1.min < mdt2.min) { mdt1.hour -= 1; min = mdt1.min + (60 - mdt2.min); } else { min = mdt1.min - mdt2.min; } if (mdt1.hour < mdt2.hour) { mdt1.date -= 1; hour = mdt1.hour + (24 - mdt2.hour); } else { hour = mdt1.hour - mdt2.hour; } day = mdt1.date - mdt2.date; } else { if (mdt1.min < mdt2.min) { mdt1.hour -= 1; min = mdt1.min + (60 - mdt2.min); } else { min = mdt1.min - mdt2.min; } hour = mdt1.hour - mdt2.hour; } time = day + "天" +hour+"时"+min+"分"; mdt3 = new M_DateTime(); //得到单独的时长数据(用来算费用) mdt3.date = day; mdt3.hour = hour; mdt3.min = min; return time; //得到一个表示出时长的字符串 } } }