/// <summary>
/// 获取指定页的联系人信息
/// </summary>
/// <param name="pageSize"></param>
/// <param name="pageNumber"></param>
/// <param name="allCount"></param>
/// <returns></returns>
public List<CustomerContactInfo> GetContactInfoList(int pageSize, int pageNumber, int allCount)
{
CustomerContactInfo info = new CustomerContactInfo();
OQL q = new OQL(info);
q.Select().OrderBy(info.CustomerName, "asc");
q.Limit(pageSize, pageNumber);
q.PageWithAllRecordCount = allCount;
return EntityQuery<CustomerContactInfo>.QueryList(q);
}
public List<GoodsBaseInfoVM> GetGoodsBaseInfoList(int pageSize, int pageNumber,int allCount)
{
GoodsBaseInfo info = new GoodsBaseInfo();
OQL q = new OQL(info);
q.Select()
.OrderBy (info.SerialNumber ,"asc");
q.Limit(pageSize, pageNumber);
q.PageWithAllRecordCount = allCount;
return GetGoodsBaseInfoList(q);
}
//测试OQL的统计功能
private int GetStockCount(string serialNumber)
{
SuperMarketDAL.Entitys.GoodsStock stock = new SuperMarketDAL.Entitys.GoodsStock();
stock.SerialNumber = serialNumber;
OQL q = new OQL(stock);
q.Select()
.Count(stock.Stocks, "")
.Where(stock.SerialNumber);
stock = EntityQuery<SuperMarketDAL.Entitys.GoodsStock>.QueryObject(q);
int stockCount = stock.Stocks;
return stockCount;
}
public int GetAllGoodsBaseInfoCount()
{
GoodsBaseInfo info = new GoodsBaseInfo();
OQL q = new OQL(info);
q.Select()
.Count(info.SerialNumber,"Count");
GoodsBaseInfo infoCount = EntityQuery<GoodsBaseInfo>.QueryObject(q);
return Convert.ToInt32(infoCount.PropertyList("Count"));
}
//该方法已经废弃，合并在 GetOverDays 中
private int GetStockCount(int goodsID)
{
GoodsStock stock = new GoodsStock();
stock.GoodsID = goodsID;
OQL q = new OQL(stock);
q.Select(stock.Stocks)
.Where(stock.GoodsID);
stock = EntityQuery<GoodsStock>.QueryObject(q);
int stockCount = stock.Stocks;
return stockCount;
}
/// <summary>
/// 获取所有的可售商品总数
/// </summary>
/// <returns></returns>
public int GetGoodsStockCount()
{
GoodsStock stock = new GoodsStock();
OQL q = new OQL(stock);
q.Select()
.Count(stock.Stocks, "库存数量")
.Where(q.Condition.AND(stock.Stocks, ">", 0));
stock = EntityQuery<GoodsStock>.QueryObject(q);
return stock.Stocks;
}
/// <summary>
/// 获取商品名称分组
/// </summary>
/// <returns></returns>
public List<string> GetAllGoodsNames()
{
GoodsBaseInfo info = new GoodsBaseInfo();
OQL q = new OQL(info);
q.Select(info.GoodsName)
.GroupBy(info.GoodsName)
.OrderBy(info.GoodsName, "asc");
List<GoodsBaseInfo> list = EntityQuery<GoodsBaseInfo>.QueryList(q);
var result = list.ConvertAll<string>(p => p.GoodsName);
return result;
}
/// <summary>
/// 获取指定商品名称下面的商品信息
/// </summary>
/// <param name="goodsName">商品名称</param>
/// <returns></returns>
public List<GoodsBaseInfoVM> GetGoodsBaseInfoWhithGoodsName(string goodsName)
{
GoodsBaseInfo info = new GoodsBaseInfo();
info.GoodsName = goodsName;
OQL q = new OQL(info);
q.Select(info.SerialNumber, info.GoodsName, info.Manufacturer, info.CanUserMonth)
.Where(info.GoodsName)
.OrderBy(info.GoodsName, "asc");
return GetGoodsBaseInfoList(q);
}
/// <summary>
/// 根据商品名称为顺序获取所有商品基本信息
/// </summary>
/// <returns></returns>
public List<GoodsBaseInfoVM> GetAllGoodsBaseInfoOrderByNames()
{
GoodsBaseInfo info = new GoodsBaseInfo();
OQL q = new OQL(info);
q.Select(info.SerialNumber,info.GoodsName,info.Manufacturer,info.CanUserMonth )
.OrderBy(info.GoodsName, "asc");
return GetGoodsBaseInfoList(q);
}