public CResult <WebMaintainItem> GetMaintainItemByID(string maintainItemID) { LogHelper.Info(MethodBase.GetCurrentMethod().ToString()); LogHelper.Info("maintainItemID", maintainItemID); if (string.IsNullOrEmpty(maintainItemID)) { return(new CResult <WebMaintainItem>(null, ErrorCode.ParameterError)); } using (var context = new DeviceMgmtEntities()) { var entity = context.MaintainItem.FirstOrDefault(t => t.ID == maintainItemID && t.IsValid); if (entity == null) { return(new CResult <WebMaintainItem>(null, ErrorCode.DataNoExist)); } var model = new WebMaintainItem() { ID = entity.ID, Note = entity.Note, Name = entity.Name, CreateDate = entity.CreateDate, CreateUserID = entity.CreateUserID, CreateUserName = entity.User.Name, ProjectID = entity.ProjectID, }; LogHelper.Info("result", model); return(new CResult <WebMaintainItem>(model)); } }
public CResult <bool> UpdateMaintainItem(WebMaintainItem 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.MaintainItem.FirstOrDefault(t => t.ID == model.ID && t.IsValid); if (entity == null) { return(new CResult <bool>(false, ErrorCode.DataNoExist)); } if (context.MaintainItem.Any(t => t.Name.ToUpper() == model.Name.ToUpper() && t.ProjectID == entity.ProjectID && t.IsValid && t.ID != model.ID)) { return(new CResult <bool>(false, ErrorCode.MaintainItemExist)); } entity.Name = model.Name; entity.Note = model.Note; context.Entry(entity).State = EntityState.Modified; return(context.Save()); } }
public ActionResult Edit(WebMaintainItem webMaintainItem) { try { var result = new MaintainItemBLL().UpdateMaintainItem(webMaintainItem); return(JsonContentHelper.GetJsonContent(result)); } catch { return(View()); } }
public ActionResult Create(WebMaintainItem webMaintainItem) { try { webMaintainItem.ProjectID = this.GetCurrentProjectID(); webMaintainItem.CreateUserID = this.GetCurrentUserID(); webMaintainItem.ProjectID = this.GetCurrentProjectID(); var result = new MaintainItemBLL().InsertMaintainItem(webMaintainItem); return(JsonContentHelper.GetJsonContent(result)); } catch { return(View()); } }
public CResult <bool> InsertMaintainItem(WebMaintainItem model) { LogHelper.Info(MethodBase.GetCurrentMethod().ToString()); LogHelper.Info("model", model); if (string.IsNullOrEmpty(model.ProjectID)) { return(new CResult <bool>(false, ErrorCode.ParameterError)); } using (var context = new DeviceMgmtEntities()) { if (context.Project.Any(t => t.IsValid && t.ID == model.ProjectID) == false) { return(new CResult <bool>(false, ErrorCode.ProjectNotExist)); } if (context.MaintainItem.Any(t => t.Name.ToUpper() == model.Name.ToUpper() && t.ProjectID == model.ProjectID && t.IsValid)) { return(new CResult <bool>(false, ErrorCode.MaintainItemExist)); } var entity = new MaintainItem(); entity.CreateDate = DateTime.Now; entity.CreateUserID = model.CreateUserID; entity.ID = Guid.NewGuid().ToString(); entity.Name = model.Name; entity.IsValid = true; entity.Note = model.Note; entity.ProjectID = model.ProjectID; context.MaintainItem.Add(entity); return(context.Save()); } }
public CResult <bool> ImportMaintainItemFromExcel(HttpPostedFileBase file, string projectID, string operatorUserID) { LogHelper.Info(MethodBase.GetCurrentMethod().ToString()); if (string.IsNullOrEmpty(projectID) || string.IsNullOrEmpty(operatorUserID)) { return(new CResult <bool>(false, ErrorCode.ParameterError)); } var fileName = string.Format("{0}{1}", Guid.NewGuid().ToString(), Path.GetExtension(file.FileName)); var filePath = FileHelper.SaveFile(file, SystemInfo.TempFileFolder, fileName); if (string.IsNullOrEmpty(filePath)) { return(new CResult <bool>(false, ErrorCode.SystemError)); } var dataTable = ExcelHelper.ExcelToDataTable(filePath, 0); if (dataTable.Rows.Count == 0) { return(new CResult <bool>(false, ErrorCode.FileContainNoData)); } var WebMaintainItemList = new List <WebMaintainItem>(); foreach (DataRow row in dataTable.Rows) { int i = 0; var WebMaintainItem = new WebMaintainItem(); WebMaintainItem.Name = row[i++].ToString(); WebMaintainItem.Note = row[i++].ToString(); WebMaintainItemList.Add(WebMaintainItem); } var nameList = WebMaintainItemList.Select(t => t.Name).Distinct().ToList(); if (nameList.Count < WebMaintainItemList.Count) { return(new CResult <bool>(false, ErrorCode.MaintainItemExist)); } using (var context = new DeviceMgmtEntities()) { if (context.Project.Any(t => t.IsValid && t.ID == projectID) == false) { return(new CResult <bool>(false, ErrorCode.ProjectNotExist)); } if (context.User.Any(t => t.IsValid && t.UserID == operatorUserID) == false) { return(new CResult <bool>(false, ErrorCode.UserNotExist)); } if (context.MaintainItem.Any(t => t.ProjectID == projectID && t.IsValid && nameList.Contains(t.Name))) { return(new CResult <bool>(false, ErrorCode.MaintainItemExist)); } var currentTime = DateTime.Now; foreach (var WebMaintainItem in WebMaintainItemList) { var item = new MaintainItem() { CreateDate = currentTime, CreateUserID = operatorUserID, ID = Guid.NewGuid().ToString(), IsValid = true, Name = WebMaintainItem.Name, Note = WebMaintainItem.Note, ProjectID = projectID, }; context.MaintainItem.Add(item); } LogHelper.Info("importList", WebMaintainItemList); return(context.Save()); } }