private void SetDataGridView(int iEventId)
{
if (GVAR.g_adoDataBase.DBConnect.State == System.Data.ConnectionState.Closed)
{
GVAR.g_adoDataBase.DBConnect.Open();
}
try
{
#region DML Command Setup for Get Event
SqlCommand cmd = new SqlCommand("Proc_WR_GetWeight", GVAR.g_adoDataBase.DBConnect);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@EventID", SqlDbType.Int);
cmdParameter1.Value = iEventId;
cmd.Parameters.Add(cmdParameter1);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvWeight, dr, null, null);
dr.Close();
this.dgvWeight.Columns["Weight (kg)"].ReadOnly = false;
this.dgvWeight.Columns["Remark"].ReadOnly = false;
}
catch (System.Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void FillModels()
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandText = "Proc_GetModels";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_DatabaseConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvModels, sdr, "");
sdr.Close();
if (dgvModels.Columns["F_Order"] != null)
{
dgvModels.Columns["F_Order"].ReadOnly = false;
}
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void InitPositionList()
{
DataTable dt = BDCommon.g_ManageDB.GetMatchMemberPosition(m_iMatchID, 0);
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvPosition, dt, "Pos");
if (dt != null && dt.Columns.Count >= 4)
{
dgvPosition.Columns[3].ReadOnly = false;
}
}
private void ResetMemberGrid()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Active Discipline
string strDisciplineID = "0";
SqlCommand cmdDiscipline = new SqlCommand("Proc_GetActiveDiscipline", sqlConnection);
cmdDiscipline.CommandType = CommandType.StoredProcedure;
SqlDataReader dr = cmdDiscipline.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
strDisciplineID = OVRDataBaseUtils.GetFieldValue2String(ref dr, "F_DisciplineID");
}
}
dr.Close();
#endregion
#region DML Command Setup for Get Member
int nRegisterID = Convert.ToInt32(m_strRegisterID);
int nDisciplineID = Convert.ToInt32(strDisciplineID);
SqlCommand cmd = new SqlCommand("Proc_GetMember_WithOrder", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.UpdatedRowSource = UpdateRowSource.None;
SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@RegisterID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = Convert.ToInt32(strDisciplineID);
cmdParameter1.Value = Convert.ToInt32(m_strRegisterID);
cmdParameter2.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
#endregion
dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvMember, dr, 3, 4);
dr.Close();
SetGridStyle(dgvMember);
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void ResetFederationList(int iDisciplineID, string strLanguageCode, int iGroupType)
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get Federation List
SqlCommand cmd = new SqlCommand("Proc_GetGroupInfo", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
SqlParameter cmdParameter3 = new SqlParameter("@GroupType", SqlDbType.Int);
cmdParameter1.Value = iDisciplineID;
cmdParameter2.Value = strLanguageCode;
cmdParameter3.Value = iGroupType;
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
cmd.Parameters.Add(cmdParameter3);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvFederation, dr, 0);
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
if (dgvFederation.Rows.Count > 0)
{
dgvFederation.ClearSelection();
for (int i = 0; i < m_arySelIndex.Count; i++)
{
int iSelIndex = (int)m_arySelIndex[i];
if (i == 0)
{
dgvFederation.FirstDisplayedScrollingRowIndex = iSelIndex;
}
dgvFederation.Rows[iSelIndex].Selected = true;
}
}
}
private void FillModels()
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandType = CommandType.StoredProcedure;
if (m_iNodeType == 0)
{
oneSqlCommand.CommandText = "Proc_GetPhaseModels";
SqlParameter cmdParameter1 = new SqlParameter(
"@PhaseID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_iPhaseID);
oneSqlCommand.Parameters.Add(cmdParameter1);
}
else if (m_iNodeType == 1)
{
oneSqlCommand.CommandText = "Proc_GetMatchModels";
SqlParameter cmdParameter1 = new SqlParameter(
"@MatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_iMatchID);
oneSqlCommand.Parameters.Add(cmdParameter1);
}
if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_DatabaseConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvModels, sdr, "");
if (dgvModels.Columns["F_Order"] != null)
{
dgvModels.Columns["F_Order"].ReadOnly = false;
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void Update_SessionGrid()
{
System.Data.DataTable dt = GetSessionTable(m_strDate);
m_dtOldSession = new DataTable();
for (int nColIndex = 0; nColIndex < dt.Columns.Count; nColIndex++)
{
m_dtOldSession.Columns.Add(dt.Columns[nColIndex].ColumnName, dt.Columns[nColIndex].DataType);
}
m_dtOldSession.Rows.Add();
this.dgv_Session.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
OVRDataBaseUtils.FillDataGridViewWithCmb(this.dgv_Session, dt, "Type");
if (this.dgv_Session.Columns["F_DisciplineID"] != null)
{
this.dgv_Session.Columns["F_DisciplineID"].Visible = false;
}
if (this.dgv_Session.Columns["F_SessionID"] != null)
{
this.dgv_Session.Columns["F_SessionID"].Visible = false;
}
if (this.dgv_Session.Columns["F_SessionTypeID"] != null)
{
this.dgv_Session.Columns["F_SessionTypeID"].Visible = false;
}
if (this.dgv_Session.Columns["Number"] != null)
{
this.dgv_Session.Columns["Number"].ReadOnly = false;
}
if (this.dgv_Session.Columns["StartTime"] != null)
{
this.dgv_Session.Columns["StartTime"].ReadOnly = false;
}
if (this.dgv_Session.Columns["EndTime"] != null)
{
this.dgv_Session.Columns["EndTime"].ReadOnly = false;
}
if (this.dgv_Session.Columns["Type"] != null)
{
this.dgv_Session.Columns["Type"].ReadOnly = false;
}
}
private void Update_RoundGrid()
{
System.Data.DataTable dt = GetRoundTable(m_strEventID);
m_dtOldRound = new DataTable();
for (int nColIndex = 0; nColIndex < dt.Columns.Count; nColIndex++)
{
m_dtOldRound.Columns.Add(dt.Columns[nColIndex].ColumnName, dt.Columns[nColIndex].DataType);
}
m_dtOldRound.Rows.Add();
this.dgv_Round.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
OVRDataBaseUtils.FillDataGridViewWithCmb(this.dgv_Round, dt, 0);
if (this.dgv_Round.Columns["F_EventID"] != null)
{
this.dgv_Round.Columns["F_EventID"].Visible = false;
}
if (this.dgv_Round.Columns["F_RoundID"] != null)
{
this.dgv_Round.Columns["F_RoundID"].Visible = false;
}
if (this.dgv_Round.Columns["Order"] != null)
{
this.dgv_Round.Columns["Order"].ReadOnly = false;
}
if (this.dgv_Round.Columns["Code"] != null)
{
this.dgv_Round.Columns["Code"].ReadOnly = false;
}
if (this.dgv_Round.Columns["LongName"] != null)
{
this.dgv_Round.Columns["LongName"].ReadOnly = false;
}
if (this.dgv_Round.Columns["ShortName"] != null)
{
this.dgv_Round.Columns["ShortName"].ReadOnly = false;
}
if (this.dgv_Round.Columns["Comment"] != null)
{
this.dgv_Round.Columns["Comment"].ReadOnly = false;
}
}
private void OVREQMatchMF_Load(object sender, EventArgs e)
{
OVRDataBaseUtils.FillDataGridViewWithCmb(this.dgvMatchMF, GVAR.g_EQDBManager.GetMatchMFs(MatchConfigID), "F_MFLongName", "F_MovementType");
//设置列标题名
this.dgvMatchMF.Columns["F_MFCode"].HeaderText = "Order";
this.dgvMatchMF.Columns["F_MFCodeDes"].HeaderText = "Code";
this.dgvMatchMF.Columns["F_MFLongName"].HeaderText = "Description";
this.dgvMatchMF.Columns["F_Coefficient"].HeaderText = "Coefficient";
this.dgvMatchMF.Columns["F_MovementType"].HeaderText = "Type";
this.dgvMatchMF.Columns["F_SubFences"].HeaderText = "SubFences";
this.dgvMatchMF.Columns["F_SubFencesDes"].HeaderText = "SubFencesDes";
//列宽
//可编辑
this.dgvMatchMF.Columns["F_MFCodeDes"].ReadOnly = false;
this.dgvMatchMF.Columns["F_Coefficient"].ReadOnly = false;
this.dgvMatchMF.Columns["F_SubFences"].ReadOnly = false;
this.dgvMatchMF.Columns["F_SubFencesDes"].ReadOnly = false;
//隐藏列
this.dgvMatchMF.Columns["F_MatchConfigID"].Visible = false;
this.dgvMatchMF.Columns["F_MFID"].Visible = false;
//如果是盛装舞步
if (MatchRuleCode.Equals("DR"))
{
this.dgvMatchMF.Columns["F_SubFences"].Visible = false;
this.dgvMatchMF.Columns["F_SubFencesDes"].Visible = false;
btnx_MF.Text = LocalizationRecourceManager.GetString(GVAR.g_strSectionName, "btnx_Movement");
this.Text = LocalizationRecourceManager.GetString(GVAR.g_strSectionName, "OVREQMatchMovement");
}
else
{
this.dgvMatchMF.Columns["F_Coefficient"].Visible = false;
this.dgvMatchMF.Columns["F_MovementType"].Visible = false;
btnx_MF.Text = LocalizationRecourceManager.GetString(GVAR.g_strSectionName, "btnx_Fence");
this.Text = LocalizationRecourceManager.GetString(GVAR.g_strSectionName, "OVREQMatchFence");
}
}
public void ResetMatchOfficial(int iMatchID, DataGridView dgv)
{
System.Data.SqlClient.SqlConnection con = GVAR.g_adoDataBase.DBConnect;
if (con.State != ConnectionState.Open)
{
con.Open();
}
try
{
#region DML Command Setup for Get MatchOfficial
SqlCommand cmd = new SqlCommand("Proc_AR_GetMatchOfficial", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@MatchID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = iMatchID;
cmdParameter1.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgv, dr, new string[] { "Function", "Position" });
if (dgv.RowCount >= 0)
{
dgv.Columns["F_RegisterID"].Visible = false;
dgv.Columns["Group"].Visible = false;
dgv.Columns["Position"].Visible = false;
}
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void Update_DateGrid()
{
System.Data.DataTable dt = GetDateTable();
m_dtOldDate = new DataTable();
for (int nColIndex = 0; nColIndex < dt.Columns.Count; nColIndex++)
{
m_dtOldDate.Columns.Add(dt.Columns[nColIndex].ColumnName, dt.Columns[nColIndex].DataType);
}
m_dtOldDate.Rows.Add();
this.dgv_Date.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
OVRDataBaseUtils.FillDataGridViewWithCmb(this.dgv_Date, dt, 0);
if (this.dgv_Date.Columns["F_DisciplineDateID"] != null)
{
this.dgv_Date.Columns["F_DisciplineDateID"].Visible = false;
}
if (this.dgv_Date.Columns["Order"] != null)
{
this.dgv_Date.Columns["Order"].ReadOnly = false;
}
if (this.dgv_Date.Columns["Date"] != null)
{
this.dgv_Date.Columns["Date"].ReadOnly = true;
}
if (this.dgv_Date.Columns["Long Description"] != null)
{
this.dgv_Date.Columns["Long Description"].ReadOnly = false;
}
if (this.dgv_Date.Columns["Short Description"] != null)
{
this.dgv_Date.Columns["Short Description"].ReadOnly = false;
}
if (this.dgv_Date.Columns["Comment"] != null)
{
this.dgv_Date.Columns["Comment"].ReadOnly = false;
}
}
public void ResetMatchOfficial(int iMatchID, DataGridView dgv)
{
if (Common.g_DataBaseCon.State == System.Data.ConnectionState.Closed)
{
Common.g_DataBaseCon.Open();
}
try
{
#region DML Command Setup for Get MatchOfficial
SqlCommand cmd = new SqlCommand("Proc_VB_EXT_MatchOfficialGetList", Common.g_DataBaseCon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@MatchID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = iMatchID;
cmdParameter1.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgv, dr, "Function");
if (dgv.RowCount >= 0)
{
dgv.Columns["F_RegisterID"].Visible = false;
}
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
public void ResetRegisterGrid(bool bUpdateSel)
{
int iSexID, iEventID, iRegTypeID;
string strGroupID;
int nSelIdx = -1;
if (cmbSex.SelectedItem == null)
{
return;
}
nSelIdx = cmbSex.SelectedIndex;
iSexID = Convert.ToInt32(cmbSex.SelectedValue);
if (cmbEvent.SelectedItem == null)
{
return;
}
nSelIdx = cmbEvent.SelectedIndex;
iEventID = Convert.ToInt32(cmbEvent.SelectedValue);
if (cmbRegType.SelectedItem == null)
{
return;
}
nSelIdx = cmbRegType.SelectedIndex;
iRegTypeID = Convert.ToInt32(cmbRegType.SelectedValue);
if (cmbFederation.SelectedItem == null)
{
return;
}
nSelIdx = cmbFederation.SelectedIndex;
strGroupID = cmbFederation.SelectedValue.ToString();
int iSelIndex = -1;
if (bUpdateSel)
{
iSelIndex = dgvRegister.SelectedRows[0].Index;
}
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get Register
SqlCommand cmd = new SqlCommand("Proc_SearchRegisters", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@SexCode", SqlDbType.Int);
SqlParameter cmdParameter3 = new SqlParameter("@RegTypeID", SqlDbType.Int);
SqlParameter cmdParameter4 = new SqlParameter("@EventID", SqlDbType.Int);
SqlParameter cmdParameter5 = new SqlParameter("@GroupID", SqlDbType.NVarChar, 9);
SqlParameter cmdParameter6 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
SqlParameter cmdParameter7 = new SqlParameter("@GroupType", SqlDbType.Int);
cmdParameter1.Value = m_iActiveDisciplineID;
cmdParameter2.Value = iSexID;
cmdParameter3.Value = iRegTypeID;
cmdParameter4.Value = iEventID;
cmdParameter5.Value = strGroupID;
cmdParameter6.Value = m_strActiveLanguageCode;
cmdParameter7.Value = m_iGroupType;
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
cmd.Parameters.Add(cmdParameter3);
cmd.Parameters.Add(cmdParameter4);
cmd.Parameters.Add(cmdParameter5);
cmd.Parameters.Add(cmdParameter6);
cmd.Parameters.Add(cmdParameter7);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvRegister, dr, null, null);
dr.Close();
if (dgvRegister.Columns["RegisterID"] != null)
{
dgvRegister.Columns["RegisterID"].Visible = false;
}
if (dgvRegister.Columns["GroupID"] != null)
{
dgvRegister.Columns["GroupID"].Visible = false;
}
if (dgvRegister.Rows.Count > 0)
{
if (bUpdateSel && iSelIndex >= 0)
{
if (iSelIndex >= dgvRegister.RowCount)
{
iSelIndex = dgvRegister.RowCount - 1;
}
dgvRegister.ClearSelection();
dgvRegister.Rows[iSelIndex].Selected = true;
dgvRegister.FirstDisplayedScrollingRowIndex = iSelIndex;
}
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
public void ResetRegisterGrid(bool bUpdateSel)
{
int iSelIndex = -1;
if (bUpdateSel)
{
if (dgvRegister.SelectedRows.Count > 0)
{
iSelIndex = dgvRegister.SelectedRows[0].Index;
}
}
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get Register
SqlCommand cmd = new SqlCommand("Proc_AR_GetCheckResults", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter("@MatchID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter1.Value = m_iMatchID;
cmdParameter2.Value = GVAR.g_strLang;
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridViewWithCmb(dgvRegister, dr, null, null);
dr.Close();
if (dgvRegister.Columns["F_MatchID"] != null)
{
dgvRegister.Columns["F_MatchID"].Visible = false;
}
if (dgvRegister.Columns["F_CompetitionPosition"] != null)
{
dgvRegister.Columns["F_CompetitionPosition"].Visible = false;
}
if (dgvRegister.Rows.Count > 0)
{
if (bUpdateSel && iSelIndex >= 0)
{
if (iSelIndex >= dgvRegister.RowCount)
{
iSelIndex = dgvRegister.RowCount - 1;
}
dgvRegister.ClearSelection();
dgvRegister.Rows[iSelIndex].Selected = true;
dgvRegister.FirstDisplayedScrollingRowIndex = iSelIndex;
}
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void Init_ScheduledGrid()
{
OVRDataBaseUtils.SetDataGridViewStyle(this.dgv_Scheduled);
System.Data.DataTable dt = GetInitScheduledDataTable();
OVRDataBaseUtils.FillDataGridViewWithCmb(this.dgv_Scheduled, dt, "Date", "Session", "Round", "Status", "Venue", "Court");
if (this.dgv_Scheduled.Columns["F_EventID"] != null)
{
this.dgv_Scheduled.Columns["F_EventID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_MatchID"] != null)
{
this.dgv_Scheduled.Columns["F_MatchID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_SessionID"] != null)
{
this.dgv_Scheduled.Columns["F_SessionID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_VenueID"] != null)
{
this.dgv_Scheduled.Columns["F_VenueID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_CourtID"] != null)
{
this.dgv_Scheduled.Columns["F_CourtID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_MatchStatusID"] != null)
{
this.dgv_Scheduled.Columns["F_MatchStatusID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_RoundID"] != null)
{
this.dgv_Scheduled.Columns["F_RoundID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["R.Num"] != null)
{
this.dgv_Scheduled.Columns["R.Num"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["M.Code"] != null)
{
this.dgv_Scheduled.Columns["M.Code"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["StartTime"] != null)
{
this.dgv_Scheduled.Columns["StartTime"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["EndTime"] != null)
{
this.dgv_Scheduled.Columns["EndTime"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["O.I.S"] != null)
{
this.dgv_Scheduled.Columns["O.I.S"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["O.I.R"] != null)
{
this.dgv_Scheduled.Columns["O.I.R"].ReadOnly = false;
}
this.dgv_Scheduled.ClearSelection();
}
private void Update_ScheduledGrid()
{
int iFirstDisplayedScrollingRowIndex = dgv_Scheduled.FirstDisplayedScrollingRowIndex;
int iFirstDisplayedScrollingColumnIndex = dgv_Scheduled.FirstDisplayedScrollingColumnIndex;
if (iFirstDisplayedScrollingRowIndex < 0)
{
iFirstDisplayedScrollingRowIndex = 0;
}
if (iFirstDisplayedScrollingColumnIndex < 0)
{
iFirstDisplayedScrollingColumnIndex = 0;
}
System.Data.DataTable dt = GetScheduledDataTable();
m_dtOldScheduled = new DataTable();
for (int nColIndex = 0; nColIndex < dt.Columns.Count; nColIndex++)
{
m_dtOldScheduled.Columns.Add(dt.Columns[nColIndex].ColumnName, dt.Columns[nColIndex].DataType);
}
m_dtOldScheduled.Rows.Add();
OVRDataBaseUtils.FillDataGridViewWithCmb(this.dgv_Scheduled, dt, "Date", "Session", "Round", "Status", "Venue", "Court");
if (this.dgv_Scheduled.Columns["F_EventID"] != null)
{
this.dgv_Scheduled.Columns["F_EventID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_MatchID"] != null)
{
this.dgv_Scheduled.Columns["F_MatchID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_SessionID"] != null)
{
this.dgv_Scheduled.Columns["F_SessionID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_VenueID"] != null)
{
this.dgv_Scheduled.Columns["F_VenueID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_CourtID"] != null)
{
this.dgv_Scheduled.Columns["F_CourtID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_MatchStatusID"] != null)
{
this.dgv_Scheduled.Columns["F_MatchStatusID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["F_RoundID"] != null)
{
this.dgv_Scheduled.Columns["F_RoundID"].Visible = false;
}
if (this.dgv_Scheduled.Columns["R.Num"] != null)
{
this.dgv_Scheduled.Columns["R.Num"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["M.Code"] != null)
{
this.dgv_Scheduled.Columns["M.Code"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["StartTime"] != null)
{
this.dgv_Scheduled.Columns["StartTime"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["EndTime"] != null)
{
this.dgv_Scheduled.Columns["EndTime"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["O.I.S"] != null)
{
this.dgv_Scheduled.Columns["O.I.S"].ReadOnly = false;
}
if (this.dgv_Scheduled.Columns["O.I.R"] != null)
{
this.dgv_Scheduled.Columns["O.I.R"].ReadOnly = false;
}
this.dgv_Scheduled.ClearSelection();
if (iFirstDisplayedScrollingRowIndex < dgv_Scheduled.Rows.Count)
{
dgv_Scheduled.FirstDisplayedScrollingRowIndex = iFirstDisplayedScrollingRowIndex;
}
if (iFirstDisplayedScrollingColumnIndex < dgv_Scheduled.Columns.Count)
{
dgv_Scheduled.FirstDisplayedScrollingColumnIndex = iFirstDisplayedScrollingColumnIndex;
}
}
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();
}
