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