private void UpdateMemberPosition(int iTeamPos, ref DataGridView dgv, DataGridViewCellEventArgs e) { if (e.ColumnIndex < 0 || e.RowIndex < 0) { return; } int iColumnIndex = e.ColumnIndex; int iRowIndex = e.RowIndex; String strColumnName = dgv.Columns[iColumnIndex].Name; DataGridViewCell CurCell = dgv.Rows[iRowIndex].Cells[iColumnIndex]; if (CurCell != null) { int iPositionID = 0; if (CurCell is DGVCustomComboBoxCell) { DGVCustomComboBoxCell CurCell1 = CurCell as DGVCustomComboBoxCell; iPositionID = GVAR.Str2Int(CurCell1.Tag); } else { return; } int iMemberID = GVAR.Str2Int(dgv.Rows[iRowIndex].Cells["F_MemberID"].Value); GVAR.g_ManageDB.UpdateMatchMembePosition(m_iMatchID, iMemberID, iTeamPos, iPositionID); } }
private void dgvMatchOfficial_CellValueChanged(object sender, DataGridViewCellEventArgs e) { if (e.ColumnIndex < 0 || e.RowIndex < 0) { return; } int iColumnIndex = e.ColumnIndex; int iRowIndex = e.RowIndex; String strColumnName = dgvMatchOfficial.Columns[iColumnIndex].Name; DataGridViewCell CurCell = dgvMatchOfficial.Rows[iRowIndex].Cells[iColumnIndex]; if (CurCell != null) { int iFunctionID = 0; if (CurCell is DGVCustomComboBoxCell) { DGVCustomComboBoxCell CurCell1 = CurCell as DGVCustomComboBoxCell; iFunctionID = GVAR.Str2Int(CurCell1.Tag); } else { return; } int iRegisterID = GVAR.Str2Int(dgvMatchOfficial.Rows[iRowIndex].Cells["F_RegisterID"].Value); GVAR.g_ManageDB.UpdateOfficialFunction(m_iMatchID, iRegisterID, iFunctionID); } ResetMatchOfficial(); }
private void UpdateMemberStartup(int iTeampos, ref DataGridView dgv, DataGridViewCellEventArgs e) { if (e.RowIndex >= dgv.RowCount || e.RowIndex < 0) { return; } if (e.ColumnIndex != dgv.Columns["Startup"].Index) { return; } string strRegisterID = dgv.Rows[e.RowIndex].Cells["F_MemberID"].Value.ToString(); if (GVAR.Str2Int(dgv.Rows[e.RowIndex].Cells[e.ColumnIndex].Value) == 1) { GVAR.g_ManageDB.UpdateMemberStartup(m_iMatchID, iTeampos, strRegisterID, false); } else { if ((iTeampos == 1 && m_iHomeStartup < 7) || (iTeampos == 2 && m_iVisitStartup < 7)) { GVAR.g_ManageDB.UpdateMemberStartup(m_iMatchID, iTeampos, strRegisterID, true); } } if (iTeampos == 1) { GVAR.g_ManageDB.ResetMemberGrid(m_iMatchID, m_iHomeRegisterID, 1, ref dgvMember_Home, ref m_iHomeStartup); } else if (iTeampos == 2) { GVAR.g_ManageDB.ResetMemberGrid(m_iMatchID, m_iVisitRegisterID, 2, ref dgvMember_Visit, ref m_iVisitStartup); } }
private void InitMatchInfo() { lb_EventDes.Text = m_CCurMatch.SportDes; lb_MatchDes.Text = m_CCurMatch.PhaseDes; lb_VenueDes.Text = m_CCurMatch.VenueDes; lb_DateDes.Text = m_CCurMatch.DateDes; lbHomeDes.Text = m_CCurMatch.m_CHomeTeam.TeamName; btnX_HomeTeam.Text = m_CCurMatch.m_CHomeTeam.TeamName; lbVisitDes.Text = m_CCurMatch.m_CVisitTeam.TeamName; btnX_VisitTeam.Text = m_CCurMatch.m_CVisitTeam.TeamName; int imatchTime = m_CCurMatch.MatchTime.Trim().Length == 0 ? 0 : int.Parse(m_CCurMatch.MatchTime.Trim()); MatchTime.Text = GVAR.TranslateINT32toTime(imatchTime); lbPeriod.Text = GVAR.g_ManageDB.GetPeriodName(GVAR.Str2Int(m_CCurMatch.MatchID), m_CCurMatch.Period.ToString()); BtnExtraVisible(); lbHomeDes.Text = m_CCurMatch.m_CHomeTeam.TeamName; btnX_HomeTeam.Text = m_CCurMatch.m_CHomeTeam.TeamName; lbVisitDes.Text = m_CCurMatch.m_CVisitTeam.TeamName; btnX_VisitTeam.Text = m_CCurMatch.m_CVisitTeam.TeamName; InitTeamInfo(); }
private void btnAdd_Click(object sender, EventArgs e) { int iColIdx = dgvAvailOfficial.Columns["F_RegisterID"].Index; int iFuncColIdx = dgvAvailOfficial.Columns["F_FunctionID"].Index; for (int i = 0; i < dgvAvailOfficial.SelectedRows.Count; i++) { int iRowIdx = dgvAvailOfficial.SelectedRows[i].Index; string strRegisterID = dgvAvailOfficial.Rows[iRowIdx].Cells[iColIdx].Value.ToString(); string strFunctionID = dgvAvailOfficial.Rows[iRowIdx].Cells[iFuncColIdx].Value.ToString(); int iRegisterID = GVAR.Str2Int(strRegisterID); int iFunctionID = 0; if (strFunctionID.Length == 0) { iFunctionID = -1; } else { iFunctionID = GVAR.Str2Int(strFunctionID); } GVAR.g_ManageDB.AddMatchOfficial(m_iMatchID, iRegisterID, iFunctionID); } ResetAvailableOfficial(); ResetMatchOfficial(); }
private void AddMember(int iTeamPos, ref DataGridView dgv) { int iColIdx = dgv.Columns["F_MemberID"].Index; int iFuncColIdx = dgv.Columns["F_FunctionID"].Index; int iShirtNumberIdex = dgv.Columns["ShirtNumber"].Index; int iPosColIdx = dgv.Columns["F_PositionID"].Index; for (int i = 0; i < dgv.SelectedRows.Count; i++) { int iRowIdx = dgv.SelectedRows[i].Index; if (dgv.Rows[iRowIdx].ReadOnly == true) { continue; } string strMemberID = dgv.Rows[iRowIdx].Cells[iColIdx].Value.ToString(); string strFunctionID = dgv.Rows[iRowIdx].Cells[iFuncColIdx].Value.ToString(); string strPositionID = dgv.Rows[iRowIdx].Cells[iPosColIdx].Value.ToString(); string strShirtNumber = dgv.Rows[iRowIdx].Cells[iShirtNumberIdex].Value.ToString(); int iMemberID = GVAR.Str2Int(strMemberID); int iFunctionID = 0; int iPostionID = 0; int iShirtNumber = 0; if (strFunctionID.Length == 0) { iFunctionID = -1; } else { iFunctionID = GVAR.Str2Int(strFunctionID); } if (strPositionID.Length == 0) { iPostionID = -1; } else { iPostionID = GVAR.Str2Int(strPositionID); } if (strShirtNumber.Length == 0) { iShirtNumber = -1; } else { iShirtNumber = GVAR.Str2Int(strShirtNumber); } GVAR.g_ManageDB.AddMatchMember(m_iMatchID, iMemberID, iTeamPos, iFunctionID, iPostionID, iShirtNumber); } }
private void RemoveMember(int iTeamPos, ref DataGridView dgv) { int iColIdx = dgv.Columns["F_MemberID"].Index; for (int i = 0; i < dgv.SelectedRows.Count; i++) { int iRowIdx = dgv.SelectedRows[i].Index; string strMemberID = dgv.Rows[iRowIdx].Cells[iColIdx].Value.ToString(); int iMemberID = GVAR.Str2Int(strMemberID); GVAR.g_ManageDB.RemoveMatchMember(m_iMatchID, iMemberID, iTeamPos); } }
private void btnRemove_Click(object sender, EventArgs e) { int iColIdx = dgvMatchOfficial.Columns["F_RegisterID"].Index; for (int i = 0; i < dgvMatchOfficial.SelectedRows.Count; i++) { int iRowIdx = dgvMatchOfficial.SelectedRows[i].Index; string strRegisterID = dgvMatchOfficial.Rows[iRowIdx].Cells[iColIdx].Value.ToString(); int iRegisterID = GVAR.Str2Int(strRegisterID); GVAR.g_ManageDB.RemoveMatchOfficial(m_iMatchID, iRegisterID); } ResetAvailableOfficial(); ResetMatchOfficial(); }
private void UpdateMemberOrder(int iTeamPos, ref DataGridView dgv, DataGridViewCellEventArgs e) { int iColumnIndex = e.ColumnIndex; int iRowIndex = e.RowIndex; DataGridViewCell CurCell = dgv.Rows[iRowIndex].Cells[iColumnIndex]; int iBatOrder = 0; if (CurCell.Value != null) { iBatOrder = GVAR.Str2Int(CurCell.Value); } int iMemberID = GVAR.Str2Int(dgv.Rows[iRowIndex].Cells["F_MemberID"].Value); GVAR.g_ManageDB.UpdatePlayerOrder(m_iMatchID.ToString(), iMemberID, iBatOrder); }
private void UpdateMemberShirtNumber(int iTeamPos, ref DataGridView dgv, DataGridViewCellEventArgs e) { int iColumnIndex = e.ColumnIndex; int iRowIndex = e.RowIndex; DataGridViewCell CurCell = dgv.Rows[iRowIndex].Cells[iColumnIndex]; string strShirtNumber = ""; if (CurCell.Value != null) { strShirtNumber = CurCell.Value.ToString(); } int iMemberID = GVAR.Str2Int(dgv.Rows[iRowIndex].Cells["F_MemberID"].Value); GVAR.g_ManageDB.UpdateMatchMemberShirtNumber(m_iMatchID, iMemberID, iTeamPos, strShirtNumber); }
public static string FormatTime(string strTime) { string strFmtTime = ""; if (strTime.Length == 0) { return(strFmtTime); } int iMatchTime = GVAR.Str2Int(strTime); int iMin = iMatchTime / 60; int iSec = iMatchTime % 60; strFmtTime = iMin.ToString() + ":" + iSec.ToString(); strFmtTime = "00:" + strFmtTime; //格式为00:00:00 return(strFmtTime); }
private void MatchPointsXmlDoc(XmlDocument xmlDoc) { XmlNodeList xmlNodeLst; XmlElement xmlElement; string strSel = "/MatchPoints/Match"; xmlNodeLst = xmlDoc.SelectNodes(strSel); XmlNodeList xmlPeroidList = null; foreach (XmlNode oneMatchNode in xmlNodeLst) { xmlElement = (XmlElement)oneMatchNode; string strHomePoints = GetAttributeValue(xmlElement, "HomePoints"); string strAwayPoints = GetAttributeValue(xmlElement, "AwayPoints"); UpdateMatchPoints(strHomePoints, strAwayPoints); xmlPeroidList = oneMatchNode.SelectNodes("Period"); foreach (XmlNode onePeroidNode in xmlPeroidList) { xmlElement = (XmlElement)onePeroidNode; string strPeriodType = GetAttributeValue(xmlElement, "Type"); string strIsCurPeriod = GetAttributeValue(xmlElement, "IsCurPeriod"); UpdateCurPeriod(strPeriodType, strIsCurPeriod); strHomePoints = GetAttributeValue(xmlElement, "HomePoints"); strAwayPoints = GetAttributeValue(xmlElement, "AwayPoints"); UpdatePeriodPoints(strPeriodType, strHomePoints, strAwayPoints); } Func_UpdateUI_ForTcp_CurPeroid(); Func_UpdateUI_ForTcp_MatchPoints(); int iMatchID = GVAR.Str2Int(m_CCurMatch.MatchID); int iEventID = GVAR.g_ManageDB.GetEventID(m_CCurMatch.MatchID); GVAR.g_BKPlugin.DataChangedNotify(OVRDataChangedType.emMatchResult, -1, iEventID, -1, iMatchID, iMatchID, null); } }
private void BtnExtraVisible() { int iCurValidSplit = GVAR.g_ManageDB.GetMaxValidSplitCode(GVAR.Str2Int(m_CCurMatch.MatchID)); lbExa1.Visible = false; txtBox_HPt_Exa1.Visible = false; txtBox_VPt_Exa1.Visible = false; lbExa2.Visible = false; txtBox_HPt_Exa2.Visible = false; txtBox_VPt_Exa2.Visible = false; lbExa3.Visible = false; txtBox_HPt_Exa3.Visible = false; txtBox_VPt_Exa3.Visible = false; lbExa4.Visible = false; txtBox_HPt_Exa4.Visible = false; txtBox_VPt_Exa4.Visible = false; if (m_CCurMatch.Period >= GVAR.PERIOD_EXTRA1 || iCurValidSplit >= GVAR.PERIOD_EXTRA1) { lbExa1.Visible = true; txtBox_HPt_Exa1.Visible = true; txtBox_VPt_Exa1.Visible = true; } if (m_CCurMatch.Period >= GVAR.PERIOD_EXTRA2 || iCurValidSplit >= GVAR.PERIOD_EXTRA2) { lbExa2.Visible = true; txtBox_HPt_Exa2.Visible = true; txtBox_VPt_Exa2.Visible = true; } if (m_CCurMatch.Period >= GVAR.PERIOD_EXTRA3 || iCurValidSplit >= GVAR.PERIOD_EXTRA3) { lbExa3.Visible = true; txtBox_HPt_Exa3.Visible = true; txtBox_VPt_Exa3.Visible = true; } if (m_CCurMatch.Period >= GVAR.PERIOD_EXTRA4 || iCurValidSplit >= GVAR.PERIOD_EXTRA4) { lbExa4.Visible = true; txtBox_HPt_Exa4.Visible = true; txtBox_VPt_Exa4.Visible = true; } }
public static void ConvetTime2String(string strFormatTime, ref string strTime) { int iIndex = strFormatTime.IndexOf(':'); if (iIndex < 0) { return; } string strMin = strFormatTime.Substring(0, iIndex); string strSec = strFormatTime.Substring(iIndex + 1); int iMin = 0; int iSec = 0; if (strMin.Length == 0) { iMin = 0; } else { try { iMin = GVAR.Str2Int(strMin) * 60; } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } } try { iSec = GVAR.Str2Int(strSec); } catch (System.Exception e) { DevComponents.DotNetBar.MessageBoxEx.Show(e.Message); } strTime = (iSec + iMin).ToString(); }
public bool CheckMatchStated() { if (GVAR.g_sqlConn.State == System.Data.ConnectionState.Closed) { GVAR.g_sqlConn.Open(); } if (m_bIsCheckMatchStated) { return(true); } SqlCommand cmd = null; cmd = new SqlCommand("Proc_BK_CheckMatchStat", GVAR.g_sqlConn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter = null; cmdParameter = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@MatchID", DataRowVersion.Current, GVAR.Str2Int(MatchID)); cmd.Parameters.Add(cmdParameter); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } m_bIsCheckMatchStated = true; return(true); }
private void UpdateMemberDSQ(int iTeamPos, ref DataGridView dgv, DataGridViewCellEventArgs e) { if (e.ColumnIndex < 0 || e.RowIndex < 0) { return; } int iColumnIndex = e.ColumnIndex; int iRowIndex = e.RowIndex; DataGridViewCell CurCell = dgv.Rows[iRowIndex].Cells[iColumnIndex]; if (CurCell != null) { int iIRMID = 0; if (CurCell is DGVCustomComboBoxCell) { DGVCustomComboBoxCell CurCell1 = CurCell as DGVCustomComboBoxCell; iIRMID = GVAR.Str2Int(CurCell1.Tag); } else { return; } int iMemberID = GVAR.Str2Int(dgv.Rows[iRowIndex].Cells["F_MemberID"].Value); int iRegisterID = 0; if (iTeamPos == 1) { iRegisterID = m_iHomeRegisterID; } else if (iTeamPos == 2) { iRegisterID = m_iVisitRegisterID; } GVAR.g_ManageDB.UpdateMemberDSQ(iRegisterID, iMemberID, iIRMID); } }
public void SetPlayerActive(DataGridViewCellMouseEventArgs e, ref DataGridView dgv, ref List <SPlayerInfo> lstActive, int iTeamPos) { int iSelRowIndex = e.RowIndex; if (iSelRowIndex < 0 || iSelRowIndex > dgv.RowCount) { return; } int iMatchID = int.Parse(m_CCurMatch.MatchID); int iPlayerID = GVAR.Str2Int(dgv.Rows[iSelRowIndex].Cells["F_RegisterID"].Value); if (dgv.Rows[iSelRowIndex].Cells["F_Active"].Value.ToString() == "1") { GVAR.g_ManageDB.UpdatePlayerActive(iMatchID, iPlayerID, 0, ""); } else { if (lstActive.Count >= 5) { return; } GVAR.g_ManageDB.UpdatePlayerActive(iMatchID, iPlayerID, 1, ""); } if (iTeamPos == 1) { ResetPlayerList(iTeamPos, ref dgvHomeList); InitPlayerAcitve(iTeamPos, ref lstActive); } else { ResetPlayerList(iTeamPos, ref dgvVisitList); InitPlayerAcitve(iTeamPos, ref lstActive); } }
public void ChangePeriod() { if (m_CCurMatch.Period == GVAR.PERIOD_EXTRA1) { if (lbExa1.Visible == false) { lbExa1.Visible = true; txtBox_HPt_Exa1.Visible = true; txtBox_VPt_Exa1.Visible = true; } if (!GVAR.g_ManageDB.IsExistMatchSplit(ref m_CCurMatch, GVAR.PERIOD_EXTRA1)) { GVAR.g_ManageDB.AddSplitMatch(ref m_CCurMatch, GVAR.PERIOD_EXTRA1.ToString()); } } if (m_CCurMatch.Period == GVAR.PERIOD_EXTRA2) { if (lbExa2.Visible == false) { lbExa2.Visible = true; txtBox_HPt_Exa2.Visible = true; txtBox_VPt_Exa2.Visible = true; } if (!GVAR.g_ManageDB.IsExistMatchSplit(ref m_CCurMatch, GVAR.PERIOD_EXTRA2)) { GVAR.g_ManageDB.AddSplitMatch(ref m_CCurMatch, GVAR.PERIOD_EXTRA2.ToString()); } } if (m_CCurMatch.Period == GVAR.PERIOD_EXTRA3) { if (lbExa3.Visible == false) { lbExa3.Visible = true; txtBox_HPt_Exa3.Visible = true; txtBox_VPt_Exa3.Visible = true; } if (!GVAR.g_ManageDB.IsExistMatchSplit(ref m_CCurMatch, GVAR.PERIOD_EXTRA3)) { GVAR.g_ManageDB.AddSplitMatch(ref m_CCurMatch, GVAR.PERIOD_EXTRA3.ToString()); } } if (m_CCurMatch.Period == GVAR.PERIOD_EXTRA4) { if (lbExa4.Visible == false) { lbExa4.Visible = true; txtBox_HPt_Exa4.Visible = true; txtBox_VPt_Exa4.Visible = true; } if (!GVAR.g_ManageDB.IsExistMatchSplit(ref m_CCurMatch, GVAR.PERIOD_EXTRA4)) { GVAR.g_ManageDB.AddSplitMatch(ref m_CCurMatch, GVAR.PERIOD_EXTRA4.ToString()); } } GVAR.g_ManageDB.UpdateMatchPeriod(ref m_CCurMatch); GVAR.g_ManageDB.UpdateTeamSetPt(m_CCurMatch.Period, ref m_CCurMatch); lbPeriod.Text = GVAR.g_ManageDB.GetPeriodName(GVAR.Str2Int(m_CCurMatch.MatchID), m_CCurMatch.Period.ToString()); }
private void UpdateMatchStatus() { InitStatusBtn(); int iMatchID = GVAR.Str2Int(m_CCurMatch.MatchID); switch (m_CCurMatch.MatchStatus) { case GVAR.STATUS_SCHEDULE: { EnalbeMatchCtrl(true); EnableScoreBtn(false); btnx_StartList.Enabled = true; btnx_Schedule.Checked = true; btnStatus.Text = btnx_Schedule.Text; btnStatus.ForeColor = System.Drawing.SystemColors.ControlText; break; } case GVAR.STATUS_ON_COURT: { EnalbeMatchCtrl(true); EnableScoreBtn(false); btnx_Running.Enabled = true; btnx_StartList.Checked = true; btnStatus.Text = btnx_StartList.Text; btnStatus.ForeColor = System.Drawing.SystemColors.ControlText; break; } case GVAR.STATUS_RUNNING: { EnalbeMatchCtrl(true); EnableScoreBtn(true); btnx_Suspend.Enabled = true; btnx_Unofficial.Enabled = true; btnx_Running.Checked = true; btnStatus.Text = btnx_Running.Text; btnStatus.ForeColor = System.Drawing.Color.Red; GVAR.g_ManageDB.CheckMatchStat(int.Parse(m_CCurMatch.MatchID)); break; } case GVAR.STATUS_SUSPEND: { EnalbeMatchCtrl(true); EnableScoreBtn(false); btnx_Running.Enabled = true; btnx_Suspend.Checked = true; btnStatus.Text = btnx_Suspend.Text; btnStatus.ForeColor = System.Drawing.Color.Red; break; } case GVAR.STATUS_UNOFFICIAL: { EnalbeMatchCtrl(true); EnableScoreBtn(true); btnx_Finished.Enabled = true; btnx_Unofficial.Checked = true; btnStatus.Text = btnx_Unofficial.Text; btnStatus.ForeColor = System.Drawing.Color.LimeGreen; UpdateMatchResult(); int iEventID = GVAR.g_ManageDB.GetEventID(m_CCurMatch.MatchID); GVAR.g_BKPlugin.DataChangedNotify(OVRDataChangedType.emMatchResult, -1, iEventID, -1, iMatchID, iMatchID, null); OVRDataBaseUtils.AutoProgressMatch(iMatchID, GVAR.g_sqlConn, GVAR.g_BKPlugin); //自动晋级 //GVAR.g_ManageDB.AutoGroupRank(iMatchID); // 自动小组排名 int iPhaseID = GVAR.g_ManageDB.GetPhaseID(iMatchID); GVAR.g_BKPlugin.DataChangedNotify(OVRDataChangedType.emPhaseResult, -1, -1, iPhaseID, -1, iPhaseID, null); break; } case GVAR.STATUS_FINISHED: { EnalbeMatchCtrl(false); EnableScoreBtn(false); btnx_Revision.Enabled = true; btnx_Finished.Checked = true; btnStatus.Text = btnx_Finished.Text; btnStatus.ForeColor = System.Drawing.Color.LimeGreen; int iEventID = GVAR.g_ManageDB.GetEventID(m_CCurMatch.MatchID); GVAR.g_BKPlugin.DataChangedNotify(OVRDataChangedType.emMatchResult, -1, iEventID, -1, iMatchID, iMatchID, null); OVRDataBaseUtils.AutoProgressMatch(iMatchID, GVAR.g_sqlConn, GVAR.g_BKPlugin); //自动晋级 GVAR.g_ManageDB.AutoGroupRank(iMatchID); // 自动小组排名 int iPhaseID = GVAR.g_ManageDB.GetPhaseID(iMatchID); GVAR.g_BKPlugin.DataChangedNotify(OVRDataChangedType.emPhaseResult, -1, -1, iPhaseID, -1, iPhaseID, null); break; } case GVAR.STATUS_REVISION: { EnalbeMatchCtrl(true); EnableScoreBtn(true); btnx_Finished.Enabled = true; btnx_Revision.Checked = true; btnStatus.Text = btnx_Revision.Text; btnStatus.ForeColor = System.Drawing.Color.LimeGreen; break; } case GVAR.STATUS_CANCELED: { EnalbeMatchCtrl(false); EnableScoreBtn(false); btnx_Canceled.Checked = true; btnStatus.Text = btnx_Canceled.Text; btnStatus.ForeColor = System.Drawing.SystemColors.ControlText; break; } default: return; } }
public int ChangePoint(int iTeamPos, bool bAdd, int iPoint) { int iResult = 0; if (m_iPeriod <= 0) { return(iResult); } if (m_CHomeTeam.GetScore(Period).Length == 0) { m_CHomeTeam.SetScore("0", Period); } if (m_CVisitTeam.GetScore(Period).Length == 0) { m_CVisitTeam.SetScore("0", Period); } OVRBKTeamInfo tmpTeam = new OVRBKTeamInfo(); int iSetPt; if (iTeamPos == 1) { tmpTeam = m_CHomeTeam; } else if (iTeamPos == 2) { tmpTeam = m_CVisitTeam; } if (bAdd) { iSetPt = GVAR.Str2Int(tmpTeam.GetScore(m_iPeriod)) + iPoint; } else { iSetPt = Math.Max(GVAR.Str2Int(tmpTeam.GetScore(m_iPeriod)) - iPoint, 0); } tmpTeam.SetScore(iSetPt.ToString(), m_iPeriod); //判断当前小节的胜负关系 if (GVAR.Str2Int(m_CHomeTeam.GetScore(m_iPeriod)) > GVAR.Str2Int(m_CVisitTeam.GetScore(m_iPeriod))) { m_CHomeTeam.SetRank(m_iPeriod, GVAR.RANK_TYPE_1ST); m_CVisitTeam.SetRank(m_iPeriod, GVAR.RANK_TYPE_2ND); m_CHomeTeam.SetResult(m_iPeriod, GVAR.RESULT_TYPE_WIN); m_CVisitTeam.SetResult(m_iPeriod, GVAR.RESULT_TYPE_LOSE); } else if (GVAR.Str2Int(m_CHomeTeam.GetScore(m_iPeriod)) < GVAR.Str2Int(m_CVisitTeam.GetScore(m_iPeriod))) { m_CVisitTeam.SetRank(m_iPeriod, GVAR.RANK_TYPE_1ST); m_CHomeTeam.SetRank(m_iPeriod, GVAR.RANK_TYPE_2ND); m_CVisitTeam.SetResult(m_iPeriod, GVAR.RESULT_TYPE_WIN); m_CHomeTeam.SetResult(m_iPeriod, GVAR.RESULT_TYPE_LOSE); } else { m_CVisitTeam.SetRank(m_iPeriod, GVAR.RANK_TYPE_TIE); m_CHomeTeam.SetRank(m_iPeriod, GVAR.RANK_TYPE_TIE); m_CVisitTeam.SetResult(m_iPeriod, GVAR.RESULT_TYPE_TIE); m_CHomeTeam.SetResult(m_iPeriod, GVAR.RESULT_TYPE_TIE); } //计算总分 int iHomePt = 0; int iVisitPt = 0; for (int i = 1; i <= GVAR.MAXSETNUM; i++) { iHomePt += GVAR.Str2Int(m_CHomeTeam.GetScore(i)); iVisitPt += GVAR.Str2Int(m_CVisitTeam.GetScore(i)); } m_CHomeTeam.TeamPoint = iHomePt; m_CVisitTeam.TeamPoint = iVisitPt; iResult = 1; return(iResult); }
public bool PutTeamStatDataToDatabase(string strPeriodType, string strTeamID, List <Statistics> lstStat) { CheckMatchStated(); if (GVAR.g_sqlConn.State == System.Data.ConnectionState.Closed) { GVAR.g_sqlConn.Open(); } SqlCommand cmd = null; cmd = new SqlCommand("Proc_BK_ImportTeamPeriodStat", GVAR.g_sqlConn); cmd.CommandType = CommandType.StoredProcedure; SqlParameter cmdParameter = null; cmdParameter = new SqlParameter( "@MatchID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@MatchID", DataRowVersion.Current, GVAR.Str2Int(MatchID)); cmd.Parameters.Add(cmdParameter); cmdParameter = new SqlParameter( "@RoundNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@RoundNo", DataRowVersion.Current, GVAR.Str2Int(RoundNo)); cmd.Parameters.Add(cmdParameter); cmdParameter = new SqlParameter( "@MatchNo", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@MatchNo", DataRowVersion.Current, GVAR.Str2Int(MatchNo)); cmd.Parameters.Add(cmdParameter); cmdParameter = new SqlParameter( "@PeriodType", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@PeriodType", DataRowVersion.Current, GVAR.Str2Int(strPeriodType)); cmd.Parameters.Add(cmdParameter); cmdParameter = new SqlParameter( "@TeamID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@TeamID", DataRowVersion.Current, GVAR.Str2Int(strTeamID)); cmd.Parameters.Add(cmdParameter); MakeStatisticsSqlParameter(lstStat, ref cmd); cmdParameter = new SqlParameter( "@Remark", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "@Remark", DataRowVersion.Current, DBNull.Value); cmd.Parameters.Add(cmdParameter); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { throw ex; } return(true); }
private void cmbUniform_Visit_SelectionChangeCommitted(object sender, EventArgs e) { m_iVisitUniformID = GVAR.Str2Int(cmbUniform_Visit.SelectedValue); GVAR.g_ManageDB.UpdateMatchUniform(m_iMatchID, 2, m_iVisitUniformID); }
public void InitAction(OVRBKMatchInfo tmpMatch, int iMatchSplitID) { m_iMatchID = GVAR.Str2Int(tmpMatch.MatchID); m_iMatchSplitID = iMatchSplitID; }
/* * 2011 FGM Field Goals Made NULL F_TotalShoots ENG * 2012 FGA Field Goals Attempt NULL F_TotalThrows ENG * 2021 2PTSM 2 Points Made NULL F_2PointsShoots ENG * 2022 2PTSA 2 Points Attempt NULL F_2PointsThrows ENG * 2031 3PTSM 3 Points Made NULL F_3PointsShoots ENG * 2032 3PTSA 3 Points Attempt NULL F_3PointsThrows ENG * 2041 FM Free Made NULL F_FreeShoots ENG * 2042 FA Free Attempt NULL F_FreeThrows ENG * 2500 PTS Points NULL F_Points ENG * 2050 TR Rebounds NULL F_Rebounds ENG * 2051 OR Offensive Rebounds NULL F_OffensiveRebounds ENG * 2052 DR DefensiveRebounds NULL F_DefensiveRebounds ENG * 2060 AS Assists NULL F_Assists ENG * 2070 TO Turnovers NULL F_Turnovers ENG * 2080 ST Steals NULL F_Steals ENG * 2090 BS Blocked Shots NULL F_BlockedShots ENG * 2101 OF Offensive Fouls NULL F_OffensiveFouls ENG * 2102 DF Defensive Fouls NULL F_DefensiveFouls ENG * 2100 TF Fouls NULL F_Fouls ENG * 2110 MIN Minutes Played NULL F_MinutesPlayed ENG * NULL NULL NULL NULL NULL NULL */ public void MakeStatisticsSqlParameter(List <Statistics> lstStat, ref SqlCommand cmd) { SqlParameter cmdParameter = null; int nIndex = 1; foreach (Statistics oneStatistics in lstStat) { if (oneStatistics.StatValue == null || oneStatistics.StatValue == string.Empty) { oneStatistics.StatValue = "0"; } String sParameterName = ""; switch (nIndex) { case 1: sParameterName = "@FGM"; break; case 2: sParameterName = "@FGA"; break; case 3: sParameterName = "@2PTSM"; break; case 4: sParameterName = "@2PTSA"; break; case 5: sParameterName = "@3PTSM"; break; case 6: sParameterName = "@3PTSA"; break; case 7: sParameterName = "@FM"; break; case 8: sParameterName = "@FA"; break; case 9: sParameterName = "@PTS"; break; case 10: sParameterName = "@TR"; break; case 11: sParameterName = "@OR"; break; case 12: sParameterName = "@DR"; break; case 13: sParameterName = "@AS"; break; case 14: sParameterName = "@TO"; break; case 15: sParameterName = "@ST"; break; case 16: sParameterName = "@BS"; break; case 17: sParameterName = "@OF"; break; case 18: sParameterName = "@DF"; break; case 19: sParameterName = "@TF"; break; case 20: sParameterName = "@MIN"; break; default: break; } cmdParameter = new SqlParameter( sParameterName, SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, sParameterName, DataRowVersion.Current, GVAR.Str2Int(oneStatistics.StatValue)); cmd.Parameters.Add(cmdParameter); nIndex++; } return; }