public ViewResult ProductOrderForm(string key) { ViewBag.Title = "ProductOrderForm"; if (string.IsNullOrEmpty(key)) { ProductOrderInfo info = new ProductOrderInfo(); return View(info); } else { ProductOrderInfo info = ProductOrderService.Load(key); return View(info); } }
public JsonResult DeleteProductOrder(string key) { ProductOrderInfo info = new ProductOrderInfo(); if (!string.IsNullOrEmpty(key)) { info.Id = key; OperationResult opr = ProductOrderService.Remove(key); return Json(new JsonResultHelper(opr.Message)); } else { return Json(new JsonResultHelper(false, "选择的记录无效", "")); } }
public virtual OperationResult Create(ProductOrderInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { ProductOrder entity = new ProductOrder(); DESwap.ProductOrderDTE(info, entity); ProductOrderRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public static void ProductOrderETD(ProductOrder entity, ProductOrderInfo info) { info.Id = entity.Id; info._IdIsDirty = 0; info.OrderNO = entity.OrderNO; info._OrderNOIsDirty = 0; info.SourceConstractNo = entity.SourceConstractNo; info._SourceConstractNoIsDirty = 0; info.ConstractFormDate = entity.ConstractFormDate; info._ConstractFormDateIsDirty = 0; info.FormDate = entity.FormDate; info._FormDateIsDirty = 0; info.DeliveryDate = entity.DeliveryDate; info._DeliveryDateIsDirty = 0; info.SumPrice = entity.SumPrice; info._SumPriceIsDirty = 0; info.ClientCompanyId = entity.ClientCompanyId; info._ClientCompanyIdIsDirty = 0; info.ClientCompanyName = entity.ClientCompanyName; info._ClientCompanyNameIsDirty = 0; info.ClientContact = entity.ClientContact; info._ClientContactIsDirty = 0; info.ClientMobile = entity.ClientMobile; info._ClientMobileIsDirty = 0; info.ClientPhone = entity.ClientPhone; info._ClientPhoneIsDirty = 0; info.ClientFax = entity.ClientFax; info._ClientFaxIsDirty = 0; info.ClientAddress = entity.ClientAddress; info._ClientAddressIsDirty = 0; info.HandleStationId = entity.HandleStationId; info._HandleStationIdIsDirty = 0; info.HandleStationName = entity.HandleStationName; info._HandleStationNameIsDirty = 0; info.HandleStaffId = entity.HandleStaffId; info._HandleStaffIdIsDirty = 0; info.HandleStaffName = entity.HandleStaffName; info._HandleStaffNameIsDirty = 0; info.Status = entity.Status; info._StatusIsDirty = 0; info.Note = entity.Note; info._NoteIsDirty = 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; }
public ActionResult SaveProductOrder(ProductOrderInfo info) { OperationResult opr = new OperationResult(OperationResultType.Success); try { if (string.IsNullOrEmpty(info.Id)) { info.Id = System.Guid.NewGuid().ToString(); opr = ProductOrderService.Create(info); } else { opr = ProductOrderService.Modify(info); } ViewBag.PromptMsg = opr.Message; } catch (Exception err) { ViewBag.PromptMsg = err.Message; } return View("ProductOrderForm", info); }
public JsonResult UpdateProductOrderValid(string key, string validstatus) { ProductOrderInfo info = new ProductOrderInfo(); if (!string.IsNullOrEmpty(key) && !string.IsNullOrEmpty(validstatus)) { info.Id = key; info.SYS_IsValid = int.Parse(validstatus); OperationResult opr = ProductOrderService.Modify(info); return Json(new JsonResultHelper(opr.Message)); } else { return Json(new JsonResultHelper(false, "选择的记录无效", "")); } }
public virtual List<ProductOrderInfo> ListAllByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection) { List<ProductOrder> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.ProductOrder 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<ProductOrderInfo> ilist = new List<ProductOrderInfo>(); list.ForEach(x => { ProductOrderInfo info = new ProductOrderInfo(); DESwap.ProductOrderETD(x, info); ilist.Add(info); }); #endregion return ilist;; }
public virtual ProductOrderInfo Load(string key) { ProductOrderInfo info = new ProductOrderInfo(); using (var DbContext = new MRPDbContext()) { ProductOrder entity = ProductOrderRpt.Get(DbContext, key); DESwap.ProductOrderETD(entity,info); } return info; }