public static void CreateNewEqRequest(NewEqRequestModel model)
{
using (var context = new BEMSContext())
{
model.ID = "NEWEQ_" + DateTime.Now.ToString("yyyyMMddHHmmss");
context.FlowNewEqRequests.Add(new EF.DBModels.FlowNewEqRequest()
{
ID = model.ID,
Amount = model.Amount,
EModel = model.EModel,
EType = model.EType,
Memo = model.Memo,
Requester = model.Requester,
RequestTime = model.RequestTime,
IsComplete = model.IsComplete
});
context.FlowProgress.Add(new EF.DBModels.FlowProgress
{
FlowType = "NEWEQ",
Assignee = model.Assignee,
AssignTime = model.RequestTime,
Comments = string.Empty,
CurrentFlowStep = model.CurrentFlowIndex.Value,
TicketID = model.ID,
LastUpdateBy = model.Requester,
LastUpdateTime = model.RequestTime
});
context.SaveChanges();
}
}
public static UserModel CheckLogin(string accountName, string Pwd)
{
using (var context = new BEMSContext())
{
var user = context.Users.SingleOrDefault(a => a.AccountName.Equals(accountName) && a.Password.Equals(Pwd));
if (user != null)
{
return(new UserModel()
{
AccountName = user.AccountName,
Address = user.Address,
CreateBy = user.CreateBy,
CreateTime = user.CreateTime,
DisplayName = user.DisplayName,
ID = user.ID,
LastModifyBy = user.LastModifyBy,
LastModifyTime = user.LastModifyTime,
Memo = user.Memo,
Phone = user.Phone,
State = user.State
});
}
else
{
throw new Exception("用户名或密码错误！");
}
}
}
public static void CreateUser(UserModel userData)
{
using (var context = new BEMSContext())
{
var user = context.Users.SingleOrDefault(a => a.AccountName.Equals(userData.AccountName));
if (user != null)
{
throw new ArgumentException("账号已存在");
}
context.Users.Add(new Users()
{
AccountName = userData.AccountName,
Address = userData.Address,
CreateBy = userData.CreateBy,
CreateTime = userData.CreateTime,
DisplayName = userData.DisplayName,
LastModifyBy = userData.LastModifyBy,
LastModifyTime = userData.LastModifyTime,
Memo = userData.Memo,
Password = userData.Password,
Phone = userData.Phone,
State = userData.State
});
context.SaveChanges();
}
}
public static List <Users> GetAllUsers()
{
using (var context = new BEMSContext())
{
var list = context.Users.ToList();
return(list);
}
}
public static void UpdateUser(UserModel userData)
{
using (var context = new BEMSContext())
{
var user = context.Users.SingleOrDefault(a => a.ID == userData.ID);
if (user != null)
{
user.Address = userData.Address;
user.DisplayName = userData.DisplayName;
user.LastModifyBy = userData.LastModifyBy;
user.LastModifyTime = userData.LastModifyTime;
user.Memo = userData.Memo;
user.Phone = userData.Phone;
}
else
{
throw new NullReferenceException("用户不存在！");
}
context.SaveChanges();
}
}