//初始化手术信息 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; } }