/// <summary> /// 获取产品信息 /// </summary> /// <returns></returns> public static List <BGoods> GetBinaryUnionData() { List <BGoods> goods; SqlSugarClient db = DbConnect.Connect(); goods = db.UnionAll <dynamic>(db.SqlQueryable <dynamic>( "select fname,1 as stype from tbSpXinXi") .Where(" left(stype,1)='1'") .Take(600), db.SqlQueryable <dynamic>( "select fname,0 as stype from tbSpXinXi") .Where(" left(stype,1)<>'1'").Take(600)) .Select <BGoods>().OrderBy(" newid()").ToList(); return(goods); }
/// <summary> /// 采购明细汇总 /// </summary> /// <param name="condition"></param> /// <param name="res"></param> /// <returns></returns> public static async Task GetPurchaseDetailPageAsync(SqlSugarClient Db) { Db.CodeFirst.InitTables<EGoods, EGoodsBrand, EGoodsClass>(); Db.CodeFirst.InitTables<EOrderAlbaran, EOrderAlbaranDetail, EOrderReturn, EOrderReturnDetail>(); //入库单 Db.Insertable(new EOrderAlbaranDetail() { AlbaranId = 1, BarCode = "a", ChineseName = "a", Commentary = "a", CostPrice = 1, DelFlag = "a", Discount = 1, GoodsBrandId = 1, GoodsBrandName = "a", GoodsClassId = 1, GoodsClassName = "a", GoodsNo = "a", Id = new Random().Next(0, 99999999), Index = 1, IsBlanceBarCode = true, IsProhibitedChangeDiscount = true, IsTemporary = true, Iva = 1, IvaId = 1, Number = 1, OrderId = 1, PackageAmount = 1, Price = 1, PurchaseSpec = "", Remark = "a", Req = 1, SpanishName = "a", TenantId = 1, Total = 1, UnitName = "a" }).ExecuteCommand(); var query1 = Db.Queryable<EOrderAlbaranDetail, EOrderAlbaran, EGoods, EGoodsClass, EGoodsBrand>((d, h, g, c, b) => new JoinQueryInfos( JoinType.Left, h.AlbaranId == d.AlbaranId, JoinType.Left, d.GoodsNo == g.GoodsNo, JoinType.Left, g.GoodsClassId == c.GoodsClassId, JoinType.Left, g.BrandId == b.BrandId )) .Where((d, h, g, c, b) => h.AlbaranType == null) //固定入库单 .Select((d, h, g, c, b) => new PurchaseDetailModel { EntryTime = h.EntryTime, No = h.AlbaranNo, Type = 1, GoodsNo = d.GoodsNo, GoodsName = g.SpanishName, GoodsCategory = c.SpanishName, BrandName = b.BranchSpanishName, Number = d.Number, Price = d.Price }); //退货单 var query2 = Db.Queryable<EOrderReturnDetail, EOrderReturn, EGoods, EGoodsClass, EGoodsBrand>((d, h, g, c, b) => new JoinQueryInfos( JoinType.Left, h.OrderReturnId == d.OrderReturnId, JoinType.Left, d.GoodsNo == g.GoodsNo, JoinType.Left, g.GoodsClassId == c.GoodsClassId, JoinType.Left, g.BrandId == b.BrandId )).Where((d, h, g, c, b) => h.OrderReturnType == 1) //固定入库单 .Select((d, h, g, c, b) => new PurchaseDetailModel { EntryTime = h.EntryTime, No = h.OrderReturnNo, Type = 2, GoodsNo = d.GoodsNo, GoodsName = g.SpanishName, GoodsCategory = c.SpanishName, BrandName = b.BranchSpanishName, Number = d.Number, Price = d.Price }); SqlSugar.RefAsync<int> totalNum = 0; var res2 = await query2.Clone().ToPageListAsync(1, 2, totalNum); var res = await Db.UnionAll(query1, query2).ToPageListAsync(1, 2, totalNum); var q = Db.Queryable<Order>().Where(it => it.Id == 1).Select(it => new { id=1}); var q2 = q.Clone(); var x = q.ToList(); var y = q2.ToList(); //var res = await Db.UnionAll<PurchaseDetailModel>(query1.Clone(), query2.Clone()).ToPageListAsync(1, 10, totalNum); }