private void FillMain()
{
DateTime dateFrom = PIn.PDate(textDateFrom.Text);
DateTime dateTo = PIn.PDate(textDateTo.Text);
table = Appointments.GetConfirmList(dateFrom, dateTo);
int scrollVal = grid.ScrollValue;
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col = new ODGridColumn(Lan.g("TableConfirmList", "Date Time"), 70);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Patient"), 80);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Age"), 30);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Contact"), 150);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Addr/Ph Note"), 100);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Status"), 80); //confirmed
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Procs"), 110);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Medical"), 80);
grid.Columns.Add(col);
col = new ODGridColumn(Lan.g("TableConfirmList", "Appt Note"), 204);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
ODGridCell cell;
for (int i = 0; i < table.Rows.Count; i++)
{
row = new ODGridRow();
//aptDateTime=PIn.PDateT(table.Rows[i][4].ToString());
row.Cells.Add(table.Rows[i]["aptDateTime"].ToString());
//aptDateTime.ToShortDateString()+"\r\n"+aptDateTime.ToShortTimeString());
row.Cells.Add(table.Rows[i]["patientName"].ToString());
row.Cells.Add(table.Rows[i]["age"].ToString());
row.Cells.Add(table.Rows[i]["contactMethod"].ToString());
row.Cells.Add(table.Rows[i]["AddrNote"].ToString());
row.Cells.Add(table.Rows[i]["confirmed"].ToString());
row.Cells.Add(table.Rows[i]["ProcDescript"].ToString());
cell = new ODGridCell(table.Rows[i]["medNotes"].ToString());
cell.ColorText = Color.Red;
row.Cells.Add(cell);
row.Cells.Add(table.Rows[i]["Note"].ToString());
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollValue = scrollVal;
}
private void FillMain(){
DateTime dateFrom=PIn.Date(textDateFrom.Text);
DateTime dateTo=PIn.Date(textDateTo.Text);
long provNum=0;
if(comboProv.SelectedIndex!=0) {
provNum=ProviderC.ListShort[comboProv.SelectedIndex-1].ProvNum;
}
long clinicNum=0;
if(comboClinic.SelectedIndex > 0) {
clinicNum=Clinics.List[comboClinic.SelectedIndex-1].ClinicNum;
}
bool showRecalls=false;
bool showNonRecalls=false;
if(comboShowRecall.SelectedIndex==0 || comboShowRecall.SelectedIndex==1) {//All or Recall Only
showRecalls=true;
}
if(comboShowRecall.SelectedIndex==0 || comboShowRecall.SelectedIndex==2) {//All or Exclude Recalls
showNonRecalls=true;
}
Table=Appointments.GetConfirmList(dateFrom,dateTo,provNum,clinicNum,showRecalls,showNonRecalls);
int scrollVal=grid.ScrollValue;
grid.BeginUpdate();
grid.Columns.Clear();
ODGridColumn col=new ODGridColumn(Lan.g("TableConfirmList","Date Time"),70);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Patient"),80);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Age"),30);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Contact"),150);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Addr/Ph Note"),100);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Status"),80);//confirmed
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Procs"),110);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Medical"),80);
grid.Columns.Add(col);
col=new ODGridColumn(Lan.g("TableConfirmList","Appt Note"),204);
grid.Columns.Add(col);
grid.Rows.Clear();
ODGridRow row;
ODGridCell cell;
for(int i=0;i<Table.Rows.Count;i++){
row=new ODGridRow();
//aptDateTime=PIn.PDateT(table.Rows[i][4].ToString());
row.Cells.Add(Table.Rows[i]["aptDateTime"].ToString());
//aptDateTime.ToShortDateString()+"\r\n"+aptDateTime.ToShortTimeString());
row.Cells.Add(Table.Rows[i]["patientName"].ToString());
row.Cells.Add(Table.Rows[i]["age"].ToString());
row.Cells.Add(Table.Rows[i]["contactMethod"].ToString());
row.Cells.Add(Table.Rows[i]["AddrNote"].ToString());
row.Cells.Add(Table.Rows[i]["confirmed"].ToString());
row.Cells.Add(Table.Rows[i]["ProcDescript"].ToString());
cell=new ODGridCell(Table.Rows[i]["medNotes"].ToString());
cell.ColorText=Color.Red;
row.Cells.Add(cell);
row.Cells.Add(Table.Rows[i]["Note"].ToString());
grid.Rows.Add(row);
}
grid.EndUpdate();
grid.ScrollValue=scrollVal;
}
