Exemplo n.º 1
0
        /// <summary>
        /// 检查类别、检查子类检索表EXAM_ITEM_DICT得到数据集绑定至检查项目列表中
        /// </summary>
        public System.Data.DataTable Bind_ExamItem(string ExamClass, string ExamSubClass, ComboBox cmb_ExamItem)
        {
            string sql = "select DESCRIPTION as EXAM_ITEM_NAME,DESCRIPTION_CODE as EXAM_ITEM_CODE ,INPUT_CODE from EXAM_RPT_PATTERN where EXAM_CLASS='" + ExamClass + "' and EXAM_SUB_CLASS='" + ExamSubClass + "' and DESC_ITEM = '检查项目'";

            System.Data.DataTable dt = GetDataSet(sql).Tables[0];
            if (GetConfig.RM_ExamItemSort)
            {
                ExamItemSorter examItemSorter = new ExamItemSorter("");
                dt = examItemSorter.ExamItemSort(ExamClass, ExamSubClass, dt);
            }
            cmb_ExamItem.DataSource    = dt.DefaultView;
            cmb_ExamItem.DisplayMember = dt.Columns["EXAM_ITEM_NAME"].ColumnName;
            cmb_ExamItem.ValueMember   = dt.Columns["EXAM_ITEM_CODE"].ColumnName;
            return(dt);
        }
Exemplo n.º 2
0
        /// <summary>
        /// 检查类别、检查子类检索表EXAM_ITEM_DICT得到数据集绑定至检查项目列表中
        /// </summary>
        public System.Data.DataTable Bind_ExamItem(string ExamClass, string ExamSubClass, ComboBox cmb_ExamItem)
        {
            string sql = "select * from EXAM_ITEM_DICT where EXAM_CLASS='" + ExamClass + "' and EXAM_SUB_CLASS='" + ExamSubClass + "' order by SORT_ID ";

            System.Data.DataTable dt = GetDataSet(sql).Tables[0];
            if (GetConfig.RM_ExamItemSort)
            {
                ExamItemSorter examItemSorter = new ExamItemSorter(true);
                dt = examItemSorter.ExamItemSort(ExamClass, ExamSubClass, dt);
            }
            cmb_ExamItem.DataSource    = dt.DefaultView;
            cmb_ExamItem.DisplayMember = dt.Columns["EXAM_ITEM_NAME"].ColumnName;
            cmb_ExamItem.ValueMember   = dt.Columns["EXAM_ITEM_CODE"].ColumnName;
            return(dt);
            //this.Now_DT_VS_Group = new System.Data.DataTable[dt.Rows.Count];
        }
Exemplo n.º 3
0
        /// <summary>
        /// 检查类别、检查子类检索表EXAM_ITEM_DICT得到数据集绑定至检查项目列表中
        /// </summary>
        public System.Data.DataTable Bind_ExamItem(string ExamClass, string ExamSubClass, ComboBox cmb_ExamItem)
        {
            BExamItemDict bExamItemDict = new BExamItemDict();

            System.Data.DataTable dt = bExamItemDict.GetList("EXAM_CLASS='" + ExamClass + "' and EXAM_SUB_CLASS='" + ExamSubClass + "' order by SORT_ID");
            if (GetConfig.RM_ExamItemSort)
            {
                if (GetConfig.RM_ExamItemSort)
                {
                    ExamItemSorter examItemSorter = new ExamItemSorter();
                    dt = examItemSorter.ExamItemSort(ExamClass, ExamSubClass, dt);
                }
            }
            cmb_ExamItem.DataSource    = dt.DefaultView;
            cmb_ExamItem.DisplayMember = dt.Columns["EXAM_ITEM_NAME"].ColumnName;
            cmb_ExamItem.ValueMember   = dt.Columns["EXAM_ITEM_CODE"].ColumnName;
            return(dt);
            //this.Now_DT_VS_Group = new System.Data.DataTable[dt.Rows.Count];
        }