public int ModifyProduct(FetchDataInfo product)
{
const string SQL = "update lmShop_FetchData set goodsname=@goodsname,GoodsPrice=@GoodsPrice,GoodsUrl=@GoodsUrl,LastUpdateTime=@date,IsChecked=@IsChecked where Id=@Id";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
Id = product.Id,
GoodsName = product.GoodsName,
GoodsPrice = product.GoodsName,
GoodsUrl = product.GoodsUrl,
GoodsGuId = product.GoodsId,
SiteId = product.SiteId,
date = product.LastUpdateTime,
IsChecked = product.IsChecked,
}));
}
}
public int AddProduct(FetchDataInfo product)
{
const string SQL = "INSERT lmShop_FetchData([GoodsName],[GoodsPrice],[GoodsUrl],[GoodsGuId],[SiteId],[LastUpdateTime],IsChecked) VALUES(@GoodsName,@GoodsPrice,@GoodsUrl,@GoodsGuId,@SiteId,@date,@IsChecked)";
using (SqlConnection conn = Databases.GetSqlConnection(GlobalConfig.ERP_DB_NAME, false))
{
return(conn.Execute(SQL, new
{
Id = product.Id,
GoodsName = product.GoodsName,
GoodsPrice = product.GoodsName,
GoodsUrl = product.GoodsUrl,
GoodsGuId = product.GoodsId,
SiteId = product.SiteId,
date = product.LastUpdateTime,
IsChecked = product.IsChecked,
}));
}
}
