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); }
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")); }
public List<GoodsBaseInfoVM> GetAllGoodsBaseInfo() { GoodsBaseInfo info = new GoodsBaseInfo(); OQL q = OQL.From(info).Select().END; return GetGoodsBaseInfoList(q); }
/// <summary> /// 修改商品信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool UpdateGoodsBaseInfo(GoodsBaseInfo info) { return EntityQuery<GoodsBaseInfo>.Instance.Update (info) > 0; }
/// <summary> /// 保存商品信息 /// </summary> /// <param name="info">商品信息</param> /// <returns></returns> /// <remarks>该方法会自动探测实体对象是新增的还是修改的,如果要求较快速度,请调用Insert或者Update方法</remarks> public bool SaveGoodsBaseInfo(GoodsBaseInfo info) { EntityQuery<GoodsBaseInfo> query = new EntityQuery<GoodsBaseInfo>(info); return query.SaveAllChanges()>0; }
/// <summary> /// 获取商品销售价格信息 /// </summary> /// <returns></returns> public IEnumerable<GoodsSaleInfoVM> GetGoodsSaleInfo() { GoodsBaseInfo bInfo = new GoodsBaseInfo(); GoodsStock stock = new GoodsStock(); OQL joinQ = OQL.From(bInfo) .Join(stock).On(bInfo.SerialNumber, stock.SerialNumber) .Select(bInfo.GoodsName, bInfo.Manufacturer, bInfo.SerialNumber, stock.GoodsPrice, stock.MakeOnDate, bInfo.CanUserMonth, stock.Stocks, stock.GoodsID) .OrderBy(bInfo.GoodsName, "asc") .END; PWMIS.DataProvider.Data.AdoHelper db = PWMIS.DataProvider.Adapter.MyDB.GetDBHelper(); EntityContainer ec = new EntityContainer(joinQ, db); ec.Execute(); var result = ec.Map<GoodsSaleInfoVM>(e => { e.GoodsName = ec.GetItemValue<string>(0); e.Manufacturer = ec.GetItemValue<string>(1); e.SerialNumber = ec.GetItemValue<string>(2); e.GoodsPrice = ec.GetItemValue<decimal>(3); e.MakeOnDate = ec.GetItemValue<DateTime>(4); e.CanUserMonth = ec.GetItemValue<int>(5); e.Stocks = ec.GetItemValue<int>(6); e.GoodsID = ec.GetItemValue<int>(7); return e; } ); return result; }
private int GetOverDays(string serialNumber, int goodsID, out decimal goodsPrice, out int stockCount) { //计算距离过期时间 GoodsBaseInfo bInfo = new GoodsBaseInfo(); bInfo.SerialNumber = serialNumber; OQL q = OQL.From(bInfo) .Select(bInfo.CanUserMonth) .Where(bInfo.SerialNumber) .END; bInfo = EntityQuery<GoodsBaseInfo>.QueryObject(q); int canUseMonth = bInfo.CanUserMonth; GoodsStock stock = new GoodsStock(); stock.GoodsID = goodsID; EntityQuery<GoodsStock>.Fill(stock); goodsPrice = stock.GoodsPrice; stockCount = stock.Stocks; //距离过期时间 int overDays = canUseMonth *30 - DateTime.Now.Subtract(stock.MakeOnDate).Days; return overDays; }
/// <summary> /// 增加商品信息 /// </summary> /// <param name="info"></param> /// <returns></returns> public bool AddGoodsBaseInfo(GoodsBaseInfo info) { return EntityQuery<GoodsBaseInfo>.Instance.Insert(info)>0; }
/// <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); }
/// <summary> /// 获取一条商品信息 /// </summary> /// <param name="sn">条码号</param> /// <returns></returns> public GoodsBaseInfo GetGoodsBaseInfo(string sn) { GoodsBaseInfo info = new GoodsBaseInfo() { SerialNumber = sn }; EntityQuery<GoodsBaseInfo>.Fill(info); return info; }