/// <summary> /// 数据字典列表 /// </summary> /// <returns></returns> public IEnumerable <DataItemViewModel> GetDataItemList() { //List<DataItemViewModel> cacheList = CacheFactory.GetCacheInstance().GetListCache<DataItemViewModel>(_dataItemDetailBll.CacheKey, out long total); //if (cacheList == null || cacheList.Count == 0) //{ // cacheList = _dataItemDetailBll.GetDataItemList().ToList(); // //以集合的方式存在缓存下面 // CacheFactory.GetCacheInstance().WriteListCache<DataItemViewModel>(cacheList, _dataItemDetailBll.CacheKey); // //以单体的形式存在缓存下面 // //foreach (DataItemViewModel model in cacheList) // //{ // // CacheFactory.GetCacheInstance().WriteCache<DataItemViewModel>(model, _dataItemDetailBll.CacheKey); // //} //} //return cacheList; List <DataItemViewModel> cacheList = CacheFactory.GetCacheInstance().GetListCache <DataItemViewModel>( _dataItemDetailBll.CacheKey, () => { return(_dataItemDetailBll.GetDataItemList().ToList()); }, out long total); return(cacheList); }
public HttpResponseMessage GetBaseItemListJson(string queryJson) { //EnCode:Client_StyleCodeOption 花型 //EnCode:Client_ColorCodeOption 色号 //EnCode:Client_OpPositionCodeOption 施工位置 //EnCode:Client_PaymentState 施工位置 var encode = queryJson.ToJObject()["encode"].ToString(); var keyword = queryJson.ToJObject()["keyword"].ToString(); var data = busines.GetDataItemList().Where(t => t.EnCode == encode).OrderBy(t => t.ItemName); if (!string.IsNullOrEmpty(keyword)) { data = busines.GetDataItemList().Where(t => t.EnCode == encode).Where(t => t.ItemCode == keyword).OrderBy(t => t.ItemName); } HttpResponseMessage ut = new HttpResponseMessage { Content = new StringContent(data.ToJson(), Encoding.GetEncoding("UTF-8"), "application/json") }; if (encode == "Client_StyleCodeOption") { var dataprice = priceBLL.GetList(""); var sg = from c in data join t in dataprice on new { id = c.ItemCode, id1 = c.ItemValue } equals new { id = t.ProductId, id1 = t.ItemDetailId } select new { ItemDetailId = c.ItemDetailId, ItemValue = c.ItemValue, ItemName = c.ItemName, Price = t.SalePrice == null ? 0 : t.SalePrice }; ut = new HttpResponseMessage { Content = new StringContent(sg.ToJson(), Encoding.GetEncoding("UTF-8"), "application/json") }; } return(ut); }
/// <summary> /// 数据字典列表 /// </summary> /// <returns></returns> public IEnumerable <DataItemViewModel> GetDataItemList() { List <DataItemViewModel> cacheList = CacheFactory.CacheFactory.GetCacheInstance().GetCache <List <DataItemViewModel> >(_dataItemDetailBll.CacheKey); if (cacheList == null) { cacheList = _dataItemDetailBll.GetDataItemList().ToList(); CacheFactory.CacheFactory.GetCacheInstance().WriteCache(_dataItemDetailBll, _dataItemDetailBll.CacheKey); } return(cacheList); }
public ActionResult GetDataItemTreeJson(string EnCode) { var data = dataItemDetailBLL.GetDataItemList().Where(x => x.EnCode == EnCode);//dataItemCache.GetDataItemList(EnCode); var treeList = new List <TreeEntity>(); foreach (DataItemModel item in data) { TreeEntity tree = new TreeEntity(); bool hasChildren = data.Count(t => t.ParentId == item.ItemDetailId) == 0 ? false : true; tree.id = item.ItemDetailId; tree.text = item.ItemName; tree.value = item.ItemValue; tree.parentId = item.ParentId; tree.isexpand = true; tree.complete = true; tree.hasChildren = hasChildren; treeList.Add(tree); } return(Content(treeList.TreeToJson())); }
/// <summary> /// 数据字典列表 /// </summary> /// <returns></returns> public IEnumerable <DataItemModel> GetDataItemList() { IEnumerable <DataItemModel> cacheList = CacheFactory.Cache().GetCache <IEnumerable <DataItemModel> >(busines.cacheKey); if (cacheList == null) { cacheList = busines.GetDataItemList(); CacheFactory.Cache().WriteCache(cacheList, busines.cacheKey); } return(cacheList); }
/// <summary> /// 数据字典列表 /// </summary> /// <returns></returns> public IEnumerable <DataItemModel> GetDataItemList() { var cacheList = CacheFactory.Cache().GetCache <IEnumerable <DataItemModel> >(busines.cacheKey); if (cacheList == null) { var data = busines.GetDataItemList(); CacheFactory.Cache().WriteCache(data, busines.cacheKey); return(data); } else { return(cacheList); } }
public ActionResult GetListJson(string EnCode) { var data = dataItemDetailBLL.GetDataItemList().Where(x => x.EnCode == EnCode);//dataItemCache.GetDataItemList(EnCode); var TreeList = new List <TreeGridEntity>(); foreach (DataItemModel item in data) { TreeGridEntity tree = new TreeGridEntity(); bool hasChildren = data.Count(t => t.ParentId == item.ItemDetailId) == 0 ? false : true; tree.id = item.ItemDetailId; tree.parentId = item.ParentId; tree.expanded = true; tree.hasChildren = hasChildren; tree.entityJson = item.ToJson(); TreeList.Add(tree); } return(Content(TreeList.TreeJson())); }
/// <summary> /// 查询热门图库分类 /// </summary> /// <param name="count"></param> /// <returns></returns> public static List <HotMenuModel> QueryHotMenu(string[] itemname) { DataItemDetailBLL dataItemCache = new DataItemDetailBLL(); IEnumerator <DataItemModel> enumerator = dataItemCache.GetDataItemList().Where(t => itemname.Contains(t.EnCode)).GetEnumerator(); List <HotMenuModel> rtdata = new List <HotMenuModel>(); while (enumerator.MoveNext()) { HotMenuModel tmp = new HotMenuModel() { EnCode = enumerator.Current.EnCode, SimpleSpelling = enumerator.Current.SimpleSpelling, SortCode = enumerator.Current.SortCode.Value, ID = enumerator.Current.ItemDetailId, ItemName = enumerator.Current.ItemName, ItemValue = enumerator.Current.ItemValue, }; rtdata.Add(tmp); } //rtdata = rtdata.OrderBy(s => s.GalleryNumber).ToList();//升序排序 return(rtdata); }
/// <summary> /// 导出订单明细(Excel模板导出) /// </summary> /// <param name="orderId">订单Id</param> /// <returns></returns> public void ExportOrderEntry(string orderId) { var order = orderBLL.GetEntity(orderId); var orderEntry = orderEntryBLL.GetList(orderId); var cachedata = CacheFactory.Cache().GetCache <IEnumerable <DataItemModel> >(dataItemDetailBLL.cacheKey); if (cachedata == null) { cachedata = dataItemDetailBLL.GetDataItemList(); // new DataItemCache().ToItemName("Client_PaymentMode", order.PaymentMode) } List <TemplateMode> list = new List <TemplateMode>(); //设置主表信息 list.Add(new TemplateMode() { row = 1, cell = 1, value = order.CustomerName }); list.Add(new TemplateMode() { row = 1, cell = 5, value = order.SellerName }); list.Add(new TemplateMode() { row = 1, cell = 8, value = order.OrderDate.ToDate().ToString("yyyy-MM-dd") }); list.Add(new TemplateMode() { row = 1, cell = 11, value = order.OrderCode }); list.Add(new TemplateMode() { row = 17, cell = 1, value = order.DiscountSum.ToString() }); list.Add(new TemplateMode() { row = 17, cell = 5, value = order.Accounts.ToString() }); list.Add(new TemplateMode() { row = 17, cell = 8, value = order.PaymentDate.ToDate().ToString("yyyy-MM-dd") }); list.Add(new TemplateMode() { row = 17, cell = 11, value = cachedata.First(x => x.EnCode == "Client_PaymentMode" && x.ItemValue == order.PaymentMode).ItemName }); list.Add(new TemplateMode() { row = 18, cell = 1, value = order.SaleCost.ToString() }); list.Add(new TemplateMode() { row = 18, cell = 5, value = order.CreateUserName }); list.Add(new TemplateMode() { row = 18, cell = 8, value = order.ContractCode }); list.Add(new TemplateMode() { row = 18, cell = 11, value = order.ContractFile }); list.Add(new TemplateMode() { row = 19, cell = 1, value = order.AbstractInfo }); list.Add(new TemplateMode() { row = 20, cell = 1, value = order.Description }); //设置明细信息 int rowIndex = 4; foreach (OrderEntryEntity item in orderEntry) { list.Add(new TemplateMode() { row = rowIndex, cell = 0, value = item.ProductName }); list.Add(new TemplateMode() { row = rowIndex, cell = 3, value = item.ProductCode }); list.Add(new TemplateMode() { row = rowIndex, cell = 4, value = item.UnitId }); list.Add(new TemplateMode() { row = rowIndex, cell = 5, value = item.Qty.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 6, value = item.Price.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 7, value = item.Amount.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 8, value = item.TaxRate.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 9, value = item.Taxprice.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 10, value = item.Tax.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 11, value = item.TaxAmount.ToString() }); list.Add(new TemplateMode() { row = rowIndex, cell = 12, value = item.Description }); rowIndex++; } //设置明细合计 list.Add(new TemplateMode() { row = 16, cell = 5, value = orderEntry.Sum(t => t.Qty).ToString() }); list.Add(new TemplateMode() { row = 16, cell = 6, value = orderEntry.Sum(t => t.Price).ToString() }); list.Add(new TemplateMode() { row = 16, cell = 7, value = orderEntry.Sum(t => t.Amount).ToString() }); list.Add(new TemplateMode() { row = 16, cell = 9, value = orderEntry.Sum(t => t.Taxprice).ToString() }); list.Add(new TemplateMode() { row = 16, cell = 10, value = orderEntry.Sum(t => t.Tax).ToString() }); list.Add(new TemplateMode() { row = 16, cell = 11, value = orderEntry.Sum(t => t.TaxAmount).ToString() }); //执行导出 ExcelHelper.ExcelDownload(list, "OrderEntry.xlsx", "订单明细-" + order.OrderCode + ".xlsx"); }