/// <summary> /// 修改数据 /// </summary> public void Update() { SqlDb db = new SQLiteDb(_connString); db.IsShowSqlToConsole = _isShowSqlToConsole; var dbFactory = db.DbBuilder.DbFactory; var dbOperator = dbFactory.GetDbParamOperator(); //根据修改字段参数及值、过滤SQL、过滤参数修改数据 var result = db.Update <UserInfo>(new { UserName = "******" }, "UserId=4", null); result = db.Update <UserInfo>(new { UserName = "******" }, string.Format("UserId={0}UserId", dbOperator), new { UserId = 4 }); }
public setting SetValue(SQLiteDb db, setting value, bool force) { // first check if the value is present setting s = GetValue(db, value.Name, value.SType, value.Group); bool hasValue = s != null; if (force) { s.Value = value.Value; Logger.LogG("Force Value: ID", s.ID.ToString()); Logger.LogG("Force Value", s.Value); } string q = hasValue ? @"UPDATE [settings] SET [name] = @name, [type] = @type, [value] = @value, [desc] = @desc, [grp] = @grp, [gid] = @gid WHERE [id] = @xid;" : @"INSERT INTO [settings] ( [name],[type],[value],[desc],[grp],[gid] ) VALUES ( @name, @type, @value, @desc, @grp, @gid );"; // our insert statement if (hasValue) { using (DataSet ds = db.Update(Context.TableName, q, s.AdapterUpdate, s.FillOperation)) { if (ds.Tables.Count == 0) { } // else // if (ds.Tables[0].Rows.Count == 1) s = new setting(ds.Tables[Context.TableName].DefaultView[0]); } } else { using (DataSet ds = db.Insert(Context.TableName, q, s.AdapterInsert, s.FillOperation)) { // if (ds.Tables.Count==0) MessageBox.Show(q, "there wasn't a table!"); // else //if (ds.Tables[0].Rows.Count == 1) s = new setting(ds.Tables[Context.TableName].DefaultView[0]); } } return(s); }
/// <inheritdoc/> public override DataSet Update(string q) { data.Tables.Clear(); using (SQLiteDb db = new SQLiteDb(datafile)) data = db.Update(Context.TableName, q, AdapterUpdate, FillUpdate); return(data); }