/// <summary>
/// 修改同步时间
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public int AddUserLastSyncTime(LastSyncTimeModel model)
{
//查找用户当前淘宝账号是否存在指定的商品未同步
//存在则更新，否则添加
var data = FindByUserLastSyncTime(model.userid, model.taobaousername);
string strSql = "";
if (data == null)
{
strSql = @"insert into sync_datetime(taobaousername,userid,datetime) values(@taobaousername,@userid,@datetime);select last_insert_rowid();";
}
else
{
strSql = @"UPDATE sync_datetime SET datetime=@datetime WHERE userid=@userid and taobaousername=@taobaousername;";
}
var param = new[] {
new SQLiteParameter("@userid", model.userid),
new SQLiteParameter("@taobaousername", model.taobaousername),
new SQLiteParameter("@datetime", model.datetime)
};
return(DBHelper.ExecuteSql(strSql, param));
}
/// <summary>
/// 修改同步时间
/// </summary>
/// <param name="model">The model.</param>
/// <returns>System.Int32.</returns>
public int AddUserLastSyncTime(LastSyncTimeModel model)
{
return(dal.AddUserLastSyncTime(model));
}
