Adding to Time Phase grid

[bw2868bond (Bernie Walker)]

@tmat

public class Script { // ** Wizard Insert Location - Do Not Remove ‘Begin/End Wizard Added Module Level Variables’ Comments! ** // Begin Wizard Added Module Level Variables ** private EpiDataView edvTimePhas; // End Wizard Added Module Level Variables ** // Add Custom Module Level Variables Here ** public void InitializeCustomCode() { // ** Wizard Insert Location - Do not delete ‘Begin/End Wizard Added Variable Initialization’ lines ** // Begin Wizard Added Variable Initialization // End Wizard Added Variable Initialization // Begin Wizard Added Custom Method Calls this.edvTimePhas = ((EpiDataView)(this.oTrans.EpiDataViews[“TimePhas”])); this.edvTimePhas.EpiViewNotification += new EpiViewNotification(this.edvTimePhas_EpiViewNotification); if (!(edvTimePhas.dataView.Table.Columns.Contains(“ParentPart”))) { edvTimePhas.dataView.Table.Columns.Add(new DataColumn(“ParentPart”)); edvTimePhas.dataView.Table.Columns[“ParentPart”].ExtendedProperties[“ReadOnly”] = true; } if (!(edvTimePhas.dataView.Table.Columns.Contains(“StartDate”))) { edvTimePhas.dataView.Table.Columns.Add(new DataColumn(“StartDate”)); edvTimePhas.dataView.Table.Columns[“StartDate”].ExtendedProperties[“ReadOnly”] = true; } // End Wizard Added Custom Method Calls } public void DestroyCustomCode() { // ** Wizard Insert Location - Do not delete ‘Begin/End Wizard Added Object Disposal’ lines ** // Begin Wizard Added Object Disposal this.edvTimePhas.EpiViewNotification -= new EpiViewNotification(this.edvTimePhas_EpiViewNotification); this.edvTimePhas = null; // End Wizard Added Object Disposal // Begin Custom Code Disposal // End Custom Code Disposal } private void edvTimePhas_EpiViewNotification(EpiDataView view, EpiNotifyArgs args) { // ** Argument Properties and Uses ** // view.dataView[args.Row][“FieldName”] // args.Row, args.Column, args.Sender, args.NotifyType // NotifyType.Initialize, NotifyType.AddRow, NotifyType.DeleteRow, NotifyType.InitLastView, NotifyType.InitAndResetTreeNodes if ((args.NotifyType == EpiTransaction.NotifyType.AddRow)) { if ((args.Row > -1)) { foreach (DataRowView drV in edvTimePhas.dataView) { DataRow dr = drV.Row; string parentPart = String.Empty; string startDate = String.Empty; if (string.IsNullOrEmpty(Convert.ToString(dr[“JobNum”])) == false) { bool recordSelected; bool showSearch = false; string whereClause = “JobNum = '” + dr[“JobNum”].ToString() + “'”; DataSet dsJobInfo = SearchFunctions.listLookup(TimePhasForm, “JobAsmSearchAdapter”,out recordSelected, showSearch, whereClause); if (recordSelected) { parentPart = dsJobInfo.Tables[0].Rows[0][“PartNum”].ToString(); startDate = ((DateTime)dsJobInfo.Tables[0].Rows[0][“StartDate”]).ToShortDateString(); } else { parentPart = “”; startDate = “”; } } dr[“ParentPart”] = parentPart; dr[“StartDate”] = startDate; } } { } } } }

Change “AddRow” to “Initialize” in the epi view notification event handler…