public long Insert(EBItem item)
{
using (var db = new EbItemDbContext())
{
db.EBItems.Add(item);
db.SaveChanges();
}
return item.Id;
}
public void SendMail(EBItem ebItem)
{
if (ebItem != null)
{
if (ebItem.Price > 0)//新数据价格大于0
{
var dataAccess = DataAccessFactory.GetDataAccess((DataSourceEnum)Enum.Parse(typeof(DataSourceEnum), AppConfigHelper.DataSourceType));
var item = dataAccess.GetLastestItemBySkuid(ebItem.Skuid, ebItem.ElectricBusiness);
if (item != null && item.Price > 0)//原数据价格大于0
{
var range = (Math.Abs(item.Price - ebItem.Price) / item.Price) * 100;
if (range > Convert.ToInt32(AppConfigHelper.PriceAdjustmentRange))
{
var type = item.Price - ebItem.Price > 0 ? "降价" : "加价";
var title = string.Format("[{0}]{1}{2}{3}%", item.ElectricBusiness, item.Name, type, range.ToString("f2"));
var mailContent = string.Format("产品ID:{0}<br/>产品名称:{1}<br/>商家:{2}<br/>商品链接:<a href='{3}' target='_blank'>{4}</a><br/><strong style='color:red'>{5}幅度：{6}%</strong><br/><strong style='color:red'>价格：{7}RMB</strong>",
item.Skuid, item.Name, item.ElectricBusiness, item.ProductUrl, item.Name, type, range.ToString("f2"), ebItem.Price.ToString("f2"));
NetSendMail.MailSend(AppConfigHelper.MailFrom, AppConfigHelper.MailFromAccount, AppConfigHelper.MailFromPwd, AppConfigHelper.MailSmtpServer, mailTo: new List<string> { AppConfigHelper.MailTo }, mailCC: new List<string>(), mailBCC: new List<string>(), mailTitle: title, mailContent: mailContent, mailAttachments: new List<string>(), encoding: Encoding.UTF8, isBodyHtml: true);
}
}
}
}
}
public long Insert(EBItem item)
{
using (MySqlConnection conn = OpenConnection())
{
const string query = "insert into EBItems(CreateTime,UpdateTime,Skuid,Name,Price,PriceDesc,Gift,PromotionDesc,ProductUrl,ElectricBusiness) values(@CreateTime,@UpdateTime,@Skuid,@name,@Price,@PriceDesc,@Gift,@PromotionDesc,@ProductUrl,@ElectricBusiness)";
int row = conn.Execute(query, item);
//更新对象的Id为数据库里新增的Id,假如增加之后不需要获得新增的对象，
//只需将对象添加到数据库里，可以将下面的一行注释掉。
SetIdentity(conn, id => item.Id = id, "id", "EBItems");
return item.Id;
}
}
