public CResult <bool> UpdateManufacturer(WebManufacturer model)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ID))
{
return(new CResult <bool>(false, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
var entity = context.Manufacturer.FirstOrDefault(t => t.ID == model.ID && t.IsValid);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.ManufacturerNotExist));
}
if (context.Manufacturer.Any(t => t.Name.ToUpper() == model.Name.ToUpper() && t.ProjectID == entity.ProjectID && t.IsValid && t.ID != model.ID))
{
return(new CResult <bool>(false, ErrorCode.ManufacturerNameIsExist));
}
entity.Name = model.Name;
entity.Note = model.Note;
entity.Address = model.Address;
entity.Contact = model.Contact;
entity.Mobile = model.Mobile;
entity.Phone = model.Phone;
context.Entry(entity).State = EntityState.Modified;
return(context.Save());
}
}
public CResult <bool> UpdateUser(WebUser webUser)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("webUser", webUser);
using (var context = new DeviceMgmtEntities())
{
var entity = context.User.FirstOrDefault(t => t.UserID == webUser.ID);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
entity.Address = webUser.Address;
entity.Email = webUser.Email;
entity.Name = webUser.UserName;
entity.Telephone = webUser.TelPhone;
entity.Moblie = webUser.Moblie;
entity.Role = (int)webUser.Role;
context.Entry(entity).State = EntityState.Modified;
LoggerBLL.AddLog(context, webUser.CreateUserID, entity.ProjectID, OperatTypeEnum.修改, _businessModel, "用户名：" + entity.LoginName);
return(context.Save());
}
}
public CResult <bool> UpdateCompanyInfo(WebOrderClient companyInfo)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("companyInfo", companyInfo);
using (var context = new DeviceMgmtEntities())
{
var entity = context.OrderClient.FirstOrDefault(t => t.ID == companyInfo.ID);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
entity.CompanyContact = companyInfo.CompanyContact;
entity.CompanyDescribe = companyInfo.CompanyDescribe;
entity.CompanyName = companyInfo.CompanyName;
context.Entry(entity).State = EntityState.Modified;
return(context.Save());
}
}
public CResult <bool> UpdateOrderClientInfo(WebOrderClient webOrderClient)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("webOrderClient", webOrderClient);
using (var context = new DeviceMgmtEntities())
{
var entity = context.OrderClient.FirstOrDefault(t => t.ID == webOrderClient.ID);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
var name = webOrderClient.Name.ToUpper();
if (context.OrderClient.Any(t => t.OrderClientName.ToUpper() == name && t.IsValid && t.ID != webOrderClient.ID))
{
return(new CResult <bool>(false, ErrorCode.OrderClientNameIsExist));
}
entity.OrderClientName = webOrderClient.Name;
entity.Note = webOrderClient.Note;
var user = context.User.FirstOrDefault(t => t.Role == (int)RoleType.客户管理员 && t.OrderClientID == webOrderClient.ID);
if (user == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
var webUser = webOrderClient.WebUser;
user.Address = webUser.Address;
user.Email = webUser.Email;
user.Name = webUser.UserName;
user.Telephone = webUser.TelPhone;
user.Moblie = webUser.Moblie;
context.Entry(entity).State = EntityState.Modified;
return(context.Save());
}
}
public CResult <bool> UpdateRepairRecord(WebRepairRecord model, List <string> deleteFiles)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ID))
{
return(new CResult <bool>(false, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
var entity = context.RepairRecord.FirstOrDefault(t => t.ID == model.ID && t.IsValid);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
entity.Note = model.Note;
entity.Operator = model.Operator;
entity.RepairDate = model.RepairDate;
entity.Solution = model.Solution;
entity.Describe = model.Describe;
context.Entry(entity).State = EntityState.Modified;
if (deleteFiles != null && deleteFiles.Count() > 0)
{
var needDelete = context.Attachment.Where(t => deleteFiles.Contains(t.ID)).ToList();
foreach (var item in needDelete)
{
context.Attachment.Remove(item);
FileHelper.DelFile(item.FilePath);
}
}
return(context.Save());
}
}
public CResult <bool> UpdateProjectInfo(WebProject webProject)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("webProject", webProject);
using (var context = new DeviceMgmtEntities())
{
var project = context.Project.FirstOrDefault(t => t.ID == webProject.ID);
if (project == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
if (context.Project.Any(t => t.CreateUserID == project.CreateUserID && t.Name.ToUpper() == webProject.Name.ToUpper() && t.IsValid && t.ID != webProject.ID))
{
return(new CResult <bool>(false, ErrorCode.ProjectNameIsExist));
}
project.Name = webProject.Name;
project.Note = webProject.Note;
var user = context.User.FirstOrDefault(t => t.Role == (int)RoleType.项目管理员 && t.ProjectID == webProject.ID);
if (user == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
var webUser = webProject.WebUser;
user.Address = webUser.Address;
user.Email = webUser.Email;
user.Name = webUser.UserName;
user.Telephone = webUser.TelPhone;
user.Moblie = webUser.Moblie;
context.Entry(project).State = EntityState.Modified;
return(context.Save());
}
}
public CResult <bool> UpdateDevice(WebDevice model)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ID))
{
return(new CResult <bool>(false, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
var entity = context.Device.FirstOrDefault(t => t.ID == model.ID && t.IsValid);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.DataNoExist));
}
if (context.Device.Any(t => t.Num.ToUpper() == model.Num.ToUpper() && t.ProjectID == entity.ProjectID && t.IsValid && t.ID != model.ID))
{
return(new CResult <bool>(false, ErrorCode.DeviceNumIsExist));
}
entity.Num = model.Num;
entity.Name = model.Name;
entity.Note = model.Note;
entity.ProductDate = model.ProductDate;
entity.MaintainDate = model.MaintainDate;
entity.DeviceState = (int)model.DeviceState;
entity.DeviceTypeID = model.DeviceTypeID;
entity.ManufacturerID = model.ManufacturerID;
entity.SupplierID = model.SupplierID;
context.Entry(entity).State = EntityState.Modified;
return(context.Save());
}
}
public CResult <bool> ResetPassword(string newPassword, string userID, string operatorUserID)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
if (string.IsNullOrWhiteSpace(newPassword) || string.IsNullOrWhiteSpace(userID))
{
return(new CResult <bool>(false, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
var entity = context.User.FirstOrDefault(t => t.UserID == userID && t.IsValid);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.UserNotExist));
}
entity.Password = newPassword;
context.Entry(entity).State = EntityState.Modified;
// LoggerBLL.AddLog(context, operatorUserID, entity.ProjectID, OperatTypeEnum.修改, _businessModel, "用户名：" + userID);
return(context.Save());
}
}
public CResult <bool> UpdateDeviceType(WebDeviceType model)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ID))
{
return(new CResult <bool>(false, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
var entity = context.DeviceType.FirstOrDefault(t => t.ID == model.ID && t.IsValid);
if (entity == null)
{
return(new CResult <bool>(false, ErrorCode.DeviceTypeNotExist));
}
if (context.DeviceType.Any(t => t.Name.ToUpper() == model.Name.ToUpper() && t.ProjectID == entity.ProjectID && t.IsValid && t.ID != model.ID))
{
return(new CResult <bool>(false, ErrorCode.DeviceTypeNameIsExist));
}
entity.Name = model.Name;
entity.Note = model.Note;
var maintainItemIDs = model.MaintainItems.Select(t => t.ID).ToList();
if (maintainItemIDs.Count > 0)
{
if (context.MaintainItem.Count(t => maintainItemIDs.Contains(t.ID) && t.IsValid && t.ProjectID == model.ProjectID) < maintainItemIDs.Count)
{
return(new CResult <bool>(false, ErrorCode.MaintainItemNotExist));
}
}
var oldRelations = context.DeviceTypeMaintainItemRel.Where(t => t.DeviceTypeID == entity.ID);
var oldRelationItemIDs = oldRelations.Select(t => t.MaintainItemID);
var newRelationItemIDs = model.MaintainItems.Select(t => t.ID).ToList();
var needDeletes = oldRelations.Where(t => newRelationItemIDs.Contains(t.MaintainItemID) == false).ToList();
var needAdd = model.MaintainItems.Where(t => oldRelationItemIDs.Contains(t.ID) == false).ToList();
foreach (var item in needDeletes)
{
context.DeviceTypeMaintainItemRel.Remove(item);
}
foreach (var item in needAdd)
{
var relation = new DeviceTypeMaintainItemRel()
{
DeviceTypeID = entity.ID,
MaintainItemID = item.ID
};
context.DeviceTypeMaintainItemRel.Add(relation);
}
context.Entry(entity).State = EntityState.Modified;
return(context.Save());
}
}
public CResult <string> UpdateMaintainRecord(WebMaintainRecord model, List <string> deleteFiles)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
LogHelper.Info("deleteFiles", deleteFiles);
if (string.IsNullOrEmpty(model.ID))
{
return(new CResult <string>("", ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
var entity = context.MaintainRecord.FirstOrDefault(t => t.ID == model.ID && t.IsValid);
if (entity == null)
{
return(new CResult <string>("", ErrorCode.DataNoExist));
}
entity.Note = model.Note;
entity.Operator = model.Operator;
entity.MaintainDate = model.MaintainDate;
context.Entry(entity).State = EntityState.Modified;
if (deleteFiles != null && deleteFiles.Count() > 0)
{
var needDelete = context.Attachment.Where(t => deleteFiles.Contains(t.ID)).ToList();
foreach (var item in needDelete)
{
context.Attachment.Remove(item);
FileHelper.DelFile(item.FilePath);
}
}
var oldRelations = context.MaintainRecordMaintainItemRel.Where(t => t.MaintainRecordID == entity.ID);
var oldRelationItemIDs = oldRelations.Select(t => t.MaintainItemID);
var newRelationItemIDs = model.MaintainItems.Select(t => t.ID).ToList();
var needDeletes = oldRelations.Where(t => newRelationItemIDs.Contains(t.MaintainItemID) == false).ToList();
var needAdd = model.MaintainItems.Where(t => oldRelationItemIDs.Contains(t.ID) == false).ToList();
foreach (var item in needDeletes)
{
context.MaintainRecordMaintainItemRel.Remove(item);
}
foreach (var item in needAdd)
{
var relation = new MaintainRecordMaintainItemRel()
{
MaintainRecordID = entity.ID,
MaintainItemID = item.ID
};
context.MaintainRecordMaintainItemRel.Add(relation);
}
if (context.SaveChanges() > 0)
{
return(new CResult <string>(""));
}
else
{
return(new CResult <string>("", ErrorCode.SaveDbChangesFailed));
}
}
}