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;
}
