/// <summary> /// Gets the integer in range. /// </summary> /// <param name="range">The range.</param> /// <returns></returns> public static int GetInteger(Core.Range <int> range) { return(Rand.Next(range.From, range.To)); }
/// <summary> /// 查询用户消费记录列表 /// </summary> /// <param name="time"></param> /// <param name="way"></param> /// <returns></returns> public static IEnumerable <IntegralConsumptionView> GetIntegralConsumptionList(Core.Range <DateTime>?time, Guid?companyId, Common.Enums.IntegralWay?way, ExchangeState state, Common.Enums.OEMCommodityState?oEMCommodityState, string falg, Guid?oemId, Pagination pagination) { using (var cmd = Factory.CreateCommand()) { var reposity = Factory.CreateIntegralReposity(cmd); return(reposity.GetIntegralConsumptionList(time, way, companyId, state, oEMCommodityState, falg, oemId, pagination)); } }
public IEnumerable <DataTransferObject.Integral.IntegralConsumptionView> GetIntegralConsumptionList(Core.Range <DateTime>?time, Common.Enums.IntegralWay?way, Guid?accountId, Common.Enums.ExchangeState state, Common.Enums.OEMCommodityState?oemstate, string falg, Guid?oemId, Pagination pagination) { List <IntegralConsumptionView> result = null; var fields = " [ID] ,[CompnayId] ,[AccountNo] ,[AccountName],[AccountPhone],[DeliveryAddress],[ExpressCompany],[ExpressDelivery],[ConsumptionIntegral],[CommodityId],[CommodityName],[ExchangeTiem],[Exchange],[IntegralWay],[CommodityCount],[Remark],[Reason],[CompanyShortName],OEMCommodityState,OEMName "; string iCondition = " "; var catelog = "[dbo].[T_IntegralConsumption]"; var orderbyFiled = "ExchangeTiem desc"; if (oemstate.HasValue) { iCondition += " OEMCommodityState = " + (byte)oemstate + " AND "; } if (oemId.HasValue) { iCondition += " OEMID = '" + oemId.Value + "' AND "; } iCondition += " CONVERT(DATE,[ExchangeTiem]) >= '" + time.Value.Lower.Date + "'"; iCondition += " AND convert(date,[ExchangeTiem]) <= '" + time.Value.Upper.Date + "'"; if (falg == "1") { if (way != Common.Enums.IntegralWay.All) { iCondition += " AND (IntegralWay = " + (byte)way + " OR IntegralWay = " + (byte)IntegralWay.ExchangeSms + " )"; } } else { if (way != Common.Enums.IntegralWay.All) { iCondition += " AND IntegralWay = " + (byte)way + " "; } } if (accountId != null) { iCondition += " AND CompnayId = '" + accountId + "'"; } else if (state != Common.Enums.ExchangeState.All) { iCondition += " AND Exchange = " + (byte)state; } AddParameter("@iField", fields); AddParameter("@iCatelog", catelog); AddParameter("@iCondition", iCondition); AddParameter("@iOrderBy", orderbyFiled); AddParameter("@iPagesize", pagination.PageSize); AddParameter("@iPageIndex", pagination.PageIndex); AddParameter("@iGetCount", pagination.GetRowCount); var totalCount = AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (var reader = ExecuteReader("dbo.P_Pagination", System.Data.CommandType.StoredProcedure)) { result = new List <IntegralConsumptionView>(); while (reader.Read()) { IntegralConsumptionView view = new IntegralConsumptionView(); view.Id = reader.GetGuid(0); view.CompnayId = reader.GetGuid(1); view.AccountNo = reader.GetString(2); view.AccountName = reader.GetString(3); view.AccountPhone = reader.GetString(4); view.DeliveryAddress = reader.GetString(5); view.ExpressCompany = reader.GetString(6); view.ExpressDelivery = reader.GetString(7); view.ConsumptionIntegral = reader.GetInt32(8); view.CommodityId = reader.GetGuid(9); view.CommodityName = reader.GetString(10); view.ExchangeTiem = reader.GetDateTime(11); view.Exchange = (ChinaPay.B3B.Common.Enums.ExchangeState)reader.GetByte(12); view.Way = (ChinaPay.B3B.Common.Enums.IntegralWay)reader.GetByte(13); view.CommodityCount = reader.GetInt32(14); view.Remark = reader.GetString(15); view.Reason = reader.GetString(16); view.CompanyShortName = reader.GetString(17); view.OEMCommodityState = (OEMCommodityState)reader.GetByte(18); view.OEMName = reader.GetString(19); result.Add(view); } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } return(result); }
/// <summary> /// 查询用户积分信息列表 /// </summary> /// <param name="time"></param> /// <param name="way"></param> /// <returns></returns> public static IEnumerable <DataTransferObject.Integral.IntegralInfoView> GetIntegralList(Core.Range <DateTime>?time, Guid?companyId, Common.Enums.IntegralWay?way, Pagination pagination) { using (var cmd = Factory.CreateCommand()) { var reposity = Factory.CreateIntegralReposity(cmd); return(reposity.GetIntegralList(time, companyId, way, pagination)); } }
public IEnumerable <DataTransferObject.Integral.IntegralInfoView> GetIntegralList(Core.Range <DateTime>?time, Guid?accountID, Common.Enums.IntegralWay?way, Pagination pagination) { List <IntegralInfoView> result = null; var fields = " [CompnayId] ,[Integral] ,[IntegralWay] ,[AccessTime] ,[Remark] "; string iCondition = " "; var catelog = "[dbo].[T_IntegralInfo]"; var orderbyFiled = " AccessTime desc"; iCondition += " convert(date,[AccessTime]) >= '" + time.Value.Lower.Date + "'"; iCondition += " AND convert(date,[AccessTime]) <= '" + time.Value.Upper.Date + "'"; if (way != Common.Enums.IntegralWay.All) { iCondition += " AND IntegralWay = " + (byte)way; } if (accountID != null) { iCondition += " AND CompnayId = '" + accountID + "'"; } AddParameter("@iField", fields); AddParameter("@iCatelog", catelog); AddParameter("@iCondition", iCondition); AddParameter("@iOrderBy", orderbyFiled); AddParameter("@iPagesize", pagination.PageSize); AddParameter("@iPageIndex", pagination.PageIndex); AddParameter("@iGetCount", pagination.GetRowCount); var totalCount = AddParameter("@oTotalCount"); totalCount.DbType = System.Data.DbType.Int32; totalCount.Direction = System.Data.ParameterDirection.Output; using (var reader = ExecuteReader("dbo.P_Pagination", System.Data.CommandType.StoredProcedure)) { result = new List <IntegralInfoView>(); while (reader.Read()) { IntegralInfoView view = new IntegralInfoView(); view.CompnayId = reader.GetGuid(0); view.Integral = reader.GetInt32(1); view.IntegralWay = (Common.Enums.IntegralWay)reader.GetByte(2); view.AccessTime = reader.GetDateTime(3); view.Remark = reader.GetString(4); result.Add(view); } } if (pagination.GetRowCount) { pagination.RowCount = (int)totalCount.Value; } return(result); }