/// <summary>
/// 从 IDataReader 中恢复ProductInfo对象
/// </summary>
/// <param name="IDataReader"></param>
/// <returns></returns>
public ProductFavoriteMySqlInfo RecoverModel(IDataReader dataReader)
{
ProductFavoriteMySqlInfo productInfo = new ProductFavoriteMySqlInfo();
productInfo.ProductID = dataReader["ProductID"].ToInt();
productInfo.Price = dataReader["Price"].ToDecimal();
productInfo.UserID = dataReader["UserID"].ToInt();
productInfo.TradePrice = dataReader["TradePrice"].ToDecimal();
productInfo.ProductName = dataReader["ChineseName"].ToString();
return(productInfo);
}
/// <summary>
/// 收藏商品降价
/// </summary>
public void ProductReduce()
{
int level1 = 0;
int level2 = 0;
GetLevel(SectionSecondType.商品降价通知, ref level1, ref level2);
bool isUse = IsUseToTime(level2);//是否属于8点以后发送的
if (isUse)
{
IList <ProductFavoriteMySqlInfo> productInfoList = null;
try
{
productInfoList = productMysqlBLL.ProductMySql_GetAll();
PushLog("ProductFavorite收藏商品降价数据已获取,共" + productInfoList.Count + "条（未匹配推送表）!");
}
catch (Exception e)
{
PushLog("ProductFavorite收藏商品降价信息获取异常：" + e.Message);
}
if (productInfoList != null)
{
for (int j = 0; j < productInfoList.Count; j++)
{
ProductFavoriteMySqlInfo productInfo = productInfoList[j];
//验证此优惠是否已推送过
bool state = mobilePushBLL.MobilePush_IsExist(productInfo.UserID, level1, level2, productInfo.ProductID.ToString());
if (state)//已推送
{
continue;
}
else//if(state==false)//未推送
{
try
{
PushMessageInfo pushMessageInfo = new PushMessageInfo();
pushMessageInfo.ChannelID = 0;
pushMessageInfo.Contents = GetContentsByLevel2(level2, productInfo.ProductName, null);
pushMessageInfo.CreateTime = DateTime.Now;
pushMessageInfo.DataID = productInfo.ProductID.ToString();
pushMessageInfo.TypeID = level1;
pushMessageInfo.Section = level2;
pushMessageInfo.PushType = "single";
pushMessageInfo.Status = 0;
pushMessageInfo.TargetList = productInfo.UserID.ToString();
pushMessageInfo.Creator = "后台推送程序";
pushMessageInfo.PushCount = 0;
pushMessageInfo.Template = 1;
pushMessageInfo.Updater = "后台推送程序";
pushMessageInfo.UpdateTime = DateTime.Now;
//修改mysql中的推送状态
productMysqlBLL.ProductMySql_UpIsPush(productInfo.ProductID, productInfo.UserID, 1);
//写入推送表
mobilePushBLL.InsertMobilePush(pushMessageInfo);
}
catch (Exception e)
{
PushLog("ProductFavorite收藏商品降价数据插入异常：" + e.Message);
}
}
}
}
}
}
