public int Update(AlterArgs args)
{
ExecArgs ea = ArgsHelper.Update("Record", args);
int count = ExecEditor(ea.Text, ea.Type, ea.Param);
return(count);
}
public static ExecArgs Update(string table, AlterArgs args)
{
SQLiteParameter[] param = null;
string set = string.Empty;
if (args != null && args.Length > 0)
{
param = new SQLiteParameter[args.Length];
for (int i = 0; i < args.Length; i++)
{
param[i] = new SQLiteParameter(args[i].Name, args[i].Value);
if (!args.Where.Contains(args[i].Name))
{
set += string.Format("{0}=@{0},", args[i].Name);
}
}
set = set.Remove(set.Length - 1);
}
string cmdText = string.Format("Update {0} Set {1} Where {2}", table, set, args?.Where);
ExecArgs ea = new ExecArgs()
{
Text = cmdText,
Type = CommandType.Text,
Param = param
};
return(ea);
}
public int Delete(AlterArgs args)
{
ExecArgs ea = ArgsHelper.Delete("Config", args);
int count = this.ExecEditor(ea.Text, ea.Type, ea.Param);
return(count);
}
public static ExecArgs Delete(string table, AlterArgs args)
{
SQLiteParameter[] param = null;
if (args != null && args.Length > 0)
{
param = new SQLiteParameter[args.Length];
for (int i = 0; i < args.Length; i++)
{
param[i] = new SQLiteParameter(args[i].Name, args[i].Value);
}
}
string cmdText = string.Format("Delete From {0} Where {1}", table, args?.Where);
ExecArgs ea = new ExecArgs()
{
Text = cmdText,
Type = CommandType.Text,
Param = param
};
return(ea);
}
public int Update <T>(T tag, AlterArgs args)
{
throw new NotImplementedException();
}
public int Update(AlterArgs args)
{
ExecArgs ea = ArgsHelper.Update("Config", args);
return(ExecEditor(ea.Text, ea.Type, ea.Param));
}
