Changeset 772
- Timestamp:
- May 21, 2010, 9:03:45 PM (14 years ago)
- Location:
- Scheduling/trunk/cs/bsdx0200GUISourceCode
- Files:
-
- 3 added
- 14 deleted
- 20 edited
Legend:
- Unmodified
- Added
- Removed
-
Scheduling/trunk/cs/bsdx0200GUISourceCode/CGDocumentManager.cs
r627 r772 11 11 using IndianHealthService.BMXNet; 12 12 using System.Configuration; 13 using Mono.Options; 13 14 14 15 namespace IndianHealthService.ClinicalScheduling … … 28 29 private bool m_bExitOK = true; 29 30 public string m_sHandle = "0"; 31 private string m_AccessCode=""; 32 private string m_VerifyCode=""; 33 private string m_Server=""; 34 private int m_Port=0; 30 35 31 36 //M Connection member variables … … 251 256 else 252 257 { 253 //Use autologin 254 _current.m_ConnectInfo.LoadConnectInfo(); 255 } 258 if (m_Server != String.Empty && m_Port != 0 && m_AccessCode != String.Empty 259 && m_VerifyCode != String.Empty) 260 m_ConnectInfo.LoadConnectInfo(m_Server, m_Port, m_AccessCode, m_VerifyCode); 261 262 else if (m_Server != String.Empty && m_Port != 0) 263 m_ConnectInfo.LoadConnectInfo(m_Server, m_Port); 264 265 else 266 m_ConnectInfo.LoadConnectInfo(); 267 } 256 268 bRetry = false; 257 269 } … … 292 304 293 305 //Set application context 294 m_ds.SetStatus("Setting Application Context ...");306 m_ds.SetStatus("Setting Application Context to BSDXRPC..."); 295 307 m_ds.Refresh(); 296 308 m_ConnectInfo.AppContext = "BSDXRPC"; … … 335 347 } 336 348 337 [STAThread()] static void Main( )349 [STAThread()] static void Main(string[] args) 338 350 { 339 351 try 340 { 341 //Store the current manager352 { 353 //Store the current manager 342 354 _current = new CGDocumentManager(); 343 355 356 var opset = new OptionSet () { 357 { "s=", s => _current.m_Server = s }, 358 { "p=", p => _current.m_Port = int.Parse(p) }, 359 { "a=", a => _current.m_AccessCode = a }, 360 { "v=", v => _current.m_VerifyCode = v } 361 }; 362 363 opset.Parse(args); 364 344 365 try 345 366 { -
Scheduling/trunk/cs/bsdx0200GUISourceCode/CGView.cs
r627 r772 376 376 // 377 377 this.mnuPrintClinicSchedules.Index = 9; 378 this.mnuPrintClinicSchedules.Shortcut = System.Windows.Forms.Shortcut.CtrlP; 378 379 this.mnuPrintClinicSchedules.Text = "&Print Clinic Schedules"; 379 380 this.mnuPrintClinicSchedules.Click += new System.EventHandler(this.mnuPrintClinicSchedules_Click); … … 2371 2372 } 2372 2373 2373 private void PrintPatientLetter()2374 {2375 //Prompt for patient and2376 //Print letter for individual patient2377 try2378 {2379 //Display a dialog to collect Patient Name2380 DPatientLookup dPat = new DPatientLookup();2381 dPat.DocManager = m_DocManager;2382 if (dPat.ShowDialog(this) == DialogResult.Cancel)2383 {2384 return;2385 }2386 2387 Debug.Assert(dPat.PatientIEN != "");2388 int nPatientID = Convert.ToInt32(dPat.PatientIEN);2389 PrintPatientLetter(nPatientID);2390 2391 }2392 catch (Exception ex)2393 {2394 MessageBox.Show(this, ex.Message, "Clinical Scheduling", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);2395 }2396 }2397 2398 private void PrintPatientLetter(int PatientID)2399 {2400 //Print letter for individual patient2401 try2402 {2403 DPatientLetter dPa = new DPatientLetter();2404 dPa.InitializeForm(DocManager, PatientID);2405 2406 if (dPa.ShowDialog(this) != DialogResult.Cancel)2407 {2408 return;2409 }2410 }2411 catch (Exception ex)2412 {2413 throw ex;2414 }2415 }2416 2417 2374 #endregion Methods 2418 2375 … … 3020 2977 private void mnuPrintPatientLetter_Click(object sender, System.EventArgs e) 3021 2978 { 3022 PrintPatientLetter();2979 ViewPatientAppointments(); 3023 2980 } 3024 2981 -
Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj
r755 r772 110 110 <HintPath>bin\Release\BMXNet20.dll</HintPath> 111 111 </Reference> 112 <Reference Include="CrystalDecisions.CrystalReports.Engine, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">113 <Private>False</Private>114 </Reference>115 <Reference Include="CrystalDecisions.Enterprise.Framework, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">116 <Private>False</Private>117 </Reference>118 <Reference Include="CrystalDecisions.Enterprise.InfoStore, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304">119 <Private>False</Private>120 </Reference>121 <Reference Include="CrystalDecisions.ReportSource, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">122 <Private>False</Private>123 </Reference>124 <Reference Include="CrystalDecisions.Shared, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">125 <Private>False</Private>126 </Reference>127 <Reference Include="CrystalDecisions.Windows.Forms, Version=10.2.3600.0, Culture=neutral, PublicKeyToken=692fbea5521e1304, processorArchitecture=MSIL">128 <Private>False</Private>129 </Reference>130 112 <Reference Include="System"> 131 113 <Name>System</Name> … … 229 211 <SubType>Form</SubType> 230 212 </Compile> 231 <Compile Include="crAppointmentList.cs">232 <DependentUpon>crAppointmentList.rpt</DependentUpon>233 <SubType>Component</SubType>234 <DesignTime>True</DesignTime>235 <AutoGen>True</AutoGen>236 </Compile>237 <Compile Include="crCancelLetter.cs">238 <DependentUpon>crCancelLetter.rpt</DependentUpon>239 <SubType>Component</SubType>240 <DesignTime>True</DesignTime>241 <AutoGen>True</AutoGen>242 </Compile>243 <Compile Include="crPatientLetter.cs">244 <DependentUpon>crPatientLetter.rpt</DependentUpon>245 <SubType>Component</SubType>246 <DesignTime>True</DesignTime>247 <AutoGen>True</AutoGen>248 </Compile>249 <Compile Include="crRebookLetter.cs">250 <DependentUpon>crRebookLetter.rpt</DependentUpon>251 <SubType>Component</SubType>252 <DesignTime>True</DesignTime>253 <AutoGen>True</AutoGen>254 </Compile>255 213 <Compile Include="DAccessBlock.cs"> 256 214 <SubType>Form</SubType> … … 327 285 <SubType>Form</SubType> 328 286 </Compile> 287 <Compile Include="dsRebookAppts.cs"> 288 <DependentUpon>dsRebookAppts.xsd</DependentUpon> 289 <SubType>Component</SubType> 290 </Compile> 329 291 <Compile Include="dsRebookAppts.Designer.cs"> 330 292 <AutoGen>True</AutoGen> … … 332 294 <DependentUpon>dsRebookAppts.xsd</DependentUpon> 333 295 </Compile> 296 <Compile Include="Options.cs" /> 297 <Compile Include="Printing.cs" /> 334 298 <Compile Include="UCPatientAppts.cs"> 335 299 <SubType>UserControl</SubType> … … 349 313 <DependentUpon>CGView.cs</DependentUpon> 350 314 <SubType>Designer</SubType> 351 </EmbeddedResource>352 <EmbeddedResource Include="crAppointmentList.rpt">353 <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>354 <LastGenOutput>crAppointmentList.cs</LastGenOutput>355 </EmbeddedResource>356 <EmbeddedResource Include="crCancelLetter.rpt">357 <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>358 <LastGenOutput>crCancelLetter.cs</LastGenOutput>359 </EmbeddedResource>360 <EmbeddedResource Include="crPatientLetter.rpt">361 <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>362 <LastGenOutput>crPatientLetter.cs</LastGenOutput>363 </EmbeddedResource>364 <EmbeddedResource Include="crRebookLetter.rpt">365 <Generator>CrystalDecisions.VSDesigner.CodeGen.ReportCodeGenerator</Generator>366 <LastGenOutput>crRebookLetter.cs</LastGenOutput>367 315 </EmbeddedResource> 368 316 <EmbeddedResource Include="DAccessGroup.resx"> -
Scheduling/trunk/cs/bsdx0200GUISourceCode/ClinicalScheduling.csproj.user
r614 r772 36 36 </RemoteDebugMachine> 37 37 <StartAction>Project</StartAction> 38 <StartArguments>http://homedev.ihs.gov/otherprgms/clinicalscheduling/ClinicalScheduling.exe</StartArguments> 38 <StartArguments> 39 </StartArguments> 39 40 <StartPage> 40 41 </StartPage> -
Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.cs
r753 r772 53 53 private System.Windows.Forms.Label label14; 54 54 private System.Windows.Forms.TextBox txtHRN; 55 private System.Windows.Forms.Button cmdPrintLetter;56 55 private GroupBox groupBox4; 57 56 private BindingSource dsPatientApptDisplay2BindingSource; … … 75 74 this.tabControl1 = new System.Windows.Forms.TabControl(); 76 75 this.tabAppointment = new System.Windows.Forms.TabPage(); 76 this.groupBox4 = new System.Windows.Forms.GroupBox(); 77 77 this.groupBox3 = new System.Windows.Forms.GroupBox(); 78 78 this.lblClinic = new System.Windows.Forms.Label(); … … 108 108 this.txtStreet = new System.Windows.Forms.TextBox(); 109 109 this.panel1 = new System.Windows.Forms.Panel(); 110 this.cmdPrintLetter = new System.Windows.Forms.Button();111 110 this.cmdCancel = new System.Windows.Forms.Button(); 112 111 this.cmdOK = new System.Windows.Forms.Button(); 113 this.groupBox4 = new System.Windows.Forms.GroupBox();114 112 this.patientApptsBindingSource = new System.Windows.Forms.BindingSource(this.components); 115 113 this.dsPatientApptDisplay2BindingSource = new System.Windows.Forms.BindingSource(this.components); … … 148 146 this.tabAppointment.TabIndex = 1; 149 147 this.tabAppointment.Text = "Appointment"; 148 // 149 // groupBox4 150 // 151 this.groupBox4.Location = new System.Drawing.Point(8, 254); 152 this.groupBox4.Name = "groupBox4"; 153 this.groupBox4.Size = new System.Drawing.Size(439, 204); 154 this.groupBox4.TabIndex = 14; 155 this.groupBox4.TabStop = false; 156 this.groupBox4.Text = "Other Appointments"; 150 157 // 151 158 // groupBox3 … … 456 463 // panel1 457 464 // 458 this.panel1.Controls.Add(this.cmdPrintLetter);459 465 this.panel1.Controls.Add(this.cmdCancel); 460 466 this.panel1.Controls.Add(this.cmdOK); … … 465 471 this.panel1.TabIndex = 1; 466 472 // 467 // cmdPrintLetter468 //469 this.cmdPrintLetter.CausesValidation = false;470 this.cmdPrintLetter.Location = new System.Drawing.Point(12, 9);471 this.cmdPrintLetter.Name = "cmdPrintLetter";472 this.cmdPrintLetter.Size = new System.Drawing.Size(68, 24);473 this.cmdPrintLetter.TabIndex = 3;474 this.cmdPrintLetter.Text = "Print Letter";475 this.cmdPrintLetter.Click += new System.EventHandler(this.cmdPrintLetter_Click);476 //477 473 // cmdCancel 478 474 // … … 493 489 this.cmdOK.Text = "OK"; 494 490 this.cmdOK.Click += new System.EventHandler(this.cmdOK_Click); 495 //496 // groupBox4497 //498 this.groupBox4.Location = new System.Drawing.Point(8, 254);499 this.groupBox4.Name = "groupBox4";500 this.groupBox4.Size = new System.Drawing.Size(439, 204);501 this.groupBox4.TabIndex = 14;502 this.groupBox4.TabStop = false;503 this.groupBox4.Text = "Other Appointments";504 491 // 505 492 // patientApptsBindingSource … … 530 517 this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent; 531 518 this.Text = "Patient Appointment"; 532 this.Load += new System.EventHandler(this.DAppointPage_Load);533 519 this.tabControl1.ResumeLayout(false); 534 520 this.tabAppointment.ResumeLayout(false); … … 674 660 } 675 661 676 private void cmdViewAppointments_Click(object sender, System.EventArgs e)677 {678 try679 {680 Debug.Assert(m_sPatientIEN != "");681 int nPatientID = Convert.ToInt32(m_sPatientIEN);682 ViewPatientAppointments(nPatientID);683 }684 catch (Exception ex)685 {686 MessageBox.Show(this, ex.Message, "Clinical Scheduling", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);687 }688 }689 690 public void ViewPatientAppointments(int PatientID)691 {692 DPatientApptDisplay dPa = new DPatientApptDisplay();693 694 dPa.InitializeForm(this.DocManager, PatientID);695 696 if (dPa.ShowDialog(this) != DialogResult.Cancel)697 {698 return;699 }700 }701 702 703 private void cmdPrintLetter_Click(object sender, System.EventArgs e)704 {705 try706 {707 Debug.Assert(m_sPatientIEN != "");708 int nPatientID = Convert.ToInt32(m_sPatientIEN);709 PrintPatientLetter(nPatientID);710 }711 catch (Exception ex)712 {713 MessageBox.Show(this, ex.Message, "Clinical Scheduling", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);714 }715 }716 717 private void PrintPatientLetter(int PatientID)718 {719 //Print letter for individual patient720 try721 {722 DPatientLetter dPa = new DPatientLetter();723 dPa.InitializeForm(DocManager, PatientID);724 725 if (dPa.ShowDialog(this) != DialogResult.Cancel)726 {727 return;728 }729 }730 catch (Exception ex)731 {732 throw ex;733 }734 }735 736 private void DAppointPage_Load(object sender, System.EventArgs e)737 {738 cmdPrintLetter.Enabled = !(m_dStartTime < DateTime.Today);739 }740 662 741 663 #endregion //Methods -
Scheduling/trunk/cs/bsdx0200GUISourceCode/DAppointPage.resx
r753 r772 124 124 <value>179, 17</value> 125 125 </metadata> 126 <metadata name="dsPatientApptDisplay2BindingSource.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">127 <value>179, 17</value>128 </metadata>129 <metadata name="dsPatientApptDisplay2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">130 <value>17, 17</value>131 </metadata>132 126 <metadata name="dsPatientApptDisplay2.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 133 127 <value>17, 17</value> -
Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.cs
r614 r772 1 1 using System; 2 using System.Drawing;3 using System.Collections;4 using System.ComponentModel;5 2 using System.Windows.Forms; 6 3 using System.Data; 7 using CrystalDecisions.Windows; 8 using CrystalDecisions.Shared; 9 using CrystalDecisions.CrystalReports.Engine; 10 using IndianHealthService.BMXNet; 4 using System.Drawing.Printing; 5 using System.Drawing; 11 6 12 7 namespace IndianHealthService.ClinicalScheduling … … 15 10 /// Summary description for DPatientLetter. 16 11 /// </summary> 17 public class DPatientLetter : System.Windows.Forms.Form 18 { 19 private CrystalDecisions.Windows.Forms.CrystalReportViewer crViewer1; 12 public class DPatientLetter : System.Windows.Forms.PrintPreviewDialog 13 { 20 14 /// <summary> 21 15 /// Required designer variable. 22 16 /// </summary> 23 private System.ComponentModel.Container components = null; 17 private System.ComponentModel.Container components = null; 18 private System.Drawing.Printing.PrintDocument printDocument1; 24 19 25 20 #region Fields 26 27 private string m_sBodyText; 21 DateTime _dtBegin, _dtEnd; //global fields to use in passing to printing method 22 int _currentResourcePrinting = 0; 23 int _currentApptPrinting = 0; 24 dsPatientApptDisplay2 _ds; 28 25 #endregion Fields 29 30 #region Properties31 32 public string BodyText33 {34 get35 {36 return m_sBodyText;37 }38 set39 {40 m_sBodyText = value;41 }42 }43 44 #endregion Properties45 46 public void InitializeForm(CGDocumentManager docManager, int nPatientID)47 {48 try49 {50 crViewer1.DisplayGroupTree = true;51 52 ClinicalScheduling.crPatientLetter cr = new crPatientLetter();53 string sSql = "BSDX PATIENT APPT DISPLAY^" + nPatientID.ToString();54 System.Data.DataSet ds = new System.Data.DataSet();55 DataTable dtAppt = docManager.RPMSDataTable(sSql, "PatientAppts");56 ds.Tables.Add(dtAppt.Copy());57 58 System.Data.DataTable dt =59 docManager.GlobalDataSet.Tables["Resources"].Copy();60 ds.Tables.Add(dt);61 62 cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);63 cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);64 65 crViewer1.SelectionFormula = "{PatientAppts.ApptDate} >= CurrentDate";66 this.crViewer1.ReportSource = cr;67 68 }69 catch (Exception ex)70 {71 throw ex;72 }73 }74 26 75 27 public void InitializeFormClinicSchedule(CGDocumentManager docManager, … … 84 36 throw new Exception("At least one clinic must be selected."); 85 37 } 38 _dtBegin = dtBegin; 39 _dtEnd = dtEnd; 86 40 string sBegin = dtBegin.ToShortDateString(); 87 41 string sEnd = dtEnd.ToShortDateString(); 88 crViewer1.DisplayGroupTree = true;89 42 this.Text="Clinic Schedules"; 90 43 91 ClinicalScheduling.crAppointmentList cr = new crAppointmentList();92 44 string sSql = "BSDX CLINIC LETTERS^" + sClinicList + "^" + sBegin + "^" + sEnd; 93 94 DataTable dtAppt = docManager.RPMSDataTable(sSql, "PatientAppts"); 95 cr.Database.Tables["PatientAppts"].SetDataSource(dtAppt);96 97 this.crViewer1.ReportSource = cr;98 45 string sSql2 = "BSDX RESOURCE LETTERS^" + sClinicList; 46 47 _ds = new dsPatientApptDisplay2(); 48 _ds.BSDXResource.Merge(docManager.RPMSDataTable(sSql2, "Resources")); 49 _ds.PatientAppts.Merge(docManager.RPMSDataTable(sSql, "PatientAppts")); 50 } 99 51 catch (Exception ex) 100 52 { … … 113 65 throw new Exception("At least one clinic must be selected."); 114 66 } 115 crViewer1.DisplayGroupTree = true; 116 117 ClinicalScheduling.crRebookLetter cr = new crRebookLetter(); 67 68 System.Data.DataSet ds = new System.Data.DataSet(); 69 ds.Tables.Add(dtLetters.Copy()); 70 71 string sSql = "BSDX RESOURCE LETTERS^" + sClinicList; 72 DataTable dt = docManager.RPMSDataTable(sSql, "Resources"); 73 ds.Tables.Add(dt.Copy()); 74 } 75 catch (Exception ex) 76 { 77 throw ex; 78 } 79 } 80 81 public void InitializeFormCancellationLetters(CGDocumentManager docManager, 82 string sClinicList, 83 DataTable dtLetters) 84 { 85 try 86 { 87 if (sClinicList == "") 88 { 89 throw new Exception("At least one clinic must be selected."); 90 } 118 91 119 92 System.Data.DataSet ds = new System.Data.DataSet(); … … 123 96 DataTable dt = docManager.RPMSDataTable(sSql, "Resources"); 124 97 ds.Tables.Add(dt.Copy()); 125 126 cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);127 cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);128 129 this.crViewer1.ReportSource = cr;130 131 }132 catch (Exception ex)133 {134 throw ex;135 }136 }137 138 public void InitializeFormCancellationLetters(CGDocumentManager docManager,139 string sClinicList,140 DataTable dtLetters)141 {142 try143 {144 if (sClinicList == "")145 {146 throw new Exception("At least one clinic must be selected.");147 }148 crViewer1.DisplayGroupTree = true;149 150 ClinicalScheduling.crCancelLetter cr = new crCancelLetter();151 152 System.Data.DataSet ds = new System.Data.DataSet();153 ds.Tables.Add(dtLetters.Copy());154 155 string sSql = "BSDX RESOURCE LETTERS^" + sClinicList;156 DataTable dt = docManager.RPMSDataTable(sSql, "Resources");157 ds.Tables.Add(dt.Copy());158 159 cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);160 cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);161 162 this.crViewer1.ReportSource = cr;163 98 164 99 } … … 183 118 string sBegin = dtBegin.ToShortDateString(); 184 119 string sEnd = dtEnd.ToShortDateString(); 185 crViewer1.DisplayGroupTree = true; 186 187 ClinicalScheduling.crPatientLetter cr = new crPatientLetter(); 120 188 121 string sSql = "BSDX CLINIC LETTERS^" + sClinicList + "^" + sBegin + "^" + sEnd; 189 122 … … 195 128 DataTable dt = docManager.RPMSDataTable(sSql, "Resources"); 196 129 ds.Tables.Add(dt.Copy()); 197 198 cr.Database.Tables["PatientAppts"].SetDataSource(ds.Tables["PatientAppts"]);199 cr.Database.Tables["BSDXResource"].SetDataSource(ds.Tables["Resources"]);200 201 this.crViewer1.ReportSource = cr;202 130 203 131 } … … 243 171 private void InitializeComponent() 244 172 { 245 this.crViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer(); 246 this.SuspendLayout(); 247 // 248 // crViewer1 249 // 250 this.crViewer1.ActiveViewIndex = -1; 251 this.crViewer1.Dock = System.Windows.Forms.DockStyle.Fill; 252 this.crViewer1.Location = new System.Drawing.Point(0, 0); 253 this.crViewer1.Name = "crViewer1"; 254 this.crViewer1.ReportSource = null; 255 this.crViewer1.Size = new System.Drawing.Size(648, 398); 256 this.crViewer1.TabIndex = 0; 257 // 258 // DPatientLetter 259 // 260 this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); 261 this.ClientSize = new System.Drawing.Size(648, 398); 262 this.Controls.Add(this.crViewer1); 263 this.Name = "DPatientLetter"; 264 this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; 265 this.Text = "Patient Letter"; 266 this.ResumeLayout(false); 173 this.printDocument1 = new System.Drawing.Printing.PrintDocument(); 174 this.SuspendLayout(); 175 // 176 // printDocument1 177 // 178 this.printDocument1.PrintPage += new System.Drawing.Printing.PrintPageEventHandler(this.printDocument1_PrintPage); 179 // 180 // DPatientLetter 181 // 182 this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); 183 this.ClientSize = new System.Drawing.Size(648, 398); 184 this.Document = this.printDocument1; 185 this.Name = "DPatientLetter"; 186 this.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen; 187 this.Text = "Patient Letter"; 188 this.ResumeLayout(false); 267 189 268 190 } 269 191 #endregion 192 193 private void printDocument1_PrintPage(object sender, System.Drawing.Printing.PrintPageEventArgs e) 194 { 195 // _currentResourcePrinting starts with zero. There will be at least this one. 196 ClinicalScheduling.Printing.PrintAppointments(_ds, e, _dtBegin, _dtEnd, 197 _currentResourcePrinting, ref _currentApptPrinting); 198 199 //If the printing routine says it needs more pages to print the appointments, 200 //return here and have it print again. 201 if (e.HasMorePages == true) return; 202 203 // if there are more resouces to print, increment. Setting HasMorePages to true 204 // calls this routine again, so printing will happen with the incremented _currentResourcePrinting 205 if (_currentResourcePrinting < _ds.BSDXResource.Rows.Count - 1) 206 { 207 _currentResourcePrinting++; 208 e.HasMorePages = true; 209 } 210 211 } 270 212 } 271 213 } -
Scheduling/trunk/cs/bsdx0200GUISourceCode/DPatientLetter.resx
r614 r772 4 4 Microsoft ResX Schema 5 5 6 Version 1.36 Version 2.0 7 7 8 8 The primary goals of this format is to allow a simple XML format … … 15 15 ... ado.net/XML headers & schema ... 16 16 <resheader name="resmimetype">text/microsoft-resx</resheader> 17 <resheader name="version"> 1.3</resheader>17 <resheader name="version">2.0</resheader> 18 18 <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader> 19 19 <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader> 20 <data name="Name1"> this is my long string</data>20 <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data> 21 21 <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data> 22 22 <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64"> 23 [base64 mime encoded serialized .NET Framework object]23 <value>[base64 mime encoded serialized .NET Framework object]</value> 24 24 </data> 25 25 <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64"> 26 [base64 mime encoded string representing a byte array form of the .NET Framework object] 26 <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value> 27 <comment>This is a comment</comment> 27 28 </data> 28 29 … … 36 37 mimetype set. 37 38 38 The mimetype is used for serialized objects, and tells the39 The mimetype is used for serialized objects, and tells the 39 40 ResXResourceReader how to depersist the object. This is currently not 40 41 extensible. For a given mimetype the value must be set accordingly: … … 46 47 mimetype: application/x-microsoft.net.object.binary.base64 47 48 value : The object must be serialized with 48 : System. Serialization.Formatters.Binary.BinaryFormatter49 : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter 49 50 : and then encoded with base64 encoding. 50 51 … … 60 61 --> 61 62 <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> 63 <xsd:import namespace="http://www.w3.org/XML/1998/namespace" /> 62 64 <xsd:element name="root" msdata:IsDataSet="true"> 63 65 <xsd:complexType> 64 66 <xsd:choice maxOccurs="unbounded"> 67 <xsd:element name="metadata"> 68 <xsd:complexType> 69 <xsd:sequence> 70 <xsd:element name="value" type="xsd:string" minOccurs="0" /> 71 </xsd:sequence> 72 <xsd:attribute name="name" use="required" type="xsd:string" /> 73 <xsd:attribute name="type" type="xsd:string" /> 74 <xsd:attribute name="mimetype" type="xsd:string" /> 75 <xsd:attribute ref="xml:space" /> 76 </xsd:complexType> 77 </xsd:element> 78 <xsd:element name="assembly"> 79 <xsd:complexType> 80 <xsd:attribute name="alias" type="xsd:string" /> 81 <xsd:attribute name="name" type="xsd:string" /> 82 </xsd:complexType> 83 </xsd:element> 65 84 <xsd:element name="data"> 66 85 <xsd:complexType> … … 69 88 <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" /> 70 89 </xsd:sequence> 71 <xsd:attribute name="name" type="xsd:string" msdata:Ordinal="1" />90 <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" /> 72 91 <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" /> 73 92 <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" /> 93 <xsd:attribute ref="xml:space" /> 74 94 </xsd:complexType> 75 95 </xsd:element> … … 90 110 </resheader> 91 111 <resheader name="version"> 92 <value> 1.3</value>112 <value>2.0</value> 93 113 </resheader> 94 114 <resheader name="reader"> 95 <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version= 1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>115 <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> 96 116 </resheader> 97 117 <resheader name="writer"> 98 <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version= 1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>118 <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value> 99 119 </resheader> 100 <data name="crViewer1.DefaultModifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 101 <value>Private</value> 102 </data> 103 <data name="crViewer1.Modifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 104 <value>Private</value> 105 </data> 106 <data name="crViewer1.Locked" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 107 <value>False</value> 108 </data> 109 <data name="$this.Locked" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 110 <value>False</value> 111 </data> 112 <data name="$this.Language" type="System.Globalization.CultureInfo, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 113 <value>(Default)</value> 114 </data> 115 <data name="$this.TrayLargeIcon" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 116 <value>False</value> 117 </data> 118 <data name="$this.Localizable" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 119 <value>False</value> 120 </data> 121 <data name="$this.GridSize" type="System.Drawing.Size, System.Drawing, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 122 <value>8, 8</value> 123 </data> 124 <data name="$this.DrawGrid" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 125 <value>True</value> 126 </data> 127 <data name="$this.TrayHeight" type="System.Int32, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 128 <value>80</value> 129 </data> 130 <data name="$this.Name"> 131 <value>DPatientLetter</value> 132 </data> 133 <data name="$this.SnapToGrid" type="System.Boolean, mscorlib, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 134 <value>True</value> 135 </data> 136 <data name="$this.DefaultModifiers" type="System.CodeDom.MemberAttributes, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089"> 137 <value>Private</value> 138 </data> 120 <metadata name="printDocument1.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"> 121 <value>116, 17</value> 122 </metadata> 139 123 </root> -
Scheduling/trunk/cs/bsdx0200GUISourceCode/DSelectLetterClinics.cs
r614 r772 9 9 { 10 10 /// <summary> 11 /// Summary description for DSelectLetterClinics. 11 /// Use this dialog to select resources and dates (begin and end) for their examination. 12 /// <example> 13 /// DSelectLetterClinics ds = new DSelectLetterClinics(); 14 /// ds.InitializePage(this.m_DocManager.GlobalDataSet, "Print Clinic Cancellation Letters"); 15 /// ds.ShowDialog(this) 16 /// 17 /// //get the resource names and call the letter printer 18 /// string sClinics = ds.SelectedClinics; 19 /// DateTime dtBegin = ds.BeginDate; 20 /// DateTime dtEnd = ds.EndDate; 21 /// </example> 12 22 /// </summary> 23 /// 13 24 public class DSelectLetterClinics : System.Windows.Forms.Form 14 25 { … … 31 42 private System.ComponentModel.Container components = null; 32 43 33 public DSelectLetterClinics() 44 /// <summary> 45 /// Ctor; also sets default enter and cancel buttons 46 /// </summary> 47 public DSelectLetterClinics() 34 48 { 35 49 InitializeComponent(); 50 this.AcceptButton = cmdOK; 51 this.CancelButton = cmdCancel; 36 52 } 37 53 -
Scheduling/trunk/cs/bsdx0200GUISourceCode/bin/Release/ClinicalScheduling.XML
r755 r772 500 500 </summary> 501 501 </member> 502 <member name="T:IndianHealthService.ClinicalScheduling.Printing"> 503 <summary> 504 Class that encapsulates printing functions in Clinical Scheduling 505 </summary> 506 </member> 507 <member name="M:IndianHealthService.ClinicalScheduling.Printing.PrintAppointments(IndianHealthService.ClinicalScheduling.dsPatientApptDisplay2,System.Drawing.Printing.PrintPageEventArgs,System.DateTime,System.DateTime,System.Int32,System.Int32@)"> 508 <summary> 509 Print Appointments 510 </summary> 511 <param name="ds">Strongly Typed DataSet contains Resources and Appointments</param> 512 <param name="e">PrintPageEventArgs from PrintDocument Print handler</param> 513 <param name="beg">Begin Datetime to print appointments</param> 514 <param name="end">End Datetime to print appointments</param> 515 <remarks>beg and end have no effect on operation--they are there for documentation for user only</remarks> 516 </member> 502 517 <member name="T:IndianHealthService.ClinicalScheduling.DResourceGroupItem"> 503 518 <summary> … … 676 691 </member> 677 692 <member name="T:IndianHealthService.ClinicalScheduling.DSelectLetterClinics"> 678 <summary> 679 Summary description for DSelectLetterClinics. 693 <summary> 694 Use this dialog to select resources and dates (begin and end) for their examination. 695 <example> 696 DSelectLetterClinics ds = new DSelectLetterClinics(); 697 ds.InitializePage(this.m_DocManager.GlobalDataSet, "Print Clinic Cancellation Letters"); 698 ds.ShowDialog(this) 699 700 //get the resource names and call the letter printer 701 string sClinics = ds.SelectedClinics; 702 DateTime dtBegin = ds.BeginDate; 703 DateTime dtEnd = ds.EndDate; 704 </example> 705 </summary> 706 707 </member> 708 <member name="M:IndianHealthService.ClinicalScheduling.DSelectLetterClinics.#ctor"> 709 <summary> 710 Ctor; also sets default enter and cancel buttons 680 711 </summary> 681 712 </member> -
Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.Designer.cs
r614 r772 2 2 // <auto-generated> 3 3 // This code was generated by a tool. 4 // Runtime Version:2.0.50727.3 0534 // Runtime Version:2.0.50727.3603 5 5 // 6 6 // Changes to this file may cause incorrect behavior and will be lost if … … 30 30 private BSDXResourceDataTable tableBSDXResource; 31 31 32 private global::System.Data.DataRelation relation BSDXResourcePatientAppts;32 private global::System.Data.DataRelation relationFK_BSDXResource_PatientAppts; 33 33 34 34 private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; … … 207 207 } 208 208 } 209 this.relation BSDXResourcePatientAppts = this.Relations["BSDXResourcePatientAppts"];209 this.relationFK_BSDXResource_PatientAppts = this.Relations["FK_BSDXResource_PatientAppts"]; 210 210 } 211 211 … … 222 222 base.Tables.Add(this.tableBSDXResource); 223 223 global::System.Data.ForeignKeyConstraint fkc; 224 fkc = new global::System.Data.ForeignKeyConstraint(" BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {224 fkc = new global::System.Data.ForeignKeyConstraint("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] { 225 225 this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] { 226 226 this.tablePatientAppts.RESOURCEIDColumn}); … … 229 229 fkc.DeleteRule = global::System.Data.Rule.Cascade; 230 230 fkc.UpdateRule = global::System.Data.Rule.Cascade; 231 this.relation BSDXResourcePatientAppts = new global::System.Data.DataRelation("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {231 this.relationFK_BSDXResource_PatientAppts = new global::System.Data.DataRelation("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] { 232 232 this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] { 233 233 this.tablePatientAppts.RESOURCEIDColumn}, false); 234 this.Relations.Add(this.relation BSDXResourcePatientAppts);234 this.Relations.Add(this.relationFK_BSDXResource_PatientAppts); 235 235 } 236 236 … … 521 521 string Clinic, 522 522 string TypeStatus, 523 BSDXResourceRow parentBSDXResourceRowBy BSDXResourcePatientAppts,523 BSDXResourceRow parentBSDXResourceRowByFK_BSDXResource_PatientAppts, 524 524 string APPT_MADE_BY, 525 525 System.DateTime DATE_APPT_MADE, … … 548 548 ZIP, 549 549 HOMEPHONE}; 550 if ((parentBSDXResourceRowBy BSDXResourcePatientAppts != null)) {551 columnValuesArray[7] = parentBSDXResourceRowBy BSDXResourcePatientAppts[0];550 if ((parentBSDXResourceRowByFK_BSDXResource_PatientAppts != null)) { 551 columnValuesArray[7] = parentBSDXResourceRowByFK_BSDXResource_PatientAppts[0]; 552 552 } 553 553 rowPatientApptsRow.ItemArray = columnValuesArray; … … 604 604 this.columnTypeStatus = new global::System.Data.DataColumn("TypeStatus", typeof(string), null, global::System.Data.MappingType.Element); 605 605 base.Columns.Add(this.columnTypeStatus); 606 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof( uint), null, global::System.Data.MappingType.Element);606 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element); 607 607 base.Columns.Add(this.columnRESOURCEID); 608 608 this.columnAPPT_MADE_BY = new global::System.Data.DataColumn("APPT_MADE_BY", typeof(string), null, global::System.Data.MappingType.Element); … … 833 833 834 834 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 835 public BSDXResourceRow AddBSDXResourceRow( uint RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT) {835 public BSDXResourceRow AddBSDXResourceRow(int RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT) { 836 836 BSDXResourceRow rowBSDXResourceRow = ((BSDXResourceRow)(this.NewRow())); 837 837 object[] columnValuesArray = new object[] { … … 865 865 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 866 866 private void InitClass() { 867 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof( uint), null, global::System.Data.MappingType.Element);867 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element); 868 868 base.Columns.Add(this.columnRESOURCEID); 869 869 this.columnRESOURCE_NAME = new global::System.Data.DataColumn("RESOURCE_NAME", typeof(string), null, global::System.Data.MappingType.Element); … … 1112 1112 1113 1113 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1114 public uint RESOURCEID {1115 get { 1116 try { 1117 return (( uint)(this[this.tablePatientAppts.RESOURCEIDColumn]));1114 public int RESOURCEID { 1115 get { 1116 try { 1117 return ((int)(this[this.tablePatientAppts.RESOURCEIDColumn])); 1118 1118 } 1119 1119 catch (global::System.InvalidCastException e) { … … 1249 1249 public BSDXResourceRow BSDXResourceRow { 1250 1250 get { 1251 return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations[" BSDXResourcePatientAppts"])));1252 } 1253 set { 1254 this.SetParentRow(value, this.Table.ParentRelations[" BSDXResourcePatientAppts"]);1251 return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]))); 1252 } 1253 set { 1254 this.SetParentRow(value, this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]); 1255 1255 } 1256 1256 } … … 1432 1432 1433 1433 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1434 public uint RESOURCEID {1435 get { 1436 return (( uint)(this[this.tableBSDXResource.RESOURCEIDColumn]));1434 public int RESOURCEID { 1435 get { 1436 return ((int)(this[this.tableBSDXResource.RESOURCEIDColumn])); 1437 1437 } 1438 1438 set { … … 1493 1493 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1494 1494 public PatientApptsRow[] GetPatientApptsRows() { 1495 if ((this.Table.ChildRelations[" BSDXResourcePatientAppts"] == null)) {1495 if ((this.Table.ChildRelations["FK_BSDXResource_PatientAppts"] == null)) { 1496 1496 return new PatientApptsRow[0]; 1497 1497 } 1498 1498 else { 1499 return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations[" BSDXResourcePatientAppts"])));1499 return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["FK_BSDXResource_PatientAppts"]))); 1500 1500 } 1501 1501 } -
Scheduling/trunk/cs/bsdx0200GUISourceCode/dsPatientApptDisplay2.xsd
r614 r772 1 <?xml version="1.0" encoding="utf-8" ?> 2 <xs:schema id="dsPatientApptDisplay2" targetNamespace="http://tempuri.org/dsPatientApptDisplay2.xsd" 3 elementFormDefault="qualified" attributeFormDefault="qualified" xmlns="http://tempuri.org/dsPatientApptDisplay2.xsd" 4 xmlns:mstns="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" 5 xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> 6 <xs:element name="dsPatientApptDisplay2" msdata:IsDataSet="true"> 7 <xs:complexType> 8 <xs:choice maxOccurs="unbounded"> 9 <xs:element name="PatientAppts"> 10 <xs:complexType> 11 <xs:sequence> 12 <xs:element name="Name" type="xs:string" minOccurs="0" /> 13 <xs:element name="DOB" type="xs:date" minOccurs="0" /> 14 <xs:element name="Sex" type="xs:string" minOccurs="0" /> 15 <xs:element name="HRN" type="xs:string" minOccurs="0" /> 16 <xs:element name="ApptDate" type="xs:date" minOccurs="0" /> 17 <xs:element name="Clinic" type="xs:string" minOccurs="0" /> 18 <xs:element name="TypeStatus" type="xs:string" minOccurs="0" /> 19 <xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" /> 20 <xs:element name="APPT_MADE_BY" type="xs:string" minOccurs="0" /> 21 <xs:element name="DATE_APPT_MADE" type="xs:date" minOccurs="0" /> 22 <xs:element name="NOTE" type="xs:string" minOccurs="0" /> 23 <xs:element name="STREET" type="xs:string" minOccurs="0" /> 24 <xs:element name="CITY" type="xs:string" minOccurs="0" /> 25 <xs:element name="STATE" type="xs:string" minOccurs="0" /> 26 <xs:element name="ZIP" type="xs:string" minOccurs="0" /> 27 <xs:element name="HOMEPHONE" type="xs:string" minOccurs="0" /> 28 </xs:sequence> 29 </xs:complexType> 30 </xs:element> 31 <xs:element name="BSDXResource"> 32 <xs:complexType> 33 <xs:sequence> 34 <xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" /> 35 <xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" /> 36 <xs:element name="LETTER_TEXT" type="xs:string" minOccurs="0" /> 37 </xs:sequence> 38 </xs:complexType> 39 </xs:element> 40 </xs:choice> 41 </xs:complexType> 42 <xs:key name="kBSDXResourceID"> 43 <xs:selector xpath=".//mstns:BSDXResource" /> 44 <xs:field xpath="mstns:RESOURCEID" /> 45 </xs:key> 46 <xs:keyref name="BSDXResourcePatientAppts" refer="kBSDXResourceID"> 47 <xs:selector xpath=".//mstns:PatientAppts" /> 48 <xs:field xpath="mstns:RESOURCEID" /> 49 </xs:keyref> 50 </xs:element> 1 <?xml version="1.0" encoding="utf-8"?> 2 <xs:schema id="dsPatientApptDisplay2" targetNamespace="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns:mstns="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns="http://tempuri.org/dsPatientApptDisplay2.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified"> 3 <xs:annotation> 4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource"> 5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> 6 <Connections /> 7 <Tables /> 8 <Sources /> 9 </DataSource> 10 </xs:appinfo> 11 </xs:annotation> 12 <xs:element name="dsPatientApptDisplay2" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsPatientApptDisplay2" msprop:Generator_DataSetName="dsPatientApptDisplay2"> 13 <xs:complexType> 14 <xs:choice minOccurs="0" maxOccurs="unbounded"> 15 <xs:element name="PatientAppts" msprop:Generator_UserTableName="PatientAppts" msprop:Generator_RowDeletedName="PatientApptsRowDeleted" msprop:Generator_TableClassName="PatientApptsDataTable" msprop:Generator_RowChangedName="PatientApptsRowChanged" msprop:Generator_RowClassName="PatientApptsRow" msprop:Generator_RowChangingName="PatientApptsRowChanging" msprop:Generator_RowEvArgName="PatientApptsRowChangeEvent" msprop:Generator_RowEvHandlerName="PatientApptsRowChangeEventHandler" msprop:Generator_TablePropName="PatientAppts" msprop:Generator_TableVarName="tablePatientAppts" msprop:Generator_RowDeletingName="PatientApptsRowDeleting"> 16 <xs:complexType> 17 <xs:sequence> 18 <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" type="xs:string" minOccurs="0" /> 19 <xs:element name="DOB" msprop:Generator_UserColumnName="DOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" type="xs:date" minOccurs="0" /> 20 <xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInTable="SexColumn" type="xs:string" minOccurs="0" /> 21 <xs:element name="HRN" msprop:Generator_UserColumnName="HRN" msprop:Generator_ColumnPropNameInRow="HRN" msprop:Generator_ColumnVarNameInTable="columnHRN" msprop:Generator_ColumnPropNameInTable="HRNColumn" type="xs:string" minOccurs="0" /> 22 <xs:element name="ApptDate" msprop:Generator_UserColumnName="ApptDate" msprop:Generator_ColumnPropNameInRow="ApptDate" msprop:Generator_ColumnVarNameInTable="columnApptDate" msprop:Generator_ColumnPropNameInTable="ApptDateColumn" type="xs:date" minOccurs="0" /> 23 <xs:element name="Clinic" msprop:Generator_UserColumnName="Clinic" msprop:Generator_ColumnPropNameInRow="Clinic" msprop:Generator_ColumnVarNameInTable="columnClinic" msprop:Generator_ColumnPropNameInTable="ClinicColumn" type="xs:string" minOccurs="0" /> 24 <xs:element name="TypeStatus" msprop:Generator_UserColumnName="TypeStatus" msprop:Generator_ColumnPropNameInRow="TypeStatus" msprop:Generator_ColumnVarNameInTable="columnTypeStatus" msprop:Generator_ColumnPropNameInTable="TypeStatusColumn" type="xs:string" minOccurs="0" /> 25 <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" minOccurs="0" /> 26 <xs:element name="APPT_MADE_BY" msprop:Generator_UserColumnName="APPT_MADE_BY" msprop:Generator_ColumnPropNameInRow="APPT_MADE_BY" msprop:Generator_ColumnVarNameInTable="columnAPPT_MADE_BY" msprop:Generator_ColumnPropNameInTable="APPT_MADE_BYColumn" type="xs:string" minOccurs="0" /> 27 <xs:element name="DATE_APPT_MADE" msprop:Generator_UserColumnName="DATE_APPT_MADE" msprop:Generator_ColumnPropNameInRow="DATE_APPT_MADE" msprop:Generator_ColumnVarNameInTable="columnDATE_APPT_MADE" msprop:Generator_ColumnPropNameInTable="DATE_APPT_MADEColumn" type="xs:date" minOccurs="0" /> 28 <xs:element name="NOTE" msprop:Generator_UserColumnName="NOTE" msprop:Generator_ColumnPropNameInRow="NOTE" msprop:Generator_ColumnVarNameInTable="columnNOTE" msprop:Generator_ColumnPropNameInTable="NOTEColumn" type="xs:string" minOccurs="0" /> 29 <xs:element name="STREET" msprop:Generator_UserColumnName="STREET" msprop:Generator_ColumnPropNameInRow="STREET" msprop:Generator_ColumnVarNameInTable="columnSTREET" msprop:Generator_ColumnPropNameInTable="STREETColumn" type="xs:string" minOccurs="0" /> 30 <xs:element name="CITY" msprop:Generator_UserColumnName="CITY" msprop:Generator_ColumnPropNameInRow="CITY" msprop:Generator_ColumnVarNameInTable="columnCITY" msprop:Generator_ColumnPropNameInTable="CITYColumn" type="xs:string" minOccurs="0" /> 31 <xs:element name="STATE" msprop:Generator_UserColumnName="STATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" type="xs:string" minOccurs="0" /> 32 <xs:element name="ZIP" msprop:Generator_UserColumnName="ZIP" msprop:Generator_ColumnPropNameInRow="ZIP" msprop:Generator_ColumnVarNameInTable="columnZIP" msprop:Generator_ColumnPropNameInTable="ZIPColumn" type="xs:string" minOccurs="0" /> 33 <xs:element name="HOMEPHONE" msprop:Generator_UserColumnName="HOMEPHONE" msprop:Generator_ColumnPropNameInRow="HOMEPHONE" msprop:Generator_ColumnVarNameInTable="columnHOMEPHONE" msprop:Generator_ColumnPropNameInTable="HOMEPHONEColumn" type="xs:string" minOccurs="0" /> 34 </xs:sequence> 35 </xs:complexType> 36 </xs:element> 37 <xs:element name="BSDXResource" msprop:Generator_UserTableName="BSDXResource" msprop:Generator_RowDeletedName="BSDXResourceRowDeleted" msprop:Generator_TableClassName="BSDXResourceDataTable" msprop:Generator_RowChangedName="BSDXResourceRowChanged" msprop:Generator_RowClassName="BSDXResourceRow" msprop:Generator_RowChangingName="BSDXResourceRowChanging" msprop:Generator_RowEvArgName="BSDXResourceRowChangeEvent" msprop:Generator_RowEvHandlerName="BSDXResourceRowChangeEventHandler" msprop:Generator_TablePropName="BSDXResource" msprop:Generator_TableVarName="tableBSDXResource" msprop:Generator_RowDeletingName="BSDXResourceRowDeleting"> 38 <xs:complexType> 39 <xs:sequence> 40 <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" /> 41 <xs:element name="RESOURCE_NAME" msprop:Generator_UserColumnName="RESOURCE_NAME" msprop:Generator_ColumnPropNameInRow="RESOURCE_NAME" msprop:Generator_ColumnVarNameInTable="columnRESOURCE_NAME" msprop:Generator_ColumnPropNameInTable="RESOURCE_NAMEColumn" type="xs:string" minOccurs="0" /> 42 <xs:element name="LETTER_TEXT" msprop:Generator_UserColumnName="LETTER_TEXT" msprop:Generator_ColumnPropNameInRow="LETTER_TEXT" msprop:Generator_ColumnVarNameInTable="columnLETTER_TEXT" msprop:Generator_ColumnPropNameInTable="LETTER_TEXTColumn" type="xs:string" minOccurs="0" /> 43 </xs:sequence> 44 </xs:complexType> 45 </xs:element> 46 </xs:choice> 47 </xs:complexType> 48 <xs:unique name="kBSDXResourceID"> 49 <xs:selector xpath=".//mstns:BSDXResource" /> 50 <xs:field xpath="mstns:RESOURCEID" /> 51 </xs:unique> 52 <xs:keyref name="FK_BSDXResource_PatientAppts" refer="kBSDXResourceID" msprop:rel_Generator_UserRelationName="FK_BSDXResource_PatientAppts" msprop:rel_Generator_RelationVarName="relationFK_BSDXResource_PatientAppts" msprop:rel_Generator_UserChildTable="PatientAppts" msprop:rel_Generator_UserParentTable="BSDXResource" msprop:rel_Generator_ParentPropName="BSDXResourceRow" msprop:rel_Generator_ChildPropName="GetPatientApptsRows"> 53 <xs:selector xpath=".//mstns:PatientAppts" /> 54 <xs:field xpath="mstns:RESOURCEID" /> 55 </xs:keyref> 56 </xs:element> 51 57 </xs:schema> -
Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.Designer.cs
r614 r772 2 2 // <auto-generated> 3 3 // This code was generated by a tool. 4 // Runtime Version:2.0.50727.3 0534 // Runtime Version:2.0.50727.3603 5 5 // 6 6 // Changes to this file may cause incorrect behavior and will be lost if … … 30 30 private BSDXResourceDataTable tableBSDXResource; 31 31 32 private global::System.Data.DataRelation relation BSDXResourcePatientAppts;32 private global::System.Data.DataRelation relationFK_BSDXResource_PatientAppts; 33 33 34 34 private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; … … 207 207 } 208 208 } 209 this.relation BSDXResourcePatientAppts = this.Relations["BSDXResourcePatientAppts"];209 this.relationFK_BSDXResource_PatientAppts = this.Relations["FK_BSDXResource_PatientAppts"]; 210 210 } 211 211 … … 222 222 base.Tables.Add(this.tableBSDXResource); 223 223 global::System.Data.ForeignKeyConstraint fkc; 224 fkc = new global::System.Data.ForeignKeyConstraint(" BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {224 fkc = new global::System.Data.ForeignKeyConstraint("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] { 225 225 this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] { 226 226 this.tablePatientAppts.RESOURCEIDColumn}); … … 229 229 fkc.DeleteRule = global::System.Data.Rule.Cascade; 230 230 fkc.UpdateRule = global::System.Data.Rule.Cascade; 231 this.relation BSDXResourcePatientAppts = new global::System.Data.DataRelation("BSDXResourcePatientAppts", new global::System.Data.DataColumn[] {231 this.relationFK_BSDXResource_PatientAppts = new global::System.Data.DataRelation("FK_BSDXResource_PatientAppts", new global::System.Data.DataColumn[] { 232 232 this.tableBSDXResource.RESOURCEIDColumn}, new global::System.Data.DataColumn[] { 233 233 this.tablePatientAppts.RESOURCEIDColumn}, false); 234 this.Relations.Add(this.relation BSDXResourcePatientAppts);234 this.Relations.Add(this.relationFK_BSDXResource_PatientAppts); 235 235 } 236 236 … … 530 530 string Clinic, 531 531 string TypeStatus, 532 BSDXResourceRow parentBSDXResourceRowBy BSDXResourcePatientAppts,532 BSDXResourceRow parentBSDXResourceRowByFK_BSDXResource_PatientAppts, 533 533 string APPT_MADE_BY, 534 534 System.DateTime DATE_APPT_MADE, … … 559 559 HOMEPHONE, 560 560 OldApptDate}; 561 if ((parentBSDXResourceRowBy BSDXResourcePatientAppts != null)) {562 columnValuesArray[7] = parentBSDXResourceRowBy BSDXResourcePatientAppts[0];561 if ((parentBSDXResourceRowByFK_BSDXResource_PatientAppts != null)) { 562 columnValuesArray[7] = parentBSDXResourceRowByFK_BSDXResource_PatientAppts[0]; 563 563 } 564 564 rowPatientApptsRow.ItemArray = columnValuesArray; … … 616 616 this.columnTypeStatus = new global::System.Data.DataColumn("TypeStatus", typeof(string), null, global::System.Data.MappingType.Element); 617 617 base.Columns.Add(this.columnTypeStatus); 618 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof( uint), null, global::System.Data.MappingType.Element);618 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element); 619 619 base.Columns.Add(this.columnRESOURCEID); 620 620 this.columnAPPT_MADE_BY = new global::System.Data.DataColumn("APPT_MADE_BY", typeof(string), null, global::System.Data.MappingType.Element); … … 865 865 866 866 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 867 public BSDXResourceRow AddBSDXResourceRow( uint RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT, string NO_SHOW_LETTER, string CLINIC_CANCELLATION_LETTER) {867 public BSDXResourceRow AddBSDXResourceRow(int RESOURCEID, string RESOURCE_NAME, string LETTER_TEXT, string NO_SHOW_LETTER, string CLINIC_CANCELLATION_LETTER) { 868 868 BSDXResourceRow rowBSDXResourceRow = ((BSDXResourceRow)(this.NewRow())); 869 869 object[] columnValuesArray = new object[] { … … 901 901 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 902 902 private void InitClass() { 903 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof( uint), null, global::System.Data.MappingType.Element);903 this.columnRESOURCEID = new global::System.Data.DataColumn("RESOURCEID", typeof(int), null, global::System.Data.MappingType.Element); 904 904 base.Columns.Add(this.columnRESOURCEID); 905 905 this.columnRESOURCE_NAME = new global::System.Data.DataColumn("RESOURCE_NAME", typeof(string), null, global::System.Data.MappingType.Element); … … 1152 1152 1153 1153 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1154 public uint RESOURCEID {1155 get { 1156 try { 1157 return (( uint)(this[this.tablePatientAppts.RESOURCEIDColumn]));1154 public int RESOURCEID { 1155 get { 1156 try { 1157 return ((int)(this[this.tablePatientAppts.RESOURCEIDColumn])); 1158 1158 } 1159 1159 catch (global::System.InvalidCastException e) { … … 1304 1304 public BSDXResourceRow BSDXResourceRow { 1305 1305 get { 1306 return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations[" BSDXResourcePatientAppts"])));1307 } 1308 set { 1309 this.SetParentRow(value, this.Table.ParentRelations[" BSDXResourcePatientAppts"]);1306 return ((BSDXResourceRow)(this.GetParentRow(this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]))); 1307 } 1308 set { 1309 this.SetParentRow(value, this.Table.ParentRelations["FK_BSDXResource_PatientAppts"]); 1310 1310 } 1311 1311 } … … 1497 1497 1498 1498 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1499 public uint RESOURCEID {1500 get { 1501 return (( uint)(this[this.tableBSDXResource.RESOURCEIDColumn]));1499 public int RESOURCEID { 1500 get { 1501 return ((int)(this[this.tableBSDXResource.RESOURCEIDColumn])); 1502 1502 } 1503 1503 set { … … 1609 1609 [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] 1610 1610 public PatientApptsRow[] GetPatientApptsRows() { 1611 if ((this.Table.ChildRelations[" BSDXResourcePatientAppts"] == null)) {1611 if ((this.Table.ChildRelations["FK_BSDXResource_PatientAppts"] == null)) { 1612 1612 return new PatientApptsRow[0]; 1613 1613 } 1614 1614 else { 1615 return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations[" BSDXResourcePatientAppts"])));1615 return ((PatientApptsRow[])(base.GetChildRows(this.Table.ChildRelations["FK_BSDXResource_PatientAppts"]))); 1616 1616 } 1617 1617 } -
Scheduling/trunk/cs/bsdx0200GUISourceCode/dsRebookAppts.xsd
r614 r772 1 <?xml version="1.0" encoding="utf-8" ?> 2 <xs:schema id="dsRebookAppts" targetNamespace="http://tempuri.org/dsRebookAppts.xsd" elementFormDefault="qualified" 3 attributeFormDefault="qualified" xmlns="http://tempuri.org/dsRebookAppts.xsd" xmlns:mstns="http://tempuri.org/dsRebookAppts.xsd" 4 xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata"> 5 <xs:element name="dsRebookAppts" msdata:IsDataSet="true"> 6 <xs:complexType> 7 <xs:choice maxOccurs="unbounded"> 8 <xs:element name="PatientAppts"> 9 <xs:complexType> 10 <xs:sequence> 11 <xs:element name="Name" type="xs:string" minOccurs="0" /> 12 <xs:element name="DOB" type="xs:date" minOccurs="0" /> 13 <xs:element name="Sex" type="xs:string" minOccurs="0" /> 14 <xs:element name="HRN" type="xs:string" minOccurs="0" /> 15 <xs:element name="NewApptDate" type="xs:date" minOccurs="0" /> 16 <xs:element name="Clinic" type="xs:string" minOccurs="0" /> 17 <xs:element name="TypeStatus" type="xs:string" minOccurs="0" /> 18 <xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" /> 19 <xs:element name="APPT_MADE_BY" type="xs:string" minOccurs="0" /> 20 <xs:element name="DATE_APPT_MADE" type="xs:date" minOccurs="0" /> 21 <xs:element name="NOTE" type="xs:string" minOccurs="0" /> 22 <xs:element name="STREET" type="xs:string" minOccurs="0" /> 23 <xs:element name="CITY" type="xs:string" minOccurs="0" /> 24 <xs:element name="STATE" type="xs:string" minOccurs="0" /> 25 <xs:element name="ZIP" type="xs:string" minOccurs="0" /> 26 <xs:element name="HOMEPHONE" type="xs:string" minOccurs="0" /> 27 <xs:element name="OldApptDate" type="xs:date" minOccurs="0" /> 28 </xs:sequence> 29 </xs:complexType> 30 </xs:element> 31 <xs:element name="BSDXResource"> 32 <xs:complexType> 33 <xs:sequence> 34 <xs:element name="RESOURCEID" type="xs:unsignedInt" minOccurs="0" /> 35 <xs:element name="RESOURCE_NAME" type="xs:string" minOccurs="0" /> 36 <xs:element name="LETTER_TEXT" type="xs:string" minOccurs="0" /> 37 <xs:element name="NO_SHOW_LETTER" type="xs:string" minOccurs="0" /> 38 <xs:element name="CLINIC_CANCELLATION_LETTER" type="xs:string" minOccurs="0" /> 39 </xs:sequence> 40 </xs:complexType> 41 </xs:element> 42 </xs:choice> 43 </xs:complexType> 44 <xs:key name="kBSDXResourceID"> 45 <xs:selector xpath=".//mstns:BSDXResource" /> 46 <xs:field xpath="mstns:RESOURCEID" /> 47 </xs:key> 48 <xs:keyref name="BSDXResourcePatientAppts" refer="kBSDXResourceID"> 49 <xs:selector xpath=".//mstns:PatientAppts" /> 50 <xs:field xpath="mstns:RESOURCEID" /> 51 </xs:keyref> 52 </xs:element> 1 <?xml version="1.0" encoding="utf-8"?> 2 <xs:schema id="dsRebookAppts" targetNamespace="http://tempuri.org/dsRebookAppts.xsd" xmlns:mstns="http://tempuri.org/dsRebookAppts.xsd" xmlns="http://tempuri.org/dsRebookAppts.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified"> 3 <xs:annotation> 4 <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource"> 5 <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource"> 6 <Connections /> 7 <Tables /> 8 <Sources /> 9 </DataSource> 10 </xs:appinfo> 11 </xs:annotation> 12 <xs:element name="dsRebookAppts" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="dsRebookAppts" msprop:Generator_DataSetName="dsRebookAppts"> 13 <xs:complexType> 14 <xs:choice minOccurs="0" maxOccurs="unbounded"> 15 <xs:element name="PatientAppts" msprop:Generator_UserTableName="PatientAppts" msprop:Generator_RowDeletedName="PatientApptsRowDeleted" msprop:Generator_TableClassName="PatientApptsDataTable" msprop:Generator_RowChangedName="PatientApptsRowChanged" msprop:Generator_RowClassName="PatientApptsRow" msprop:Generator_RowChangingName="PatientApptsRowChanging" msprop:Generator_RowEvArgName="PatientApptsRowChangeEvent" msprop:Generator_RowEvHandlerName="PatientApptsRowChangeEventHandler" msprop:Generator_TablePropName="PatientAppts" msprop:Generator_TableVarName="tablePatientAppts" msprop:Generator_RowDeletingName="PatientApptsRowDeleting"> 16 <xs:complexType> 17 <xs:sequence> 18 <xs:element name="Name" msprop:Generator_UserColumnName="Name" msprop:Generator_ColumnPropNameInRow="Name" msprop:Generator_ColumnVarNameInTable="columnName" msprop:Generator_ColumnPropNameInTable="NameColumn" type="xs:string" minOccurs="0" /> 19 <xs:element name="DOB" msprop:Generator_UserColumnName="DOB" msprop:Generator_ColumnPropNameInRow="DOB" msprop:Generator_ColumnVarNameInTable="columnDOB" msprop:Generator_ColumnPropNameInTable="DOBColumn" type="xs:date" minOccurs="0" /> 20 <xs:element name="Sex" msprop:Generator_UserColumnName="Sex" msprop:Generator_ColumnPropNameInRow="Sex" msprop:Generator_ColumnVarNameInTable="columnSex" msprop:Generator_ColumnPropNameInTable="SexColumn" type="xs:string" minOccurs="0" /> 21 <xs:element name="HRN" msprop:Generator_UserColumnName="HRN" msprop:Generator_ColumnPropNameInRow="HRN" msprop:Generator_ColumnVarNameInTable="columnHRN" msprop:Generator_ColumnPropNameInTable="HRNColumn" type="xs:string" minOccurs="0" /> 22 <xs:element name="NewApptDate" msprop:Generator_UserColumnName="NewApptDate" msprop:Generator_ColumnPropNameInRow="NewApptDate" msprop:Generator_ColumnVarNameInTable="columnNewApptDate" msprop:Generator_ColumnPropNameInTable="NewApptDateColumn" type="xs:date" minOccurs="0" /> 23 <xs:element name="Clinic" msprop:Generator_UserColumnName="Clinic" msprop:Generator_ColumnPropNameInRow="Clinic" msprop:Generator_ColumnVarNameInTable="columnClinic" msprop:Generator_ColumnPropNameInTable="ClinicColumn" type="xs:string" minOccurs="0" /> 24 <xs:element name="TypeStatus" msprop:Generator_UserColumnName="TypeStatus" msprop:Generator_ColumnPropNameInRow="TypeStatus" msprop:Generator_ColumnVarNameInTable="columnTypeStatus" msprop:Generator_ColumnPropNameInTable="TypeStatusColumn" type="xs:string" minOccurs="0" /> 25 <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" minOccurs="0" /> 26 <xs:element name="APPT_MADE_BY" msprop:Generator_UserColumnName="APPT_MADE_BY" msprop:Generator_ColumnPropNameInRow="APPT_MADE_BY" msprop:Generator_ColumnVarNameInTable="columnAPPT_MADE_BY" msprop:Generator_ColumnPropNameInTable="APPT_MADE_BYColumn" type="xs:string" minOccurs="0" /> 27 <xs:element name="DATE_APPT_MADE" msprop:Generator_UserColumnName="DATE_APPT_MADE" msprop:Generator_ColumnPropNameInRow="DATE_APPT_MADE" msprop:Generator_ColumnVarNameInTable="columnDATE_APPT_MADE" msprop:Generator_ColumnPropNameInTable="DATE_APPT_MADEColumn" type="xs:date" minOccurs="0" /> 28 <xs:element name="NOTE" msprop:Generator_UserColumnName="NOTE" msprop:Generator_ColumnPropNameInRow="NOTE" msprop:Generator_ColumnVarNameInTable="columnNOTE" msprop:Generator_ColumnPropNameInTable="NOTEColumn" type="xs:string" minOccurs="0" /> 29 <xs:element name="STREET" msprop:Generator_UserColumnName="STREET" msprop:Generator_ColumnPropNameInRow="STREET" msprop:Generator_ColumnVarNameInTable="columnSTREET" msprop:Generator_ColumnPropNameInTable="STREETColumn" type="xs:string" minOccurs="0" /> 30 <xs:element name="CITY" msprop:Generator_UserColumnName="CITY" msprop:Generator_ColumnPropNameInRow="CITY" msprop:Generator_ColumnVarNameInTable="columnCITY" msprop:Generator_ColumnPropNameInTable="CITYColumn" type="xs:string" minOccurs="0" /> 31 <xs:element name="STATE" msprop:Generator_UserColumnName="STATE" msprop:Generator_ColumnPropNameInRow="STATE" msprop:Generator_ColumnVarNameInTable="columnSTATE" msprop:Generator_ColumnPropNameInTable="STATEColumn" type="xs:string" minOccurs="0" /> 32 <xs:element name="ZIP" msprop:Generator_UserColumnName="ZIP" msprop:Generator_ColumnPropNameInRow="ZIP" msprop:Generator_ColumnVarNameInTable="columnZIP" msprop:Generator_ColumnPropNameInTable="ZIPColumn" type="xs:string" minOccurs="0" /> 33 <xs:element name="HOMEPHONE" msprop:Generator_UserColumnName="HOMEPHONE" msprop:Generator_ColumnPropNameInRow="HOMEPHONE" msprop:Generator_ColumnVarNameInTable="columnHOMEPHONE" msprop:Generator_ColumnPropNameInTable="HOMEPHONEColumn" type="xs:string" minOccurs="0" /> 34 <xs:element name="OldApptDate" msprop:Generator_UserColumnName="OldApptDate" msprop:Generator_ColumnPropNameInRow="OldApptDate" msprop:Generator_ColumnVarNameInTable="columnOldApptDate" msprop:Generator_ColumnPropNameInTable="OldApptDateColumn" type="xs:date" minOccurs="0" /> 35 </xs:sequence> 36 </xs:complexType> 37 </xs:element> 38 <xs:element name="BSDXResource" msprop:Generator_UserTableName="BSDXResource" msprop:Generator_RowDeletedName="BSDXResourceRowDeleted" msprop:Generator_TableClassName="BSDXResourceDataTable" msprop:Generator_RowChangedName="BSDXResourceRowChanged" msprop:Generator_RowClassName="BSDXResourceRow" msprop:Generator_RowChangingName="BSDXResourceRowChanging" msprop:Generator_RowEvArgName="BSDXResourceRowChangeEvent" msprop:Generator_RowEvHandlerName="BSDXResourceRowChangeEventHandler" msprop:Generator_TablePropName="BSDXResource" msprop:Generator_TableVarName="tableBSDXResource" msprop:Generator_RowDeletingName="BSDXResourceRowDeleting"> 39 <xs:complexType> 40 <xs:sequence> 41 <xs:element name="RESOURCEID" msprop:Generator_UserColumnName="RESOURCEID" msprop:Generator_ColumnPropNameInRow="RESOURCEID" msprop:Generator_ColumnVarNameInTable="columnRESOURCEID" msprop:Generator_ColumnPropNameInTable="RESOURCEIDColumn" type="xs:int" /> 42 <xs:element name="RESOURCE_NAME" msprop:Generator_UserColumnName="RESOURCE_NAME" msprop:Generator_ColumnPropNameInRow="RESOURCE_NAME" msprop:Generator_ColumnVarNameInTable="columnRESOURCE_NAME" msprop:Generator_ColumnPropNameInTable="RESOURCE_NAMEColumn" type="xs:string" minOccurs="0" /> 43 <xs:element name="LETTER_TEXT" msprop:Generator_UserColumnName="LETTER_TEXT" msprop:Generator_ColumnPropNameInRow="LETTER_TEXT" msprop:Generator_ColumnVarNameInTable="columnLETTER_TEXT" msprop:Generator_ColumnPropNameInTable="LETTER_TEXTColumn" type="xs:string" minOccurs="0" /> 44 <xs:element name="NO_SHOW_LETTER" msprop:Generator_UserColumnName="NO_SHOW_LETTER" msprop:Generator_ColumnPropNameInRow="NO_SHOW_LETTER" msprop:Generator_ColumnVarNameInTable="columnNO_SHOW_LETTER" msprop:Generator_ColumnPropNameInTable="NO_SHOW_LETTERColumn" type="xs:string" minOccurs="0" /> 45 <xs:element name="CLINIC_CANCELLATION_LETTER" msprop:Generator_UserColumnName="CLINIC_CANCELLATION_LETTER" msprop:Generator_ColumnPropNameInRow="CLINIC_CANCELLATION_LETTER" msprop:Generator_ColumnVarNameInTable="columnCLINIC_CANCELLATION_LETTER" msprop:Generator_ColumnPropNameInTable="CLINIC_CANCELLATION_LETTERColumn" type="xs:string" minOccurs="0" /> 46 </xs:sequence> 47 </xs:complexType> 48 </xs:element> 49 </xs:choice> 50 </xs:complexType> 51 <xs:unique name="kBSDXResourceID"> 52 <xs:selector xpath=".//mstns:BSDXResource" /> 53 <xs:field xpath="mstns:RESOURCEID" /> 54 </xs:unique> 55 <xs:keyref name="FK_BSDXResource_PatientAppts" refer="kBSDXResourceID" msprop:rel_Generator_UserRelationName="FK_BSDXResource_PatientAppts" msprop:rel_Generator_RelationVarName="relationFK_BSDXResource_PatientAppts" msprop:rel_Generator_UserChildTable="PatientAppts" msprop:rel_Generator_UserParentTable="BSDXResource" msprop:rel_Generator_ParentPropName="BSDXResourceRow" msprop:rel_Generator_ChildPropName="GetPatientApptsRows"> 56 <xs:selector xpath=".//mstns:PatientAppts" /> 57 <xs:field xpath="mstns:RESOURCEID" /> 58 </xs:keyref> 59 </xs:element> 53 60 </xs:schema>
Note:
See TracChangeset
for help on using the changeset viewer.