/// <summary>
/// 查询全部数据报表
/// </summary>
/// <returns></returns>
public async Task <List <ShopReportData> > GetShopReportAsync()
{
EnsureConnectionOpen();
//using (var command = CreateCommand("select * from ShopReportData", CommandType.Text))
using (var command = CreateCommand("USP_GetShopReportDate", CommandType.StoredProcedure))
{
using (var dataReader = await command.ExecuteReaderAsync())
{
var result = new List <ShopReportData>();
while (dataReader.Read())
{
var shopReportData = new ShopReportData();
shopReportData.RootId = (int)dataReader["RootId"];
shopReportData.CompanyId = (int)dataReader["CompanyId"];
shopReportData.AreaId = (int)dataReader["AreaId"];
shopReportData.SlsmanNameId = (int)dataReader["SlsmanNameId"];
shopReportData.GroupNum = (int)dataReader["GroupNum"];
shopReportData.Organization = dataReader["Organization"].ToString();
shopReportData.ShopTotal = (int?)dataReader["ShopTotal"];
shopReportData.ScanQuantity = (int?)dataReader["ScanQuantity"];
shopReportData.ScanFrequency = (int?)dataReader["ScanFrequency"];
shopReportData.PriceTotal = (decimal)dataReader["PriceTotal"];
shopReportData.CustIntegral = (int?)dataReader["CustIntegral"];
shopReportData.RetailerIntegral = (int?)dataReader["RetailerIntegral"];
//shopReportData.CreationTime = (DateTime?)dataReader["CreationTime"];
result.Add(shopReportData);
}
return(result);
}
}
}
/// <summary>
/// 根据时间范围查询数据报表
/// </summary>
/// <param name="BeginTime"></param>
/// <param name="EndTime"></param>
/// <returns></returns>
public async Task <List <ShopReportData> > GetShopReportByRangeAsync(DateTime BeginTime, DateTime EndTime)
{
EnsureConnectionOpen();
SqlParameter[] sql = new SqlParameter[]
{
new SqlParameter("@BeginDate", BeginTime),
new SqlParameter("@EndDate", EndTime)
};
using (var command = CreateCommand("USP_GetShopReportDateByRange", CommandType.StoredProcedure, sql))
{
using (var dataReader = await command.ExecuteReaderAsync())
{
var result = new List <ShopReportData>();
while (dataReader.Read())
{
var shopReportData = new ShopReportData();
shopReportData.RootId = (int)dataReader["RootId"];
shopReportData.CompanyId = (int)dataReader["CompanyId"];
shopReportData.AreaId = (int)dataReader["AreaId"];
shopReportData.SlsmanNameId = (int)dataReader["SlsmanNameId"];
shopReportData.GroupNum = (int)dataReader["GroupNum"];
shopReportData.Organization = dataReader["Organization"].ToString();
shopReportData.ShopTotal = (int?)dataReader["ShopTotal"];
shopReportData.ScanQuantity = (int?)dataReader["ScanQuantity"];
shopReportData.ScanFrequency = (int?)dataReader["ScanFrequency"];
shopReportData.PriceTotal = (decimal)dataReader["PriceTotal"];
shopReportData.CustIntegral = (int?)dataReader["CustIntegral"];
shopReportData.RetailerIntegral = (int?)dataReader["RetailerIntegral"];
//shopReportData.CreationTime = (DateTime?)dataReader["CreationTime"];
result.Add(shopReportData);
}
return(result);
}
}
}
