/// <summary>
/// 根据检查类别绑定检查子类
/// </summary>
public void Bind_ExamSubClass(string DbUesr, string ExamClass, ComboBox cmb_ExamSubClass)
{
System.Data.DataTable dt;
if (GetConfig.RM_RegisterMode == 1)
{
string sql = "select distinct EXAM_SUB_CLASS from USER_EXAM_CLASS where DB_USER='******' and EXAM_CLASS='" + ExamClass + "' order by SORT_ID";
dt = GetDataSet(sql).Tables[0];
cmb_ExamSubClass.DataSource = dt;
cmb_ExamSubClass.DisplayMember = dt.Columns["EXAM_SUB_CLASS"].ColumnName;
}
else
{
BExamClass bExamClass = new BExamClass();
dt = bExamClass.GetList(" EXAM_CLASS ='" + ExamClass + "' ORDER BY SORT_ID");
cmb_ExamSubClass.DataSource = dt;
cmb_ExamSubClass.DisplayMember = dt.Columns["EXAM_SUB_CLASS"].ColumnName;
}
//if (cmb_ExamSubClass.Items.Count == 1)
//{
// this.cmb_ExamSubClass.SelectedIndex = 0;
// this.comb_Sub_Class_SelectionChangeCommitted(null, null);
//}
//else
//{
// this.cmb_ExamSubClass.SelectedIndex = -1;
//}
}
/// <summary>
/// 根据检查类别绑定检查子类
/// </summary>
public void Bind_ExamSubClass(string ExamClass, ComboBox cmb_ExamSubClass)
{
System.Data.DataTable dt;
if (GetConfig.RM_RegisterMode == 1)
{
//string sql = "select distinct EXAM_SUB_CLASS from USER_EXAM_CLASS where DB_USER='******' and EXAM_CLASS='" + comb_ExamClass.Text.ToString() + "'";
//dt = DBoperate.OdbcDaAd(sql, this.connOdbc).Tables[0];
//cmb_ExamSubClass.DataSource = dt;
//cmb_ExamSubClass.DisplayMember = dt.Columns["EXAM_SUB_CLASS"].ColumnName;
}
else
{
BExamClass bExamClass = new BExamClass();
dt = bExamClass.GetList(" EXAM_CLASS ='" + ExamClass + "' order by SORT_ID");
cmb_ExamSubClass.DataSource = dt;
cmb_ExamSubClass.DisplayMember = dt.Columns["EXAM_SUB_CLASS"].ColumnName;
}
//if (cmb_ExamSubClass.Items.Count == 1)
//{
// this.cmb_ExamSubClass.SelectedIndex = 0;
// this.comb_Sub_Class_SelectionChangeCommitted(null, null);
//}
//else
//{
// this.cmb_ExamSubClass.SelectedIndex = -1;
//}
}
//根据检查类别检索相应的检查之类
private void cmb_ExamClass_SelectedIndexChanged(object sender, EventArgs e)
{
this.cmb_ExamSubClass.Items.Clear();
this.initSql = "";
if (this.cmb_ExamClass.Text.Trim() == "全部")
{
SIS_BLL.BExamClass bExam_class = new BExamClass();
string examClass = GetConfig.ExamClass.Replace(",", "','");
DataTable dt = bExamClass.GetList(" exam_class in ('" + examClass + "')");
//string[] examSubClass = GetConfig.ExamSubClass.Split(';');
this.cmb_ExamSubClass.Items.Add("全部");
for (int i = 0; i < dt.Rows.Count; i++)
{
this.cmb_ExamSubClass.Items.Add(dt.Rows[i]["EXAM_SUB_CLASS"]);
}
}
else
{
this.initSql = " exam_class = '" + this.cmb_ExamClass.Text.Trim() + "' ";
this.dt = bExamClass.GetList(this.initSql);
this.cmb_ExamSubClass.Items.Add("全部");
for (int i = 0; i < this.dt.Rows.Count; i++)
{
this.cmb_ExamSubClass.Items.Add(this.dt.Rows[i]["exam_sub_class"].ToString().Trim());
}
}
this.cmb_ExamSubClass.SelectedIndex = 0;
}
/// <summary>
/// °ó¶¨¶¨Î»Í¼
/// </summary>
public void BindLocalMap(string ExamClass, string ExamSubClass)
{
BExamClass bExamClass = new BExamClass();
System.Data.DataTable dt = bExamClass.GetList(" EXAM_CLASS = '" + ExamClass + "' and EXAM_SUB_CLASS ='" + ExamSubClass + "'");
if (dt != null && dt.Rows.Count > 0)
{
LocalMapName = dt.Rows[0]["TAG_IMAGE_NAME"].ToString();
if (LocalMapName != "")
{
this.SetLocMap(LocalMapName);
}
}
}
//改变时填充检查子类下拉框
private void cmb_EXAM_CLASS_SelectedIndexChanged(object sender, EventArgs e)
{
if (cmb_EXAM_CLASS.Text == "")
{
return;
}
BExamClass bem = new BExamClass();
DataTable dt = bem.GetList(" EXAM_CLASS='" + cmb_EXAM_CLASS.Text + "' ORDER BY EXAM_SUB_CLASS");
DataRow dr = dt.NewRow();
dt.Rows.InsertAt(dr, 0);
cmb_EXAM_SUB_CLASS.DataSource = dt;
cmb_EXAM_SUB_CLASS.DisplayMember = "EXAM_SUB_CLASS";
cmb_EXAM_SUB_CLASS.ValueMember = "EXAM_SUB_CLASS";
}
/// <summary>
/// 获取LOCAL_ID_CLASS和PATIENT_INF_LOCAL_ID表中的PATIENT_LOCAL_ID、EXAM_TIMES
/// </summary>
public string SelectPatientInfLocalId(ref bool isExit)
{
BExamClass bExamClass = new BExamClass();
IModel iExamClass = bExamClass.GetModel(this.examClass, this.examSubClass);
string localId = "";
isExit = false;
try
{
switch (GetConfig.DALAndModel)
{
case "SIS":
SIS_Model.MExamClass smExamClass = (SIS_Model.MExamClass)iExamClass;
this.LocalIdClass = smExamClass.LOCAL_ID_CLASS;
this.iPatientInfLocalId = bPatientInfLocalId.GetModel(this.patientId, this.LocalIdClass);
if (iPatientInfLocalId != null)
{
SIS_Model.MPatientInfLocalId smPatientInfLocalId = (SIS_Model.MPatientInfLocalId) this.iPatientInfLocalId;
localId = smPatientInfLocalId.PATIENT_LOCAL_ID;
ExamTimes = smPatientInfLocalId.EXAM_TIMES;
isExit = true;
}
break;
case "PACS":
PACS_Model.MExamClass pmExamClass = (PACS_Model.MExamClass)iExamClass;
this.LocalIdClass = pmExamClass.LOCAL_ID_CLASS;
this.iPatientInfLocalId = bPatientInfLocalId.GetModel(this.patientId, this.LocalIdClass);
if (iPatientInfLocalId != null)
{
PACS_Model.MPatientInfLocalId pmPatientInfLocalId = (PACS_Model.MPatientInfLocalId) this.iPatientInfLocalId;
localId = pmPatientInfLocalId.PATIENT_LOCAL_ID;
ExamTimes = pmPatientInfLocalId.EXAM_TIMES;
isExit = true;
}
break;
}
}
catch (Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message, "提示");
}
return(localId);
}
/// <summary>
/// 检查类别根据配置文件RegisterSettings.ini绑定
/// </summary>
public void Bind_ExamClass(string DbUser, ComboBox cmb_ExamClass, int mode)
{
System.Data.DataTable dt_ExamClass = new System.Data.DataTable();
switch (mode)
{
case 0:
string ExamClass = GetConfig.RM_ExamClass;
string[] ary = ExamClass.Split(',');
dt_ExamClass.Columns.Add("ExamClass");
for (int i = 0; i < ary.Length; i++)
{
System.Data.DataRow mydatarow = dt_ExamClass.NewRow();
mydatarow["ExamClass"] = ary[i];
dt_ExamClass.Rows.Add(mydatarow);
}
cmb_ExamClass.DataSource = dt_ExamClass;
cmb_ExamClass.DisplayMember = dt_ExamClass.Columns["ExamClass"].ColumnName;
break;
case 1:
string sql = "select distinct EXAM_CLASS from USER_EXAM_CLASS where DB_USER='******'";
dt_ExamClass = GetDataSet(sql).Tables[0];
cmb_ExamClass.DataSource = dt_ExamClass;
break;
case 2:
//检查类别
BExamClass bExamClass = new BExamClass();
System.Data.DataTable dt = bExamClass.GetList("1=1").DefaultView.ToTable(true, "EXAM_CLASS");
cmb_ExamClass.DataSource = dt;
cmb_ExamClass.DisplayMember = dt.Columns["EXAM_CLASS"].ColumnName;
break;
default:
break;
}
}
/// <summary>
/// 检查类别根据配置文件RegisterSettings.ini绑定
/// </summary>
public void Bind_ExamClass(ComboBox cmb_ExamClass, int mode)
{
System.Data.DataTable dt_ExamClass = new System.Data.DataTable();
switch (mode)
{
case 0:
string ExamClass = GetConfig.RM_ExamClass;
string[] ary = ExamClass.Split(',');
dt_ExamClass.Columns.Add("ExamClass");
for (int i = 0; i < ary.Length; i++)
{
System.Data.DataRow mydatarow = dt_ExamClass.NewRow();
mydatarow["ExamClass"] = ary[i];
dt_ExamClass.Rows.Add(mydatarow);
}
cmb_ExamClass.DataSource = dt_ExamClass;
cmb_ExamClass.DisplayMember = dt_ExamClass.Columns["ExamClass"].ColumnName;
break;
case 1:
//IsMode1 = true;
//string ExamClass_sql = "select distinct EXAM_CLASS from USER_EXAM_CLASS where DB_USER='******'";
//dt_ExamClass = DBoperate.OdbcDaAd(ExamClass_sql, this.connOdbc).Tables[0];
//comb_ExamClass.DataSource = dt_ExamClass;
break;
case 2:
//检查类别
BExamClass bExamClass = new BExamClass();
System.Data.DataTable dt = bExamClass.GetList("1=1");
cmb_ExamClass.DataSource = dt;
cmb_ExamClass.DisplayMember = dt.Columns["EXAM_CLASS"].ColumnName;
break;
default:
break;
}
}
