Пример #1
0
 /// <summary>
 ///根据传入的字符串查询结果绑定数据
 ///王冀 2012 10 24
 ///edit zyx 2012-12-17  系统参数配置中,当查询不到结果时给出提示框
 ///edit by xlb 2012-12-28 改用参数化查询
 /// </summary>
 /// <param name="key"></param>
 private void BindData(string sql, string key)
 {
     try
     {
         //sql_helper = DataAccessFactory.DefaultDataAccess;
         appdal = new AppConfigDalc();
         //sourceTable = sql_helper.ExecuteDataTable(sql_str);
         SqlParameter[] sps = { new SqlParameter("@conName", key) };
         //DataTable sourceTable = sql_helper.ExecuteDataTable(key);
         DataTable sourceTable = DS_SqlHelper.ExecuteDataTable(sql, sps, CommandType.Text);
         if (sourceTable == null || sourceTable.Rows.Count <= 0)
         {
             MessageBox.Show("没有符合条件的数据");
         }
         gridControl1.DataSource = sourceTable;
         //if (sourceTable == null || sourceTable.Rows.Count <= 0)
         //{
         //    MessageBox.Show("没有符合您查询的系统参数配置的相关数据!");
         //}
         m_app.PublicMethod.ConvertGridDataSourceUpper(gridView1);
         //绑定数据  查询结构加载时 changed事件获取不到句柄 不能自动绑定数据需要手动加载 2012-10-25
         DataRow dataRow = gridView1.GetDataRow(gridView1.FocusedRowHandle);
         if (dataRow == null)
         {
             return;
         }
         SetApp(dataRow);
         AddControlToMyPanel(dataRow);
     }
     catch (Exception)
     {
         throw;
     }
 }
Пример #2
0
        private void GetDefaultSeting()
        {
            AppConfigDalc _AppConfigDalc = new AppConfigDalc();

            m_EmrAppConfig = _AppConfigDalc.SelectAppConfig("EmrDefaultSet");
            //XMLCommon;
            if (m_EmrAppConfig == null)
            {
                button3_Click(null, null);
            }
            m_XmlDocument.LoadXml(m_EmrAppConfig.Config);


            //XMLCommon _XMLCommon = new XMLCommon();
            this.comboBox1.SelectedItem  = m_XmlDocument.GetElementsByTagName("fontname").Item(0).InnerText;
            this.comboBox2.Text          = m_XmlDocument.GetElementsByTagName("fontsize").Item(0).InnerText;
            this.comboBox3.SelectedIndex = Convert.ToInt32(Convert.ToDouble(m_XmlDocument.GetElementsByTagName("linespace").Item(0).InnerText) * 2);
            this.comboBox4.SelectedItem  = m_XmlDocument.GetElementsByTagName("elestyle").Item(0).InnerText;
            this.labelColor.BackColor    = ColorTranslator.FromHtml(m_XmlDocument.GetElementsByTagName("elecolor").Item(0).InnerText);
            this.checkBox1.Checked       = false;
        }