//初始化单位列表数据源 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; } }