public void ResetAvailableGrid(int iMatchID, int iTeamID, int iTeamPos, ref DataGridView dgv)
{
if (Common.g_DataBaseCon.State == System.Data.ConnectionState.Closed)
{
Common.g_DataBaseCon.Open();
}
try
{
#region DML Command Setup for Get AvailbleTeamMember
SqlCommand cmd = new SqlCommand("Proc_VB_EXT_GetTeamAvailable", Common.g_DataBaseCon);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@RegisterID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@MatchID", SqlDbType.Int);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
SqlParameter cmdParameter3 = new SqlParameter("@TeamPos", SqlDbType.Int);
cmdParameter0.Value = iTeamID;
cmdParameter1.Value = iMatchID;
cmdParameter2.Value = Common.g_strLanguage;
cmdParameter3.Value = iTeamPos;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
cmd.Parameters.Add(cmdParameter3);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgv, dr, null, null);
if (dgv.RowCount >= 0)
{
dgv.Columns["F_MemberID"].Visible = false;
dgv.Columns["F_FunctionID"].Visible = false;
for (int i = 0; i < dgv.RowCount; i++)
{
int iDSQ = Common.Str2Int(dgv.Rows[i].Cells["DSQ"].Value);
if (iDSQ == 1)
{
dgv.Rows[i].ReadOnly = true;
dgv.Rows[i].DefaultCellStyle.BackColor = System.Drawing.Color.DarkGray;
}
}
}
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
public frmEntryOfficial(Int32 iMatchID, Int32 iMatchType)
{
InitializeComponent();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvEventOfficials);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchOfficial);
m_iMatchID = iMatchID;
m_iMatchType = iMatchType;
m_iMatchSplitID = -1;
}
private void FillPositionComboBox()
{
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
int nDisciplineID = Convert.ToInt32(strDisciplineID);
#region DML Command Setup for Fill position combo
SqlCommand cmd = new SqlCommand("Proc_GetPosition", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = nDisciplineID;
cmdParameter1.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
dr = cmd.ExecuteReader();
#endregion
DataTable table = new DataTable();
table.Columns.Add("F_PositionLongName", typeof(string));
table.Columns.Add("F_PositionID", typeof(int));
table.Rows.Add("", "-1");
table.Load(dr);
(dgvMember.Columns[4] as DGVCustomComboBoxColumn).FillComboBoxItems(table, "F_PositionLongName", "F_PositionID");
dr.Close();
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
private void SetDgvSingleDiveList()
{
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvSingleDiveList);
dgvSingleDiveList.SelectionMode = DataGridViewSelectionMode.CellSelect;
FontFamily fontFamily = new FontFamily("Arial");
FontStyle fontStyle = new FontStyle();
Font gridFont = new Font(fontFamily, 13, fontStyle);
dgvSingleDiveList.Font = gridFont;
}
public frmTeamPlayers(Int32 iMatchID, Int32 iMatchType, Int32 iPos)
{
InitializeComponent();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeamPlayers);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchPlayers);
m_iMatchID = iMatchID;
m_iMatchType = iMatchType;
m_iPos = iPos;
}
private void InitMatchById(Int32 iNodeType, Int32 iEventID, Int32 iPhaseID, Int32 iMatchID)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandText = "Proc_GetMatchCompetitionRuleInfo";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@NodeType", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iNodeType);
oneSqlCommand.Parameters.Add(cmdParameter1);
SqlParameter cmdParameter2 = new SqlParameter(
"@EventID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iEventID);
oneSqlCommand.Parameters.Add(cmdParameter2);
SqlParameter cmdParameter3 = new SqlParameter(
"@PhaseID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iPhaseID);
oneSqlCommand.Parameters.Add(cmdParameter3);
SqlParameter cmdParameter4 = new SqlParameter(
"@MatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iMatchID);
oneSqlCommand.Parameters.Add(cmdParameter4);
if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_DatabaseConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
CmbCompetitionRule.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_CompetitionRuleID");
}
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void frmOVRWPPenaltyPlayer_Load(object sender, EventArgs e)
{
Localization();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Home);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Visit);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Home);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Visit);
ResetHomeGrid();
ResetVisitGrid();
}
private void InitMatchById(Int32 iMatchID, String strLanguageCode)
{
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = m_DatabaseConnection;
oneSqlCommand.CommandText = "Proc_GetMatchInfo";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@MatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, iMatchID);
oneSqlCommand.Parameters.Add(cmdParameter1);
SqlParameter cmdParameter2 = new SqlParameter(
"@LanguageCode", SqlDbType.Char, 3,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, strLanguageCode);
oneSqlCommand.Parameters.Add(cmdParameter2);
if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed)
{
m_DatabaseConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
TextCode.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchCode");
TextOrder.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_Order");
TextMatchNum.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchNum");
textHasMedal.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchHasMedal");
TextLongName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchLongName");
TextShortName.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchShortName");
TextComment.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_MatchComment");
TextComment2.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "MatchComment2");
TextCompetitorNum.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "MatchCompetitorNum");
CmbStatus.SelectedValue = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_MatchStatusID");
}
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void frmOfficialEntry_Load(object sender, EventArgs e)
{
Localization();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailOfficial);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchOfficial);
ResetAvailableOfficial();
ResetMatchOfficial();
InitPeriodCmb();
tbAttendance.Text = GVAR.g_ManageDB.GetMatchAttendance(m_iMatchID);
}
public OVREventRecordsForm(int nEventID, SqlConnection dbConnection)
{
m_nEventID = nEventID;
m_dbConnection = dbConnection;
InitializeComponent();
OVRDataBaseUtils.SetDataGridViewStyle(dgvEventRecords);
OVRDataBaseUtils.SetDataGridViewStyle(dgvRecordValue);
OVRDataBaseUtils.SetDataGridViewStyle(dgvRecordMember);
Localization();
}
public frmEntryOfficial(Int32 iMatchID, bool bIsTeam, ArrayList teamSplitIDs)
{
InitializeComponent();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvEventOfficials);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchOfficial);
m_bIsTeam = bIsTeam;
m_iMatchID = iMatchID;
m_teamSplitIDs = teamSplitIDs;
}
private void SetDgvStyle()
{
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvOuterMatchList);
FontFamily fontFamily = new FontFamily("Arial");
FontStyle fontStyle = new FontStyle();
Font gridFont = new Font(fontFamily, 13, fontStyle);
dgvOuterMatchList.Font = gridFont;
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMatchList);
dgvMatchList.Font = gridFont;
}
private void LoadData()
{
// Load Active Info
OVRDataBaseUtils.GetActiveInfo(m_RegisterModule.DatabaseConnection, out m_iActiveSport, out m_iActiveDiscipline, out m_strActiveLanguage);
m_iSportGroupType = GetGroupType();
//Register Tab
RegisterInfoLoadData();
//Inscription Tab
InscriptionLoadData();
}
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 frmGFCourse_Load(object sender, EventArgs e)
{
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvCourseList);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvCourseDetail);
Localization();
InitMatchInfo();
InitCourseInfo();
InitCmbRules();
cmbCourseList.SelectedValue = m_iCurMatchRuleID;
}
private void frmOVRWPPenaltyScore_Load(object sender, EventArgs e)
{
Localization();
lbHomeName.Text = m_CCurMatch.m_CHomeTeam.TeamName;
lbVisitName.Text = m_CCurMatch.m_CVisitTeam.TeamName;
lbHGKName.Text = "";
lbVGKName.Text = "";
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHomePenalty);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvVisitPenalty);
FillPlayerUI();
}
private void frmTeamMemberEntry_Load(object sender, EventArgs e)
{
Localization();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Home);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailable_Visit);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Home);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvMember_Visit);
ResetHomeGrid();
ResetVisitGrid();
InitUniformCmb();
}
public SetEventModelForm()
{
InitializeComponent();
Localization();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvModels);
m_iOpearateTypeID = 0;
this.dgvModels.Enabled = false;
this.btnImportEventModel.Enabled = false;
this.btnExportEventModel.Enabled = false;
this.btnDelEventModel.Enabled = false;
this.RadioByParameter.Checked = true;
}
private void ResetRegisterGrid()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for Get AvailbleMember
SqlCommand cmd = new SqlCommand("proc_GetAvailbleMember_With_Language", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.UpdatedRowSource = UpdateRowSource.None;
SqlParameter cmdParameter0 = new SqlParameter("@DisciplineID", SqlDbType.Int);
SqlParameter cmdParameter1 = new SqlParameter("@GroupID", SqlDbType.NVarChar, 9);
SqlParameter cmdParameter2 = new SqlParameter("@RegisterID", SqlDbType.Int);
SqlParameter cmdParameter3 = new SqlParameter("@SexCode", SqlDbType.Int);
SqlParameter cmdParameter4 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
SqlParameter cmdParameter5 = new SqlParameter("@GroupType", SqlDbType.Int);
m_strGroupID = cmbGroup.SelectedValue.ToString();
m_strSexCode = cmbSex.SelectedValue.ToString();
cmdParameter0.Value = Convert.ToInt32(m_strDisciplineID);
cmdParameter1.Value = Convert.ToInt32(m_strGroupID);
cmdParameter2.Value = Convert.ToInt32(m_strRegisterID);
cmdParameter3.Value = Convert.ToInt32(m_strSexCode);
cmdParameter4.Value = m_strLanguageCode;
cmdParameter5.Value = m_iGroupType;
cmd.Parameters.Add(cmdParameter0);
cmd.Parameters.Add(cmdParameter1);
cmd.Parameters.Add(cmdParameter2);
cmd.Parameters.Add(cmdParameter3);
cmd.Parameters.Add(cmdParameter4);
cmd.Parameters.Add(cmdParameter5);
#endregion
SqlDataReader dr = cmd.ExecuteReader();
OVRDataBaseUtils.FillDataGridView(dgvAllRegister, dr, null, null);
dr.Close();
SetGridStyle(dgvAllRegister);
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
public frmOVRSEDataEntry()
{
InitializeComponent();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeamA);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeamB);
//Hoop
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHoopResult);
this.dgvHoopResult.SelectionMode = DataGridViewSelectionMode.CellSelect;
m_processer = new QueueDataProcess<string>(this);
m_processer.StartProcess();
}
public OVRCommunicationForm()
{
InitializeComponent();
m_oReportInfoOfc = new OVRReportInfo();
m_oReportInfoOnDuty = new OVRReportInfo();
m_oReportInfoOffDuty = new OVRReportInfo();
OVRDataBaseUtils.SetDataGridViewStyle(dgvReportForDuty);
OVRDataBaseUtils.SetDataGridViewStyle(dgvCommunication);
dgvReportForDuty.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
dgvReportForDuty.ReadOnly = false;
}
private void btnx_Status_Click(object sender, EventArgs e)
{
if (sender == btnx_StartList)
{
m_iCurStatusID = GFCommon.STATUS_STARTLIST;
}
else if (sender == btnx_Running)
{
m_iCurStatusID = GFCommon.STATUS_RUNNING;
}
else if (sender == btnx_Suspend)
{
m_iCurStatusID = GFCommon.STATUS_SUSPEND;
}
else if (sender == btnx_Unofficial)
{
m_iCurStatusID = GFCommon.STATUS_UNOFFICIAL;
}
else if (sender == btnx_Official)
{
m_iCurStatusID = GFCommon.STATUS_OFFICIAL;
}
else if (sender == btnx_Revision)
{
m_iCurStatusID = GFCommon.STATUS_REVISION;
}
else if (sender == btnx_Canceled)
{
m_iCurStatusID = GFCommon.STATUS_CANCELED;
}
if (sender == btnx_Unofficial)
{//计算详细成绩排名信息
GFCommon.g_ManageDB.UpdateMatchResult(m_iCurMatchID, 1);
GFCommon.g_ManageDB.UpdateTeamResult(m_iCurMatchID, 1);
}
Int32 iResultTeam = OVRDataBaseUtils.ChangeMatchStatus(m_iCurTeamMatchID, m_iCurStatusID, GFCommon.g_DataBaseCon, GFCommon.g_GFPlugin);
Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_iCurMatchID, m_iCurStatusID, GFCommon.g_DataBaseCon, GFCommon.g_GFPlugin);
if (iResult == 1)
{
UpdateMatchStatus();
}
if (sender == btnx_Unofficial)
{//计算小项奖牌信息
GFCommon.g_ManageDB.CalculateEventResult(m_iCurMatchID);
}
}
private string QueryDistrubutedVersion(string strTplType, string strRscCode)
{
string strDisVersion;
strDisVersion = "";
strDisVersion = strTplType + strRscCode;
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = sqlConnection;
oneSqlCommand.CommandText = "Proc_GetDistrubutedVersion";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@TplType", SqlDbType.NVarChar, 20,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, strTplType);
oneSqlCommand.Parameters.Add(cmdParameter1);
SqlParameter cmdParameter2 = new SqlParameter(
"@RscCode", SqlDbType.NVarChar, 50,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, strRscCode);
oneSqlCommand.Parameters.Add(cmdParameter2);
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
strDisVersion = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "F_DistrubutedVersion");
}
}
sdr.Close();
}
catch (Exception ex)
{
UIMessageDialog.ShowMessageDialog(ex.Message, "Information", false, this.Style);
}
return(strDisVersion);
}
private void frmOVRGFDataEntry_Load(object sender, EventArgs e)
{
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHolePar);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvTeam);
SetDataGridViewStyle(this.dgvPlayer);
Localization();
EnableControlButton(false, true);
SetTCPInfo();
m_time = new System.Timers.Timer(3000);
m_time.Elapsed += new System.Timers.ElapsedEventHandler(TimeElapsed);
m_time.AutoReset = true;
m_time.Enabled = true;
}
public frmChosePhaseCompetitors(Int32 iEventID, Int32 iPhaseID, Int32 iNodeType, String strLanguageCode)
{
InitializeComponent();
Localization();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvEventCompetitors);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvPhaseCompetitors);
this.dgvEventCompetitors.RowHeadersVisible = true;
this.dgvPhaseCompetitors.RowHeadersVisible = true;
m_iEventID = iEventID;
m_iPhaseID = iPhaseID;
m_iNodeType = iNodeType;
m_strLanguageCode = strLanguageCode;
}
private void InitMatchInfo()
{
SqlConnection theDataBaseCon;
theDataBaseCon = DVCommon.g_DataBaseCon;
try
{
SqlCommand oneSqlCommand = new SqlCommand();
oneSqlCommand.Connection = theDataBaseCon;
oneSqlCommand.CommandText = "Proc_DV_GetMatchInfo";
oneSqlCommand.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter1 = new SqlParameter(
"@MatchID", SqlDbType.Int, 4,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_iCurMatchID);
oneSqlCommand.Parameters.Add(cmdParameter1);
SqlParameter cmdParameter2 = new SqlParameter(
"@LanguageCode", SqlDbType.Char, 3,
ParameterDirection.Input, true, 0, 0, "",
DataRowVersion.Current, m_strLanguageCode);
oneSqlCommand.Parameters.Add(cmdParameter2);
if (theDataBaseCon.State == System.Data.ConnectionState.Closed)
{
theDataBaseCon.Open();
}
SqlDataReader sdr = oneSqlCommand.ExecuteReader();
if (sdr.HasRows)
{
if (sdr.Read())
{
lb_MatchDes.Text = OVRDataBaseUtils.GetFieldValue2String(ref sdr, "MatchDes");
m_iDisciplineID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_DisciplineID");
m_iCurMatchRuleID = OVRDataBaseUtils.GetFieldValue2Int32(ref sdr, "F_CompetitionRuleID");
}
}
sdr.Close();
}
catch (Exception ex)
{
DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message);
}
}
private void FillInfoGrid()
{
if (sqlConnection.State == System.Data.ConnectionState.Closed)
{
sqlConnection.Open();
}
try
{
#region DML Command Setup for NOC Info
SqlCommand cmd = new SqlCommand("Proc_EQ_GetDesInfoList", sqlConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter cmdParameter0 = new SqlParameter("@DesTableName", SqlDbType.NVarChar, 50);
SqlParameter cmdParameter1 = new SqlParameter("@DesName", SqlDbType.NVarChar, 50);
SqlParameter cmdParameter2 = new SqlParameter("@LanguageCode", SqlDbType.NVarChar, 3);
cmdParameter0.Value = m_strDesTableName;
cmd.Parameters.Add(cmdParameter0);
cmdParameter1.Value = m_strDesName;
cmd.Parameters.Add(cmdParameter1);
cmdParameter2.Value = m_strLanguageCode;
cmd.Parameters.Add(cmdParameter2);
SqlDataReader dr = cmd.ExecuteReader();
#endregion
OVRDataBaseUtils.FillDataGridView(dgvInfo, dr, null, null);
dr.Close();
//隐藏ID列
dgvInfo.Columns[0].Visible = false;
if (dgvInfo.Rows.Count > 0)
{
if (m_iSelRowIdx < 0)
{
return;
}
else if (m_iSelRowIdx > dgvInfo.RowCount - 1)
{
m_iSelRowIdx = dgvInfo.RowCount - 1;
}
dgvInfo.Rows[m_iSelRowIdx].Selected = true;
dgvInfo.FirstDisplayedScrollingRowIndex = m_iSelRowIdx;
}
}
catch (System.Exception e)
{
DevComponents.DotNetBar.MessageBoxEx.Show(e.Message);
}
}
public bool UpdateUI(int matchID)
{
DataTable dt = BDCommon.g_ManageDB.GetViewScore(matchID);
if (dt == null)
{
return(false);
}
OVRDataBaseUtils.FillDataGridView(dgViewScore, dt);
dgViewScore.Columns[0].Width = 50;
foreach (DataGridViewColumn col in dgViewScore.Columns)
{
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
lbMatchID.Text = matchID.ToString();
lbMatchCourt.Text = BDCommon.g_ManageDB.GetMatchCourtName(matchID);
lbMatchRSC.Text = BDCommon.g_ManageDB.GetRscStringFromMatchID(matchID);
String strSportDes, strPhaseDes, strDateDes, strVenueDes, strPlayNameA, strPlayNameB, strHomeScore, strAwayScore;
int m_nCurPlayIDA, m_nCurPlayIDB, m_nCurStatusID, m_nRegAPos, m_nRegBPos;
BDCommon.g_ManageDB.GetOneMatchDes(matchID, out m_nCurPlayIDA, out m_nCurPlayIDB, out strPlayNameA, out strPlayNameB, out m_nCurStatusID,
out strSportDes, out strPhaseDes, out strDateDes, out strVenueDes, out strHomeScore, out strAwayScore, out m_nRegAPos, out m_nRegBPos);
//lb_SportDes.Text = strSportDes;
lbMatchTime.Text = strDateDes;
this.Text = strPhaseDes;
lbPlayerA.Text = strPlayNameA;
lbPlayerB.Text = strPlayNameB;
lbMatchScore.Text = BDCommon.g_ManageDB.GetMatchScoreString(matchID);
bool bFound = false;
for (int i = 0; i < lsbMatchID.Items.Count; i++)
{
if ((string)lsbMatchID.Items[i] == matchID.ToString())
{
lsbMatchID.SelectedIndex = i;
bFound = true;
break;
}
}
if (!bFound)
{
lsbMatchID.SelectedIndex = -1;
}
return(true);
}
public HorseInscriptionForm(Int32 iEventID, Int32 iRegisterID, String strLanguageCode)
{
InitializeComponent();
Localization();
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvAvailableHorses);
OVRDataBaseUtils.SetDataGridViewStyle(this.dgvHorseInscription);
this.dgvAvailableHorses.RowHeadersVisible = true;
this.dgvHorseInscription.RowHeadersVisible = true;
dgvAvailableHorses.MultiSelect = false;
dgvHorseInscription.MultiSelect = false;
m_iEventID = iEventID;
m_iRegisterID = iRegisterID;
m_strLanguageCode = strLanguageCode;
}
public frmImportMatchInfo(string strImportDir, XmlTypeEnum xmlType)
{
InitializeComponent();
OVRDataBaseUtils.SetDataGridViewStyle(dgMatchInfo);
importDir_ = strImportDir;
xmlType_ = xmlType;
if (xmlType_ == XmlTypeEnum.XmlTypeMatchInfo)
{
btnImportAllAction.Visible = false;
this.Text = "Import Match Result";
}
else
{
this.Text = "Import Match Action";
}
}
