public ActionResult EditMaintainRecord(WebMaintainRecord webMaintainRecord, List <string> delIDList) { MaintainRecordBLL maintainRecordBLL = new MaintainRecordBLL(); var cResult = maintainRecordBLL.UpdateMaintainRecord(webMaintainRecord, delIDList); return(JsonContentHelper.GetJsonContent(cResult)); }
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 ActionResult AddMainTainRecord(WebMaintainRecord webMaintainRecord, List <string> delIDList) { MaintainRecordBLL maintainRecordBLL = new MaintainRecordBLL(); webMaintainRecord.CreateUserID = this.GetCurrentUserID(); webMaintainRecord.ProjectID = this.GetCurrentProjectID(); var cResult = maintainRecordBLL.InsertMaintainRecord(webMaintainRecord); return(JsonContentHelper.GetJsonContent(cResult)); }
public ActionResult AddMainTainRecord(string deviceID, string deviceName, string returnUrl) { int totalCount; var items = new MaintainItemBLL().GetMaintainItemListByDeviceID(deviceID); ViewBag.AllMaintainItems = items.Data; ViewBag.ReturnUrl = returnUrl; ViewBag.DeviceName = deviceName; ViewBag.DeviceID = deviceID; ViewBag.OperateAction = "Add"; ViewBag.IsAddRecord = "True"; ViewBag.LeftName = "设备信息"; WebMaintainRecord webMaintainRecord = new WebMaintainRecord(); webMaintainRecord.MaintainDate = DateTime.Now.Date; return(View("MaintainRecord/AddMainTainRecord", webMaintainRecord)); }
public CResult <WebMaintainRecord> GetMaintainRecordByID(string maintainRecordID) { LogHelper.Info(MethodBase.GetCurrentMethod().ToString()); LogHelper.Info("maintainRecordID", maintainRecordID); if (string.IsNullOrEmpty(maintainRecordID)) { return(new CResult <WebMaintainRecord>(null, ErrorCode.ParameterError)); } using (var context = new DeviceMgmtEntities()) { var entity = context.MaintainRecord.FirstOrDefault(t => t.ID == maintainRecordID && t.IsValid); if (entity == null) { return(new CResult <WebMaintainRecord>(null, ErrorCode.DataNoExist)); } var model = new WebMaintainRecord() { ID = entity.ID, Note = entity.Note, DeviceID = entity.DeviceID, DeviceName = entity.Device.Name, Operator = entity.Operator, MaintainDate = entity.MaintainDate, CreateDate = entity.CreateDate, CreateUserID = entity.CreateUserID, CreateUserName = entity.User.Name, ProjectID = entity.ProjectID }; var attachments = context.Attachment.Where(a => a.RelationID == entity.ID).ToList(); foreach (var attachment in attachments) { model.Attachments.Add(new WebAttachment() { DisplayName = attachment.DisplayName, FilePath = attachment.FilePath, ID = attachment.ID, Note = attachment.Note }); } var items = (from rel in context.MaintainRecordMaintainItemRel join item in context.MaintainItem on rel.MaintainItemID equals item.ID where rel.MaintainRecordID == entity.ID select new WebMaintainItem() { ID = item.ID, Name = item.Name }).ToList(); model.MaintainItems = items; LogHelper.Info("result", model); return(new CResult <WebMaintainRecord>(model)); } }
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)); } } }