/// <summary>
/// 获取跨店抢单骑士统计信息
/// 胡灵波-20150124
/// </summary>
/// <param name="daysAgo">几天前</param>
/// <returns></returns>
public bool InsertDataCrossShopStatisticLog(int daysAgo)
{
IList <Ets.Model.DomainModel.Business.BusinessesDistributionModel> clienteStorerGrabStatistical = clienterDao.GetClienteStorerGrabStatisticalInfo(daysAgo);
CrossShopStatisticLogModel model = new CrossShopStatisticLogModel();
foreach (var item in clienteStorerGrabStatistical)
{
bool isExist = _dao.IsExistCrossShopStatisticLog(item.date);
if (isExist)
{
continue;
}
model.TotalAmount = item.totalAmount;
model.OnceCount = item.c1;
model.TwiceCount = item.c2;
model.ThreeTimesCount = item.c3;
model.FourTimesCount = item.c4;
model.FiveTimesCount = item.c5;
model.SixTimesCount = item.c6;
model.SevenTimesCount = item.c7;
model.EightTimesCount = item.c8;
model.NineTimesCount = item.c9;
model.ExceedNineTimesCount = item.c10;
model.OncePrice = item.a1;
model.TwicePrice = item.a1;
model.ThreeTimesPrice = item.a1;
model.FourTimesPrice = item.a1;
model.FiveTimesPrice = item.a1;
model.SixTimesPrice = item.a1;
model.SevenTimesPrice = item.a1;
model.EightTimesPrice = item.a1;
model.NineTimesPrice = item.a1;
model.ExceedNineTimesPrice = item.a1;
model.CreateTime = DateTime.Now;
model.StatisticalTime = Convert.ToDateTime(item.date);
//using (IUnitOfWork tran = EdsUtilOfWorkFactory.GetUnitOfWorkOfEDS())
//{
_dao.InsertDataCrossShopStatisticLogLog(model);
// tran.Complete();
//}
}
return(true);
}
/// <summary>
/// 新增跨店抢单骑士统计
/// 胡灵波
/// 2015年4月24日 15:30:11
/// </summary>
/// <param name="model">跨店抢单骑士实体</param>
/// <returns></returns>
public bool InsertDataCrossShopStatisticLogLog(CrossShopStatisticLogModel model)
{
string sql = @"INSERT INTO [dbo].[CrossShopStatisticLog]
([TotalAmount]
,[OnceCount]
,[TwiceCount]
,[ThreeTimesCount]
,[FourTimesCount]
,[FiveTimesCount]
,[SixTimesCount]
,[SevenTimesCount]
,[EightTimesCount]
,[NineTimesCount]
,[ExceedNineTimesCount]
,[OncePrice]
,[TwicePrice]
,[ThreeTimesPrice]
,[FourTimesPrice]
,[FiveTimesPrice]
,[SixTimesPrice]
,[SevenTimesPrice]
,[EightTimesPrice]
,[NineTimesPrice]
,[ExceedNineTimesPrice]
,[CreateTime]
,[StatisticalTime])
VALUES
(@TotalAmount
,@OnceCount
,@TwiceCount
,@ThreeTimesCount
,@FourTimesCount
,@FiveTimesCount
,@SixTimesCount
,@SevenTimesCount
,@EightTimesCount
,@NineTimesCount
,@ExceedNineTimesCount
,@OncePrice
,@TwicePrice
,@ThreeTimesPrice
,@FourTimesPrice
,@FiveTimesPrice
,@SixTimesPrice
,@SevenTimesPrice
,@EightTimesPrice
,@NineTimesPrice
,@ExceedNineTimesPrice
,@CreateTime
,@StatisticalTime)
";
IDbParameters parm = DbHelper.CreateDbParameters();
parm.AddWithValue("@TotalAmount", model.TotalAmount);
parm.AddWithValue("@OnceCount", model.OnceCount);
parm.AddWithValue("@TwiceCount", model.TwiceCount);
parm.AddWithValue("@ThreeTimesCount", model.ThreeTimesCount);
parm.AddWithValue("@FourTimesCount", model.FourTimesCount);
parm.AddWithValue("@FiveTimesCount", model.FiveTimesCount);
parm.AddWithValue("@SixTimesCount", model.SixTimesCount);
parm.AddWithValue("@SevenTimesCount", model.SevenTimesCount);
parm.AddWithValue("@EightTimesCount", model.EightTimesCount);
parm.AddWithValue("@NineTimesCount", model.NineTimesCount);
parm.AddWithValue("@ExceedNineTimesCount", model.ExceedNineTimesCount);
parm.AddWithValue("@OncePrice", model.OncePrice);
parm.AddWithValue("@TwicePrice", model.TwicePrice);
parm.AddWithValue("@ThreeTimesPrice", model.ThreeTimesPrice);
parm.AddWithValue("@FourTimesPrice", model.FourTimesPrice);
parm.AddWithValue("@FiveTimesPrice", model.FiveTimesPrice);
parm.AddWithValue("@SixTimesPrice", model.SixTimesPrice);
parm.AddWithValue("@SevenTimesPrice", model.SevenTimesPrice);
parm.AddWithValue("@EightTimesPrice", model.EightTimesPrice);
parm.AddWithValue("@NineTimesPrice", model.NineTimesPrice);
parm.AddWithValue("@ExceedNineTimesPrice", model.ExceedNineTimesPrice);
parm.AddWithValue("@CreateTime", model.CreateTime);
parm.AddWithValue("@StatisticalTime", model.StatisticalTime);
return(DbHelper.ExecuteNonQuery(SuperMan_Write, sql, parm) > 0 ? true : false);
}
