public static int Update <T>(this DbAccessor db, object objParameters)
{
var mapping = new TableMapping(typeof(T));
mapping.FilterColumn(objParameters);
ISqlBuilder sqlBuilder = new DefaultSqlBuilder(mapping);
return(db.ExecuteNonQuery(sqlBuilder.BuildUpdate(), objParameters));
}
public static int UpdateFields(this DbAccessor db, object objEntity, params string[] inclusiveFields)
{
List <string> lsInclusiveFields = new List <string>();
lsInclusiveFields.AddRange(inclusiveFields);
var mapping = new TableMapping(objEntity.GetType());
foreach (var item in mapping.GetKeyColumns())
{
lsInclusiveFields.Add(item.ColumnName);
}
mapping.FilterColumn(lsInclusiveFields.ToArray());
ISqlBuilder sqlBuilder = new DefaultSqlBuilder(mapping);
return(db.ExecuteNonQuery(sqlBuilder.BuildUpdate(), objEntity));
}
public void TableMapping()
{
TableMapping table = new TableMapping(typeof(SysProduct));
Console.WriteLine(table.TableName);
foreach (var col in table.Columns)
{
Console.WriteLine(col.ColumnName + " " + col.IsPrimaryKey);
}
DefaultSqlBuilder sqlb = new DefaultSqlBuilder(table);
Console.WriteLine(sqlb.BuildDelete());
Console.WriteLine(sqlb.BuildInsert());
Console.WriteLine(sqlb.BuildUpdate());
}
public static int Update(this DbAccessor db, object objEntity)
{
ISqlBuilder sqlBuilder = new DefaultSqlBuilder(new TableMapping(objEntity.GetType()));
return(db.ExecuteNonQuery(sqlBuilder.BuildUpdate(), objEntity));
}