public int ReportForRepair(string DormNum, string goods, string why, DateTime date)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Repair repair = new Repair();
repair.DormNum = DormNum;
repair.CommitDate = date;
repair.Goods = goods;
db.Repair.Add(repair);
db.SaveChanges();
dbContextTransaction.Commit();
return(1);//添加成功
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int DeleteStudent(string Id)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Student dbstudent = db.Student.Find(Id);
if (dbstudent != null)
{
Dorm dorm = db.Dorm.Find(dbstudent.DormNum);
dorm.UsedNum--;
dorm.AllowNum++;
db.Student.Remove(dbstudent);
db.SaveChanges();
return(1); //完成
}
return(0); //用户不存在
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int ChangeDorm(string StudentId, string newDormNum, string why)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Student student = db.Student.Find(StudentId);
ChangeDorm dorm = new ChangeDorm();
if (db.Dorm.Find(newDormNum).UsedNum != 0)
{
dorm.OldDormNum = student.DormNum;
dorm.StudentId = StudentId;
dorm.Begindate = DateTime.Now;
dorm.Why = why;
dorm.NewDormNum = newDormNum;
db.SaveChanges();
dbContextTransaction.Commit();
return(1); //申请成功
}
return(0); //当前寝室床位不足，请更换寝室
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int DealRepair(int Id, decimal money, string ReasonsForUncompletion)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Repair repair = db.Repair.Find(Id);
if (repair != null && repair.ResolutionDate == null)
{
repair.ResolutionDate = DateTime.Now;
repair.Money = money;
repair.ReasonsForUncompletion = ReasonsForUncompletion;
return(1); //维修完成
}
return(0); //该维修已处理
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int DeleteStaff(string Id)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Staff dbstaff = db.Staff.Find(Id);
if (dbstaff != null)
{
db.Staff.Remove(dbstaff);
db.SaveChanges();
return(1); //完成
}
return(0); //用户不存在
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int DeleteDorm(String Id)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Dorm dorm = db.Dorm.Find(Id);
if (dorm != null)
{
if (dorm.UsedNum == 0)
{
db.Dorm.Remove(dorm);
db.SaveChanges();
return(1);//完成
}
else
{
return(3);//寝室有学生使用，请更换学生寝室
}
}
return(0);//寝室号不存在
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int EditDorm(Dorm dorm)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Dorm dbdorm = db.Dorm.Find(dorm.DormNum);
if (dbdorm == null)
{
db.Dorm.Add(dorm);
db.SaveChanges();
dbContextTransaction.Commit();
return(1);//寝室不存在 新增
}
else
{
dbdorm.DormNum = dorm.DormNum;
dbdorm.AllowNum = dorm.AllowNum;
dbdorm.LouNum = dorm.LouNum;
dbdorm.UsedNum = dorm.UsedNum;
db.SaveChanges();
dbContextTransaction.Commit();
return(0);//寝室号已存在，修改
}
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int DealChangeDorm(int Id, bool flag, string why)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
ChangeDorm changeDorm = db.ChangeDorm.Find(Id);
if (changeDorm.AdminOpinion != null)
{
return(0); //管理员已处理，无需处理
}
changeDorm.AgreeDate = DateTime.Now;
changeDorm.AdminOpinion = flag;
changeDorm.Why = why;
return(1);//处理完成
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int EditStaff(Staff staff)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Staff dbstaff = db.Staff.Find(staff.Code);
if (dbstaff == null)
{
db.Staff.Add(staff);
db.SaveChanges();
dbContextTransaction.Commit();
return(1);//用户不存在 添加
}
else
{
dbstaff.Name = staff.Name;
dbstaff.Birth = staff.Birth;
dbstaff.Managenment = staff.Managenment;
dbstaff.Password = staff.Password;
dbstaff.Phone = staff.Phone;
dbstaff.Position = staff.Position;
dbstaff.Sex = staff.Sex;
db.SaveChanges();
dbContextTransaction.Commit();
return(0);//用户已存在 修改
}
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}
public int EditStudent(Student student)
{
using (var db = new SDMSEntities())
{
using (var dbContextTransaction = db.Database.BeginTransaction())
{
try
{
Student dbstudent = db.Student.Find(student.Code);
if (dbstudent == null)
{
db.Student.Add(student);
db.SaveChanges();
dbContextTransaction.Commit();
return(1);//用户不存在 新增成功
}
else
{
dbstudent.Class = student.Class;
dbstudent.DormNum = student.DormNum;
dbstudent.Name = student.Name;
dbstudent.Password = student.Password;
dbstudent.Phone = student.Phone;
dbstudent.Sex = student.Sex;
db.SaveChanges();
dbContextTransaction.Commit();
return(0);//学生以存在，修改
}
}
catch (Exception)
{
dbContextTransaction.Rollback();
return(2);//数据库添加异常
}
}
}
}