private void btnx_Running_Click(object sender, EventArgs e) { // Auto Select 1st Split or 1st Set if (m_nCurMatchType == SQCommon.MATCH_TYPE_TEAM) { btnx_Match1.Checked = true; m_nCurSplitOffset = 0; if (!ChangeTeamSplit(0)) { return; } } else if (m_nCurMatchType == SQCommon.MATCH_TYPE_SINGLE) { rad_Game1.Checked = true; m_nCurSplitOffset = 0; m_nCurSetOffset = 0; } m_nCurStatusID = SQCommon.STATUS_RUNNING; Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_nCurMatchID, m_nCurStatusID, SQCommon.g_adoDataBase.m_dbConnect, SQCommon.g_SQPlugin); if (iResult == 1) { UpdateMatchStatus(); } }
private void btnx_StartList_Click(object sender, EventArgs e) { m_nCurStatusID = SECommon.STATUS_STARTLIST; Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_nCurMatchID, m_nCurStatusID, SECommon.g_adoDataBase.m_dbConnect, SECommon.g_SEPlugin); if (iResult == 1) UpdateMatchStatus(); }
private void btnx_Unofficial_Click(object sender, EventArgs e) { m_nCurStatusID = SECommon.STATUS_UNOFFICIAL; Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_nCurMatchID, m_nCurStatusID, SECommon.g_adoDataBase.m_dbConnect, SECommon.g_SEPlugin); if (iResult == 1) UpdateMatchStatus(); SECommon.g_ManageDB.UpdateSplitStatusUnofficial(m_nCurMatchID); }
private void btnx_MatchStatus_Click(object sender, EventArgs e) { int nStatusID = 0; if (sender == btnx_Schedule) { nStatusID = Common.STATUS_SCHEDULE; } else if (sender == btnx_StartList) { nStatusID = Common.STATUS_STARTLIST; } else if (sender == btnx_Running) { nStatusID = Common.STATUS_RUNNING; } else if (sender == btnx_Suspend) { nStatusID = Common.STATUS_SUSPEND; } else if (sender == btnx_Unofficial) { nStatusID = Common.STATUS_UNOFFICIAL; } else if (sender == btnx_Official) { nStatusID = Common.STATUS_OFFICIAL; } else if (sender == btnx_Revision) { nStatusID = Common.STATUS_REVISION; } else if (sender == btnx_Canceled) { nStatusID = Common.STATUS_CANCELED; } else { return; } Int32 nResult = OVRDataBaseUtils.ChangeMatchStatus( Common.g_nMatchID, nStatusID, Common.g_DataBaseCon, Common.g_Plugin); //晋级比赛 if (sender == btnx_Official) { //淘汰赛晋级 OVRDataBaseUtils.AutoProgressMatch(Common.g_nMatchID, Common.g_DataBaseCon, Common.g_Plugin); //小组赛计分计算 Common.dbCalGroupResult(Common.g_nMatchID); } Common.dbMatchModifyTimeSet(); RefreshAll(); }
private void btnx_Canceled_Click(object sender, EventArgs e) { m_nCurStatusID = SQCommon.STATUS_CANCELED; Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_nCurMatchID, m_nCurStatusID, SQCommon.g_adoDataBase.m_dbConnect, SQCommon.g_SQPlugin); if (iResult == 1) { UpdateMatchStatus(); } }
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 void btnx_HoopStatus_Click(object sender, EventArgs e) { if (sender == btnx_HoopSchedule) { m_nCurStatusID = SECommon.STATUS_SCHEDULE; } else if (sender == btnx_HoopStartList) { m_nCurStatusID = SECommon.STATUS_STARTLIST; } else if (sender == btnx_HoopRunning) { m_nCurStatusID = SECommon.STATUS_RUNNING; } else if (sender == btnx_HoopSuspend) { m_nCurStatusID = SECommon.STATUS_SUSPEND; } else if (sender == btnx_HoopUnOfficial) { m_nCurStatusID = SECommon.STATUS_UNOFFICIAL; } else if (sender == btnx_HoopFinished) { m_nCurStatusID = SECommon.STATUS_FINISHED; } else if (sender == btnx_HoopRevision) { m_nCurStatusID = SECommon.STATUS_REVISION; } else if (sender == btnx_HoopCanceled) { m_nCurStatusID = SECommon.STATUS_CANCELED; } else { return; } Int32 iResult = OVRDataBaseUtils.ChangeMatchStatus(m_nCurMatchID, m_nCurStatusID, SECommon.g_adoDataBase.m_dbConnect, SECommon.g_SEPlugin); if (iResult == 1) { UpdateHoopMatchStatus(); } }
public bool UpdateMatchStatus(int nMatchID, int nMatchStatusID) { Int32 nChangeStatusResult = 0; nChangeStatusResult = OVRDataBaseUtils.ChangeMatchStatus( nMatchID, nMatchStatusID, SHCommon.g_DataBaseCon, m_oPlugin); if (nChangeStatusResult == 1) { UpdateMatchStatus(); return(true); } else { return(false); } }
private bool EditMatch() { bool bResult = false; Int32 iChangeStatusResult = 0; iChangeStatusResult = OVRDataBaseUtils.ChangeMatchStatus(m_iMatchID, ConvertStrToInt(CmbStatus.SelectedValue.ToString()), m_DatabaseConnection, m_Module); if (iChangeStatusResult != 1) { switch (iChangeStatusResult) { case 1: //修改成功! break; case -1: DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditMatchStatus2")); break; default: //其余的需要为修改失败! DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditMatchStatus1")); break; } return(bResult); } try { Int32 iOperateResult; SqlCommand oneSqlCommand = new SqlCommand(); oneSqlCommand.Connection = m_DatabaseConnection; oneSqlCommand.CommandText = "proc_EditMatch"; oneSqlCommand.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter0 = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_iMatchID); oneSqlCommand.Parameters.Add(cmdParameter0); SqlParameter cmdParameter7 = new SqlParameter( "@Code", SqlDbType.NVarChar, 20, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextCode.Text); oneSqlCommand.Parameters.Add(cmdParameter7); SqlParameter cmdParameter8 = new SqlParameter( "@Order", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextOrder.Text); oneSqlCommand.Parameters.Add(cmdParameter8); SqlParameter cmdParameter12 = new SqlParameter( "@MatchNum", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextMatchNum.Text); oneSqlCommand.Parameters.Add(cmdParameter12); SqlParameter cmdParameter13 = new SqlParameter( "@HasMedal", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(textHasMedal.Text)); oneSqlCommand.Parameters.Add(cmdParameter13); SqlParameter cmdParameter14 = new SqlParameter( "@languageCode", SqlDbType.Char, 3, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, m_strLanguageCode); oneSqlCommand.Parameters.Add(cmdParameter14); SqlParameter cmdParameter17 = new SqlParameter( "@MatchLongName", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextLongName.Text); oneSqlCommand.Parameters.Add(cmdParameter17); SqlParameter cmdParameter18 = new SqlParameter( "@MatchShortName", SqlDbType.NVarChar, 50, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextShortName.Text); oneSqlCommand.Parameters.Add(cmdParameter18); SqlParameter cmdParameter19 = new SqlParameter( "@MatchComment", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextComment.Text); oneSqlCommand.Parameters.Add(cmdParameter19); SqlParameter cmdParameter20 = new SqlParameter( "@MatchComment2", SqlDbType.NVarChar, 100, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, TextComment2.Text); oneSqlCommand.Parameters.Add(cmdParameter20); SqlParameter cmdParameter21 = new SqlParameter( "@StatusID", SqlDbType.Int, 4, ParameterDirection.Input, true, 0, 0, "", DataRowVersion.Current, ConvertStrToInt(CmbStatus.SelectedValue.ToString())); oneSqlCommand.Parameters.Add(cmdParameter21); SqlParameter cmdParameterResult = new SqlParameter( "@Result", SqlDbType.Int, 4, ParameterDirection.Output, true, 0, 0, "", DataRowVersion.Current, 0); oneSqlCommand.Parameters.Add(cmdParameterResult); if (m_DatabaseConnection.State == System.Data.ConnectionState.Closed) { m_DatabaseConnection.Open(); } if (oneSqlCommand.ExecuteNonQuery() != 0) { iOperateResult = (Int32)cmdParameterResult.Value; switch (iOperateResult) { case 0: DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditMatch1")); bResult = false; break; case -1: DevComponents.DotNetBar.MessageBoxEx.Show(LocalizationRecourceManager.GetString(m_strSectionName, "MsgEditMatch2")); bResult = false; break; default: //其余的需要为修改成功! bResult = true; break; } } } catch (Exception ex) { DevComponents.DotNetBar.MessageBoxEx.Show(ex.Message); } return(bResult); }
void ImportMatchInfo(String strImprotFile) { if (!File.Exists(strImprotFile)) { MessageBox.Show(LocalizationRecourceManager.GetString(strSectionName, "msgFilePath")); return; } String strInPut = ""; StreamReader sr = new StreamReader(strImprotFile); String strLine; while ((strLine = sr.ReadLine()) != null) { strInPut = strInPut + strLine; } sr.Close(); Int32 nMatchID; Int32 nStatusID; // Output Prompt if (SQCommon.g_ManageDB.ImportMatchInfoXml(strInPut, out nMatchID, out nStatusID)) { String strMsg = LocalizationRecourceManager.GetString(strSectionName, "msgImportMatchInfoSuc") + nMatchID.ToString() + "\r\n"; SetTextBoxText(strMsg); } else { String strMsg = LocalizationRecourceManager.GetString(strSectionName, "msgImportMatchInfo") + "\r\n"; SetTextBoxText(strMsg); } if (nMatchID > 0) { if (nStatusID == SQCommon.STATUS_UNOFFICIAL || nStatusID == SQCommon.STATUS_FINISHED) { SQCommon.g_ManageDB.UpdateMatchRankSets(nMatchID); SQCommon.g_ManageDB.CreateGroupResult(nMatchID); Int32 iPhaseID = SQCommon.g_ManageDB.GetPhaseID(nMatchID); SQCommon.g_SQPlugin.DataChangedNotify(OVRDataChangedType.emPhaseResult, -1, -1, iPhaseID, -1, iPhaseID, null); } SqlConnection sqlConnection = new SqlConnection(SQCommon.g_adoDataBase.m_strConnection); if (sqlConnection.State == System.Data.ConnectionState.Closed) { sqlConnection.Open(); } OVRDataBaseUtils.ChangeMatchStatus(nMatchID, nStatusID, sqlConnection, SQCommon.g_SQPlugin); OVRDataBaseUtils.AutoProgressMatch(nMatchID, sqlConnection, SQCommon.g_SQPlugin); if (sqlConnection != null) { sqlConnection.Close(); } SQCommon.g_SQPlugin.DataChangedNotify(OVRDataChangedType.emMatchResult, -1, -1, -1, nMatchID, nMatchID, null); SQCommon.g_SQPlugin.DataChangedNotify(OVRDataChangedType.emSplitInfo, -1, -1, -1, nMatchID, nMatchID, null); } }
private void BtnStatus_Click(object sender, RoutedEventArgs e) { System.Windows.Controls.Button btn = sender as System.Windows.Controls.Button; int newStatus = Convert.ToInt32(btn.Tag); if (newStatus == m_curMatchStatus) { return; } if (m_curMatchStatus != (int)MatchStatus.Scheduled && newStatus == (int)MatchStatus.StartList) { if (System.Windows.Forms.DialogResult.Cancel == GVAR.MsgBox("Are you confirm to change status to \"STARTLIST\"? To do this,all the match data will be cleared!", "Warning", System.Windows.Forms.MessageBoxButtons.OKCancel, System.Windows.Forms.MessageBoxIcon.Warning)) { return; } } if (newStatus == (int)MatchStatus.Unofficial || newStatus == (int)MatchStatus.Official) { if (m_homeTeamScore.ScoreTotal > m_awayTeamScore.ScoreTotal) { m_homeTeamScore.ResultID = GVAR.RESULT_TYPE_WIN; m_homeTeamScore.RankID = GVAR.RANK_TYPE_1ST; m_awayTeamScore.ResultID = GVAR.RESULT_TYPE_LOSE; m_awayTeamScore.RankID = GVAR.RANK_TYPE_2ND; } else if (m_homeTeamScore.ScoreTotal == m_awayTeamScore.ScoreTotal) { m_homeTeamScore.ResultID = GVAR.RESULT_TYPE_TIE; m_homeTeamScore.RankID = GVAR.RANK_TYPE_TIE; m_awayTeamScore.ResultID = GVAR.RESULT_TYPE_TIE; m_awayTeamScore.RankID = GVAR.RANK_TYPE_TIE; } else if (m_homeTeamScore.ScoreTotal < m_awayTeamScore.ScoreTotal) { m_homeTeamScore.ResultID = GVAR.RESULT_TYPE_LOSE; m_homeTeamScore.RankID = GVAR.RANK_TYPE_2ND; m_awayTeamScore.ResultID = GVAR.RESULT_TYPE_WIN; m_awayTeamScore.RankID = GVAR.RANK_TYPE_1ST; } GVAR.g_ManageDB.UpdateMatchRank(m_curMatchID, m_homeTeamScore.RankID, m_homeTeamScore.ResultID, 1); GVAR.g_ManageDB.UpdateMatchRank(m_curMatchID, m_awayTeamScore.RankID, m_awayTeamScore.ResultID, 2); } if (OVRDataBaseUtils.ChangeMatchStatus(m_curMatchID, newStatus, GVAR.g_adoDataBase.DBConnect, GVAR.g_RUPlugin) != 1) { Log.WriteLog("RU_Error", "调用OVRDataBaseUtils.ChangeMatchStatus改变状态失败!"); GVAR.MsgBox("Change match status failed!"); return; } else { if (newStatus == (int)MatchStatus.Unofficial || newStatus == (int)MatchStatus.Official) { GVAR.g_ManageDB.AutoProgressMatch(m_curMatchID); } GVAR.g_RUPlugin.DataChangedNotify(AutoSports.OVRCommon.OVRDataChangedType.emMatchStatus, -1, -1, -1, GVAR.g_matchID, GVAR.g_matchID, null); } CurMatchStatus = newStatus; GVAR.g_RUPlugin.UpdateMatchList(); CloseStatusWindow(); }