Esempio n. 1
0
        /// <summary>初始化明细数据源
        ///
        /// </summary>
        private void DoInitDetailGridSource()
        {
            const string strBindSql = "SELECT 'true' AS  value , '有效' AS  Name UNION ALL  SELECT   'false' AS  value , '无效' AS  Name ;SELECT 'cbkQueryRemark '";

            BindSourceHelper.BindClass bindClass = new BindSourceHelper.BindClass()
            {
                SqlType = SqlType.SqlServer,
                BindSql = strBindSql
            };
            m_dsDetailGridSource = BindSourceHelper.GetBindSourceDataSet(bindClass);
        }
/// <summary>初始化明细数据源
        ///
        /// </summary>
        private void DoInitDetailGridSource()
        {
            const string strBindSql = "SELECT  'True' AS value ,'有效' AS name  UNION  ALL SELECT 'False' AS value ,'无效' AS name ;SELECT 'gridDetailmrzStatus '";

            BindSourceHelper.BindClass bindClass = new BindSourceHelper.BindClass()
            {
                SqlType = SqlType.SqlServer,
                BindSql = strBindSql
            };
            m_dsDetailGridSource = BindSourceHelper.GetBindSourceDataSet(bindClass);
        }
Esempio n. 3
0
        /// <summary>初始化绑定下拉框等
        ///
        /// </summary>
        private void DoInitData()
        {
            const string strBindSql = "SELECT 2 AS  value , '管理员' AS  Name UNION ALL  SELECT 3 AS  value , '功城队' AS  NAME;SELECT 'cbkQueryRemark '";

            BindSourceHelper.BindClass bindClass = new BindSourceHelper.BindClass()
            {
                SqlType = SqlType.SqlServer,
                BindSql = strBindSql
            };
            DataSet ds = BindSourceHelper.GetBindSourceDataSet(bindClass);
            //CheckedComboBoxHelper.BindCheckedComboBox(cbkQueryRemark, ds.Tables["cbkQueryRemark"], "Name", "value");
        }
Esempio n. 4
0
        private void grdData_RowsAdded(object sender, DataGridViewRowsAddedEventArgs e)
        {
            if (m_dsGridSource == null)
            {
                const string strBindGridSql          = "SELECT 1 AS  value , '排序1' AS  Name UNION ALL  SELECT 2 AS  value , '排序2' AS  NAME UNION ALL  SELECT 3 AS  value , '排序3' AS  NAME UNION ALL  SELECT 9 AS  value , '排序9' AS  NAME;SELECT 'gridcboSortnum '";
                BindSourceHelper.BindClass bindClass = new BindSourceHelper.BindClass()
                {
                    SqlType = SqlType.SqlServer,
                    BindSql = strBindGridSql
                };
                m_dsGridSource = BindSourceHelper.GetBindSourceDataSet(bindClass);
            }
            DataGridViewComboBoxCell gridcboSortnumCell = this.grdData.Rows[e.RowIndex].Cells[gridcboSortnum.Name] as DataGridViewComboBoxCell;

            ComboBoxHelper.BindDataGridViewComboBoxCell(gridcboSortnumCell, m_dsGridSource.Tables["gridcboSortnum"], "Name", "value");
        }