//初始化手术信息
public static void InitializeOperation(ref DrectSoft.Common.Library.LookUpEditor lookUpEditorOperation,
ref DrectSoft.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;
}
}
//初始化借阅目的
public static void InitializePurpose(ref DrectSoft.Common.Library.LookUpEditor lookUpEditorPurpose,
ref DrectSoft.Common.Library.LookUpWindow lookUpWindowPurpose)
{
try
{
lookUpWindowPurpose.SqlHelper = SqlUtil.App.SqlHelper;
DataTable Purpose = SqlUtil.App.SqlHelper.ExecuteDataTable("usp_GetMedicalRrecordViewFrm",
new SqlParameter[] { new SqlParameter("@GetType", "2") }, CommandType.StoredProcedure);
Purpose.Columns["NAME"].Caption = "借阅目的";
Dictionary <string, int> PurposeCols = new Dictionary <string, int>();
PurposeCols.Add("NAME", 150);
SqlWordbook PurposeWordBook = new SqlWordbook("querybook", Purpose, "ID", "NAME", PurposeCols, "ID//NAME//PY//WB");
lookUpEditorPurpose.SqlWordbook = PurposeWordBook;
lookUpEditorPurpose.CodeValue = "5001";
}
catch (Exception)
{
throw;
}
}
//初始化单位列表数据源
public static void InitializeDepartment(ref DrectSoft.Common.Library.LookUpEditor lookUpEditorDepartment,
ref DrectSoft.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;
}
}
//初始化主治医生列表数据源 add by ck 2013-8-26
public static void InitializeDoctor(ref DrectSoft.Common.Library.LookUpEditor lookUpEditorDoctor,
ref DrectSoft.Common.Library.LookUpWindow lookUpWindowDoctor)
{
try
{
//lookUpWindowDoctor.SqlHelper = SqlUtil.App.SqlHelper;
//DataTable Dept = SqlUtil.App.SqlHelper.ExecuteDataTable("usp_GetMedicalRrecordViewFrm",
// new SqlParameter[] { new SqlParameter("@GetType", "1") }, CommandType.StoredProcedure);
string sql = @"select t.id,t.name,t.py,t.wb from users t where t.valid='1'";
DataTable dt = DrectSoft.DSSqlHelper.DS_SqlHelper.ExecuteDataTable(sql);
dt.Columns["ID"].Caption = "医生编号";
dt.Columns["NAME"].Caption = "医生姓名";
Dictionary <string, int> cols = new Dictionary <string, int>();
cols.Add("ID", 80);
cols.Add("NAME", 120);
SqlWordbook doctorWordBook = new SqlWordbook("querybook", dt, "ID", "NAME", cols, "ID//NAME//PY//WB");
lookUpEditorDoctor.SqlWordbook = doctorWordBook;
//lookUpEditorDoctor.CodeValue = "0000";
}
catch (Exception ex)
{
throw ex;
}
}
//初始化出院诊断信息
public static void InitializeDiagnosis(ref DrectSoft.Common.Library.LookUpEditor lookUpEditorDiagnosis,
ref DrectSoft.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;
}
}
