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);
}
public DataTransferObject.Integral.IntegralInfoView GetIntegral(Guid id)
{
IntegralInfoView result = null;
string sql = @"SELECT [ID] ,[CompnayId] ,[Integral] ,[IntegralWay] ,[AccessTime] ,[Remark] FROM [dbo].[T_IntegralInfo] WHERE ID=@ID ";
AddParameter("ID", id);
using (var reader = ExecuteReader(sql))
{
if (reader.Read())
{
result = new IntegralInfoView();
result.CompnayId = reader.GetGuid(0);
result.Integral = reader.GetInt32(1);
result.IntegralWay = (Common.Enums.IntegralWay)reader.GetByte(2);
result.AccessTime = reader.GetDateTime(3);
result.Remark = reader.GetString(4);
}
}
return(result);
}
