/// <summary> /// 修改学生邮箱 /// </summary> /// <param name="username"></param> /// <param name="newemail"></param> /// <returns></returns> public bool ChangeEmail(string username, string newemail) { Help h = new Help(); bool flags = false; //正则表达匹配用户名,学号true bool flag = h.IsStudentId(username); Student s = new Student(); using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (!flag) { s = context.Student.FirstOrDefault(x => x.Sid == username); if (s != null) { s.Semail = newemail; context.Student.Update(s); context.SaveChanges(); transaction.Commit(); flags = true; } //修改对应邮箱,返回true } else { s = context.Student.FirstOrDefault(x => x.Semail == username); if (s != null) { s.Semail = newemail; context.Student.Update(s); context.SaveChanges(); transaction.Commit(); flags = true; } //修改邮箱,返回false } } catch (Exception e) { transaction.Rollback(); return(false); } return(flags); } } }
/// <summary> /// 修改学生的积分 /// </summary> /// <param name="a">目标值</param> public bool ResetGlory(int a) { //将所有学生的积分值都修改为a List <Student> student = new List <Student>(); using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { student = (from s in context.Student select s ).ToList(); for (int i = 0; i < student.LongCount(); i++) { student[i].Svalue = a; context.Student.Update(student[i]); } context.SaveChanges(); transaction.Commit(); } catch (Exception) { transaction.Rollback(); return(false); } } } return(true); }
/// <summary> /// 向管理员表中写入该管理员的新密码 /// </summary> /// <param name="username">管理员名</param> /// <param name="newpassword">新密码</param> public bool ChangePassword(string userId, string newpassword) { //直接写密码(管理员表) bool flag = false; using (var dbContext = new LSSDataContext()) { Administor adminstor = new Administor(); //修改数据库信息最好有一些事务操作 using (var transaction = dbContext.Database.BeginTransaction()) { try { adminstor = dbContext.Administor.Where(x => x.Aid == userId).FirstOrDefault(); if (adminstor != null) { adminstor.Apassword = newpassword; dbContext.Administor.Update(adminstor); dbContext.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } } return(flag); } }
public bool deleteSb(string sid) { bool flag = false; using (var dbContext = new LSSDataContext()) { //修改数据库信息最好有一些事务操作 using (var transaction = dbContext.Database.BeginTransaction()) { try { var student = dbContext.Student.Where(x => x.Sid == sid).ToList().First(); dbContext.Student.Remove(student); dbContext.SaveChanges(); transaction.Commit(); flag = true; } catch (Exception e) { Console.WriteLine(e.Message); transaction.Rollback(); } return(flag); } } }
/// <summary> /// 添加图书馆 /// </summary> /// <param name="library">图书馆对象</param> public bool AddLibrary(Library library) { bool flag = false; using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { context.Add(library); context.SaveChanges(); transaction.Commit(); flag = true; } catch (Exception) { transaction.Rollback(); return(false); } return(false); } } //将除id之外的字段添加进图书馆表中 }
/// <summary> /// 修改该图书馆的起始楼层和结束楼层 /// </summary> /// <param name="libraryname">图书馆名称</param> /// <param name="startfloor">起始楼层</param> /// <param name="endfloor">结束楼层</param> public bool AddFloor(string libraryname, int startfloor, int endfloor) { //修改该图书馆的起始楼层和结束楼层 Library library = new Library(); bool flag = false; using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { library = context.Library.FirstOrDefault(x => x.Lname == libraryname); if (library != null) { library.Lsfloor = startfloor; library.Lefloor = endfloor; context.Library.Update(library); context.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } return(flag); } } }
public bool UpdataStudentFen(string sid) { using (var dbContext = new LSSDataContext()) { bool flag = false; //修改数据库信息最好有一些事务操作 using (var transaction = dbContext.Database.BeginTransaction()) { try { var sql = @"Update Student SET Svalue = {0} WHERE Sid = {1}"; dbContext.Database.ExecuteSqlCommand(sql, 2, sid); dbContext.SaveChanges(); transaction.Commit(); flag = true; } catch (Exception e) { Console.WriteLine(e.Message); transaction.Rollback(); } return(flag); } } }
/// <summary> /// 修改该学生的积分 /// </summary> /// <param name="studentid">学生id</param> public bool AddGlory(string studentid) { //给该学生的信誉积分加1 Student student = new Student(); bool flag = false; using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { student = context.Student.FirstOrDefault(x => x.Sid == studentid); if (student != null) { student.Svalue += student.Svalue; context.Student.Update(student); context.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } return(flag); } } }
public bool SetSeatState(string id, string operation) { bool flag = false; using (var dbContext = new LSSDataContext()) { Seat seat = new Seat(); //修改数据库信息最好有一些事务操作 using (var transaction = dbContext.Database.BeginTransaction()) { try { seat = dbContext.Seat.Where(x => x.Tid == id).FirstOrDefault(); if (seat != null) { seat.Tstate = operation; dbContext.Seat.Update(seat); dbContext.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } } return(flag); } }
public bool updateLibrary(int lid, string name) { bool flag = false; using (var dbContext = new LSSDataContext()) { //修改数据库信息最好有一些事务操作 using (var transaction = dbContext.Database.BeginTransaction()) { try { var library = dbContext.Library.Where(x => x.Lid == lid).ToList().First(); library.Lname = name; dbContext.Library.Update(library); dbContext.SaveChanges(); transaction.Commit(); flag = true; } catch (Exception e) { Console.WriteLine(e.Message); transaction.Rollback(); } return(flag); } } }
/// <summary> /// 根据ID直接改变订单状态 /// </summary> /// <param name="oid">订单ID</param> public bool ChangeOrderState(string oid, string operation) { //根据ID直接改变订单状态 bool flag = false; using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { var order = context.Order.Where(x => x.Oid == oid).FirstOrDefault(); if (order != null) { order.Ostate = operation; context.Order.Update(order); context.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } } } return(flag); }
/// <summary> /// 在订单表中插入一条记录 /// </summary> /// <param name="order"></param> public bool SetOrder(Order order) { //插入一条订单记录到订单表(id,学号,座位号,订单开始时间,结束时间,打卡时间,订单状态) //订单id(图书馆号+层号+座位号+系统时间) bool flag = false; using (var context = new LSSDataContext()) { context.Order.Add(order); context.SaveChanges(); flag = true; } return(flag); }
/// <summary> /// 修改个人的lock锁 /// </summary> /// <param name="operation">状态修改的目标值这里为char类型,只传一个字符就可以例如‘1’</param> /// <param name="date">日期</param> /// <param name="username">个人id</param> public bool ModifyInfor(char operation, int date, string username) { Student student = new Student(); bool flag = false; Help h = new Help(); using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { if (h.IsStudentId(username)) { student = context.Student.FirstOrDefault(x => x.Sid == username); } else { student = context.Student.FirstOrDefault(x => x.Semail == username); } if (student != null) { char[] old = { student.Slock.ElementAt(0), student.Slock.ElementAt(1) }; if (date == 0) { old[0] = operation; //修改第一天的状态 } else { old[1] = operation; //修改第二天的状态 } string str = new string(old); student.Slock = str; context.Update(student); context.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } return(flag); } } }
/// <summary> /// 修改学生得信誉积分,每次修改减1 /// </summary> /// <param name="sid">学生学号</param> /// <returns></returns> public bool DuctGlory(string sid) { bool flag = false; using (var dbContext = new LSSDataContext()) { Student student = new Student(); student = dbContext.Student.FirstOrDefault(x => x.Sid == sid); if (student != null) { student.Svalue = student.Svalue + 1; dbContext.Update(student); dbContext.SaveChanges(); flag = true; } } return(flag); }
/// <summary> /// 修改数据库中的对应密码 /// </summary> /// <param name="user"></param> /// <param name="password"></param> public bool ChangePassword(string user, string password) { //使用工具方法判断学号/邮箱IsStudentId() //修改对应密码 Student student = null; bool flag = false; Help h = new Help(); using (var dbContext = new LSSDataContext()) { //修改数据库信息最好有一些事务操作 using (var transaction = dbContext.Database.BeginTransaction()) { try {//学号 if (h.IsStudentId(user)) { student = dbContext.Student.Where(x => x.Sid == user).ToList().First(); } else { student = dbContext.Student.Where(x => x.Semail == user).ToList().First(); } if (student != null) { student.Spassword = password; dbContext.Student.Update(student); dbContext.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception e) { transaction.Rollback(); return(false); } return(flag); } } }
/// <summary> /// 修改座位状态 【operation 类型应该为string】 /// </summary> /// <param name="seatid">座位id</param> /// <param name="operation">目标值</param> public bool SeatInfor(string seatid, int operation) { //将座位所有时间的状态修改为operation Seat seat = new Seat(); bool flag = false; using (var context = new LSSDataContext()) { using (var transaction = context.Database.BeginTransaction()) { try { seat = context.Seat.FirstOrDefault(x => x.Tid == seatid); if (seat != null) { char[] a = new char[48]; for (int i = 0; i < 48; i++) { a[i] = char.Parse(operation.ToString()); } string str = new string(a); seat.Tstate = str; context.Seat.Update(seat); context.SaveChanges(); transaction.Commit(); flag = true; } } catch (Exception) { transaction.Rollback(); return(false); } return(flag); } } }
/// <summary> /// 修改座位状态 /// </summary> /// <param name="date">第几天</param> /// <param name="str">座位状态信息</param> /// <param name="seatid">座位id</param> /// <param name="num">处理后需要修改的状态的开始坐标</param> /// <param name="duration">时长</param> /// <param name="operation">目标值</param> public bool SeatInfor(int date, string seatid, int num, int duration, char operation) { Seat seat = new Seat(); bool flag = false; using (var context = new LSSDataContext()) { seat = context.Seat.FirstOrDefault(x => x.Tid == seatid); if (seat != null) { char[] c = new char[48]; c = seat.Tstate.ToCharArray(); if (date == 1) { for (int i = 23 + num; i < 23 + num + duration; i++) { c[i] = operation; } } else { for (int i = num; i < num + duration; i++) { c[i] = operation; } } string s = new string(c); seat.Tstate = s; context.Seat.Update(seat); context.SaveChanges(); flag = true; } } return(flag); //将字符串修改之后直接插入座位表 }