本文整理汇总了C#中OpenDentBusiness.Patient.GetNameLF方法的典型用法代码示例。如果您正苦于以下问题:C# Patient.GetNameLF方法的具体用法?C# Patient.GetNameLF怎么用?C# Patient.GetNameLF使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OpenDentBusiness.Patient
的用法示例。
在下文中一共展示了Patient.GetNameLF方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: FormEncounters_Load
public void FormEncounters_Load(object sender,EventArgs e) {
_patCur=Patients.GetPat(_encCur.PatNum);
this.Text+=" - "+_patCur.GetNameLF();
textDateEnc.Text=_encCur.DateEncounter.ToShortDateString();
_provNumSelected=_encCur.ProvNum;
comboProv.Items.Clear();
for(int i=0;i<ProviderC.ListShort.Count;i++) {
comboProv.Items.Add(ProviderC.ListShort[i].GetLongDesc());//Only visible provs added to combobox.
if(ProviderC.ListShort[i].ProvNum==_encCur.ProvNum) {
comboProv.SelectedIndex=i;//Sets combo text too.
}
}
if(_provNumSelected==0) {//Is new
comboProv.SelectedIndex=0;
_provNumSelected=ProviderC.ListShort[0].ProvNum;
}
if(comboProv.SelectedIndex==-1) {//The provider exists but is hidden
comboProv.Text=Providers.GetLongDesc(_provNumSelected);//Appends "(hidden)" to the end of the long description.
}
textNote.Text=_encCur.Note;
textCodeValue.Text=_encCur.CodeValue;
textCodeSystem.Text=_encCur.CodeSystem;
//to get description, first determine which table the code is from. Encounter is only allowed to be a CDT, CPT, HCPCS, and SNOMEDCT. Will be null if new encounter.
switch(_encCur.CodeSystem) {
case "CDT":
textCodeDescript.Text=ProcedureCodes.GetProcCode(_encCur.CodeValue).Descript;
break;
case "CPT":
Cpt cptCur=Cpts.GetByCode(_encCur.CodeValue);
if(cptCur!=null) {
textCodeDescript.Text=cptCur.Description;
}
break;
case "HCPCS":
Hcpcs hCur=Hcpcses.GetByCode(_encCur.CodeValue);
if(hCur!=null) {
textCodeDescript.Text=hCur.DescriptionShort;
}
break;
case "SNOMEDCT":
Snomed sCur=Snomeds.GetByCode(_encCur.CodeValue);
if(sCur!=null) {
textCodeDescript.Text=sCur.Description;
}
break;
case null:
textCodeDescript.Text="";
break;
default:
MsgBox.Show(this,"Error: Unknown code system");
break;
}
}
示例2: FormScreenPatEdit_Load
private void FormScreenPatEdit_Load(object sender,EventArgs e) {
if(IsNew) {
ScreenPatCur.SheetNum=PrefC.GetLong(PrefName.PublicHealthScreeningSheet);
}
PatCur=Patients.GetPat(ScreenPatCur.PatNum);
if(PatCur!=null) {
textPatient.Text=PatCur.GetNameLF();
}
if(ScreenGroupCur!=null) {
textScreenGroup.Text=ScreenGroupCur.Description;
}
ExamSheetDefCur=SheetDefs.GetSheetDef(ScreenPatCur.SheetNum);
if(ExamSheetDefCur!=null) {
textSheet.Text=ExamSheetDefCur.Description;
}
}
示例3: butReport_Click
private void butReport_Click(object sender, System.EventArgs e)
{
//if(errorProvider1.GetError(textDateFrom) != ""
// || errorProvider1.GetError(textDateTo) != "")
//{
// MsgBox.Show(this,"Please fix data entry errors first.");
// return;
//}
//DateTime dateFrom=PIn.PDate(textDateFrom.Text);
//DateTime dateTo=PIn.PDate(textDateTo.Text);
//if(dateTo < dateFrom)
//{
// MsgBox.Show(this,"To date cannot be before From date.");
// return;
//}
ReportLikeCrystal report=new ReportLikeCrystal();
report.ReportName=Lan.g(this,"PaymentPlans");
report.AddTitle(Lan.g(this,"Payment Plans"));
report.AddSubTitle(PrefC.GetString(PrefName.PracticeTitle));
report.AddSubTitle(DateTime.Today.ToShortDateString());
DataTable table=new DataTable();
//table.Columns.Add("date");
table.Columns.Add("guarantor");
table.Columns.Add("ins");
table.Columns.Add("princ");
table.Columns.Add("paid");
table.Columns.Add("due");
table.Columns.Add("dueTen");
DataRow row;
string datesql="CURDATE()";
if(DataConnection.DBtype==DatabaseType.Oracle){
datesql="(SELECT CURRENT_DATE FROM dual)";
}
string [email protected]"SELECT FName,LName,MiddleI,PlanNum,Preferred,
(SELECT SUM(Principal+Interest) FROM payplancharge WHERE payplancharge.PayPlanNum=payplan.PayPlanNum
AND ChargeDate <= "[email protected]") ""_accumDue"",
(SELECT SUM(Principal+Interest) FROM payplancharge WHERE payplancharge.PayPlanNum=payplan.PayPlanNum
AND ChargeDate <= "+DbHelper.DateAddDay(datesql,POut.Long(PrefC.GetLong(PrefName.PayPlansBillInAdvanceDays)))[email protected]") ""_dueTen"",
(SELECT SUM(SplitAmt) FROM paysplit WHERE paysplit.PayPlanNum=payplan.PayPlanNum) ""_paid"",
(SELECT SUM(Principal) FROM payplancharge WHERE payplancharge.PayPlanNum=payplan.PayPlanNum) ""_principal""
FROM payplan
LEFT JOIN patient ON patient.PatNum=payplan.Guarantor "
//WHERE SUBSTRING(Birthdate,6,5) >= '"+dateFrom.ToString("MM-dd")+"' "
//+"AND SUBSTRING(Birthdate,6,5) <= '"+dateTo.ToString("MM-dd")+"' "
+"GROUP BY FName,LName,MiddleI,Preferred,payplan.PayPlanNum ORDER BY LName,FName";
DataTable raw=Reports.GetTable(command);
//DateTime payplanDate;
Patient pat;
double princ;
double paid;
double accumDue;
double dueTen;
for(int i=0;i<raw.Rows.Count;i++){
princ=PIn.Double(raw.Rows[i]["_principal"].ToString());
paid=PIn.Double(raw.Rows[i]["_paid"].ToString());
accumDue=PIn.Double(raw.Rows[i]["_accumDue"].ToString());
dueTen=PIn.Double(raw.Rows[i]["_dueTen"].ToString());
row=table.NewRow();
//payplanDate=PIn.PDate(raw.Rows[i]["PayPlanDate"].ToString());
//row["date"]=raw.Rows[i]["PayPlanDate"].ToString();//payplanDate.ToShortDateString();
pat=new Patient();
pat.LName=raw.Rows[i]["LName"].ToString();
pat.FName=raw.Rows[i]["FName"].ToString();
pat.MiddleI=raw.Rows[i]["MiddleI"].ToString();
pat.Preferred=raw.Rows[i]["Preferred"].ToString();
row["guarantor"]=pat.GetNameLF();
if(raw.Rows[i]["PlanNum"].ToString()=="0"){
row["ins"]="";
}
else{
row["ins"]="X";
}
row["princ"]=princ.ToString("f");
row["paid"]=paid.ToString("f");
row["due"]=(accumDue-paid).ToString("f");
row["dueTen"]=(dueTen-paid).ToString("f");
table.Rows.Add(row);
}
report.ReportTable=table;
//report.AddColumn("Date",90,FieldValueType.Date);
report.AddColumn("Guarantor",160,FieldValueType.String);
report.AddColumn("Ins",40,FieldValueType.String);
report.GetLastRO(ReportObjectKind.TextObject).TextAlign=ContentAlignment.MiddleCenter;
report.GetLastRO(ReportObjectKind.FieldObject).TextAlign=ContentAlignment.MiddleCenter;
report.AddColumn("Princ",100,FieldValueType.String);
report.GetLastRO(ReportObjectKind.TextObject).TextAlign=ContentAlignment.MiddleRight;
report.GetLastRO(ReportObjectKind.FieldObject).TextAlign=ContentAlignment.MiddleRight;
report.AddColumn("Paid",100,FieldValueType.String);
report.GetLastRO(ReportObjectKind.TextObject).TextAlign=ContentAlignment.MiddleRight;
report.GetLastRO(ReportObjectKind.FieldObject).TextAlign=ContentAlignment.MiddleRight;
report.AddColumn("Due Now",100,FieldValueType.String);
report.GetLastRO(ReportObjectKind.TextObject).TextAlign=ContentAlignment.MiddleRight;
report.GetLastRO(ReportObjectKind.FieldObject).TextAlign=ContentAlignment.MiddleRight;
report.AddColumn("Due in "+PrefC.GetLong(PrefName.PayPlansBillInAdvanceDays).ToString()
+" Days",100,FieldValueType.String);
report.GetLastRO(ReportObjectKind.TextObject).TextAlign=ContentAlignment.MiddleRight;
report.GetLastRO(ReportObjectKind.FieldObject).TextAlign=ContentAlignment.MiddleRight;
//report.GetLastRO(ReportObjectKind.FieldObject).FormatString="d";
report.AddPageNum();
//report.SubmitQuery();
//.........这里部分代码省略.........
示例4: listFamily_Click
private void listFamily_Click(object sender,EventArgs e)
{
//Changes the patient to whoever was clicked in the list
long oldPatNum=PatCur.PatNum;
long newPatNum=FamCur.ListPats[listFamily.SelectedIndices[0]].PatNum;
if(newPatNum==oldPatNum){
return;
}
PatCur=FamCur.GetPatient(newPatNum);
Text=Lan.g(this,"Appointments for")+" "+PatCur.GetNameLF();
textApptModNote.Text=PatCur.ApptModNote;
Filltb();
CheckStatus();
}
示例5: GetAgingList
//.........这里部分代码省略.........
case "30":
command+=" AND (Bal_31_60 > '0' OR Bal_61_90 > '0' OR BalOver90 > '0' OR PayPlanDue > 0)";
break;
case "60":
command+=" AND (Bal_61_90 > '0' OR BalOver90 > '0' OR PayPlanDue > 0)";
break;
case "90":
command+=" AND (BalOver90 > '0' OR PayPlanDue > 0)";
break;
}
//if billingNums.Count==0, then we'll include all billing types
for(int i=0;i<billingNums.Count;i++){
if(i==0){
command+=" AND (billingtype = '";
}
else{
command+=" OR billingtype = '";
}
command+=POut.Long(billingNums[i])+"'";
//DefC.Short[(int)DefCat.BillingTypes][billingIndices[i]].DefNum.ToString()+"'";
if(i==billingNums.Count-1){
command+=")";
}
}
if(excludeAddr){
command+=" AND (zip !='')";
}
if(clinicNum>0) {
command+=" AND patient.ClinicNum="+clinicNum+" ";
}
command+=" GROUP BY patient.PatNum,Bal_0_30,Bal_31_60,Bal_61_90,BalOver90,BalTotal,BillingType,"
+"InsEst,LName,FName,MiddleI,PayPlanDue,Preferred "
+"HAVING (LastStatement < "+POut.Date(lastStatement.AddDays(1))+" ";//<midnight of lastStatement date
//+"OR PayPlanDue>0 ";we don't have a great way to trigger due to a payplancharge yet
if(includeChanged){
command+=
"OR LastChange > LastStatement "//eg '2005-10-25' > '2005-10-24 15:00:00'
+"OR LastPayment > LastStatement) ";
}
else{
command+=") ";
}
if(excludeInsPending){
command+="AND ClaimCount=0 ";
}
if(excludeIfUnsentProcs) {
command+="AND unsentProcCount_=0 ";
}
command+="ORDER BY LName,FName";
//Debug.WriteLine(command);
DataTable table=Db.GetTable(command);
List<PatAging> agingList=new List<PatAging>();
PatAging patage;
Patient pat;
for(int i=0;i<table.Rows.Count;i++){
patage=new PatAging();
patage.PatNum = PIn.Long (table.Rows[i]["PatNum"].ToString());
patage.Bal_0_30 = PIn.Double(table.Rows[i]["Bal_0_30"].ToString());
patage.Bal_31_60= PIn.Double(table.Rows[i]["Bal_31_60"].ToString());
patage.Bal_61_90= PIn.Double(table.Rows[i]["Bal_61_90"].ToString());
patage.BalOver90= PIn.Double(table.Rows[i]["BalOver90"].ToString());
patage.BalTotal = PIn.Double(table.Rows[i]["BalTotal"].ToString());
patage.InsEst = PIn.Double(table.Rows[i]["InsEst"].ToString());
pat=new Patient();
pat.LName=PIn.String(table.Rows[i]["LName"].ToString());
pat.FName=PIn.String(table.Rows[i]["FName"].ToString());
pat.MiddleI=PIn.String(table.Rows[i]["MiddleI"].ToString());
pat.Preferred=PIn.String(table.Rows[i]["Preferred"].ToString());
patage.PatName=pat.GetNameLF();
patage.AmountDue=patage.BalTotal-patage.InsEst;
patage.DateLastStatement=PIn.Date(table.Rows[i]["LastStatement"].ToString());
patage.BillingType=PIn.Long(table.Rows[i]["BillingType"].ToString());
patage.PayPlanDue =PIn.Double(table.Rows[i]["PayPlanDue"].ToString());
//if(excludeInsPending && patage.InsEst>0){
//don't add
//}
//else{
agingList.Add(patage);
//}
}
//PatAging[] retVal=new PatAging[agingList.Count];
//for(int i=0;i<retVal.Length;i++){
// retVal[i]=agingList[i];
//}
if(includeChanged){
command="DROP TABLE IF EXISTS templastproc";
Db.NonQ(command);
command="DROP TABLE IF EXISTS templastpay";
Db.NonQ(command);
}
if(excludeInsPending){
command="DROP TABLE IF EXISTS tempclaimspending";
Db.NonQ(command);
}
if(excludeIfUnsentProcs){
command="DROP TABLE IF EXISTS tempunsentprocs";
Db.NonQ(command);
}
return agingList;
}
示例6: FormPopupEdit_Load
private void FormPopupEdit_Load(object sender,EventArgs e) {
Pat=Patients.GetPat(PopupCur.PatNum);
textPatient.Text=Pat.GetNameLF();
if(PopupCur.IsNew) {//If popup is new User is the logged-in user and create date is now.
butAudit.Visible=false;
textUser.Text=Security.CurUser.UserName;
textCreateDate.Text=DateTime.Now.ToShortDateString()+" "+DateTime.Now.ToShortTimeString();
}
else {
if(PopupCur.UserNum!=0) {//This check is so that any old popups without a user will still display correctly.
textUser.Text=Userods.GetUser(PopupCur.UserNum).UserName;
}
if(PopupAudit!=null) {//This checks if this window opened from FormPopupAudit
textCreateDate.Text="";
if(PopupAudit.DateTimeEntry.Year > 1880) {
textCreateDate.Text=PopupAudit.DateTimeEntry.ToShortDateString()+" "+PopupAudit.DateTimeEntry.ToShortTimeString();//Sets the original creation date.
}
textEditDate.Text="";
if(DateLastEdit.Year > 1880) {
textEditDate.Text=DateLastEdit.ToShortDateString()+" "+DateLastEdit.ToShortTimeString();
}
}
else {
textCreateDate.Text="";
if(PopupCur.DateTimeEntry.Year > 1880) {
textCreateDate.Text=PopupCur.DateTimeEntry.ToShortDateString()+" "+PopupCur.DateTimeEntry.ToShortTimeString();//Sets the original creation date.
}
DateTime dateT=Popups.GetLastEditDateTimeForPopup(PopupCur.PopupNum);
textEditDate.Text="";
if(dateT.Year > 1880) {
textEditDate.Text=dateT.ToShortDateString()+" "+dateT.ToShortTimeString();//Sets the Edit date to the entry date of the last popup change that was archived for this popup.
}
}
}
comboPopupLevel.Items.Add(Lan.g("enumEnumPopupFamily",Enum.GetNames(typeof(EnumPopupLevel))[0]));//Patient
comboPopupLevel.Items.Add(Lan.g("enumEnumPopupFamily",Enum.GetNames(typeof(EnumPopupLevel))[1]));//Family
if(Pat.SuperFamily!=0) {
comboPopupLevel.Items.Add(Lan.g("enumEnumPopupFamily",Enum.GetNames(typeof(EnumPopupLevel))[2]));//SuperFamily
}
comboPopupLevel.SelectedIndex=(int)PopupCur.PopupLevel;
checkIsDisabled.Checked=PopupCur.IsDisabled;
textDescription.Text=PopupCur.Description;
if(PopupCur.IsArchived) {
butDelete.Enabled=false;
butOK.Enabled=false;
comboPopupLevel.Enabled=false;
checkIsDisabled.Enabled=false;
textDescription.ReadOnly=true;
textPatient.ReadOnly=true;
}
if(PopupCur.PopupNumArchive!=0) {
butAudit.Visible=false;
}
}
示例7: FormPopupEdit_Load
private void FormPopupEdit_Load(object sender,EventArgs e)
{
Pat=Patients.GetPat(PopupCur.PatNum);
textPatient.Text=Pat.GetNameLF();
comboPopupLevel.Items.Add(Lan.g("enumEnumPopupFamily",Enum.GetNames(typeof(EnumPopupLevel))[0]));//Patient
comboPopupLevel.Items.Add(Lan.g("enumEnumPopupFamily",Enum.GetNames(typeof(EnumPopupLevel))[1]));//Family
if(Pat.SuperFamily!=0) {
comboPopupLevel.Items.Add(Lan.g("enumEnumPopupFamily",Enum.GetNames(typeof(EnumPopupLevel))[2]));//SuperFamily
}
comboPopupLevel.SelectedIndex=(int)PopupCur.PopupLevel;
checkIsDisabled.Checked=PopupCur.IsDisabled;
textDescription.Text=PopupCur.Description;
}
示例8: GetTable
//.........这里部分代码省略.........
+"LEFT JOIN ( "
+"SELECT ehrmeasureevent.FKey "
+"FROM ehrmeasureevent "
+"WHERE EventType="+POut.Int((int)EhrMeasureEventType.SummaryOfCareProvidedToDr)+" "
+"AND DATE(ehrmeasureevent.DateTEvent) BETWEEN "+POut.Date(dateStart)+" AND "+POut.Date(dateEnd)+" "
+") socevent ON socevent.FKey=refattach.RefAttachNum "
+"WHERE RefDate BETWEEN "+POut.Date(dateStart)+" AND "+POut.Date(dateEnd)+" "
+"AND IsFrom=0 AND IsTransitionOfCare=1 "
+"AND refattach.ProvNum IN("+POut.String(provs)+") "
+"GROUP BY refattach.RefAttachNum";
tableRaw=Db.GetTable(command);
break;
#endregion
default:
throw new ApplicationException("Type not found: "+mtype.ToString());
}
//PatNum, PatientName, Explanation, and Met (X).
DataTable table=new DataTable("audit");
DataRow row;
table.Columns.Add("PatNum");
table.Columns.Add("patientName");
table.Columns.Add("explanation");
table.Columns.Add("met");//X or empty
List<DataRow> rows=new List<DataRow>();
Patient pat;
string explanation;
for(int i=0;i<tableRaw.Rows.Count;i++) {
row=table.NewRow();
row["PatNum"]=tableRaw.Rows[i]["PatNum"].ToString();
pat=new Patient();
pat.LName=tableRaw.Rows[i]["LName"].ToString();
pat.FName=tableRaw.Rows[i]["FName"].ToString();
pat.Preferred="";
row["patientName"]=pat.GetNameLF();
row["met"]="";
explanation="";
switch(mtype) {
#region ProblemList
case EhrMeasureType.ProblemList:
if(tableRaw.Rows[i]["problemsNone"].ToString()!="0") {
explanation="Problems indicated 'None'.";
row["met"]="X";
}
else if(tableRaw.Rows[i]["problemsAll"].ToString()!="0") {
explanation="Problems entered: "+tableRaw.Rows[i]["problemsAll"].ToString();
row["met"]="X";
}
else {
//explanation="No Problems entered";
explanation="No Problems entered with ICD-9 code or SNOMED code attached.";
}
break;
#endregion
#region MedicationList
case EhrMeasureType.MedicationList:
if(tableRaw.Rows[i]["medsNone"].ToString()!="0") {
explanation="Medications indicated 'None'";
row["met"]="X";
}
else if(tableRaw.Rows[i]["medsAll"].ToString()!="0") {
explanation="Medications entered: "+tableRaw.Rows[i]["medsAll"].ToString();
row["met"]="X";
}
else {
explanation="No Medications entered";
}
示例9: FillFieldsInStaticText
//.........这里部分代码省略.........
genderHisHers="His";
genderhishers="his";
break;
case PatientGender.Female:
genderHeShe="She";
genderheshe="she";
genderHimHer="Her";
genderhimher="her";
genderHimselfHerself="Herself";
genderhimselfherself="herself";
genderHisHer="Her";
genderhisher="her";
genderHisHers="Hers";
genderhishers="hers";
break;
case PatientGender.Unknown:
genderHeShe="The patient";
genderheshe="the patient";
genderHimHer="The patient";
genderhimher="the patient";
genderHimselfHerself="The patient";
genderhimselfherself="the patient";
genderHisHer="The patient's";
genderhisher="the patient's";
genderHisHers="The patient's";
genderhishers="the patient's";
break;
}
Patient guar=Patients.GetPat(pat.Guarantor);
if(guar!=null) {
guarantorNameF=guar.FName;
guarantorNameFL=guar.GetNameFL();
guarantorNameL=guar.LName;
guarantorNameLF=guar.GetNameLF();
guarantorNamePref=guar.Preferred;
}
address=pat.Address;
if(pat.Address2!="") {
address+=", "+pat.Address2;
}
birthdate=pat.Birthdate.ToShortDateString();
if(pat.Birthdate.Year<1880) {
birthdate="";
}
dateFirstVisit=pat.DateFirstVisit.ToShortDateString();
if(pat.DateFirstVisit.Year<1880) {
dateFirstVisit="";
}
fam=Patients.GetFamily(pat.PatNum);
List<Procedure> procsList=null;
if(Sheets.ContainsStaticField(sheet,"treatmentPlanProcs") || Sheets.ContainsStaticField(sheet,"plannedAppointmentInfo")) {
procsList=Procedures.Refresh(pat.PatNum);
if(Sheets.ContainsStaticField(sheet,"treatmentPlanProcs")) {
for(int i=0;i<procsList.Count;i++) {
if(procsList[i].ProcStatus!=ProcStat.TP) {
continue;
}
if(treatmentPlanProcs!="") {
treatmentPlanProcs+="\r\n";
}
treatmentPlanProcs+=ProcedureCodes.GetStringProcCode(procsList[i].CodeNum)+", "
+Procedures.GetDescription(procsList[i])+", "
+procsList[i].ProcFee.ToString("c");
}
}
}
示例10: FormApptEdit_Load
private void FormApptEdit_Load(object sender, System.EventArgs e){
if(IsNew){
if(!Security.IsAuthorized(Permissions.AppointmentCreate)){
DialogResult=DialogResult.Cancel;
return;
}
}
else{
if(!Security.IsAuthorized(Permissions.AppointmentEdit)){
butOK.Enabled=false;
butDelete.Enabled=false;
butPin.Enabled=false;
tbProc.Enabled=false;
}
}
fam=Patients.GetFamily(AptCur.PatNum);
pat=fam.GetPatient(AptCur.PatNum);
PlanList=InsPlans.Refresh(fam);
PatPlanList=PatPlans.Refresh(AptCur.PatNum);
//CovPats.Refresh(PlanList,PatPlanList);
if(PrefB.GetBool("EasyHideDentalSchools")){
groupDentalSchools.Visible=false;
}
if(PrefB.GetBool("EasyNoClinics")){
labelClinic.Visible=false;
comboClinic.Visible=false;
}
if(!PinIsVisible)
butPin.Visible=false;
if(AptCur.AptStatus==ApptStatus.Planned){
Text=Lan.g(this,"Edit Planned Appointment")+" - "+pat.GetNameLF();
labelStatus.Visible=false;
comboStatus.Visible=false;
butDelete.Visible=false;
}
else{
Text=Lan.g(this,"Edit Appointment")+" - "+pat.GetNameLF();
comboStatus.Items.Add(Lan.g("enumApptStatus","Scheduled"));
comboStatus.Items.Add(Lan.g("enumApptStatus","Complete"));
comboStatus.Items.Add(Lan.g("enumApptStatus","UnschedList"));
comboStatus.Items.Add(Lan.g("enumApptStatus","ASAP"));
comboStatus.Items.Add(Lan.g("enumApptStatus","Broken"));
comboStatus.SelectedIndex=(int)AptCur.AptStatus-1;
}
if(IsNew){
//for this, the appointment has to be created somewhere else first.
//It might only be temporary, and will be deleted if Cancel is clicked.
//AptCur=new Appointment();//handled previously
//Appointments.SaveApt();
if(AptCur.Confirmed==0)
AptCur.Confirmed=DefB.Short[(int)DefCat.ApptConfirmed][0].DefNum;
if(AptCur.ProvNum==0)
AptCur.ProvNum=Providers.List[0].ProvNum;
}
//for(int i=1;i<Enum.GetNames(typeof(ApptStatus)).Length;i++){//none status is not displayed
// listStatus.Items.Add(Enum.GetNames(typeof(ApptStatus))[i]);
//}
//convert time pattern from 5 to current increment.
strBTime=new StringBuilder();
for(int i=0;i<AptCur.Pattern.Length;i++){
strBTime.Append(AptCur.Pattern.Substring(i,1));
i++;
if(PrefB.GetInt("AppointmentTimeIncrement")==15){
i++;
}
}
comboUnschedStatus.Items.Add(Lan.g(this,"none"));
comboUnschedStatus.SelectedIndex=0;
for(int i=0;i<DefB.Short[(int)DefCat.RecallUnschedStatus].Length;i++){
comboUnschedStatus.Items.Add(DefB.Short[(int)DefCat.RecallUnschedStatus][i].ItemName);
if(DefB.Short[(int)DefCat.RecallUnschedStatus][i].DefNum==AptCur.UnschedStatus)
comboUnschedStatus.SelectedIndex=i+1;
}
for(int i=0;i<DefB.Short[(int)DefCat.ApptConfirmed].Length;i++){
comboConfirmed.Items.Add(DefB.Short[(int)DefCat.ApptConfirmed][i].ItemName);
if(DefB.Short[(int)DefCat.ApptConfirmed][i].DefNum==AptCur.Confirmed)
comboConfirmed.SelectedIndex=i;
}
textAddTime.MinVal=-1200;
textAddTime.MaxVal=1200;
textAddTime.Text=POut.PInt(AptCur.AddTime*PIn.PInt(((Pref)PrefB.HList["AppointmentTimeIncrement"]).ValueString));
textNote.Text=AptCur.Note;
for(int i=0;i<DefB.Short[(int)DefCat.ApptProcsQuickAdd].Length;i++){
listQuickAdd.Items.Add(DefB.Short[(int)DefCat.ApptProcsQuickAdd][i].ItemName);
}
//SchoolClassNum must be filled before provider
comboSchoolClass.Items.Add(Lan.g(this,"none"));
for(int i=0;i<SchoolClasses.List.Length;i++){
comboSchoolClass.Items.Add(SchoolClasses.List[i].GradYear.ToString()+"-"+SchoolClasses.List[i].Descript);
}
comboClinic.Items.Add(Lan.g(this,"none"));
comboClinic.SelectedIndex=0;
for(int i=0;i<Clinics.List.Length;i++){
comboClinic.Items.Add(Clinics.List[i].Description);
if(Clinics.List[i].ClinicNum==AptCur.ClinicNum)
comboClinic.SelectedIndex=i+1;
}
for(int i=0;i<Providers.List.Length;i++){
comboProvNum.Items.Add(Providers.List[i].Abbr);
if(Providers.List[i].ProvNum==AptCur.ProvNum)
//.........这里部分代码省略.........
示例11: GetMainTitle
///<summary>Accepts null for pat and 0 for clinicNum.</summary>
public static string GetMainTitle(Patient pat,long clinicNum) {
string retVal=PrefC.GetString(PrefName.MainWindowTitle);
object[] parameters = { retVal };
Plugins.HookAddCode(null,"PatientL.GetMainTitle_beginning",parameters);
retVal = (string)parameters[0];
if(!PrefC.GetBool(PrefName.EasyNoClinics) && clinicNum>0) {
if(retVal!="") {
retVal+=" - Clinic: ";
}
retVal+=Clinics.GetDesc(clinicNum);
}
if(Security.CurUser!=null){
retVal+=" {"+Security.CurUser.UserName+"}";
}
if(pat==null || pat.PatNum==0 || pat.PatNum==-1){
return retVal;
}
retVal+=" - "+pat.GetNameLF();
if(PrefC.GetLong(PrefName.ShowIDinTitleBar)==1) {
retVal+=" - "+pat.PatNum.ToString();
}
else if(PrefC.GetLong(PrefName.ShowIDinTitleBar)==2) {
retVal+=" - "+pat.ChartNumber;
}
else if(PrefC.GetLong(PrefName.ShowIDinTitleBar)==3) {
if(pat.Birthdate.Year>1880) {
retVal+=" - "+pat.Birthdate.ToShortDateString();
}
}
if(pat.SiteNum!=0){
retVal+=" - "+Sites.GetDescription(pat.SiteNum);
}
return retVal;
}
示例12: GetTable
//.........这里部分代码省略.........
+"GROUP BY refattach.PatNum";
Db.NonQ(command);
command="UPDATE tempehrmeasure "
+"SET CcdCount = (SELECT COUNT(*) FROM ehrmeasureevent "
+"WHERE ehrmeasureevent.PatNum=tempehrmeasure.PatNum AND EventType="+POut.Int((int)EhrMeasureEventType.SummaryOfCareProvidedToDr)+" "
+"AND DATE(ehrmeasureevent.DateTEvent) >= "+POut.Date(dateStart)+" "
+"AND DATE(ehrmeasureevent.DateTEvent) <= "+POut.Date(dateEnd)+")";
Db.NonQ(command);
command="SELECT * FROM tempehrmeasure";
tableRaw=Db.GetTable(command);
command="DROP TABLE IF EXISTS tempehrmeasure";
Db.NonQ(command);
break;
default:
throw new ApplicationException("Type not found: "+mtype.ToString());
}
//PatNum, PatientName, Explanation, and Met (X).
DataTable table=new DataTable("audit");
DataRow row;
table.Columns.Add("PatNum");
table.Columns.Add("patientName");
table.Columns.Add("explanation");
table.Columns.Add("met");//X or empty
List<DataRow> rows=new List<DataRow>();
Patient pat;
string explanation;
for(int i=0;i<tableRaw.Rows.Count;i++) {
row=table.NewRow();
row["PatNum"]=tableRaw.Rows[i]["PatNum"].ToString();
pat=new Patient();
pat.LName=tableRaw.Rows[i]["LName"].ToString();
pat.FName=tableRaw.Rows[i]["FName"].ToString();
pat.Preferred="";
row["patientName"]=pat.GetNameLF();
row["met"]="";
explanation="";
switch(mtype) {
case EhrMeasureType.ProblemList:
if(tableRaw.Rows[i]["problemsNone"].ToString()!="0") {
explanation="Problems indicated 'None'";
row["met"]="X";
}
else if(tableRaw.Rows[i]["problemsAll"].ToString()!="0") {
explanation="Problems entered: "+tableRaw.Rows[i]["problemsAll"].ToString();
row["met"]="X";
}
else{
explanation="No Problems entered";
}
break;
case EhrMeasureType.MedicationList:
if(tableRaw.Rows[i]["medsNone"].ToString()!="0") {
explanation="Medications indicated 'None'";
row["met"]="X";
}
else if(tableRaw.Rows[i]["medsAll"].ToString()!="0") {
explanation="Medications entered: "+tableRaw.Rows[i]["medsAll"].ToString();
row["met"]="X";
}
else {
explanation="No Medications entered";
}
break;
case EhrMeasureType.AllergyList:
if(tableRaw.Rows[i]["allergiesNone"].ToString()!="0") {
explanation="Allergies indicated 'None'";
示例13: ToolButAdd_Click
//private void butAddPt_Click(object sender, System.EventArgs e) {
private void ToolButAdd_Click()
{
Patient tempPat=new Patient();
tempPat.LName =PatCur.LName;
tempPat.PatStatus =PatientStatus.Patient;
tempPat.Address =PatCur.Address;
tempPat.Address2 =PatCur.Address2;
tempPat.City =PatCur.City;
tempPat.State =PatCur.State;
tempPat.Zip =PatCur.Zip;
tempPat.HmPhone =PatCur.HmPhone;
tempPat.Guarantor =PatCur.Guarantor;
tempPat.CreditType =PatCur.CreditType;
tempPat.PriProv =PatCur.PriProv;
tempPat.SecProv =PatCur.SecProv;
tempPat.FeeSched =PatCur.FeeSched;
tempPat.BillingType=PatCur.BillingType;
tempPat.AddrNote =PatCur.AddrNote;
tempPat.ClinicNum =PatCur.ClinicNum;//this is probably better in case they don't have user.ClinicNums set.
//tempPat.ClinicNum =Security.CurUser.ClinicNum;
if(Patients.GetPat(tempPat.Guarantor).SuperFamily!=0) {
tempPat.SuperFamily=PatCur.SuperFamily;
}
Patients.Insert(tempPat,false);
FormPatientEdit FormPE=new FormPatientEdit(tempPat,FamCur);
FormPE.IsNew=true;
FormPE.ShowDialog();
if(FormPE.DialogResult==DialogResult.OK){
OnPatientSelected(tempPat.PatNum,tempPat.GetNameLF(),tempPat.Email!="",tempPat.ChartNumber);
ModuleSelected(tempPat.PatNum);
}
else{
ModuleSelected(PatCur.PatNum);
}
}
示例14: GetPeriodWaitingRoomTable
public static DataTable GetPeriodWaitingRoomTable()
{
if(RemotingClient.RemotingRole==RemotingRole.ClientWeb) {
return Meth.GetTable(MethodBase.GetCurrentMethod());
}
//DateTime dateStart=PIn.PDate(strDateStart);
//DateTime dateEnd=PIn.PDate(strDateEnd);
DataConnection dcon=new DataConnection();
DataTable table=new DataTable("WaitingRoom");
DataRow row;
//columns that start with lowercase are altered for display rather than being raw data.
table.Columns.Add("patName");
table.Columns.Add("waitTime");
string command="SELECT DateTimeArrived,DateTimeSeated,LName,FName,Preferred,"+DbHelper.Now()+" dateTimeNow "
+"FROM appointment,patient "
+"WHERE appointment.PatNum=patient.PatNum "
+"AND "+DbHelper.DateColumn("AptDateTime")+" = "+POut.Date(DateTime.Now)+" "
+"AND DateTimeArrived > "+POut.Date(DateTime.Now)+" "//midnight earlier today
+"AND DateTimeArrived < "+DbHelper.Now()+" "
+"AND "+DbHelper.DateColumn("DateTimeArrived")+"="+DbHelper.DateColumn("AptDateTime")+" ";//prevents people from getting "stuck" in waiting room.
if(DataConnection.DBtype==DatabaseType.Oracle) {
command+="AND TO_NUMBER(TO_CHAR(DateTimeSeated,'SSSSS')) = 0 ";
}
else{
command+="AND TIME(DateTimeSeated) = 0 ";
}
command+="AND AptStatus IN ("+POut.Int((int)ApptStatus.Complete)+","
+POut.Int((int)ApptStatus.Scheduled)+","
+POut.Int((int)ApptStatus.ASAP)+") "//None of the other statuses
+"ORDER BY AptDateTime";
DataTable raw=dcon.GetTable(command);
TimeSpan timeArrived;
//DateTime timeSeated;
DateTime waitTime;
Patient pat;
DateTime dateTimeNow;
//int minutes;
for(int i=0;i<raw.Rows.Count;i++) {
row=table.NewRow();
pat=new Patient();
pat.LName=raw.Rows[i]["LName"].ToString();
pat.FName=raw.Rows[i]["FName"].ToString();
pat.Preferred=raw.Rows[i]["Preferred"].ToString();
row["patName"]=pat.GetNameLF();
dateTimeNow=PIn.DateT(raw.Rows[i]["dateTimeNow"].ToString());
timeArrived=(PIn.DateT(raw.Rows[i]["DateTimeArrived"].ToString())).TimeOfDay;
waitTime=dateTimeNow-timeArrived;
row["waitTime"]=waitTime.ToString("H:mm:ss");
//minutes=waitTime.Minutes;
//if(waitTime.Hours>0){
// row["waitTime"]+=waitTime.Hours.ToString()+"h ";
//minutes-=60*waitTime.Hours;
//}
//row["waitTime"]+=waitTime.Minutes.ToString()+"m";
table.Rows.Add(row);
}
return table;
}
示例15: GetTable
//.........这里部分代码省略.........
command="UPDATE tempehrquality,vitalsign "
+"SET Systolic=BpSystolic, "
+"Diastolic=BpDiastolic "
+"WHERE tempehrquality.PatNum=vitalsign.PatNum "
+"AND tempehrquality.DateBP=vitalsign.DateTaken";
Db.NonQ(command);
command="SELECT * FROM tempehrquality";
tableRaw=Db.GetTable(command);
command="DROP TABLE IF EXISTS tempehrquality";
Db.NonQ(command);
break;
#endregion
default:
throw new ApplicationException("Type not found: "+qtype.ToString());
}
//PatNum, PatientName, Numerator(X), and Exclusion(X).
DataTable table=new DataTable("audit");
DataRow row;
table.Columns.Add("PatNum");
table.Columns.Add("patientName");
table.Columns.Add("numerator");//X
table.Columns.Add("exclusion");//X
table.Columns.Add("explanation");
List<DataRow> rows=new List<DataRow>();
Patient pat;
//string explanation;
for(int i=0;i<tableRaw.Rows.Count;i++) {
row=table.NewRow();
row["PatNum"]=tableRaw.Rows[i]["PatNum"].ToString();
pat=new Patient();
pat.LName=tableRaw.Rows[i]["LName"].ToString();
pat.FName=tableRaw.Rows[i]["FName"].ToString();
pat.Preferred="";
row["patientName"]=pat.GetNameLF();
row["numerator"]="";
row["exclusion"]="";
row["explanation"]="";
float weight=0;
float height=0;
float bmi=0;
DateTime dateVisit;
int visitCount;
switch(qtype) {
#region WeightOver65
case QualityType.WeightOver65:
//WeightOver65-----------------------------------------------------------------------------------------------------------------
weight=PIn.Float(tableRaw.Rows[i]["Weight"].ToString());
height=PIn.Float(tableRaw.Rows[i]["Height"].ToString());
bmi=Vitalsigns.CalcBMI(weight,height);
bool hasFollowupPlan=PIn.Bool(tableRaw.Rows[i]["HasFollowupPlan"].ToString());
bool isIneligible=PIn.Bool(tableRaw.Rows[i]["IsIneligible"].ToString());
string documentation=tableRaw.Rows[i]["Documentation"].ToString();
if(bmi==0){
row["explanation"]="No BMI";
}
else if(bmi < 22) {
row["explanation"]="Underweight";
if(hasFollowupPlan) {
row["explanation"]+=", has followup plan: "+documentation;
row["numerator"]="X";
}
}
else if(bmi < 30) {
row["numerator"]="X";
row["explanation"]="Normal weight";
}