/// <summary>
/// 添加同步商品到本地数据库
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public int AddUserSyncGoods(SyncGoodsList model)
{
//查找用户当前淘宝账号是否存在指定的商品未同步
//存在则更新，否则添加
var data = FindByUserSyncGoodsInfo(model.goodsId, model.userid, model.taobaousername);
string strSql = "";
if (data == null)
{
strSql = @"insert into sync_goods_list(userid,taobaousername,goodsId,url) values(@userid,@taobaousername,@goodsId,@url);select last_insert_rowid();";
var param = new[] {
new SQLiteParameter("@userid", model.userid),
new SQLiteParameter("@taobaousername", model.taobaousername),
new SQLiteParameter("@goodsId", model.goodsId),
new SQLiteParameter("@url", model.url)
};
return(DBHelper.ExecuteSql(strSql, param));
}
else
{
strSql = @"UPDATE sync_goods_list SET url=@url WHERE id = @id;";
var param = new[] {
new SQLiteParameter("@id", data.id),
new SQLiteParameter("@url", model.url)
};
return(DBHelper.ExecuteSql(strSql, param));
}
}
/// <summary>
/// 打开计划页面
/// </summary>
/// <param name="url">The URL.</param>
public void GoPlanPage(SyncGoodsList item)
{
if (!string.IsNullOrEmpty(item.url))
{
goods = item;
isLoadPlanCompleted = false;
planUrl = item.url.Trim();
browser.Load(planUrl);
}
else
{
isLoadPlanCompleted = true;
//提交完成
SubmitSuccessHandle?.Invoke(false, goods);
}
}
/// <summary>
/// 添加同步商品到本地数据库
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public int AddUserSyncGoods(SyncGoodsList model)
{
return(dal.AddUserSyncGoods(model));
}
/// <summary>
/// 定向计划申请完成
/// </summary>
/// <param name="success">if set to true [success].</param>
/// <param name="data">The data.</param>
private void Lw_SubmitSuccessHandle(bool success, SyncGoodsList data)
{
SetText(string.Format("{0} 计划申请成功.", data.goodsId));
LogicSyncGoods.In(currentUserId).DeleteUserSyncGoods(data.goodsId, currentUserId, data.taobaousername);
isCompleted = true;
}
