Viewing 1 post (of 1 total)
  • Author
    Posts
  • #36884
    Pioneer Software
    Keymaster

    This example script can be used on the frmEditorPatient – OnAfterLoadScreen event to display some information in a MessageBox when a patient record is loaded.

    using System.Collections.Generic;
    
    using System.Data;
    
    frmEditorBaseRec Editor = (Params[0] as frmEditorBaseRec);
    
    cPer per = (Editor.Record as cPer);
    
    cDBBaseRec custom = (Editor.Records[1]);
    
    DataTable tbl = cGlobals.DB.GetCannedTable("select count(*) from app where per_id=" + per.id);
    
    if (tbl.Rows.Count > 0)
    
    {
    
    int num_appts = Convert.ToInt32(tbl.Rows[0][0]);
    
    PSDevEx.cMessages.InformationBox("This patient has " + num_appts + " appointment(s)");
    
    }
Viewing 1 post (of 1 total)
  • You must be logged in to reply to this topic.