/// <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)); }