public CResult <bool> UpdateCompayLogo(HttpPostedFileBase file, string orderClientID)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("orderClientID", orderClientID);
using (var context = new DeviceMgmtEntities())
{
var date = DateTime.Now.ToString("yyyy-MM-dd");
var fileName = string.Format("{0}{1}", Guid.NewGuid().ToString(), Path.GetExtension(file.FileName));
var filePath = FileHelper.SaveFile(file, Path.Combine(SystemInfo.UploadFolder, date), fileName);
if (string.IsNullOrEmpty(filePath) == false)
{
var orderClient = context.OrderClient.FirstOrDefault(t => t.IsValid && t.ID == orderClientID);
if (string.IsNullOrEmpty(orderClient.LogoFile) == false)
{
FileHelper.DelFile(orderClient.LogoFile);
}
orderClient.LogoFile = filePath;
}
else
{
return(new CResult <bool>(false, ErrorCode.SaveFileFailed));
}
if (context.SaveChanges() > 0)
{
return(new CResult <bool>(true));
}
else
{
FileHelper.DelFile(filePath);
}
return(new CResult <bool>(true));
}
}
public CResult <string> InsertMaintainRecord(WebMaintainRecord model)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ProjectID))
{
return(new CResult <string>("", ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
if (context.Project.Any(t => t.IsValid && t.ID == model.ProjectID) == false)
{
return(new CResult <string>("", ErrorCode.ProjectNotExist));
}
if (context.Device.Any(t => t.ID == model.DeviceID) == false)
{
return(new CResult <string>("", ErrorCode.DeviceNotExist));
}
var entity = new MaintainRecord();
entity.CreateDate = DateTime.Now;
entity.CreateUserID = model.CreateUserID;
entity.ID = Guid.NewGuid().ToString();
entity.MaintainDate = model.MaintainDate;
entity.IsValid = true;
entity.Note = model.Note;
entity.ProjectID = model.ProjectID;
entity.Operator = model.Operator;
entity.DeviceID = model.DeviceID;
context.MaintainRecord.Add(entity);
foreach (var item in model.MaintainItems)
{
var relation = new MaintainRecordMaintainItemRel()
{
MaintainRecordID = entity.ID,
MaintainItemID = item.ID
};
context.MaintainRecordMaintainItemRel.Add(relation);
}
if (context.SaveChanges() > 0)
{
return(new CResult <string>(entity.ID));
}
else
{
return(new CResult <string>("", ErrorCode.SaveDbChangesFailed));
}
}
}
//public CResult<List<WebRepairRecord>> GetRepairRecordListByDeviceID(string deviceID, out int totalCount, string searchInfo, int pageIndex = 1, int pageSize = 10, string orderby = null, bool ascending = false)
//{
// LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
// LogHelper.Info("deviceID", deviceID);
// using (DeviceMgmtEntities context = new DeviceMgmtEntities())
// {
// Expression<Func<RepairRecord, bool>> filter = t => t.DeviceID == deviceID && t.IsValid == true;
// if (string.IsNullOrWhiteSpace(searchInfo) == false)
// {
// searchInfo = searchInfo.Trim().ToUpper();
// filter = filter.And(t => t.Note.ToUpper().Contains(searchInfo));
// }
// var temp = context.RepairRecord.Where(filter).Page(out totalCount, pageIndex, pageSize, orderby, ascending, true);
// var result = temp.Select(t => new WebRepairRecord()
// {
// ID = t.ID,
// Note = t.Note,
// DeviceID = t.DeviceID,
// DeviceName = t.Device.Name,
// Operator = t.Operator,
// RepairDate = t.RepairDate,
// CreateDate = t.CreateDate,
// CreateUserID = t.CreateUserID,
// CreateUserName = t.User.Name,
// ProjectID = t.ProjectID
// }).ToList();
// LogHelper.Info("result", result);
// return new CResult<List<WebRepairRecord>>(result);
// }
//}
public CResult <string> InsertRepairRecord(WebRepairRecord model)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("model", model);
if (string.IsNullOrEmpty(model.ProjectID))
{
return(new CResult <string>(string.Empty, ErrorCode.ParameterError));
}
using (var context = new DeviceMgmtEntities())
{
if (context.Project.Any(t => t.IsValid && t.ID == model.ProjectID) == false)
{
return(new CResult <string>(string.Empty, ErrorCode.ProjectNotExist));
}
if (context.Device.Any(t => t.ID == model.DeviceID) == false)
{
return(new CResult <string>(string.Empty, ErrorCode.DeviceNotExist));
}
var entity = new RepairRecord();
entity.CreateDate = DateTime.Now;
entity.CreateUserID = model.CreateUserID;
entity.ID = Guid.NewGuid().ToString();
entity.RepairDate = model.RepairDate;
entity.IsValid = true;
entity.Note = model.Note;
entity.ProjectID = model.ProjectID;
entity.Operator = model.Operator;
entity.DeviceID = model.DeviceID;
entity.Solution = model.Solution;
entity.Describe = model.Describe;
context.RepairRecord.Add(entity);
if (context.SaveChanges() > 0)
{
return(new CResult <string>(entity.ID));
}
else
{
return(new CResult <string>("", ErrorCode.SaveDbChangesFailed));
}
}
}
public void InitDB()
{
Membership.DeleteUser("SuperAdmin");
using (var context = new DeviceMgmtEntities())
{
foreach (var item in Enum.GetNames(typeof(RoleType)))
{
if (Roles.RoleExists(item) == false)
{
Roles.CreateRole(item);
}
}
User superAdmin;
if (Membership.FindUsersByName("SuperAdmin").Count == 0)
{
var member = Membership.CreateUser("SuperAdmin", "111111");
Roles.AddUserToRole("SuperAdmin", RoleType.超级管理员.ToString());
superAdmin = new User()
{
Address = "",
CreateDate = DateTime.Now,
CreateUserID = "",
Email = "",
IsValid = true,
LoginName = "SuperAdmin",
ProjectID = "",
UserID = member.ProviderUserKey.ToString(),
Name = "SuperAdmin",
Telephone = "",
Moblie = ""
};
context.User.Add(superAdmin);
}
else
{
superAdmin = context.User.FirstOrDefault(t => t.LoginName == "SuperAdmin");
}
context.SaveChanges();
}
}
public bool CreateDevice(DeviceModel deviceModel)
{
using (var ctx = new DeviceMgmtEntities())
{
var device = new Device()
{
UserAccount_ID = userId,
Description = deviceModel.DeviceDescription,
DeviceSerialNr = deviceModel.DeviceSerialNumber,
DeviceType = deviceModel.DeviceType,
Name = deviceModel.DeviceName
};
ctx.Devices.Add(device);
if (0 < ctx.SaveChanges())
{
return(true);
}
return(false);
}
}
public CResult <bool> AddRepairRecordFile(HttpPostedFileBase file, string repairRecordID)
{
LogHelper.Info(MethodBase.GetCurrentMethod().ToString());
LogHelper.Info("repairRecordID", repairRecordID);
using (var context = new DeviceMgmtEntities())
{
var date = DateTime.Now.ToString("yyyy-MM-dd");
var fileName = string.Format("{0}{1}", Guid.NewGuid().ToString(), Path.GetExtension(file.FileName));
var filePath = FileHelper.SaveFile(file, Path.Combine(SystemInfo.UploadFolder, date), fileName);
if (string.IsNullOrEmpty(filePath) == false)
{
var fileMode = new Attachment()
{
DisplayName = file.FileName,
FilePath = filePath,
ID = Guid.NewGuid().ToString(),
Note = "",
RelationID = repairRecordID,
};
context.Attachment.Add(fileMode);
}
else
{
return(new CResult <bool>(false, ErrorCode.SaveFileFailed));
}
if (context.SaveChanges() > 0)
{
return(new CResult <bool>(true));
}
else
{
FileHelper.DelFile(filePath);
}
return(new CResult <bool>(true));
}
}
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));
}
}
}