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