shortqolurinary.ascx.cs

医疗决策支持系统

namespace Caisis.UI.Modules.Prostate.Eforms
{
	using System;
	using System.Data;
	using System.Data.SqlClient;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;

	using Caisis.BusinessObject;
	using Caisis.UI.Core.Classes;
	using Caisis.UI.Modules.Prostate.PaperForms;
	using Caisis.DataAccess;
	using Caisis.UI.Core.Classes.CustomControls;

	using System.Collections;


	/// <summary>
	///		Summary description for ProstateHPI.
	/// </summary>
	public class ShortQOLUrinary : BaseEFormControl
	{
		protected EformTextBox DateMildContinenceAchieved, DateTotalContinenceAchieved;
		protected Label LastCont, LastIncontTx, UrinaryQOL, DateMildContinenceAchievedLabel, DateTotalContinenceAchievedLabel;
		protected HtmlTableRow LastUrinaryQOLRow, PastMildContinenceRow, PastTotalContinenceRow;

		// protected Literal Inc_Stub, Stric_Stub;
		protected EformHidden IncontinenceTX_Indication, StrictureTX_Indication;

		protected EformHidden SurveyDate_1, SurveyDate_2, SurveyDate_IPSS;
		protected EformHidden SurveyDateText_1, SurveyDateText_2, SurveyDateText_IPSS;



		override protected void Page_Load(object sender, System.EventArgs e)
		{
			base.Page_Load(sender, e);
			PopulateContinenceFields();

//			Inc_Stub.Text = IncontinenceTX_Indication.ClientID;
//			Stric_Stub.Text = StrictureTX_Indication.ClientID;

			object o_phy = Session[SessionKey.CurrentListCrit];
			object o_dt = Session[SessionKey.CurrentClinicDate];
			object o_mrn = Session[SessionKey.PtMRN];

			if (o_phy != null && o_dt != null && o_mrn != null)
			{	
				string clinicDateString = GetAppointmentDateString(o_mrn.ToString(), o_phy.ToString(), DateTime.Parse(o_dt.ToString()));
				
				if (clinicDateString != null)
				{
					if (SurveyDateText_1.Value == null || SurveyDateText_1.Value.Length < 1)
					{
						SurveyDate_1.Value = clinicDateString;
						SurveyDateText_1.Value = clinicDateString;
						SurveyDate_1.Disabled = true;
					}

					if (SurveyDateText_2.Value == null || SurveyDateText_2.Value.Length < 1)
					{
						SurveyDate_2.Value = clinicDateString;
						SurveyDateText_2.Value = clinicDateString;
						SurveyDate_2.Disabled = true;
					}

					if (SurveyDateText_IPSS.Value == null || SurveyDateText_IPSS.Value.Length < 1)
					{
						SurveyDate_IPSS.Value = clinicDateString;
						SurveyDateText_IPSS.Value = clinicDateString;
						SurveyDate_IPSS.Disabled = true;
					}
				}
			}
		}

		protected void PopulateContinenceFields()
		{
			SurveyDa urinaryDa = new SurveyDa();
			Hashtable ht = urinaryDa.FormGetUrinaryStatusValues(this._patientId, this._eformName, "Dynamic");
			if (ht["ContLv2"] != null && ht["ContLv2"].ToString() != "")
			{
//				DateMildContinenceAchieved.Text = ht["ContLv2"].ToString();
//				DateMildContinenceAchieved.ReadOnly = true;

				DateMildContinenceAchievedLabel.Text = ht["ContLv2"].ToString();
				PastMildContinenceRow.Visible = false;
			}
			if (ht["ContLv1"] != null && ht["ContLv1"].ToString() != "")
			{
//				DateTotalContinenceAchieved.Text = ht["ContLv1"].ToString();
//				DateTotalContinenceAchieved.ReadOnly = true;

				DateTotalContinenceAchievedLabel.Text = ht["ContLv1"].ToString();
				PastTotalContinenceRow.Visible = false;
			}
			if (ht["LastCont"] != null && ht["LastCont"].ToString() != "")
			{
				LastCont.Text = "<br/><br/>" + ht["LastCont"].ToString();
			}
				else
				{
					LastCont.Visible = false;
				}
			if (ht["LastIncontTx"] != null && ht["LastIncontTx"].ToString() != "")
			{
				LastIncontTx.Text = "<br/><br/>" + ht["LastIncontTx"].ToString();
			}
				else
				{
					LastIncontTx.Visible = false;
				}
			if (ht["UrinaryQOL"] != null && ht["UrinaryQOL"].ToString() != "")
			{
				UrinaryQOL.Text = ht["UrinaryQOL"].ToString();
			}
			else
			{
				LastUrinaryQOLRow.Visible = false;
			}
		}

		// Checks to see if the appointment data in session is in the database
		private string GetAppointmentDateString(string mrn, string physician, DateTime clinicDate)
		{
			string cmdText = "SELECT * FROM Appointments WHERE ApptMRN = @ApptMRN And ApptPhysician = @ApptPhysician And ApptClinicDate = @ApptClinicDate";
			
			SqlCommand cmd = DataAccessHelper.CreateCommand(cmdText);
			cmd.CommandType = CommandType.Text;

			cmd.Parameters.Add("@ApptMRN", mrn);
			cmd.Parameters.Add("@ApptPhysician", physician);
			cmd.Parameters.Add("@ApptClinicDate", clinicDate);

			DataTable table = new DataTable();
			DataAccessHelper.GetList(cmd, table);

			if (table.Rows.Count > 0)
			{
				DataRow row = table.Rows[0];
				
				return clinicDate.ToShortDateString();
			}

			return null;
		}
	}
}