private int GetPlayerEndScore(DataGridViewRow row) { int rowTotal = 0; rowTotal = ARFunctions.ConvertToIntFromObject(row.Cells["Total"].Value); return(rowTotal); }
private void SetPlayerEndTotal(DataGridViewRow row) { int rowTotal = 0; foreach (DataGridViewCell cell in row.Cells) { int curArrow = 0; if (cell.OwningColumn.Name.Contains("Arrow")) { if (cell.Value.ToString().ToUpper() == "X") { curArrow = 10; } else if (cell.Value.ToString().ToUpper() == "M") { curArrow = 0; } else { curArrow = ARFunctions.ConvertToIntFromObject(cell.Value); } rowTotal += curArrow; } } row.Cells["Total"].Value = rowTotal == 0 ? "" : rowTotal.ToString(); }
public static AR_End GetPlayerOneEndByDistince(int nMatchID, int nDistince, int nCompetitionPosition, string nEndIndex) { List <AR_End> myEnds = new List <AR_End>(); DataTable dt = GVAR.g_ManageDB.GetPlayerEnds(nMatchID, nDistince, nCompetitionPosition, nEndIndex); for (int nRow = 0; nRow < dt.Rows.Count; nRow++) { string strFieldName = ""; object obj = null; AR_End oneEnd = new AR_End(); strFieldName = "F_CompetitionPosition"; obj = dt.Rows[nRow][strFieldName]; oneEnd.CompetitionPosition = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_Points"; obj = dt.Rows[nRow][strFieldName]; oneEnd.Total = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "EndIndex"; obj = dt.Rows[nRow][strFieldName]; oneEnd.EndIndex = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "EndCode"; obj = dt.Rows[nRow][strFieldName]; oneEnd.EndIndex = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "F_MatchID"; obj = dt.Rows[nRow][strFieldName]; oneEnd.MatchID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_MatchSplitID"; obj = dt.Rows[nRow][strFieldName]; oneEnd.SplitID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "SetPoints"; obj = dt.Rows[nRow][strFieldName]; oneEnd.Point = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Num10s"; obj = dt.Rows[nRow][strFieldName]; oneEnd.R10Num = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "NumXs"; obj = dt.Rows[nRow][strFieldName]; oneEnd.Xnum = ARFunctions.ConvertToStringFromObject(obj); myEnds.Add(oneEnd); } AR_End ar = new AR_End(); if (myEnds.Count > 0) { ar = myEnds[0]; } return(ar); }
public string GetTatalRings() { int LA = ARFunctions.ConvertToIntFromObject(_totalLongA); int LB = ARFunctions.ConvertToIntFromObject(_totalLongB); int SA = ARFunctions.ConvertToIntFromObject(_totalShortA); int SB = ARFunctions.ConvertToIntFromObject(_totalShortB); int tempTotal = LA + LB + SA + SB; return(tempTotal == 0 ? "" : tempTotal.ToString()); }
public static List <AR_End> GetPlayerShootEnds(int nMatchID, int nCompetitionPosition) { List <AR_End> myEnds = new List <AR_End>(); DataTable dt = GVAR.g_ManageDB.GetPlayerShootEnds(nMatchID, 1, nCompetitionPosition, "-1"); for (int nRow = 0; nRow < dt.Rows.Count; nRow++) { string strFieldName = ""; object obj = null; AR_End oneEnd = new AR_End(); strFieldName = "F_CompetitionPosition"; obj = dt.Rows[nRow][strFieldName]; oneEnd.CompetitionPosition = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "Total"; obj = dt.Rows[nRow][strFieldName]; oneEnd.Total = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "EndIndex"; obj = dt.Rows[nRow][strFieldName]; oneEnd.EndIndex = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "EndCode"; obj = dt.Rows[nRow][strFieldName]; oneEnd.EndIndex = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "F_MatchID"; obj = dt.Rows[nRow][strFieldName]; oneEnd.MatchID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_MatchSplitID"; obj = dt.Rows[nRow][strFieldName]; oneEnd.SplitID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "SetPoints"; obj = dt.Rows[nRow][strFieldName]; oneEnd.Point = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Num10s"; obj = dt.Rows[nRow][strFieldName]; oneEnd.R10Num = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "NumXs"; obj = dt.Rows[nRow][strFieldName]; oneEnd.Xnum = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "EndComment"; obj = dt.Rows[nRow][strFieldName]; oneEnd.EndComment = ARFunctions.ConvertToStringFromObject(obj); myEnds.Add(oneEnd); } return(myEnds); }
public static AR_Arrow GetPlayerOneShootArrow(int nMatchID, int nSplitID, int nCompetitionPosition, string nArrowIndex) { List <AR_Arrow> Arrows = new List <AR_Arrow>(); DataTable dt = GVAR.g_ManageDB.GetPlayerShootArrows(nMatchID, nSplitID, nCompetitionPosition, nArrowIndex); for (int nRow = 0; nRow < dt.Rows.Count; nRow++) { string strFieldName = ""; object obj = null; AR_Arrow oneAR = new AR_Arrow(); strFieldName = "F_CompetitionPosition"; obj = dt.Rows[nRow][strFieldName]; oneAR.CompetitionPosition = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_Points"; obj = dt.Rows[nRow][strFieldName]; oneAR.Ring = ARFunctions.ConvertToStringFromObject(obj); //strFieldName = "F_Order"; //obj = dt.Rows[nRow][strFieldName]; //oneAR.ArrowIndex = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "F_MatchSplitCode"; obj = dt.Rows[nRow][strFieldName]; oneAR.ArrowIndex = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "F_MatchID"; obj = dt.Rows[nRow][strFieldName]; oneAR.MatchID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_MatchSplitID"; obj = dt.Rows[nRow][strFieldName]; oneAR.SplitID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_FatherMatchSplitID"; obj = dt.Rows[nRow][strFieldName]; oneAR.FatherSplitID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "FaterCode"; obj = dt.Rows[nRow][strFieldName]; oneAR.EndIndex = ARFunctions.ConvertToStringFromObject(obj); Arrows.Add(oneAR); } AR_Arrow AA = new AR_Arrow(); if (Arrows.Count > 0) { AA = Arrows[0]; } return(AA); }
private string GetPlayerTotalByColumns(DataGridViewColumn col) { string PlayerPoint = string.Empty; if (col.DataGridView.Rows.Count > 0) { int total = 0; foreach (DataGridViewRow row in col.DataGridView.Rows) { int rowTotal = ARFunctions.ConvertToIntFromObject(row.Cells[col.Name].Value); total += rowTotal; } PlayerPoint = total.ToString(); //== 0 ? "" : total.ToString(); } return(PlayerPoint); }
private string GetPlayerTotalPoint(DataGridView dgv) { string PlayerPoint = string.Empty; if (dgv.Rows.Count > 0) { int point = 0; foreach (DataGridViewRow row in dgv.Rows) { int rowPoint = ARFunctions.ConvertToIntFromObject(row.Cells["SetPoints"].Value); point += rowPoint; } PlayerPoint = point.ToString(); //== 0 ? "" : point.ToString(); } return(PlayerPoint); }
private string GetPlayerTotalScore(DataGridView dgv) { string PlayerPoint = string.Empty; if (dgv.Rows.Count > 0) { int total = 0; foreach (DataGridViewRow row in dgv.Rows) { int rowTotal = ARFunctions.ConvertToIntFromObject(row.Cells["Total"].Value); total += rowTotal; } PlayerPoint = total.ToString(); //== 0 ? "" : total.ToString(); } return(PlayerPoint); }
private void btnX_OK_Click(object sender, EventArgs e) { CurMatchInfo.EndCount = ARFunctions.ConvertToIntFromString(this.txtX_EndCount.Text); CurMatchInfo.ArrowCount = ARFunctions.ConvertToIntFromString(this.txtX_ArrowCount.Text); CurMatchInfo.IsSetPoints = cbX_IsSetPoints.Checked ? 0 : 1; CurMatchInfo.WinPoints = ARFunctions.ConvertToIntFromString(this.txtX_WinPoints.Text); CurMatchInfo.Distince = ARFunctions.ConvertToIntFromObject(((ComboBoxItem)cbX_Distince.SelectedItem).ToString()); CurMatchInfo.CurMatchRuleID = ARFunctions.ConvertToIntFromObject(cbbX_ComRule.SelectedValue); bool bReturn = GVAR.g_ManageDB.UpdateMatchSettings(CurMatchInfo.MatchID, CurMatchInfo.EndCount, CurMatchInfo.ArrowCount, CurMatchInfo.IsSetPoints, CurMatchInfo.WinPoints, CurMatchInfo.Distince, CurMatchInfo.CurMatchRuleID, -1); if (bReturn) { this.DialogResult = DialogResult.OK; } else { this.DialogResult = DialogResult.No; } this.Close(); }
public static List <AR_Archer> GetCompetitionPlayers(int nMatchID) { List <AR_Archer> Archers = new List <AR_Archer>(); DataTable dt = GVAR.g_ManageDB.GetCompetitionPlayers(nMatchID); for (int nRow = 0; nRow < dt.Rows.Count; nRow++) { string strFieldName = ""; object obj = null; AR_Archer onePlayer = new AR_Archer(); strFieldName = "F_CompetitionPosition"; obj = dt.Rows[nRow][strFieldName]; onePlayer.CompetitionPosition = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "F_RegisterID"; obj = dt.Rows[nRow][strFieldName]; onePlayer.RegisterID = ARFunctions.ConvertToIntFromObject(obj); strFieldName = "Bib"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Bib = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Name"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Name = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "NOC"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Noc = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Rank"; obj = dt.Rows[nRow][strFieldName]; onePlayer.QRank = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Total"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Total = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Point"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Result = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "IRM"; obj = dt.Rows[nRow][strFieldName]; onePlayer.IRM = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "10s"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Num10S = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Xs"; obj = dt.Rows[nRow][strFieldName]; onePlayer.NumXS = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Remark"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Remark = ARFunctions.ConvertToStringFromObject(obj); strFieldName = "Target"; obj = dt.Rows[nRow][strFieldName]; onePlayer.Target = ARFunctions.ConvertToStringFromObject(obj); Archers.Add(onePlayer); } return(Archers); }