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