private void init_combo_players(int iddivision) { CEntryPlayers clEP = new CEntryPlayers(connect); CEntryTeam clET = new CEntryTeam(connect); List <STEntryPlayers> list; List <STEntryTeam> list_team; string text = null; try { comboBoxPlayer.Items.Clear(); list_team = clET.GetTeamParticipant(idseason, iddivision); foreach (STEntryTeam it in list_team) { list = clEP.GetListEntryPlayersReal(idseason, it.idteam, DateTime.Now, null); foreach (STEntryPlayers item in list) { CPlayer clPlayer = new CPlayer(connect, item.idplayer); text = string.Format("{0} {1} ({2})", clPlayer.stPlayer.family, clPlayer.stPlayer.name, clPlayer.stPlayer.personalnum); comboBoxPlayer.Items.Add(text); } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void init_data() { try { dataGridViewAwardResult.Rows.Clear(); list = clWork.GetListData(IS.idseason, currdiv.id); if (list.Count > 0) { g_f = true; dataGridViewAwardResult.Rows.Add(list.Count); for (int i = 0; i < list.Count; i++) { STAward st = clAward.GetAward(list[i].idaward); dataGridViewAwardResult.Rows[i].Cells[0].Value = st.nameaward; clPlayer = new CPlayer(connect, list[i].idplayer); dataGridViewAwardResult.Rows[i].Cells[1].Value = string.Format("{0} {1}", clPlayer.stPlayer.name, clPlayer.stPlayer.family); clEP = new CEntryPlayers(connect); int x = clEP.IsEntryPlayer(IS.idseason, list[i].idplayer); if (x > 0) { clTeam = new CTeam(connect, x); dataGridViewAwardResult.Rows[i].Cells[2].Value = clTeam.stTeam.name; } if (list[i].result != null) { dataGridViewAwardResult.Rows[i].Cells[3].Value = string.Format("{0:f2}", list[i].result); } dataGridViewAwardResult.Rows[i].Cells[4].Value = list[i].idplayer; if (flawour.Equals(list[i])) { gpos = i; } } dataGridViewAwardResult.ClearSelection(); dataGridViewAwardResult.AllowUserToAddRows = false; } else { dataGridViewAwardResult.AllowUserToAddRows = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void comboBoxName_SelectedIndexChanged(object sender, EventArgs e) { try { if (comboBoxName.Text.Length > 0) { char[] del = { ' ', '(', ')' }; string s = comboBoxName.Text.Trim(); string[] words = s.Split(del); clPlayer = new CPlayer(connect, words[0].Trim(), words[1].Trim(), words[3].Trim()); CEntryPlayers cl = new CEntryPlayers(connect); int idt = cl.IsEntryPlayer(IS.idseason, clPlayer.stPlayer.idplayer); if (idt != 0) { CTeam tm = new CTeam(connect, idt); labelIsDemind.ForeColor = Color.Red; labelIsDemind.Text = string.Format("{0}", tm.stTeam.name); } else { labelIsDemind.ForeColor = Color.DarkGreen; labelIsDemind.Text = "свободен"; } string str1 = string.Format("{0} {1} {2}", clPlayer.stPlayer.family, clPlayer.stPlayer.name, clPlayer.stPlayer.payname); labelFIO.Text = str1; CAge age = new CAge(); if (clPlayer.stPlayer.datebirth != null) { DateTime dte = (DateTime)clPlayer.stPlayer.datebirth; string sm = age.GetFullAge(dte, datein); string str2 = string.Format("{0}, {1}", dte.ToLongDateString(), sm); labelDate.Text = str2; } CCountry clCountry = new CCountry(connect); string str3 = string.Format("{0}, {1}", clPlayer.stPlayer.personalnum, clCountry.stCountry.shortname); labelPersNum.Text = str3; } } catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); } }
/* вставка данных */ private void set_data() { CCoach clCoach; CPlayer clPlayer; string text; try { team = new CTeam(connect, stTeamPart.idteam); comboBoxNameTeam.Text = team.stTeam.name; CCity city = new CCity(connect, team.stTeam.idcity); labelDisl.Text = string.Format("{0}, {1}", city.stFullCity.name, city.stFullCity.nameregion); dateTimePickerDateIn.Value = stTeamPart.datein; div = new CDivision(connect, (int)IS.idseason, stTeamPart.iddivision); comboBoxDivision.Text = div.stDiv.name; clTeamComposition = new CEntryPlayers(connect); team_composition = clTeamComposition.GetListEntryPlayers(IS.idseason, stTeamPart.idteam, "Number"); init_data(team_composition); init_combo_captain(); if (stTeamPart.idcoach1 != null) { clCoach = new CCoach(connect, (int)stTeamPart.idcoach1); text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name); comboBoxCoach1.Text = text; } if (stTeamPart.idcoach2 != null) { clCoach = new CCoach(connect, (int)stTeamPart.idcoach2); text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name); comboBoxCoach2.Text = text; } if (stTeamPart.idcoach3 != null) { clCoach = new CCoach(connect, (int)stTeamPart.idcoach3); text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name); comboBoxCoach3.Text = text; } if (stTeamPart.idcaptain != null) { clPlayer = new CPlayer(connect, (int)stTeamPart.idcaptain); string num = get_num_captain((int)stTeamPart.idcaptain); text = string.Format("#{0} {1} {2}", num, clPlayer.stPlayer.family, clPlayer.stPlayer.name); comboBoxCaptain.Text = text; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void DlgEntryId_Load(object sender, EventArgs e) { try { clEP = new CEntryPlayers(connect); labelText.Text = string.Format("Кто играл под номером {0}?", number); init_combo(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void init_data_in() { CPlayer clP = new CPlayer(connect); CEntryPlayers clEP = new CEntryPlayers(connect); CInfoSeason clIS; CTeam clTeam; try { dataGridViewIn.Rows.Clear(); List <STEntryPlayers> list = clEP.GetListEntryPlayer(gstPlayer.idplayer); if (list.Count > 0) { dataGridViewIn.Rows.Add(list.Count); for (int i = 0; i < list.Count; i++) { dataGridViewIn.Rows[i].Cells[0].Value = list[i].idseason; clIS = new CInfoSeason(connect, list[i].idseason); STInfoSeason st = (STInfoSeason)clIS.s_IS; dataGridViewIn.Rows[i].Cells[1].Value = st.nameseason; clTeam = new CTeam(connect, list[i].idteam); dataGridViewIn.Rows[i].Cells[2].Value = clTeam.stTeam.name; int cnt = clP.GetCntGames(list[i].idseason, list[i].idteam, gstPlayer.idplayer); dataGridViewIn.Rows[i].Cells[3].Value = cnt.ToString(); dataGridViewIn.Rows[i].Cells[4].Value = list[i].datein.ToLongDateString(); if (list[i].dateout != null) { DateTime dt = (DateTime)list[i].dateout; dataGridViewIn.Rows[i].Cells[5].Value = dt.ToLongDateString(); } } dataGridViewIn.ClearSelection(); dataGridViewIn.AllowUserToAddRows = false; } else { dataGridViewIn.AllowUserToAddRows = false; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void DlgTeamsPlayer_Load(object sender, EventArgs e) { string text = null; try { clWork = new CEntryPlayers(connect); clTeam = new CTeam(connect); init_combo_players(); init_combo_team(); if (oldData != null) { mode = 1; } else { mode = 0; } if (mode == 0) { text = "Добавить заявку игрока"; dateTimePickerDate.Value = IS.datebegin; DateTime dttt = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day, 0, 0, 0, 0); dateTimePickerTimeIn.Value = dttt; if (recomendedteam != null) { clTeam = new CTeam(connect, recomendedteam); comboBoxTeam.Text = clTeam.stTeam.name; } checkBoxOut.CheckState = CheckState.Unchecked; dateTimePickerDateOut.Enabled = false; dateTimePickerTimeOut.Enabled = false; } if (mode == 1) { text = "Редактировать заявку игрока"; set_data((STEntryPlayers)oldData); } view_param.idseason = null; this.Text = text; } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void create() { try { FileInfo fi1 = new FileInfo(fullpath); StreamWriter sw = fi1.CreateText(); CEntryTeam clET = new CEntryTeam(connect); CEntryPlayers clEP = new CEntryPlayers(connect); List <STEntryPlayers> list_p; CPlayer clPlayer; string text; string number; List <STEntryTeamWithName> lst = clET.GetTeamParticipantWithName(IS.idseason, "EntryTeam.IdDivision, Team.NameTeam"); foreach (STEntryTeamWithName team in lst) { sw.WriteLine("-"); sw.WriteLine(team.name.ToString().ToUpper()); list_p = clEP.GetListEntryPlayersReal(IS.idseason, team.idteam, param, null); foreach (STEntryPlayers ep in list_p) { if (ep.priority == 0) { clPlayer = new CPlayer(connect, ep.idplayer); number = "0"; if (ep.number.Length > 0 && ep.number.Length <= 2) { number = ep.number; } text = string.Format("{0} {1}", number, clPlayer.stPlayer.family); sw.WriteLine(text); } } } sw.WriteLine("-"); sw.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
/* запуск формы */ private void DlgTeamParticipant_Load(object sender, EventArgs e) { try { this.Text = caption; init_combo_team(); init_combo_coach(); init_combo_division(); clTeamComposition = new CEntryPlayers(connect); if (stTeamPart.idteam != 0) { set_data(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void EntryPlayer_Load(object sender, EventArgs e) { try { clWork = new CEntryPlayers(connect); this.WindowState = FormWindowState.Maximized; recom = 0; param_iddiv = 0; param_idteam = 0; init_combo_div(); radioButtonAll.Checked = true; comboBoxDivision.Enabled = false; comboBoxTeam.Enabled = false; init_data(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void comboBoxName_SelectedIndexChanged(object sender, EventArgs e) { try { if (comboBoxName.Text.Length > 0) { char[] del = { ' ', '(', ')' }; string s = comboBoxName.Text.Trim(); string[] words = s.Split(del); clPlayer = new CPlayer(connect, words[0].Trim(), words[1].Trim(), words[3].Trim()); CEntryPlayers cl = new CEntryPlayers(connect); int idt = cl.IsEntryPlayer(IS.idseason, clPlayer.stPlayer.idplayer); if (idt != 0) { CTeam tm = new CTeam(connect, idt); labelIsDemind.ForeColor = Color.Red; labelIsDemind.Text = string.Format("{0}", tm.stTeam.name); } else { labelIsDemind.ForeColor = Color.DarkGreen; labelIsDemind.Text = "свободен"; } string str1 = string.Format("{0} {1} {2}", clPlayer.stPlayer.family, clPlayer.stPlayer.name, clPlayer.stPlayer.payname); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void out_player() { CEntryPlayers clEP; List <STEntryPlayers> list; CPlayer clPlayer; try { clEP = new CEntryPlayers(connect); list = clEP.GetListEntryPlayers(IS.idseason, 0, "IdTeam,Number"); List <STSmartBookPlayer> lst_smart = new List <STSmartBookPlayer>(); STSmartBookPlayer item; foreach (STEntryPlayers row in list) { if (row.dateout == null) { item = new STSmartBookPlayer(); clPlayer = new CPlayer(connect, row.idplayer); item.family = clPlayer.stPlayer.family; item.idplayer = row.idplayer; item.idteam = row.idteam; item.name = clPlayer.stPlayer.name; item.number = int.Parse(row.number); lst_smart.Add(item); } } CSmartBookPlayer clSmart = new CSmartBookPlayer(pathbook); clSmart.Write(lst_smart); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void comboBoxPlayer_SelectedIndexChanged(object sender, EventArgs e) { try { char[] del = { ' ', '(', ')' }; string s = comboBoxPlayer.Text.Trim(); string[] words = s.Split(del); clPlayer = new CPlayer(connect, words[0].Trim(), words[1].Trim(), words[3].Trim()); CEntryPlayers cl = new CEntryPlayers(connect); int idt = cl.IsEntryPlayer(IS.idseason, clPlayer.stPlayer.idplayer); if (idt != 0) { CTeam tm = new CTeam(connect, idt); textBoxTeam.Text = tm.stTeam.name; } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void insert_report(List <STGame> lst_game, StreamWriter sw, string name) { CStats clSatas = new CStats(connect); List <STStats> stats; STParamStats prst; List <STStats> data = new List <STStats>(); try { if (lst_game.Count > 0) { sw.WriteLine(name); sw.WriteLine("---------------------------"); sw.WriteLine("<p> </p>"); lst_center = new List <STDataSymbol5>(); lst_defender = new List <STDataSymbol5>(); lst_forward = new List <STDataSymbol5>(); data = new List <STStats>(); // вытягиваем стаистику foreach (STGame game in lst_game) { int r = 0; STStats newst; prst = new STParamStats(); prst.idseason = game.idseason; prst.idgame = game.idgame; prst.idteam = game.idteam1; stats = clSatas.GetStats(prst); if (game.apoints >= 0 && game.bpoints >= 0) { r = (int)game.apoints - (int)game.bpoints; } foreach (STStats st in stats) { newst = st; newst.pm = r; data.Add(newst); } prst = new STParamStats(); prst.idseason = game.idseason; prst.idgame = game.idgame; prst.idteam = game.idteam2; stats = clSatas.GetStats(prst); if (game.apoints >= 0 && game.bpoints >= 0) { r = (int)game.bpoints - (int)game.apoints; } foreach (STStats st in stats) { newst = st; newst.pm = r; data.Add(newst); } } // сортируем по id ListCompareStatsByID clCompareStats = new ListCompareStatsByID(); data.Sort(clCompareStats); // расчитываем int currid = 0; int curteam = 0; int cnt = 1; STDataSymbol5 item; CEntryPlayers clEP = new CEntryPlayers(connect); STEntryPlayers stEP; CTeam clTeam = new CTeam(connect); CPlayer clPlayer = new CPlayer(connect); int point = 0; int reb = 0; int ass = 0; int stl = 0; int blk = 0; int res = 0; double kf = 0; bool first = true; for (int i = 0; i < data.Count; i++) { if (first) { currid = data[0].idplayer; curteam = data[0].idteam; point = data[0].points; reb = data[0].rebounds; ass = data[0].assists; stl = data[0].steals; blk = data[0].blocks; res = data[0].pm; cnt = 1; first = false; } else { if (currid == data[i].idplayer) { cnt++; ass += data[i].assists; blk += data[i].blocks; point += data[i].points; reb += data[i].rebounds; stl += data[i].steals; res += data[i].pm; } else { // item = new STDataSymbol5(); clTeam = new CTeam(connect, curteam); clPlayer = new CPlayer(connect, currid); stEP = clEP.GetEntryPlayerLast(data[i].idseason, currid); item.team = clTeam.stTeam.name; item.name = clPlayer.stPlayer.family + " " + clPlayer.stPlayer.name; item.points = (1.0 * point) / cnt; item.assists = (1.0 * ass) / cnt; item.block = (1.0 * blk) / cnt; item.rebounds = (1.0 * reb) / cnt; item.steals = (1.0 * stl) / cnt; item.res = res; if (item.res > 30) { kf = 1.1; } if (item.res > 20 && item.res <= 30) { kf = 1.2; } if (item.res > 10 && item.res <= 20) { kf = 1.25; } if (item.res > 5 && item.res <= 10) { kf = 1.3; } if (item.res > 0 && item.res <= 5) { kf = 1.35; } if (item.res > -5 && item.res <= 0) { kf = 0.95; } if (item.res > -10 && item.res <= -5) { kf = 0.9; } if (item.res > -20 && item.res <= -10) { kf = 0.85; } if (item.res > -30 && item.res <= -20) { kf = 0.8; } if (item.res <= -30) { kf = 0.7; } if (stEP.amplua != null) { if (stEP.amplua == 1) { item.amplua = "защитник"; item.ball = ((item.points * 1.5) + (item.assists * 2.5) + item.rebounds + (item.steals * 2) + item.block) * kf; lst_defender.Add(item); } if (stEP.amplua == 2) { item.amplua = "форвард"; item.ball = ((item.points * 2.5) + (item.assists * 1.5) + item.rebounds + item.steals + item.block) * kf; lst_forward.Add(item); } if (stEP.amplua == 3) { item.amplua = "центровой"; item.ball = ((item.points + item.assists + (item.rebounds * 2.5) + item.steals + (item.block * 2))) * kf; lst_center.Add(item); } } currid = data[i].idplayer; curteam = data[i].idteam; point = data[i].points; reb = data[i].rebounds; ass = data[i].assists; stl = data[i].steals; blk = data[i].blocks; res = data[i].pm; cnt = 1; } } } item = new STDataSymbol5(); clTeam = new CTeam(connect, curteam); clPlayer = new CPlayer(connect, currid); stEP = clEP.GetEntryPlayerLast(IS.idseason, currid); item.team = clTeam.stTeam.name; item.name = clPlayer.stPlayer.family + " " + clPlayer.stPlayer.name; item.points = (1.0 * point) / cnt; item.assists = (1.0 * ass) / cnt; item.block = (1.0 * blk) / cnt; item.rebounds = (1.0 * reb) / cnt; item.steals = (1.0 * stl) / cnt; item.res = res; if (item.res > 30) { kf = 1.1; } if (item.res > 20 && item.res <= 30) { kf = 1.2; } if (item.res > 10 && item.res <= 20) { kf = 1.25; } if (item.res > 5 && item.res <= 10) { kf = 1.3; } if (item.res > 0 && item.res <= 5) { kf = 1.35; } if (item.res > -5 && item.res <= 0) { kf = 0.95; } if (item.res > -10 && item.res <= -5) { kf = 0.9; } if (item.res > -20 && item.res <= -10) { kf = 0.85; } if (item.res > -30 && item.res <= -20) { kf = 0.8; } if (item.res <= -30) { kf = 0.7; } if (stEP.amplua != null) { if (stEP.amplua == 1) { item.amplua = "защитник"; item.ball = ((item.points * 1.5) + (item.assists * 2.5) + item.rebounds + (item.steals * 2) + item.block) * kf; lst_defender.Add(item); } if (stEP.amplua == 2) { item.amplua = "форвард"; item.ball = ((item.points * 2.5) + (item.assists * 1.5) + item.rebounds + item.steals + item.block) * kf; lst_forward.Add(item); } if (stEP.amplua == 3) { item.amplua = "центровой"; item.ball = ((item.points + item.assists + (item.rebounds * 2.5) + item.steals + (item.block * 2))) * kf; lst_center.Add(item); } } // сортируем по баллам ListCompareByBall clComparyBall = new ListCompareByBall(); lst_center.Sort(clComparyBall); lst_defender.Sort(clComparyBall); lst_forward.Sort(clComparyBall); // выводим в файл int x = 1; foreach (STDataSymbol5 set in lst_defender) { // if (x == 5) break; sw.WriteLine(string.Format ("<p>{0,2}.{1,-20} ({2}) {3} , баллы:{4}, о:{5}, пб:{6}, пр:{7}, пх:{8}, б:{9}</p>", x, set.name, set.team, set.amplua, set.ball, set.points, set.rebounds, set.assists, set.steals, set.block)); x++; } foreach (STDataSymbol5 set in lst_forward) { // if (x == 9) break; sw.WriteLine(string.Format ("<p>{0,2}.{1,-20} ({2}) {3} , баллы:{4}, о:{5}, пб:{6}, пр:{7}, пх:{8}, б:{9}</p>", x, set.name, set.team, set.amplua, set.ball, set.points, set.rebounds, set.assists, set.steals, set.block)); x++; } foreach (STDataSymbol5 set in lst_center) { // if (x == 11) break; sw.WriteLine(string.Format ("<p>{0,2}.{1,-20} ({2}) {3} , баллы:{4}, о:{5}, пб:{6}, пр:{7}, пх:{8}, б:{9}</p>", x, set.name, set.team, set.amplua, set.ball, set.points, set.rebounds, set.assists, set.steals, set.block)); x++; } sw.WriteLine("<p> </p>"); sw.WriteLine("<p><img src=\"\" alt=\"\" /></p>"); sw.WriteLine("<p> </p>"); sw.WriteLine("<p> </p>"); sw.WriteLine("------------"); sw.WriteLine(""); sw.WriteLine(""); sw.WriteLine(""); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void Stats_Load(object sender, EventArgs e) { string text; CTeam cl; CCity clc; int idcity1 = 0, idcity2 = 0; try { cl = new CTeam(connect, (int)gSTGame.idteam1); nameteam1 = cl.stTeam.name; idcity1 = cl.stTeam.idcity; cl = new CTeam(connect, (int)gSTGame.idteam2); nameteam2 = cl.stTeam.name; idcity2 = cl.stTeam.idcity; text = string.Format("Статистика игры: {0} - {1} {2}:{3}", nameteam1, nameteam2, gSTGame.apoints, gSTGame.bpoints); this.Text = text; clc = new CCity(connect, idcity1); if (clc.stFullCity.name != null) { radioButtonTeam1.Text = string.Format("{0} ({1},{2})", nameteam1, clc.stFullCity.name, clc.stFullCity.namecountry); } else { radioButtonTeam1.Text = nameteam1; } clc = new CCity(connect, idcity2); if (clc.stFullCity.name != null) { radioButtonTeam2.Text = string.Format("{0} ({1},{2})", nameteam2, clc.stFullCity.name, clc.stFullCity.namecountry); } else { radioButtonTeam2.Text = nameteam2; } curridteam = (int)gSTGame.idteam1; currnameteam = nameteam1; currentpoints = (int)gSTGame.apoints; clTC = new CEntryPlayers(connect); List <STEntryPlayers> lst = clTC.GetListEntryPlayersReal(IS.idseason, (int)gSTGame.idteam1, (DateTime)gSTGame.datetime, null); team1 = lst; team1.Sort(clep); lst = clTC.GetListEntryPlayersReal(IS.idseason, (int)gSTGame.idteam2, (DateTime)gSTGame.datetime, null); team2 = lst; team2.Sort(clep); currteam = team1; init_data(); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void Start() { CEntryPlayers clEP = new CEntryPlayers(connect); List <STEntryPlayers> data_list = clEP.GetListEntryPlayers(IS.idseason, 0, "IdTeam"); RecordDisplayStats record; CEntryTeam clET; CStats clSatas = new CStats(connect); List <STStats> stats; STParamStats prst; CPlayer clPlayer; string text; try { container = new List <RecordDisplayStats>(); foreach (STEntryPlayers data in data_list) { if (data.dateout == null) { record = new RecordDisplayStats(); /* Номер и команда */ record.idplayer = data.idplayer; clPlayer = new CPlayer(connect, data.idplayer); text = string.Format("{0} {1}", clPlayer.stPlayer.family.ToUpper(), clPlayer.stPlayer.name); record.fio = text; record.idteam = data.idteam; clTeam = new CTeam(connect, data.idteam); record.nameteam = clTeam.stTeam.name; /*Дивизион */ clET = new CEntryTeam(connect, IS.idseason, data.idteam); record.iddivision = clET.gstTeamPart.iddivision; /* Гражданство */ clPlayer = new CPlayer(connect, data.idplayer); if (clPlayer.stPlayer.idcountry != null) { record.idcountry = (int)clPlayer.stPlayer.idcountry; } else { record.idcountry = 0; } /* Число сезонов */ record.cntseason = clEP.GetCntSeasonPlayer(data.idplayer); /* Возраст */ CAge age = new CAge(); if (clPlayer.stPlayer.datebirth != null) { record.age = age.GetAge((DateTime)clPlayer.stPlayer.datebirth, DateTime.Now); record.agestart = age.GetAge((DateTime)clPlayer.stPlayer.datebirth, IS.datebegin); } else { record.age = 0; record.agestart = 0; } /* Считам статистику */ prst = new STParamStats(); prst.idseason = IS.idseason; prst.idplayer = data.idplayer; stats = clSatas.GetStats(prst); if (stats.Count > 0) { foreach (STStats statplayer in stats) { record.cntgame++; record.afg += statplayer.afg; record.a3fg += statplayer.a3fg; record.aft += statplayer.aft; record.hfg += statplayer.hfg; record.h3fg += statplayer.h3fg; record.hft += statplayer.hft; record.points += statplayer.points; record.rebits += statplayer.rebits; record.rebounds += statplayer.rebounds; record.rebstg += statplayer.rebstg; record.assists += statplayer.assists; record.steals += statplayer.steals; record.blocks += statplayer.blocks; record.foulsadv += statplayer.foulsadv; record.turnass += statplayer.turnass; record.turnovers += statplayer.turnovers; record.turnteh += statplayer.turnteh; record.psfouls += statplayer.psfouls; record.ptime += statplayer.ptime; record.pm += statplayer.pm; KPI kpi = new KPI(statplayer); record.kpi += kpi.kpi; } if (record.afg > 0) { record.pc2 = (1.0 * record.hfg) / record.afg * 100; } else { record.pc2 = 0; } if (record.a3fg > 0) { record.pc3 = (1.0 * record.h3fg) / record.a3fg * 100; } else { record.pc3 = 0; } if (record.aft > 0) { record.pcft = (1.0 * record.hft) / record.aft * 100; } else { record.pcft = 0; } if (record.afg + record.a3fg > 0) { record.pcall = ((1.0 * record.hfg + record.h3fg) / (record.afg + record.a3fg)) * 100; } else { record.pcall = 0; } if (record.cntgame > 0) { record.averpoints = 1.0 * record.points / record.cntgame; record.averrebounds = 1.0 * record.rebounds / record.cntgame; record.averassists = 1.0 * record.assists / record.cntgame; record.averblocks = 1.0 * record.blocks / record.cntgame; record.aversteals = 1.0 * record.steals / record.cntgame; record.averfoulsadv = 1.0 * record.foulsadv / record.cntgame; record.averkpi = 1.0 * record.kpi / record.cntgame; record.averptime = 1.0 * record.ptime / record.cntgame; record.averturnovers = 1.0 * record.turnovers / record.cntgame; record.averafg = 1.0 * record.afg / record.cntgame; record.avera3fg = 1.0 * record.a3fg / record.cntgame; record.averaft = 1.0 * record.aft / record.cntgame; record.averhfg = 1.0 * record.hfg / record.cntgame; record.averh3fg = 1.0 * record.h3fg / record.cntgame; record.averhft = 1.0 * record.hft / record.cntgame; record.averpsfouls = 1.0 * record.psfouls / record.cntgame; if (record.averafg > 0) { record.averpc2 = (1.0 * record.averhfg) / record.averafg * 100; } else { record.averpc2 = 0; } if (record.avera3fg > 0) { record.averpc3 = (1.0 * record.averh3fg) / record.avera3fg * 100; } else { record.averpc3 = 0; } if (record.averaft > 0) { record.averpcft = (1.0 * record.averhft) / record.averaft * 100; } else { record.averpcft = 0; } if (record.averafg + record.avera3fg > 0) { record.averpcall = ((1.0 * record.averhfg + record.averh3fg) / (record.averafg + record.avera3fg)) * 100; } else { record.averpcall = 0; } } else { record.averpoints = 0; record.averrebounds = 0; record.averassists = 0; record.averblocks = 0; record.aversteals = 0; record.averfoulsadv = 0; record.averkpi = 0; record.averptime = 0; record.averturnovers = 0; record.averafg = 0; record.avera3fg = 0; record.averaft = 0; record.averhfg = 0; record.averh3fg = 0; record.averhft = 0; record.averpcall = 0; record.averpcft = 0; record.averpc3 = 0; record.averpc2 = 0; record.averpsfouls = 0; } } container.Add(record); } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private List <STDataRating> calculate() { List <STDataRating> ret = new List <STDataRating>(); STDataRating item; CPlayer clPlayer; List <STPlayer> lst_player; STPlayerParam paramPlayer = new STPlayerParam(); paramPlayer.idseason = null; CStats clStats; List <STStats> stStats; STParamStats paramStats; CEntryPlayers clEP; STEntryPlayers stEP; int idteam = 0; CTeam clTeam; try { clPlayer = new CPlayer(connect); clStats = new CStats(connect); clEP = new CEntryPlayers(connect); lst_player = clPlayer.GetList(paramPlayer); foreach (STPlayer st in lst_player) { item = new STDataRating(); clPlayer = new CPlayer(connect, st.idplayer); item.name = string.Format("{0} {1} {2}", clPlayer.stPlayer.family, clPlayer.stPlayer.name, clPlayer.stPlayer.payname); idteam = clEP.IsEntryPlayer(IS.idseason, st.idplayer); if (idteam > 0) { clTeam = new CTeam(connect, idteam); item.nameteam = clTeam.stTeam.name; } else { item.nameteam = "не заявлен в текущем сезоне"; } paramStats = new STParamStats(); paramStats.idplayer = st.idplayer; stStats = clStats.GetStats(paramStats); foreach (STStats stst in stStats) { item.cntgame++; item.points += stst.points; item.rebounds += stst.rebounds; item.steals += stst.steals; item.fouls += stst.psfouls; item.blocks += stst.blocks; item.assists += stst.assists; } ret.Add(item); } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } return(ret); }
private void init_data_leader_team() { try { CEntryPlayers clEP = new CEntryPlayers(connect); List <STEntryPlayers> data_list1 = clEP.GetListEntryPlayersReal(IS.idseason, team1.id, DateTime.Now, null); List <STEntryPlayers> data_list2 = clEP.GetListEntryPlayersReal(IS.idseason, team2.id, DateTime.Now, null); List <RecordPlayerPreView> stTeam1 = CalculateStats(data_list1); List <RecordPlayerPreView> stTeam2 = CalculateStats(data_list2); dataGridViewLeader.Rows.Clear(); dataGridViewLeader.Rows.Add(9); /* Очки */ dataGridViewLeader.Rows[0].Cells[0].Value = GetStringData(stTeam1, 1); dataGridViewLeader.Rows[0].Cells[1].Value = "Очки"; dataGridViewLeader.Rows[0].Cells[2].Value = GetStringData(stTeam2, 1); /* Подборы */ dataGridViewLeader.Rows[1].Cells[0].Value = GetStringData(stTeam1, 2); dataGridViewLeader.Rows[1].Cells[1].Value = "Подборы"; dataGridViewLeader.Rows[1].Cells[2].Value = GetStringData(stTeam2, 2); /* Передачи */ dataGridViewLeader.Rows[2].Cells[0].Value = GetStringData(stTeam1, 3); dataGridViewLeader.Rows[2].Cells[1].Value = "Передачи"; dataGridViewLeader.Rows[2].Cells[2].Value = GetStringData(stTeam2, 3); /* Перехваты */ dataGridViewLeader.Rows[3].Cells[0].Value = GetStringData(stTeam1, 4); dataGridViewLeader.Rows[3].Cells[1].Value = "Перехваты"; dataGridViewLeader.Rows[3].Cells[2].Value = GetStringData(stTeam2, 4); /* Блок-шоты */ dataGridViewLeader.Rows[4].Cells[0].Value = GetStringData(stTeam1, 5); dataGridViewLeader.Rows[4].Cells[1].Value = "Блок-шоты"; dataGridViewLeader.Rows[4].Cells[2].Value = GetStringData(stTeam2, 5); /* Процент 2 очк. */ dataGridViewLeader.Rows[5].Cells[0].Value = GetStringData(stTeam1, 6); dataGridViewLeader.Rows[5].Cells[1].Value = "Процент 2 очк."; dataGridViewLeader.Rows[5].Cells[2].Value = GetStringData(stTeam2, 6); /* Процент 3 очк. */ dataGridViewLeader.Rows[6].Cells[0].Value = GetStringData(stTeam1, 7); dataGridViewLeader.Rows[6].Cells[1].Value = "Процент 3 очк."; dataGridViewLeader.Rows[6].Cells[2].Value = GetStringData(stTeam2, 7); /* Процент штраф. */ dataGridViewLeader.Rows[7].Cells[0].Value = GetStringData(stTeam1, 8); dataGridViewLeader.Rows[7].Cells[1].Value = "Процент штраф."; dataGridViewLeader.Rows[7].Cells[2].Value = GetStringData(stTeam2, 8); /* Процент с игры */ dataGridViewLeader.Rows[8].Cells[0].Value = GetStringData(stTeam1, 9); dataGridViewLeader.Rows[8].Cells[1].Value = "Процент с игры"; dataGridViewLeader.Rows[8].Cells[2].Value = GetStringData(stTeam2, 9); } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void init_combo_part() { int idteam = 0; CEntryPlayers clEP = new CEntryPlayers(connect); CEntryTeam clET; string text; try { comboBoxPart.Items.Clear(); if (comboBoxTeam.Text.Length > 0) { clTeam = new CTeam(connect, comboBoxTeam.Text.Trim()); idteam = clTeam.stTeam.id; } else { idteam = 0; } if (radioButtonPlayer.Checked == true) { List <STEntryPlayers> lst = clEP.GetListEntryPlayers(idseason, idteam, null); foreach (STEntryPlayers step in lst) { clPlayer = new CPlayer(connect, step.idplayer); text = string.Format("{0} {1} ({2})", clPlayer.stPlayer.family, clPlayer.stPlayer.name, clPlayer.stPlayer.personalnum); comboBoxPart.Items.Add(text); } } if (radioButtonCoach.Checked == true) { clET = new CEntryTeam(connect, idseason, idteam); if (clET.gstTeamPart.idcoach1 != null) { clCoach = new CCoach(connect, (int)clET.gstTeamPart.idcoach1); if (clCoach.stCoach.idcoach > 0) { text = string.Format("{0} {1} ({2})", clCoach.stCoach.family, clCoach.stCoach.name, clCoach.stCoach.personalnum); comboBoxPart.Items.Add(text); } } if (clET.gstTeamPart.idcoach2 != null) { clCoach = new CCoach(connect, (int)clET.gstTeamPart.idcoach2); if (clCoach.stCoach.idcoach > 0) { text = string.Format("{0} {1} ({2})", clCoach.stCoach.family, clCoach.stCoach.name, clCoach.stCoach.personalnum); comboBoxPart.Items.Add(text); } } if (clET.gstTeamPart.idcoach3 != null) { clCoach = new CCoach(connect, (int)clET.gstTeamPart.idcoach3); if (clCoach.stCoach.idcoach > 0) { text = string.Format("{0} {1} ({2})", clCoach.stCoach.family, clCoach.stCoach.name, clCoach.stCoach.personalnum); comboBoxPart.Items.Add(text); } } } } catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); } }
private void init_data() { CTeam clTeam; CDivision clDivision; CPlayer clPlayer; CCoach clCoach; CEntryPlayers clEP = new CEntryPlayers(connect); string text; try { g_f = false; dataGridViewTeamPart.Rows.Clear(); list = new List <STEntryTeam>(); if (iddiv == 0) { list = clTeamParticipant.GetTeamParticipant((int)IS.idseason); } else { list = clTeamParticipant.GetTeamParticipant((int)IS.idseason, iddiv); } if (list.Count > 0) { g_f = true; dataGridViewTeamPart.Rows.Add(list.Count); for (int i = 0; i < list.Count; i++) { /* № п\п */ dataGridViewTeamPart.Rows[i].Cells[0].Value = (i + 1).ToString(); /* Команда */ clTeam = new CTeam(connect, list[i].idteam); dataGridViewTeamPart.Rows[i].Cells[1].Value = clTeam.stTeam.name; /* Главный тренер */ if (list[i].idcoach1 != null) { clCoach = new CCoach(connect, (int)list[i].idcoach1); text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name); dataGridViewTeamPart.Rows[i].Cells[2].Value = text; } /* Помощник тренера */ if (list[i].idcoach2 != null && list[i].idcoach2 != 0) { clCoach = new CCoach(connect, (int)list[i].idcoach2); text = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name); if (list[i].idcoach3 != null && list[i].idcoach3 != 0) { clCoach = new CCoach(connect, (int)list[i].idcoach3); string text1 = string.Format("{0} {1}", clCoach.stCoach.family, clCoach.stCoach.name); text = text + ", " + text1; } dataGridViewTeamPart.Rows[i].Cells[3].Value = text; } /* Капитан */ if (list[i].idcaptain != null) { clPlayer = new CPlayer(connect, (int)list[i].idcaptain); text = string.Format("{0} {1}", clPlayer.stPlayer.family, clPlayer.stPlayer.name); dataGridViewTeamPart.Rows[i].Cells[4].Value = text; } /* Число игроков в команде */ dataGridViewTeamPart.Rows[i].Cells[5].Value = clEP.GetCntPlayers(list[i].idseason, list[i].idteam, null); /* Дата заявки */ dataGridViewTeamPart.Rows[i].Cells[6].Value = list[i].datein.ToShortDateString(); /* Дивизион */ clDivision = new CDivision(connect, list[i].idseason, list[i].iddivision); dataGridViewTeamPart.Rows[i].Cells[7].Value = clDivision.stDiv.name; double power = get_power(list[i].idteam); dataGridViewTeamPart.Rows[i].Cells[8].Value = power.ToString(); } dataGridViewTeamPart.AllowUserToAddRows = false; } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } }