//初始化单位列表数据源
public static void InitializeDepartment(ref YidanSoft.Common.Library.LookUpEditor lookUpEditorDepartment,
ref YidanSoft.Common.Library.LookUpWindow lookUpWindowDepartment)
{
try
{
lookUpWindowDepartment.SqlHelper = SqlUtil.App.SqlHelper;
DataTable Dept = SqlUtil.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", 80);
cols.Add("NAME", 120);
SqlWordbook deptWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//NAME//PY//WB");
lookUpEditorDepartment.SqlWordbook = deptWordBook;
lookUpEditorDepartment.CodeValue = "0000";
}
catch (Exception)
{
throw;
}
}
//初始化手术信息
public static void InitializeOperation(ref YidanSoft.Common.Library.LookUpEditor lookUpEditorOperation,
ref YidanSoft.Common.Library.LookUpWindow lookUpWindowOperation)
{
try
{
lookUpWindowOperation.SqlHelper = SqlUtil.App.SqlHelper;
DataTable Dept = SqlUtil.App.SqlHelper.ExecuteDataTable("usp_GetRecordManageFrm",
new SqlParameter[] { new SqlParameter("@FrmType", "2") }, 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", 120);
SqlWordbook operWordBook = new SqlWordbook("querybook", Dept, "ID", "NAME", cols, "ID//NAME//PY//WB");
lookUpEditorOperation.SqlWordbook = operWordBook;
}
catch (Exception)
{
throw;
}
}
private void BindLookUpEditorData()
{
try
{
YidanSoft.Common.Library.LookUpWindow luApplyDept = new YidanSoft.Common.Library.LookUpWindow();
YidanSoft.Common.Library.LookUpWindow luEmplyeeDept = new YidanSoft.Common.Library.LookUpWindow();
luApplyDept.SqlHelper = m_app.SqlHelper;
luEmplyeeDept.SqlHelper = m_app.SqlHelper;
lookUpEditorApplyDept.ListWindow = luApplyDept;
lookUpEditorEmployeeDept.ListWindow = luEmplyeeDept;
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", 70);
cols.Add("NAME", 80);
SqlWordbook deptWordBook = new SqlWordbook("querydept", Dept, "ID", "NAME", cols, "ID//NAME");
lookUpEditorApplyDept.SqlWordbook = deptWordBook;
lookUpEditorEmployeeDept.SqlWordbook = deptWordBook;
lookUpEditorApplyDept.CodeValue = m_app.User.CurrentDeptId; //王冀 2013 2 22 初始值设置为用户所在科室
//lookUpEditorApplyDept.SelectedText = "妇科";
//lookUpEditorEmployeeDept.SelectedText = "妇科";
}
catch (Exception)
{
throw;
}
}
//初始化出院诊断信息
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;
}
}
