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