public JsonResult DeleteMaterialCatalog(string key) { MaterialCatalogInfo info = new MaterialCatalogInfo(); if (!string.IsNullOrEmpty(key)) { info.Id = key; OperationResult opr = MaterialCatalogService.Remove(key); return Json(new JsonResultHelper(opr.Message)); } else { return Json(new JsonResultHelper(false, "选择的记录无效", "")); } }
public virtual OperationResult Create(MaterialCatalogInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { MaterialCatalog entity = new MaterialCatalog(); DESwap.MaterialCatalogDTE(info, entity); MaterialCatalogRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual List<MaterialCatalogInfo> ListAllByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection) { List<MaterialCatalog> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.MaterialCatalog select i; #region 条件 foreach (string key in searchCondtionCollection) { string condition = searchCondtionCollection[key]; switch (key.ToLower()) { case "isvalid": int value = Convert.ToInt32(condition); query = query.Where(x => x.SYS_IsValid.Equals(value)); break; default: break; } } #endregion #region 排序 foreach (string sort in sortCollection) { string direct = string.Empty; switch (sort.ToLower()) { case "createtime": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => new { x.SYS_CreateTime }); } else { query = query.OrderByDescending(x => new { x.SYS_CreateTime }); } break; default: query = query.OrderByDescending(x => new { x.SYS_OrderSeq }); break; } } list = query.ToList(); } #endregion #region linq to entity List<MaterialCatalogInfo> ilist = new List<MaterialCatalogInfo>(); list.ForEach(x => { MaterialCatalogInfo info = new MaterialCatalogInfo(); DESwap.MaterialCatalogETD(x, info); ilist.Add(info); }); #endregion return ilist;; }
public virtual MaterialCatalogInfo Load(string key) { MaterialCatalogInfo info = new MaterialCatalogInfo(); using (var DbContext = new MRPDbContext()) { MaterialCatalog entity = MaterialCatalogRpt.Get(DbContext, key); DESwap.MaterialCatalogETD(entity,info); } return info; }
public JsonResult UpdateMaterialCatalogValid(string key, string validstatus) { MaterialCatalogInfo info = new MaterialCatalogInfo(); if (!string.IsNullOrEmpty(key) && !string.IsNullOrEmpty(validstatus)) { info.Id = key; info.SYS_IsValid = int.Parse(validstatus); OperationResult opr = MaterialCatalogService.Modify(info); return Json(new JsonResultHelper(opr.Message)); } else { return Json(new JsonResultHelper(false, "选择的记录无效", "")); } }
public ActionResult SaveMaterialCatalog(MaterialCatalogInfo info) { OperationResult opr = new OperationResult(OperationResultType.Success); try { if (string.IsNullOrEmpty(info.Id)) { info.Id = System.Guid.NewGuid().ToString(); opr = MaterialCatalogService.Create(info); } else { opr = MaterialCatalogService.Modify(info); } ViewBag.DicMaterialCatalog = PublicMethod.ListAllMaterialCatalogInfo(MaterialCatalogService, info.Id); ViewBag.PromptMsg = opr.Message; } catch (Exception err) { ViewBag.PromptMsg = err.Message; } return View("MaterialCatalogForm", info); }
public ViewResult MaterialCatalogForm(string key) { ViewBag.Title = "MaterialCatalogForm"; ViewBag.DicMaterialCatalog = PublicMethod.ListAllMaterialCatalogInfo(MaterialCatalogService, key); if (string.IsNullOrEmpty(key)) { MaterialCatalogInfo info = new MaterialCatalogInfo(); return View(info); } else { MaterialCatalogInfo info = MaterialCatalogService.Load(key); return View(info); } }
public static void MaterialCatalogETD(MaterialCatalog entity, MaterialCatalogInfo info) { info.Id = entity.Id; info._IdIsDirty = 0; info.ParentId = entity.ParentId; info._ParentIdIsDirty = 0; info.MaterialCatalogCode = entity.MaterialCatalogCode; info._MaterialCatalogCodeIsDirty = 0; info.MaterialCatalogName = entity.MaterialCatalogName; info._MaterialCatalogNameIsDirty = 0; info.SYS_OrderSeq = entity.SYS_OrderSeq; info._SYS_OrderSeqIsDirty = 0; info.SYS_IsValid = entity.SYS_IsValid; info._SYS_IsValidIsDirty = 0; info.SYS_IsDeleted = entity.SYS_IsDeleted; info._SYS_IsDeletedIsDirty = 0; info.SYS_Remark = entity.SYS_Remark; info._SYS_RemarkIsDirty = 0; info.SYS_StaffId = entity.SYS_StaffId; info._SYS_StaffIdIsDirty = 0; info.SYS_StationId = entity.SYS_StationId; info._SYS_StationIdIsDirty = 0; info.SYS_DepartmentId = entity.SYS_DepartmentId; info._SYS_DepartmentIdIsDirty = 0; info.SYS_CompanyId = entity.SYS_CompanyId; info._SYS_CompanyIdIsDirty = 0; info.SYS_AppId = entity.SYS_AppId; info._SYS_AppIdIsDirty = 0; info.SYS_CreateTime = entity.SYS_CreateTime; info._SYS_CreateTimeIsDirty = 0; info.SYS_ModifyTime = entity.SYS_ModifyTime; info._SYS_ModifyTimeIsDirty = 0; info.SYS_DeleteTime = entity.SYS_DeleteTime; info._SYS_DeleteTimeIsDirty = 0; }