private void dgvPositionCell_beginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
DataGridView dgv = sender as DataGridView;
if (!(dgv.Columns[e.ColumnIndex] is DGVCustomComboBoxColumn) || e.RowIndex < 0)
{
return;
}
DataTable dtPos = BDCommon.g_ManageDB.GetPositionList();
DGVCustomComboBoxColumn dgvCol = dgv.Columns[e.ColumnIndex] as DGVCustomComboBoxColumn;
dgvCol.FillComboBoxItems(dtPos, "F_PositionCode", "F_PositionID");
}
private void InitMatchResult(int iMatchID)
{
try
{
string strSQL = string.Format("exec Proc_SH_GetMatchResult {0} ", iMatchID);
SqlCommand SqlCommand = new SqlCommand();
SqlCommand.Connection = SHCommon.g_DataBaseCon;
SqlCommand.CommandText = strSQL;
if (SHCommon.g_DataBaseCon.State == System.Data.ConnectionState.Closed)
{
SHCommon.g_DataBaseCon.Open();
}
SqlDataReader sdr = SqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgv_List, sdr, "Remark");
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
int iColumn = dgv_List.Columns.Count;
if (iColumn <= 0)
{
return;
}
for (int i = 0; i < iColumn; i++)
{
dgv_List.Columns[i].ReadOnly = true;
dgv_List.Columns[i].HeaderCell.Style.BackColor = Color.AliceBlue;
if (dgv_List.Columns[i].HeaderText == "Soff" || dgv_List.Columns[i].HeaderText == "CB")
{
dgv_List.Columns[i].ReadOnly = false;
}
}
dgv_List.Columns[0].Width = 30;
dgv_List.Columns[0].Visible = false;
dgv_List.Columns[1].Width = 30;
dgv_List.Columns[2].Width = 40;
if (iColumn >= (iHeaderCount + m_nShotCount))
{
for (int i = iHeaderCount; i < iHeaderCount + m_nShotCount; i++)
{
dgv_List.Columns[i].ReadOnly = false;
dgv_List.Columns[i].HeaderCell.Style.BackColor = Color.Yellow;
dgv_List.Columns[i].SortMode = DataGridViewColumnSortMode.NotSortable;
dgv_List.Columns[i].Width = 40;
}
}
dgv_List.Columns["Remark"].HeaderCell.Style.BackColor = Color.Yellow;
dgv_List.Columns["Remark"].ReadOnly = false;
m_nRemarkIndex = dgv_List.Columns["Remark"].Index;
// Add DNS,DSQ,.. Combobox
DGVCustomComboBoxColumn TypeCmbCol = (DGVCustomComboBoxColumn)dgv_List.Columns["Remark"];
if (TypeCmbCol != null)
{
DataTable TypeCmbContent = new DataTable();
TypeCmbContent.Columns.Add();
TypeCmbContent.Rows.Add("");
TypeCmbContent.Rows.Add("DNS");
TypeCmbContent.Rows.Add("DSQ");
TypeCmbContent.Rows.Add("DNF");
TypeCmbCol.FillComboBoxItems(TypeCmbContent, 0, 0);
}
UpdateMatchStatus();
}