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