public EzLookup ExistingChecksum(EzComponent attacher)
{
EzLookup component = new EzLookup(this);
component.AttachTo(attacher);
component.Name = "Lookup - Existing Checksum";
component.OleDbConnection = this.p.Conns["Commercial_PSA"];
component.SqlCommand = "select MatchKey, Checksum from dbo.[" + this.p.tableName() + "] where ActiveFlag ='Y'";
component.SetJoinCols("MatchKey,MatchKey");
component.SetPureCopyCols("Checksum");
return component;
}
public EzDerivedColumn AddAuditColumns(EzComponent attacher)
{
EzDerivedColumn component = new EzDerivedColumn(this);
component.AttachTo(attacher);
component.Name = "Add Audit Columns";
component.Expression["CreatedDate"] = "GETDATE()";
component.Expression["ActiveFlag"] = "(DT_STR,1,1252)\"Y\"";
return component;
}
