/// <summary>
/// 根据选择科室控制，质控员和科主任下拉框
/// </summary>
private void GetDoctorUser()
{
try
{
string deptid = lookUpEditorDepartment.CodeValue;
if (deptid == "")
{
return;
}
else
{
//处理科室质控员下拉框
string sql = string.Format(@"select * from users a where a.valid = 1 and a.deptid = '{0}' and a.grade is not null and a.grade <> '2004' ", deptid);
lookUpWQCPerson.SqlHelper = m_App.SqlHelper;
DataTable dt = m_App.SqlHelper.ExecuteDataTable(sql);
dt.Columns["ID"].Caption = "医生代码";
dt.Columns["NAME"].Caption = "医生名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 70);
cols.Add("NAME", 80);
SqlWordbook deptWordBook = new SqlWordbook("querybook", dt, "ID", "NAME", cols, "ID//NAME//py//wb");
lookUpEQCPerson.SqlWordbook = deptWordBook;
//处理科室主任下拉框
lookUpEZhuRen.Enabled = true;
lookUpWZhuren.SqlHelper = m_App.SqlHelper;
DataTable dt1 = m_SqlManager.GetDirectorDoc(deptid);
dt1.Columns["ID"].Caption = "医生代码";
dt1.Columns["NAME"].Caption = "医生名称";
Dictionary <string, int> cols1 = new Dictionary <string, int>();
cols1.Add("ID", 70);
cols1.Add("NAME", 80);
SqlWordbook deptWordBook1 = new SqlWordbook("querybook", dt1, "ID", "NAME", cols1, "ID//NAME//py//wb");
lookUpEZhuRen.SqlWordbook = deptWordBook1;
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 初始化受邀科室列表
/// Add by xlb 2013-03-11
/// </summary>
private void InitDepartMent()
{
try
{
lookUpEditorDepartment.Kind = WordbookKind.Sql;
lookUpEditorDepartment.ListWindow = lookUpWindowDepartment;
// string sqlInitdepart = @"SELECT distinct ID, NAME, PY, WB
// FROM department, dept2ward
// WHERE department.ID = dept2ward.deptid and
// department.valid = '1' AND valid = '1'";
//中心医院要求捞取医技科室，此处没必要过多筛选 add by ywk 2013年4月2日9:21:16
//string sqlInitdepart = @"select * from department where sort in('101','102','104','105') and valid='1'";
//中心医院信息科周主任需求，此处科室只捞取包含主治医生以上级别的科室 add by ywk 2013年8月14日 09:30:27
string sqlInitdepart = @"select distinct de.id,de.name,de.py,de.wb
from department de inner join users us on de.id=us.deptid and us.grade in ('2001','2002','2000')
where de.sort in ('101', '102', '104', '105')
and de.valid = '1' ";
DataTable dtDepartment = DS_SqlHelper.ExecuteDataTable(sqlInitdepart, CommandType.Text);
for (int i = 0; i < dtDepartment.Columns.Count; i++)
{
if (dtDepartment.Columns[i].ColumnName.ToUpper().Trim() == "ID")
{
dtDepartment.Columns[i].Caption = "科室代码";
}
else if (dtDepartment.Columns[i].ColumnName.ToUpper().Trim() == "NAME")
{
dtDepartment.Columns[i].Caption = "科室名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 60);
colWidths.Add("NAME", 70);
SqlWordbook wordBook = new SqlWordbook("Department", dtDepartment, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorDepartment.SqlWordbook = wordBook;
}
catch (Exception ex)
{
throw ex;
}
}
private void BindApplyDirectorWordBook(DataTable dataTableData)
{
for (int i = 0; i < dataTableData.Columns.Count; i++)
{
if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "id")
{
dataTableData.Columns[i].Caption = "医师代码";
}
else if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "name")
{
dataTableData.Columns[i].Caption = "医师名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 70);
colWidths.Add("NAME", 80);
SqlWordbook wordBook = new SqlWordbook("Director", dataTableData, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorDirector.SqlWordbook = wordBook;
}
/// <summary>
/// 新增初始化中医诊断检索框数据
/// edit by Yanqiao.Cai 2012-11-07
/// 1、add try ... catch
/// 2、优化下拉列表
/// </summary>
private void InitLookDiag()
{
try
{
lookUpWindowDiag.SqlHelper = m_app.SqlHelper;
if (m_DiagTable == null)
{
m_DiagTable = m_SysTableManger.GetDiagnosisOfChinese_Table("");
}
m_DiagTable.Columns["ID"].Caption = "诊断代码";
m_DiagTable.Columns["NAME"].Caption = "诊断名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 80);
cols.Add("NAME", 170);
SqlWordbook deptWordBook = new SqlWordbook("querybook", m_DiagTable, "ID", "NAME", cols, "ID//Name//PY//WB");
lookUpEditorDiag.SqlWordbook = deptWordBook;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void BindBedWordBook(DataTable dataTableData)
{
try
{
for (int i = 0; i < dataTableData.Columns.Count; i++)
{
if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "id")
{
dataTableData.Columns[i].Caption = "床位号";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 120);
SqlWordbook wordBook = new SqlWordbook("Bed", dataTableData, "ID", "ID", colWidths, "ID");
lookUpEditorBed.SqlWordbook = wordBook;
}
catch (Exception ex)
{
throw ex;
}
}
private void BindUrgencyWordBook(DataTable dataTableData)
{
try
{
for (int i = 0; i < dataTableData.Columns.Count; i++)
{
if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "name")
{
dataTableData.Columns[i].Caption = "紧急度";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("NAME", 120);
SqlWordbook wordBook = new SqlWordbook("Urgency", dataTableData, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorUrgency.SqlWordbook = wordBook;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 初始化员工姓名和病人姓名
/// </summary>
private void InitName()
{
try
{
this.lookUpWindowUser.SqlHelper = SqlUtil.App.SqlHelper;
this.lookUpWindowPatient.SqlHelper = SqlUtil.App.SqlHelper;
string sqlusers = "select ID,NAME,PY,WB from users where";
if (this.lookUpEditorUserDept.CodeValue.Trim() != "")
{
string deptid = this.lookUpEditorUserDept.CodeValue == "0000" ? "" : this.lookUpEditorUserDept.CodeValue;
if (deptid != "")
{
sqlusers = "select ID,NAME,PY,WB from users where Deptid='" + deptid + "'";
}
}
DataTable users = SqlUtil.App.SqlHelper.ExecuteDataTable(sqlusers);
users.Columns["ID"].Caption = "员工工号";
users.Columns["NAME"].Caption = "员工姓名";
DataTable patients = SqlUtil.App.SqlHelper.ExecuteDataTable("usp_GetMedicalRrecordViewFrm",
new SqlParameter[] { new SqlParameter("@GetType", "4") }, CommandType.StoredProcedure);
patients.Columns["ID"].Caption = "病人编号";
patients.Columns["NAME"].Caption = "病人姓名";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 60);
cols.Add("NAME", 90);
SqlWordbook userWordBook = new SqlWordbook("queryuser", users, "ID", "NAME", cols, "ID//NAME//PY//WB");
this.lookUpEditorUser.SqlWordbook = userWordBook;
SqlWordbook patientWordBook = new SqlWordbook("querypatient", patients, "ID", "NAME", cols, "ID//NAME//PY//WB");
this.lookUpEditorPatient.SqlWordbook = patientWordBook;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 绑定科室下拉列表
/// </summary>
private void InitDepartment()
{
lookUpWindowDepartment.SqlHelper = m_app.SqlHelper;
string sql = string.Format(@"select distinct ID, NAME,py,wb from department a ,dept2ward b where a.id = b.deptid ");
DataTable Dept = m_app.SqlHelper.ExecuteDataTable(sql);
Dept.Columns["ID"].Caption = "科室代码";
Dept.Columns["NAME"].Caption = "科室名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 70);
cols.Add("NAME", 80);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//Name//PY//WB");
lookUpEditorDepartment.SqlWordbook = deptWordBook;
InitlookUpEditorValue();
lookUpEditorDepartment.CodeValue = m_app.User.CurrentDeptId;
}
private void BindDepartmentWordBook(DataTable dataTableData)
{
for (int i = 0; i < dataTableData.Columns.Count; i++)
{
if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "id")
{
dataTableData.Columns[i].Caption = "科室编码";
}
else if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "name")
{
dataTableData.Columns[i].Caption = "科室名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 60);
colWidths.Add("NAME", 120);
SqlWordbook wordBook = new SqlWordbook("Department", dataTableData, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorDepartment.SqlWordbook = wordBook;
}
private void BindEmployeeInGridWordBook(DataTable dataTableData)
{
for (int i = 0; i < dataTableData.Columns.Count; i++)
{
if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "employeecode")
{
dataTableData.Columns[i].Caption = "医师代码";
}
else if (dataTableData.Columns[i].ColumnName.ToLower().Trim() == "employeename")
{
dataTableData.Columns[i].Caption = "医师名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("EMPLOYEECODE", 60);
colWidths.Add("EMPLOYEENAME", 120);
SqlWordbook wordBook = new SqlWordbook("Employee", dataTableData, "EMPLOYEECODE", "EMPLOYEENAME", colWidths, "EMPLOYEECODE//EMPLOYEENAME//PY//WB");
lookUpEditorEmployeeInGrid.SqlWordbook = wordBook;
}
/// <summary>
/// 绑定失分类型
/// </summary>
private void InitSqlWorkBook()
{
UpWindowtInpatient.SqlHelper = _app.SqlHelper;
DataTable dtInpatient = GetInpatientList();
if (dtInpatient.Rows.Count == 0)
{
return;
}
dtInpatient.Columns["NOOFINPAT"].Caption = "住院号";
dtInpatient.Columns["NAME"].Caption = "患者姓名";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("NOOFINPAT", 50);
cols.Add("NAME", 100);
SqlWordbook Inpatientworkbook = new SqlWordbook("querybook", dtInpatient, "NOOFINPAT", "NAME", cols, "NOOFINPAT//NAME");
UpEditorInpatient.SqlWordbook = Inpatientworkbook;
}
/// <summary>
/// 绑定病人状态下拉框
/// </summary>
private void InitStatus()
{
lookUpWindowStatus.SqlHelper = m_app.SqlHelper;
string sql = string.Format(@"select c.id, c.name from categorydetail c
where c.categoryid = '15' and c.id in
(select distinct status from inpatient)
");
DataTable Dept = m_app.SqlHelper.ExecuteDataTable(sql);
Dept.Columns["ID"].Caption = "状态代码";
Dept.Columns["NAME"].Caption = "状态名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 65);
cols.Add("NAME", 160);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//Name");
lookUpEditorStatus.SqlWordbook = deptWordBook;
}
private void InitDiag()
{
try
{
DataTable disease = new DataTable();
disease.Columns.Add("ICD");
disease.Columns.Add("NAME");
disease.Columns.Add("PY");
disease.Columns.Add("WB");
DataTable diagnosis = SqlUtil.App.SqlHelper.ExecuteDataTable("select py, wb, name, icd from diagnosis where valid='1' union select py, wb, name, icdid from diagnosisothername where valid='1'");
foreach (DataRow row in diagnosis.Rows)
{
DataRow displayRow = disease.NewRow();
displayRow["ICD"] = row["ICD"];
displayRow["NAME"] = row["NAME"];
displayRow["PY"] = row["PY"];
displayRow["WB"] = row["WB"];
disease.Rows.Add(displayRow);
}
this.lookUpWindowInDiag.SqlHelper = SqlUtil.App.SqlHelper;
this.lookUpWindowOutDiag.SqlHelper = SqlUtil.App.SqlHelper;
disease.Columns["ICD"].Caption = "诊断编码";
disease.Columns["NAME"].Caption = "诊断名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ICD", 70);
cols.Add("NAME", 162);
SqlWordbook diagWordBook = new SqlWordbook("queryDiag", disease, "ICD", "NAME", cols, "ICD//NAME//PY//WB");
this.lookUpEditorInDiag.SqlWordbook = diagWordBook;
this.lookUpEditorOutDiag.SqlWordbook = diagWordBook;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void GetDoctor()
{
string deptid = lookUpEditorDepartment.CodeValue;
string Level = lookUpEditorLevel.CodeValue;
string usersid = lookUpEditorEmployee.CodeValue;
if (deptid == "" || usersid != "")
{
return;
}
else
{
string sql = "";
if (Level == "")
{
sql = string.Format(@"select * from users a where a.valid = 1 and a.deptid = '{0}' and a.grade is not null and a.grade <> '2004'", deptid);
}
else
{
sql = string.Format(@"select * from users a where a.valid = 1 and a.grade = '{0}' and a.deptid = '{1}' and a.grade is not null and a.grade <> '2004'", Level, deptid);
}
lookUpWindowEmployee.SqlHelper = m_App.SqlHelper;
DataTable Dept = m_App.SqlHelper.ExecuteDataTable(sql);
Dept.Columns["ID"].Caption = "医生代码";
Dept.Columns["NAME"].Caption = "医生名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 65);
cols.Add("NAME", 160);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//NAME//py//wb");
lookUpEditorEmployee.SqlWordbook = deptWordBook;
}
}
//初始化出院诊断信息
public static void InitializeDiagnosis(ref YidanSoft.Common.Library.LookUpEditor lookUpEditorDiagnosis,
ref YidanSoft.Common.Library.LookUpWindow lookUpWindowDiagnosis)
{
try
{
DataTable disease = new DataTable();
disease.Columns.Add("ICD");
disease.Columns.Add("NAME");
disease.Columns.Add("PY");
disease.Columns.Add("WB");
DataTable diagnosis = SqlUtil.App.SqlHelper.ExecuteDataTable("select * from diagnosis");
foreach (DataRow row in diagnosis.Rows)
{
DataRow displayRow = disease.NewRow();
displayRow["ICD"] = row["ICD"];
displayRow["NAME"] = row["NAME"];
displayRow["PY"] = row["PY"];
displayRow["WB"] = row["WB"];
disease.Rows.Add(displayRow);
}
lookUpWindowDiagnosis.SqlHelper = SqlUtil.App.SqlHelper;
disease.Columns["ICD"].Caption = "诊断编码";
disease.Columns["NAME"].Caption = "诊断名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ICD", 60);
cols.Add("NAME", 120);
SqlWordbook diagWordBook = new SqlWordbook("queryDiag", disease, "ICD", "NAME", cols, "ICD//NAME//PY//WB");
lookUpEditorDiagnosis.SqlWordbook = diagWordBook;
}
catch (Exception)
{
throw;
}
}
//add by jxh 下拉选择事件触发出院诊断内容
private void comboBoxEdit1_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (this.comboBoxEdit1.Text == "西医出院诊断")
{
string sql_diagxy = "select py, wb, name, icd from diagnosis where valid='1' union select py, wb, name, icdid from diagnosisothername where valid='1'";
DataTable diagxy = m_app.SqlHelper.ExecuteDataTable(sql_diagxy);
diagxy.Columns["ICD"].Caption = "编号";
diagxy.Columns["NAME"].Caption = "诊断名称";
Dictionary <string, int> colDiag = new Dictionary <string, int>();
colDiag.Add("ICD", 80);
colDiag.Add("NAME", 160);
SqlWordbook outWordBook = new SqlWordbook("outDiag", diagxy, "ICD", "NAME", colDiag, "ICD//NAME//PY//WB");
this.lookUpEditorOutDiag.SqlWordbook = outWordBook;
}
else
{
string sql_diag = "select py, wb, name, id from diagnosisofchinese where valid='1' union select py, wb, name, icdid from diagnosischiothername where valid='1'";
DataTable diag = m_app.SqlHelper.ExecuteDataTable(sql_diag);
diag.Columns["ID"].Caption = "编号";
diag.Columns["NAME"].Caption = "诊断名称";
Dictionary <string, int> colDiag = new Dictionary <string, int>();
colDiag.Add("ID", 80);
colDiag.Add("NAME", 160);
SqlWordbook outWordBook = new SqlWordbook("outDiag", diag, "ID", "NAME", colDiag, "ID//NAME//PY//WB");
this.lookUpEditorOutDiag.SqlWordbook = outWordBook;
}
}
catch (Exception ex)
{
throw ex;
}
}
//初始化科室
private void InitHospitel()
{
lookUpWindowHospitel.SqlHelper = m_app.SqlHelper;
//yxy 暂时加载TP科室
//DataTable Dept = m_app.SqlHelper.ExecuteDataTable("usp_GetMedicalRrecordViewFrm",
// new SqlParameter[] { new SqlParameter("@GetType", "1") }, CommandType.StoredProcedure);
string sql = string.Format(@"select a.medicalid ID,a.name NAME from hospitalinfo a ");
DataTable Dept = m_app.SqlHelper.ExecuteDataTable(sql);
Dept.Columns["ID"].Caption = "医院代码";
Dept.Columns["NAME"].Caption = "医院名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 60);
cols.Add("NAME", 120);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols);
lookUpEditorHospitel.SqlWordbook = deptWordBook;
}
/// <summary>
/// 初始化住院医师
/// </summary>
private void InitPhysician()
{
try
{
this.lookUpWindowPhysician.SqlHelper = SqlUtil.App.SqlHelper;
string sql = "select ID,NAME,PY,WB from users";
DataTable Name = SqlUtil.App.SqlHelper.ExecuteDataTable(sql);
Name.Columns["ID"].Caption = "医师工号";
Name.Columns["NAME"].Caption = "医师姓名";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 80);
cols.Add("NAME", 100);
SqlWordbook nameWordBook = new SqlWordbook("queryname", Name, "ID", "NAME", cols, "ID//NAME//PY//WB");
this.lookUpEditorPhysician.SqlWordbook = nameWordBook;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
private void InitControls()
{
try
{
this.lookUpWindowLock.SqlHelper = this.m_SqlHelper;
this.m_DataTable = this.m_SqlHelper.ExecuteDataTable(" SELECT ID , ID + '_' + Name as 用户名,Images FROM Users WHERE Valid = 1 order by ID");
Dictionary <string, int> dictionary = new Dictionary <string, int>();
dictionary.Add("用户名", 165);
SqlWordbook sqlWordbook = new SqlWordbook("ID", this.m_DataTable, "ID", "用户名", dictionary, true);
this.lookUpEditorLock.SqlWordbook = sqlWordbook;
this.lookUpEditorLock.ListWindow = this.lookUpWindowLock;
this.lookUpEditorLock.CodeValue = this.m_CurrentUser.Id;
this.textEditPassWord.Focus();
}
catch (SqlException message)
{
this.m_Logger.Error(message);
}
catch (Exception message2)
{
this.m_Logger.Error(message2);
}
}
private void BindLueData(LookUpEditor lueInfo, Decimal queryType)
{
try
{
LookUpWindow lupInfo = new LookUpWindow();
lupInfo.SqlHelper = m_App.SqlHelper;
DataTable dataTable = GetEditroData(queryType);
dataTable.Columns["ID"].Caption = "诊断编码";
dataTable.Columns["NAME"].Caption = "诊断名称";
Dictionary <string, int> columnwidth = new Dictionary <String, Int32>();
columnwidth.Add("ID", 90);
columnwidth.Add("NAME", 210);
SqlWordbook sqlWordBook = new SqlWordbook("ID", dataTable, "ID", "NAME", columnwidth, "ID//NAME//PY//WB");
lueInfo.SqlWordbook = sqlWordBook;
lueInfo.ListWindow = lupInfo;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 所有科室
/// </summary>
private void BindDeptData()
{
LookUpWindow lupInfo = new LookUpWindow();
lupInfo.SqlHelper = m_SqlHelper;
DataTable dataTable = GetEditroData(9);
Dictionary <string, int> columnwidth = new Dictionary <String, Int32>();
columnwidth.Add("名称", lueAdmitDept.Width);
SqlWordbook sqlWordBook = new SqlWordbook("ID", dataTable, "ID", "Name", columnwidth, true);
lueAdmitDept.SqlWordbook = sqlWordBook;
lueAdmitDept.ListWindow = lupInfo;
lueTransAdmitDept.SqlWordbook = sqlWordBook;
lueTransAdmitDept.ListWindow = lupInfo;
//lueAdmitDeptAgain.SqlWordbook = sqlWordBook;
//lueAdmitDeptAgain.ListWindow = lupInfo;
lueOutHosDept.SqlWordbook = sqlWordBook;
lueOutHosDept.ListWindow = lupInfo;
}
private void BindWardData()
{
LookUpWindow lupInfo1 = new LookUpWindow();
lupInfo1.SqlHelper = m_SqlHelper;
if (m_DataTableWard == null)
{
m_DataTableWard = GetEditroData(10);
}
Dictionary <string, int> columnwidth1 = new Dictionary <String, Int32>();
columnwidth1.Add("名称", lueAdmitWard.Width);
SqlWordbook sqlWordBook1 = new SqlWordbook("ID", m_DataTableWard, "ID", "Name", columnwidth1, true);
lueAdmitWard.SqlWordbook = sqlWordBook1;
lueAdmitWard.ListWindow = lupInfo1;
//lueTransAdmitWard.SqlWordbook = sqlWordBook1;
//lueTransAdmitWard.ListWindow = lupInfo1;
lueOutHosWard.SqlWordbook = sqlWordBook1;
lueOutHosWard.ListWindow = lupInfo1;
}
//初始化科室
private void InitDepartment()
{
lookUpWindowDepartment.SqlHelper = m_app.SqlHelper;
//yxy 暂时加载TP科室
//DataTable Dept = m_app.SqlHelper.ExecuteDataTable("usp_GetMedicalRrecordViewFrm",
// new SqlParameter[] { new SqlParameter("@GetType", "1") }, CommandType.StoredProcedure);
string sql = string.Format(@"select distinct ID, NAME,py,wb from department a ,dept2ward b where a.id = b.deptid ");
DataTable Dept = m_app.SqlHelper.ExecuteDataTable(sql);
Dept.Columns["ID"].Caption = "科室代码";
Dept.Columns["NAME"].Caption = "科室名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 65);
cols.Add("NAME", 160);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//Name//PY//WB");
lookUpEditorDepartment.SqlWordbook = deptWordBook;
}
private void BindLueOperData(LookUpEditor lueInfo, Decimal queryType)
{
try
{
LookUpWindow lupInfo = new LookUpWindow();
lupInfo.SqlHelper = m_App.SqlHelper;
if (m_DataTableDiag == null)
{
m_DataTableDiag = GetEditroData(queryType);
}
Dictionary <string, int> columnwidth = new Dictionary <String, Int32>();
columnwidth.Add("名称", lueInfo.Width);
SqlWordbook sqlWordBook = new SqlWordbook("ID", m_DataTableDiag, "ID", "Name", columnwidth, true);
lueInfo.SqlWordbook = sqlWordBook;
lueInfo.ListWindow = lupInfo;
}
catch (Exception)
{
throw;
}
}
private void InitShowDisease()
{
DataTable disease = new DataTable();
disease.Columns.Add("ICD");
disease.Columns.Add("NAME");
disease.Columns.Add("PY");
disease.Columns.Add("WB");
DataTable diagnosis = m_SqlHelper.ExecuteDataTable("select py, wb, name, icd from diagnosis where valid='1' union select py, wb, name, icdid from diagnosisothername where valid='1'");
foreach (DataRow row in diagnosis.Rows)
{
DataRow displayRow = disease.NewRow();
displayRow["ICD"] = row["ICD"];
displayRow["NAME"] = row["NAME"];
displayRow["PY"] = row["PY"];
displayRow["WB"] = row["WB"];
disease.Rows.Add(displayRow);
}
//checkedListBoxControlDisease.DisplayMember = "ICD";
//checkedListBoxControlDisease.DisplayMember = "NAME";
//checkedListBoxControlDisease.ValueMember = "ICD";
//checkedListBoxControlDisease.DataSource = disease;
this.lookUpWindowDisease.SqlHelper = m_SqlHelper;
disease.Columns["ICD"].Caption = "代码";
disease.Columns["NAME"].Caption = "病种";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ICD", 80);
cols.Add("NAME", 160);
SqlWordbook diagWordBook = new SqlWordbook("queryDiag", disease, "ICD", "NAME", cols, "ICD//NAME//PY//WB");
this.lookUpEditorDisease.SqlWordbook = diagWordBook;
}
/// <summary>
/// 初始化科室
/// </summary>
/// <auth>Yanqiao.Cai</auth>
/// <date>2012-12-28</date>
private void InitDepartment()
{
try
{
lookUpWindowDepartment.SqlHelper = m_app.SqlHelper;
DataTable Dept = m_app.SqlHelper.ExecuteDataTable("usp_GetMedicalRrecordViewFrm",
new SqlParameter[] { new SqlParameter("@GetType", "1") }, CommandType.StoredProcedure);
Dept.Columns["ID"].Caption = "科室代码";
Dept.Columns["NAME"].Caption = "科室名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 60);
cols.Add("NAME", 90);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//NAME//PY//WB");
lookUpEditorDepartment.SqlWordbook = deptWordBook;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
/// <summary>
/// 初始化接收人下拉数据源
/// Add by xlb 2013-07-02
/// </summary>
/// <param name="lookUpEditor"></param>
/// <param name="lookUpWindows"></param>
private void InitializeJSR(ref LookUpEditor lookUpEditor, ref LookUpWindow lookUpWindows)
{
try
{
YD_SqlHelper.CreateSqlHelper();
lookUpEditor.Kind = WordbookKind.Sql;
lookUpEditor.ListWindow = lookUpWindows;
DataTable dataJCZ = YD_SqlHelper.ExecuteDataTable(@"select id,name,py,wb from users where valid='1' and
grade in ('2000','2001','2002','2003') and category in ('400','401') and deptid=@deptId",
new SqlParameter[] { new SqlParameter("@deptId", DrectSoft.Common.DS_Common.currentUser.CurrentDeptId) }, CommandType.Text);
Dictionary <string, Int32> columnWidth = new Dictionary <string, int>();
dataJCZ.Columns["ID"].Caption = "编码";
dataJCZ.Columns["NAME"].Caption = "名称";
columnWidth.Add("ID", 68);
columnWidth.Add("NAME", 120);
SqlWordbook sqlWord = new SqlWordbook("JCZ", dataJCZ, "ID", "NAME", columnWidth, "ID//NAME//PY//WB");
lpEdiMidwifery.SqlWordbook = sqlWord;
dtEdiMidwifery = dataJCZ;
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 绑定医生列表
/// </summary>
/// <param name="dtDoc"></param>
private void BindEmployeeWordBook(DataTable dtDoc)
{
for (int i = 0; i < dtDoc.Columns.Count; i++)
{
if (dtDoc.Columns[i].ColumnName.ToLower().Trim() == "id")
{
dtDoc.Columns[i].Caption = "医师代码";
}
else if (dtDoc.Columns[i].ColumnName.ToLower().Trim() == "name")
{
dtDoc.Columns[i].Caption = "医师名称";
}
}
Dictionary <string, int> colWidths = new Dictionary <string, int>();
colWidths.Add("ID", 60);
colWidths.Add("NAME", 60);
SqlWordbook wordBook = new SqlWordbook("Employee", dtDoc, "ID", "NAME", colWidths, "ID//NAME//PY//WB");
lookUpEditorEmployee.SqlWordbook = wordBook;
lookUpEditorEmployee2.SqlWordbook = wordBook;
lookUpEmpFuze.SqlWordbook = wordBook;
}
/// <summary>
/// 绑定科室负责人，相应科室下的负责人医生
/// </summary>
private void GetFuzeDoctor()
{
string deptid = lookUpDeptFuze.CodeValue;
string usersid = lookUpEmpFuze.CodeValue;
if (deptid == "" || usersid != "")
{
return;
}
else
{
#region 设置科室负责人 Modify by wwj 2013-03-05
//筛掉护士
string sql = string.Format(@"SELECT * FROM users a WHERE a.deptid = '{0}' and a.grade is not null and a.grade <> '2004' and a.valid = '1'
UNION
SELECT * FROM users b
WHERE b.grade is not null and b.grade <> '2004' and b.valid = '1'
AND EXISTS (SELECT 1 FROM user2dept WHERE user2dept.userid = b.id AND user2dept.deptid = '{0}')", deptid);
lookUpWindow2.SqlHelper = m_App.SqlHelper;
DataTable Dept = m_App.SqlHelper.ExecuteDataTable(sql);
Dept.Columns["ID"].Caption = "医生代码";
Dept.Columns["NAME"].Caption = "医生名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 60);
cols.Add("NAME", 60);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//NAME//py//wb");
lookUpEmpFuze.SqlWordbook = deptWordBook;
#endregion
}
}
/// <summary>
/// 初始化文件类型
/// edit by Yanqiao.Cai 2012-11-06
/// add try ... catch
/// </summary>
private void InitMRClass()
{
try
{
lookUpWindowDepartment.SqlHelper = m_app.SqlHelper;
DataTable Dept = m_sqlUtil.ItemCatalogTable;
new GenerateShortCode(m_app.SqlHelper).AutoAddShortCode(Dept, "NAME");
Dept.Columns["ID"].Caption = "类型编码";
Dept.Columns["NAME"].Caption = "类型名称";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 60);
cols.Add("NAME", 90);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//NAME//PY//WB");
lookUpEditorMr_class.SqlWordbook = deptWordBook;
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
