/// <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");
}
