public virtual OperationResult Create(MaterialPurchaseItemInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { MaterialPurchaseItem entity = new MaterialPurchaseItem(); DESwap.MaterialPurchaseItemDTE(info, entity); MaterialPurchaseItemRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Create(GatherBillInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { GatherBill entity = new GatherBill(); DESwap.GatherBillDTE(info, entity); GatherBillRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Create(WareHouseInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { WareHouse entity = new WareHouse(); DESwap.WareHouseDTE(info, entity); WareHouseRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Create(ProductWareStockInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { ProductWareStock entity = new ProductWareStock(); DESwap.ProductWareStockDTE(info, entity); ProductWareStockRpt.Insert(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Create(IEnumerable<ProductCatalogInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<ProductCatalog> eList = new List<ProductCatalog>(); infoList.ForEach(x => { ProductCatalog entity = new ProductCatalog(); DESwap. ProductCatalogDTE(x, entity); eList.Add(entity); }); using (var DbContext = new MRPDbContext()) { ProductCatalogRpt.Insert(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Create(IEnumerable<MaterialPurchaseItemInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<MaterialPurchaseItem> eList = new List<MaterialPurchaseItem>(); infoList.ForEach(x => { MaterialPurchaseItem entity = new MaterialPurchaseItem(); DESwap. MaterialPurchaseItemDTE(x, entity); eList.Add(entity); }); using (var DbContext = new MRPDbContext()) { MaterialPurchaseItemRpt.Insert(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Create(IEnumerable<WareHouseInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<WareHouse> eList = new List<WareHouse>(); infoList.ForEach(x => { WareHouse entity = new WareHouse(); DESwap. WareHouseDTE(x, entity); eList.Add(entity); }); using (var DbContext = new MRPDbContext()) { WareHouseRpt.Insert(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual ProductCatalogInfo Load(string key) { ProductCatalogInfo info = new ProductCatalogInfo(); using (var DbContext = new MRPDbContext()) { ProductCatalog entity = ProductCatalogRpt.Get(DbContext, key); DESwap.ProductCatalogETD(entity,info); } return info; }
public virtual WareHouseInfo Load(string key) { WareHouseInfo info = new WareHouseInfo(); using (var DbContext = new MRPDbContext()) { WareHouse entity = WareHouseRpt.Get(DbContext, key); DESwap.WareHouseETD(entity,info); } return info; }
public virtual OperationResult Modify(IEnumerable<ManufacturePlanInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<ManufacturePlan> eList = new List<ManufacturePlan>(); infoList.ForEach(x => { ManufacturePlan entity = new ManufacturePlan(); DESwap. ManufacturePlanDTE(x, entity); eList.Add(entity); }); using (var DbContext = new MRPDbContext()) { ManufacturePlanRpt.Update(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Modify(ManufacturePlanInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { ManufacturePlan entity = ManufacturePlanRpt.Get(DbContext, info.Id); DESwap.ManufacturePlanDTE(info, entity); ManufacturePlanRpt.Update(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual ManufacturePlanInfo Load(string key) { ManufacturePlanInfo info = new ManufacturePlanInfo(); using (var DbContext = new MRPDbContext()) { ManufacturePlan entity = ManufacturePlanRpt.Get(DbContext, key); DESwap.ManufacturePlanETD(entity,info); } return info; }
public PageResult<ProductInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize) { PageResult<ProductInfo> result = new PageResult<ProductInfo>(); int skip = (pageNumber - 1) * pageSize; int take = pageSize; List<ProductInfo> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.Product join p in DbContext.ProductCatalog on i.ProductCatalogId equals p.Id select new ProductInfo() { Id = i.Id, ProductCode = i.ProductCode, ProductName = i.ProductName, ProductCatalogName = p.ProductCatalogName, ProductCatalogId = i.ProductCatalogId, ImageUrl = i.ImageUrl, SearchKey = i.SearchKey, Special = i.Special, Size = i.Size, MinStock = i.MinStock, Stock = i.Stock, MaxStock = i.MaxStock, Texture = i.Texture, Color = i.Color, UnitId = i.UnitId, SYS_IsValid = i.SYS_IsValid, SYS_OrderSeq = i.SYS_OrderSeq, SYS_AppId = i.SYS_AppId, SYS_StaffId = i.SYS_StaffId, SYS_StationId = i.SYS_StationId, SYS_DepartmentId = i.SYS_DepartmentId, SYS_CompanyId = i.SYS_CompanyId, SYS_CreateTime = i.SYS_CreateTime }; #region 条件 foreach (string key in searchCondtionCollection) { string condition = searchCondtionCollection[key]; switch (key.ToLower()) { case "productname": query = query.Where(x => x.ProductName.Contains(condition)); break; case "productcatalogid": query = query.Where(x => x.ProductCatalogId.Equals(condition)); break; case "searchkey": query = query.Where(x => x.SearchKey.Equals(condition)); break; case "isvalid": int value = Convert.ToInt32(condition); query = query.Where(x => x.SYS_IsValid.Equals(value)); break; default: break; } } #endregion result.TotalRecords = query.Count(); #region 排序 foreach (string sort in sortCollection) { string direct = sortCollection[sort]; switch (sort.ToLower()) { case "createtime": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } break; case "productname": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => x.ProductName).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => x.ProductName).Skip(skip).Take(take); } break; default: query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take); break; } } #endregion list = query.ToList(); } result.PageSize = pageSize; result.PageNumber = pageNumber; result.Data = list; return result; }
public virtual ProductOrderItemInfo Load(string key) { ProductOrderItemInfo info = new ProductOrderItemInfo(); using (var DbContext = new MRPDbContext()) { ProductOrderItem entity = ProductOrderItemRpt.Get(DbContext, key); DESwap.ProductOrderItemETD(entity,info); } return info; }
public virtual List<MaterialPurchaseItemInfo> ListAllByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection) { List<MaterialPurchaseItem> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.MaterialPurchaseItem 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<MaterialPurchaseItemInfo> ilist = new List<MaterialPurchaseItemInfo>(); list.ForEach(x => { MaterialPurchaseItemInfo info = new MaterialPurchaseItemInfo(); DESwap.MaterialPurchaseItemETD(x, info); ilist.Add(info); }); #endregion return ilist;; }
public virtual GatherBillInfo Load(string key) { GatherBillInfo info = new GatherBillInfo(); using (var DbContext = new MRPDbContext()) { GatherBill entity = GatherBillRpt.Get(DbContext, key); DESwap.GatherBillETD(entity,info); } return info; }
public virtual OperationResult Remove(string key) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { MaterialPurchaseItem entity = MaterialPurchaseItemRpt.Get(DbContext, key); MaterialPurchaseItemRpt.Delete(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Modify(IEnumerable<ProductWareStockInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<ProductWareStock> eList = new List<ProductWareStock>(); infoList.ForEach(x => { ProductWareStock entity = new ProductWareStock(); DESwap. ProductWareStockDTE(x, entity); eList.Add(entity); }); using (var DbContext = new MRPDbContext()) { ProductWareStockRpt.Update(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual ProductWareStockInfo Load(string key) { ProductWareStockInfo info = new ProductWareStockInfo(); using (var DbContext = new MRPDbContext()) { ProductWareStock entity = ProductWareStockRpt.Get(DbContext, key); DESwap.ProductWareStockETD(entity,info); } return info; }
public PageResult<WareHouseInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize) { PageResult<WareHouseInfo> result = new PageResult<WareHouseInfo>(); int skip = (pageNumber - 1) * pageSize; int take = pageSize; List<WareHouseInfo> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.WareHouse select new WareHouseInfo() { Id = i.Id, WareHouseCode = i.WareHouseCode, WareHouseName = i.WareHouseName, RegionId = i.RegionId, Address = i.Address, SYS_IsValid = i.SYS_IsValid, SYS_OrderSeq = i.SYS_OrderSeq, SYS_AppId = i.SYS_AppId, SYS_StaffId = i.SYS_StaffId, SYS_StationId = i.SYS_StationId, SYS_DepartmentId = i.SYS_DepartmentId, SYS_CompanyId = i.SYS_CompanyId, SYS_CreateTime = i.SYS_CreateTime }; #region 条件 foreach (string key in searchCondtionCollection) { string condition = searchCondtionCollection[key]; switch (key.ToLower()) { case "warehousename": query = query.Where(x => x.WareHouseName.Contains(condition)); break; case "regionid": query = query.Where(x => x.RegionId.Equals(condition)); break; case "isvalid": int value = Convert.ToInt32(condition); query = query.Where(x => x.SYS_IsValid.Equals(value)); break; default: break; } } #endregion result.TotalRecords = query.Count(); #region 排序 foreach (string sort in sortCollection) { string direct = sortCollection[sort]; switch (sort.ToLower()) { case "createtime": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } break; case "warehousename": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => x.WareHouseName).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => x.WareHouseName).Skip(skip).Take(take); } break; default: query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take); break; } } #endregion list = query.ToList(); } result.PageSize = pageSize; result.PageNumber = pageNumber; result.Data = list; return result; }
public virtual OperationResult Modify(ProductOrderItemInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { ProductOrderItem entity = ProductOrderItemRpt.Get(DbContext, info.Id); DESwap.ProductOrderItemDTE(info, entity); ProductOrderItemRpt.Update(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual MaterialWareStockInfo Load(string key) { MaterialWareStockInfo info = new MaterialWareStockInfo(); using (var DbContext = new MRPDbContext()) { MaterialWareStock entity = MaterialWareStockRpt.Get(DbContext, key); DESwap.MaterialWareStockETD(entity,info); } return info; }
public virtual MaterialPurchaseItemInfo Load(string key) { MaterialPurchaseItemInfo info = new MaterialPurchaseItemInfo(); using (var DbContext = new MRPDbContext()) { MaterialPurchaseItem entity = MaterialPurchaseItemRpt.Get(DbContext, key); DESwap.MaterialPurchaseItemETD(entity,info); } return info; }
public virtual OperationResult Modify(IEnumerable<GatherBillInfo> infoList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<GatherBill> eList = new List<GatherBill>(); infoList.ForEach(x => { GatherBill entity = new GatherBill(); DESwap. GatherBillDTE(x, entity); eList.Add(entity); }); using (var DbContext = new MRPDbContext()) { GatherBillRpt.Update(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Remove(IEnumerable<string> keyList) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); List<MaterialPurchaseItem> eList = new List<MaterialPurchaseItem>(); using (var DbContext = new MRPDbContext()) { keyList.ForEach(x => { MaterialPurchaseItem entity = MaterialPurchaseItemRpt.Get(DbContext, x); eList.Add(entity); }); MaterialPurchaseItemRpt.Delete(DbContext, eList); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Modify(CompanyWareHouseInfo info) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { CompanyWareHouse entity = CompanyWareHouseRpt.Get(DbContext, info.Id); DESwap.CompanyWareHouseDTE(info, entity); CompanyWareHouseRpt.Update(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
public virtual OperationResult Remove(string key) { OperationResult result = new OperationResult(OperationResultType.Error, "操作失败,请稍后重试!"); using (var DbContext = new MRPDbContext()) { CompanyWareHouse entity = CompanyWareHouseRpt.Get(DbContext, key); CompanyWareHouseRpt.Delete(DbContext, entity); DbContext.SaveChanges(); } result.ResultType = OperationResultType.Success; result.Message = "操作成功!"; return result; }
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 PageResult<MaterialPurchaseInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize) { PageResult<MaterialPurchaseInfo> result = new PageResult<MaterialPurchaseInfo>(); int skip = (pageNumber - 1) * pageSize; int take = pageSize; List<MaterialPurchase> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.MaterialPurchase 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 result.TotalRecords = query.Count(); #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 }).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } break; default: query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take); break; } } list = query.ToList(); } #endregion #region linq to entity List<MaterialPurchaseInfo> ilist = new List<MaterialPurchaseInfo>(); list.ForEach(x => { MaterialPurchaseInfo info = new MaterialPurchaseInfo(); DESwap.MaterialPurchaseETD(x, info); ilist.Add(info); }); #endregion result.PageSize = pageSize; result.PageNumber = pageNumber; result.Data = ilist; return result;; }
public PageResult<MaterialCatalogInfo> ListByCondition(NameValueCollection searchCondtionCollection, NameValueCollection sortCollection, int pageNumber, int pageSize) { PageResult<MaterialCatalogInfo> result = new PageResult<MaterialCatalogInfo>(); int skip = (pageNumber - 1) * pageSize; int take = pageSize; List<MaterialCatalogInfo> list = null; using (var DbContext = new MRPDbContext()) { var query = from i in DbContext.MaterialCatalog join p in DbContext.MaterialCatalog on i.ParentId equals p.Id into parent from tp in parent.DefaultIfEmpty() select new MaterialCatalogInfo() { Id = i.Id, MaterialCatalogCode = i.MaterialCatalogCode, MaterialCatalogName = i.MaterialCatalogName, ParentId = i.ParentId, SYS_IsValid = i.SYS_IsValid, SYS_OrderSeq = i.SYS_OrderSeq, SYS_AppId = i.SYS_AppId, SYS_StaffId = i.SYS_StaffId, SYS_StationId = i.SYS_StationId, SYS_DepartmentId = i.SYS_DepartmentId, SYS_CompanyId = i.SYS_CompanyId, SYS_CreateTime = i.SYS_CreateTime, ParentName = tp.MaterialCatalogName == null ? "" : tp.MaterialCatalogName }; #region 条件 foreach (string key in searchCondtionCollection) { string condition = searchCondtionCollection[key]; switch (key.ToLower()) { case "materialcatalogname": query = query.Where(x => x.MaterialCatalogName.Contains(condition)); break; case "materialcatalogcode": query = query.Where(x => x.MaterialCatalogCode.Contains(condition)); break; case "parentid": query = query.Where(x => x.ParentId.Equals(condition)); break; case "isvalid": int value = Convert.ToInt32(condition); query = query.Where(x => x.SYS_IsValid.Equals(value)); break; default: break; } } #endregion result.TotalRecords = query.Count(); #region 排序 foreach (string sort in sortCollection) { string direct = sortCollection[sort]; switch (sort.ToLower()) { case "createtime": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => new { x.SYS_CreateTime }).Skip(skip).Take(take); } break; case "materialcatalogname": if (direct.ToLower().Equals("asc")) { query = query.OrderBy(x => x.MaterialCatalogName).Skip(skip).Take(take); } else { query = query.OrderByDescending(x => x.MaterialCatalogName).Skip(skip).Take(take); } break; default: query = query.OrderByDescending(x => new { x.SYS_OrderSeq }).Skip(skip).Take(take); break; } } #endregion list = query.ToList(); } result.PageSize = pageSize; result.PageNumber = pageNumber; result.Data = list; return result; }