/// <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); }
/// <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"); }
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"); }