Class DbCmdInsert

Namespace

PHCDataLayer

Assembly

PHCDataLayer.dll

public class DbCmdInsert : DbCmd, IBaseSerialization, ICloneVO, ICloneable

Inheritance

object

BaseVO

CloneVO

DbCmd

DbCmdInsert

Constructors

DbCmdInsert()

In this way the class outside the dll can only be used with Inherits, but inside it can be used with New

protected DbCmdInsert()

Properties

Fields

public List<FieldStructure> Fields { get; set; }

Property Value

List<FieldStructure>

FilterItems

public FilterItems FilterItems { get; set; }

Property Value

FilterItems

FromAliasName

public string FromAliasName { get; set; }

Property Value

string

FromTableName

public string FromTableName { get; set; }

Property Value

string

InsertByFrom

public bool InsertByFrom { get; set; }

Property Value

bool

JoinEntities

public JoinEntities JoinEntities { get; set; }

Property Value

JoinEntities

Values

public List<object> Values { get; set; }

Property Value

List<object>

Methods

AddField(FieldStructure, object)

public void AddField(FieldStructure field, object value)

Parameters

Nome	Tipo	Descrição
field	FieldStructure
value	object

AddFields(GenericVO)

public DbCmdInsert AddFields(GenericVO item)

Parameters

Nome	Tipo	Descrição
item	GenericVO

Returns

DbCmdInsert

AddFields(VOStructure, string)

public DbCmdInsert AddFields(VOStructure structItem, string table_alias = "")

Parameters

Nome	Tipo	Descrição
structItem	VOStructure
table_alias	string

Returns

DbCmdInsert

AddFields(List<FieldStructure>, List<object>)

public void AddFields(List<FieldStructure> fields, List<object> values)

Parameters

Nome	Tipo	Descrição
fields	List<FieldStructure>
values	List<object>

AddJoin(string, string, JoinsType)

public JoinEntity AddJoin(string tableName, string aliasName = "", JoinsType _joinType = JoinsType.Inner)

Parameters

Nome	Tipo	Descrição
tableName	string
aliasName	string
_joinType	JoinsType

Returns

JoinEntity

GetCommand()

public override SqlCommand GetCommand()

Returns

SqlCommand

GetFieldsValues(GenericVO, List<string>, VOStructure)

public List<object> GetFieldsValues(GenericVO item, List<string> names, VOStructure structureItem)

Parameters

Nome	Tipo	Descrição
item	GenericVO
names	List<string>
structureItem	VOStructure

Returns

List<object>

RequireTransaction()

public override bool RequireTransaction()

Returns

bool