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