Пример #1
0
        private void out_place()
        {
            CPlace         clPlace;
            List <STPlace> list;

            List <STSmartBookPlace> lst_smart = new List <STSmartBookPlace>();
            STSmartBookPlace        item;

            try
            {
                clPlace = new CPlace(connect);
                list    = clPlace.GetListPlace();

                foreach (STPlace row in list)
                {
                    item = new STSmartBookPlace();

                    item.id    = row.id;
                    item.place = row.name;

                    lst_smart.Add(item);
                }

                CSmartBookPlace clSmart = new CSmartBookPlace(pathbook);
                clSmart.Write(lst_smart);
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
        }
Пример #2
0
        private STGameDays GetSelectionData()
        {
            STGameDays ret = new STGameDays();
            CPlace     clPlace;

            int n;
            int idplace = 0;

            try
            {
                foreach (DataGridViewRow item in dataGridViewGameDays.SelectedRows)
                {
                    if (item.Cells[0].Value != null)
                    {
                        n = int.Parse(item.Cells[0].Value.ToString());

                        if (item.Cells[2].Value.ToString() != null)
                        {
                            clPlace = new CPlace(connect, item.Cells[2].Value.ToString());
                            idplace = clPlace.stPlace.id;
                        }


                        ret = clWork.GetRecord(IS.idseason, n, idplace);
                    }
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }

            return(ret);
        }
Пример #3
0
        /* инициализаци¤ списка площадок */
        private void init_combo_place()
        {
            try
            {
                comboBoxPlace.Items.Clear();

                clPlace = new CPlace(connect);
                List <STPlace> list = clPlace.GetListPlace();

                comboBoxPlace.Items.Add("");

                if (list.Count > 0)
                {
                    foreach (STPlace item in list)
                    {
                        if (item.vf == 1)
                        {
                            comboBoxPlace.Items.Add(item.name);
                        }
                    }
                }
                else
                {
                    comboBoxPlace.Enabled = false;
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
        }
Пример #4
0
        private void DlgPlace_Load(object sender, EventArgs e)
        {
            this.Text = caption;

            clPlace = new CPlace(connect);

            textBoxName.Focus();
        }
Пример #5
0
        public DlgGameDays(SqlConnection cn, STInfoSeason si, STGameDays?data)
        {
            InitializeComponent();

            connect = cn;
            IS      = si;
            oldData = data;

            clPlace = new CPlace(connect);

            init_combo_palce();
        }
Пример #6
0
        public Place(SqlConnection cn, STInfoSeason inf, ushort md)
        {
            InitializeComponent();

            connect = cn;
            IS      = inf;
            mode    = md;

            clPlace = new CPlace(connect);

            this.WindowState = FormWindowState.Maximized;

            gpos = 0;
        }
Пример #7
0
        private void set_data(STGameDays data)
        {
            try
            {
                textBoxNDay.Text = data.nday.ToString();

                dateTimePickerDate.Value = data.date;

                textBoxCntGame.Text = data.cntgames.ToString();

                clPlace = new CPlace(connect, data.idplace);

                comboBoxPlace.Text = clPlace.stPlace.name;
            }
            catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
        }
Пример #8
0
        private STPlace GetSelectionData()
        {
            STPlace ret = new STPlace();

            string n;

            foreach (DataGridViewRow item in dataGridViewPlace.SelectedRows)
            {
                n = item.Cells[1].Value.ToString();

                CPlace sp = new CPlace(connect, n);

                ret = sp.stPlace;
            }

            return(ret);
        }
Пример #9
0
        /* вспомогательные функции виз. отображения календаря */
        private void init_list_add_row(STGame item, int i)
        {
            CTeam     clTeam     = new CTeam(connect);
            CPlace    clPlace    = new CPlace(connect);
            CDivision clDivision = new CDivision(connect);
            CGroup    clGroup    = new CGroup(connect);
            CCity     clCity;

            string text  = null;
            string team1 = null;
            string team2 = null;

            Color color = Color.Black;

            try
            {
                if (item.apoints > 0 && item.bpoints > 0)
                {
                    color = Color.Black;
                }
                else
                {
                    color = Color.Red;
                }

                dataGridViewGames.Rows[i].DefaultCellStyle.ForeColor = color;

                /* вставляем номер игры */
                dataGridViewGames.Rows[i].Cells[1].Value = item.idgame;

                /* игра и результат */
                if (item.idteam1 != null)
                {
                    clTeam = new CTeam(connect, (int)item.idteam1);
                    team1  = clTeam.stTeam.name;
                }
                if (item.idteam2 != null)
                {
                    clTeam = new CTeam(connect, (int)item.idteam2);
                    team2  = clTeam.stTeam.name;
                }

                text = string.Format("{0} {1} - {2} {3}", team1, item.apoints, item.bpoints, team2);

                /* выводим команды которые играют */
                dataGridViewGames.Rows[i].Cells[2].Value = text;

                /* дата и время игры */
                if (item.datetime != null)
                {
                    DateTime dt = (DateTime)item.datetime;
                    text = string.Format("{0} {1}:{2:00}", dt.ToLongDateString(), dt.Hour, dt.Minute);
                    dataGridViewGames.Rows[i].Cells[3].Value = text;
                }

                /* место игры */
                if (item.idplace != null)
                {
                    clPlace = new CPlace(connect, (int)item.idplace);
                    clCity  = new CCity(connect, clPlace.stPlace.idcity);
                    text    = clPlace.stPlace.name;
                    if (clCity.stFullCity.name != null)
                    {
                        text += string.Format(" ({0},{1})", clCity.stFullCity.name,
                                              clCity.stFullCity.shortnamecountry);
                    }

                    dataGridViewGames.Rows[i].Cells[4].Value = text;
                }

                /* группа */
                if (item.idgroup != null)
                {
                    clGroup = new CGroup(connect, (int)IS.idseason, (int)item.iddivision, (int)item.idgroup);
                    text    = string.Format("{0}", clGroup.stGroup.namegroup);

                    dataGridViewGames.Rows[i].Cells[5].Value = text;
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }
        }
Пример #10
0
        private STGameDays read_data()
        {
            STGameDays ret    = new STGameDays();
            List <int> arr    = new List <int>();
            string     text   = null;
            string     family = null;
            string     name   = null;

            string[] words;

            try
            {
                ret.idseason = IS.idseason;

                if (textBoxNDay.Text.Length > 0)
                {
                    ret.nday = int.Parse(textBoxNDay.Text.Trim());
                }
                else
                {
                    ret.nday = 0;
                }

                ret.date = new DateTime(dateTimePickerDate.Value.Year,
                                        dateTimePickerDate.Value.Month, dateTimePickerDate.Value.Day, 0, 0, 0, 0);

                if (textBoxCntGame.Text.Length > 0)
                {
                    ret.cntgames = int.Parse(textBoxCntGame.Text.Trim());
                }
                else
                {
                    ret.cntgames = 0;
                }

                for (int i = 0; i < checkedListBoxAdmin.Items.Count; i++)
                {
                    if (checkedListBoxAdmin.GetItemChecked(i))
                    {
                        text = checkedListBoxAdmin.Items[i].ToString();
                        if (text.Length > 0)
                        {
                            char[] del = { ' ' };
                            words = text.Split(del);

                            family = words[0];
                            name   = words[1];

                            clPart = new CParticipant(connect, family, name);
                        }

                        arr.Add(clPart.stPart.idpart);
                    }
                }

                if (arr.Count > 0)
                {
                    ret.adminline = clWork.GetStringData(arr);
                }
                else
                {
                    ret.adminline = null;
                }

                arr = new List <int>();
                for (int i = 0; i < checkedListBoxWasher.Items.Count; i++)
                {
                    if (checkedListBoxWasher.GetItemChecked(i))
                    {
                        text = checkedListBoxWasher.Items[i].ToString();
                        if (text.Length > 0)
                        {
                            char[] del = { ' ' };
                            words = text.Split(del);

                            family = words[0];
                            name   = words[1];

                            clPart = new CParticipant(connect, family, name);
                        }

                        arr.Add(clPart.stPart.idpart);
                    }
                }

                if (arr.Count > 0)
                {
                    ret.washerline = clWork.GetStringData(arr);
                }
                else
                {
                    ret.washerline = null;
                }

                if (comboBoxPlace.Text.Length > 1)
                {
                    clPlace     = new CPlace(connect, comboBoxPlace.Text.Trim());
                    ret.idplace = clPlace.stPlace.id;
                }
                else
                {
                    ret.idplace = 0;
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message.ToString()); }

            return(ret);
        }
Пример #11
0
        private void init_data_history()
        {
            string text, tm1, tm2;

            CInfoSeason  clIS = new CInfoSeason(connect);
            STInfoSeason st;

            DateTime dt;

            CPlace clPlace;

            try
            {
                //    if (MessageBox.Show("Обнулить данные?", "Внимание!", MessageBoxButtons.OKCancel, MessageBoxIcon.Question)
                //        == DialogResult.OK)
                //    {
                //        dataGridViewPersonalResult.Rows.Clear();

//                    cnt = 1;
//                }

                dataGridViewPersonalResult.Rows.Clear();

                cnt = 1;

                if (list_data.Count > 0)
                {
                    dataGridViewPersonalResult.Rows.Add(list_data.Count);


                    for (int i = 0; i < list_data.Count; i++)
                    {
                        dataGridViewPersonalResult.Rows[i].Cells[0].Value = cnt.ToString();

                        clIS = new CInfoSeason(connect, list_data[i].idseason);
                        st   = (STInfoSeason)clIS.s_IS;
                        dataGridViewPersonalResult.Rows[i].Cells[1].Value = st.nameseason;

                        dataGridViewPersonalResult.Rows[i].Cells[2].Value = list_data[i].idgame;

                        clTeam = new CTeam(connect, (int)list_data[i].idteam1);
                        tm1    = clTeam.stTeam.name;
                        clTeam = new CTeam(connect, (int)list_data[i].idteam2);
                        tm2    = clTeam.stTeam.name;

                        text = string.Format("{0} {1} - {2} {3}", tm1, list_data[i].apoints, list_data[i].bpoints, tm2);
                        dataGridViewPersonalResult.Rows[i].Cells[3].Value = text;

                        dt   = (DateTime)list_data[i].datetime;
                        text = dt.ToShortDateString();
                        dataGridViewPersonalResult.Rows[i].Cells[4].Value = text;

                        clPlace = new CPlace(connect, (int)list_data[i].idplace);
                        dataGridViewPersonalResult.Rows[i].Cells[5].Value = clPlace.stPlace.name;

                        cnt++;
                    }
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
        }
Пример #12
0
        private void init_data()
        {
            string     text;
            List <int> arr;
            bool       fl;

            bool fll;
            int  curmonth = 0;

            Color colorfont;

            try
            {
                dataGridViewGameDays.Rows.Clear();

                list = clWork.GetData(IS.idseason);

                if (list.Count > 0)
                {
                    dataGridViewGameDays.Rows.Add(list.Count);

                    curmonth = list[0].date.Month;
                    fll      = false;

                    for (int i = 0; i < list.Count; i++)
                    {
                        if (curmonth != list[i].date.Month)
                        {
                            curmonth = list[i].date.Month;
                            fll      = !fll;
                        }

                        if (fll)
                        {
                            colorfont = Color.LightCyan;
                        }
                        else
                        {
                            colorfont = Color.White;
                        }

                        dataGridViewGameDays.Rows[i].DefaultCellStyle.BackColor = colorfont;

                        dataGridViewGameDays.Rows[i].Cells[0].Value = list[i].nday;
                        dataGridViewGameDays.Rows[i].Cells[1].Value = list[i].date.ToLongDateString();

                        if (list[i].idplace > 0)
                        {
                            clPlace = new CPlace(connect, list[i].idplace);
                            dataGridViewGameDays.Rows[i].Cells[2].Value = clPlace.stPlace.name;
                        }
                        else
                        {
                            dataGridViewGameDays.Rows[i].Cells[2].Value = "";
                        }

                        dataGridViewGameDays.Rows[i].Cells[3].Value = list[i].cntgames;

                        if (list[i].adminline != null)
                        {
                            arr = clWork.GetArrayData(list[i].adminline);

                            if (arr.Count > 0)
                            {
                                text = null;
                                fl   = false;

                                foreach (int n in arr)
                                {
                                    clPart = new CParticipant(connect, n);

                                    if (fl == false)
                                    {
                                        text = string.Format("{0} {1}", clPart.stPart.family,
                                                             clPart.stPart.name);
                                        fl = true;
                                    }
                                    else
                                    {
                                        text += ", " + string.Format("{0} {1}", clPart.stPart.family,
                                                                     clPart.stPart.name);
                                    }
                                }

                                dataGridViewGameDays.Rows[i].Cells[4].Value = text;
                            }
                        }

                        if (list[i].washerline != null)
                        {
                            arr = clWork.GetArrayData(list[i].washerline);

                            if (arr.Count > 0)
                            {
                                text = null;
                                fl   = false;

                                foreach (int n in arr)
                                {
                                    clPart = new CParticipant(connect, n);

                                    if (fl == false)
                                    {
                                        text = string.Format("{0} {1}", clPart.stPart.family,
                                                             clPart.stPart.name);
                                        fl = true;
                                    }
                                    else
                                    {
                                        text += ", " + string.Format("{0} {1}", clPart.stPart.family,
                                                                     clPart.stPart.name);
                                    }
                                }

                                dataGridViewGameDays.Rows[i].Cells[5].Value = text;
                            }
                        }

                        if (flawour.Equals(list[i]))
                        {
                            gpos = i;
                        }
                    }

                    dataGridViewGameDays.AllowUserToAddRows = false;

                    if (gpos <= 0)
                    {
                        dataGridViewGameDays.FirstDisplayedScrollingRowIndex = list.Count - 1;
                    }
                }
                else
                {
                    dataGridViewGameDays.AllowUserToAddRows = false;
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
        }
Пример #13
0
        private STGame read_data()
        {
            STGame ret = new STGame();

            try
            {
                /* сезон */
                ret.idseason = IS.idseason;
                /* тип игры */
                ret.type = gType;
                /* номер игры */
                if (textBoxNum.Text.Length > 0)
                {
                    ret.idgame = int.Parse(textBoxNum.Text.Trim());
                }
                /* дата\врем¤ игры */
                ret.datetime = new DateTime(dateTimePickerDate.Value.Year, dateTimePickerDate.Value.Month,
                                            dateTimePickerDate.Value.Day, dateTimePickerTime.Value.Hour, dateTimePickerTime.Value.Minute,
                                            0, 0);
                /* дивизион */
                if (comboBoxDivision.Text.Length > 0)
                {
                    clDivision     = new CDivision(connect, IS.idseason, comboBoxDivision.Text);
                    ret.iddivision = clDivision.stDiv.id;
                }
                else
                {
                    ret.iddivision = 0;
                }
                /* стади¤ */
                if (comboBoxStage.Text.Length > 0)
                {
                    clScheme    = new CScheme(connect, IS.idseason, (int)ret.iddivision, comboBoxStage.Text.Trim());
                    ret.idstage = clScheme.stScheme.idstage;
                }
                else
                {
                    ret.idstage = null;
                }
                /* группа */
                if (comboBoxGroup.Text.Length > 0)
                {
                    clGroup     = new CGroup(connect, IS.idseason, (int)ret.iddivision, comboBoxGroup.Text.Trim());
                    ret.idgroup = clGroup.stGroup.idgroup;
                }
                else
                {
                    ret.idgroup = null;
                }
                /* номер тура */
                if (comboBoxRound.Text.Length > 0)
                {
                    ret.round = int.Parse(comboBoxRound.Text.Trim());
                }
                else
                {
                    ret.round = null;
                }
                /* площадка */
                if (comboBoxPlace.Text.Length > 0)
                {
                    clPlace     = new CPlace(connect, comboBoxPlace.Text.Trim());
                    ret.idplace = clPlace.stPlace.id;
                }
                else
                {
                    ret.idplace = null;
                }
                /* команда 1 */
                if (comboBoxTeam1.Text.Length > 0)
                {
                    clTeam      = new CTeam(connect, comboBoxTeam1.Text.Trim());
                    ret.idteam1 = clTeam.stTeam.id;
                }
                else
                {
                    ret.idteam1 = null;
                }
                /* команда 2 */
                if (comboBoxTeam2.Text.Length > 0)
                {
                    clTeam      = new CTeam(connect, comboBoxTeam2.Text.Trim());
                    ret.idteam2 = clTeam.stTeam.id;
                }
                else
                {
                    ret.idteam2 = null;
                }
                /* данный команд */
                if (textBoxAPer1.Text.Length > 0)
                {
                    ret.aper1 = int.Parse(textBoxAPer1.Text.Trim());
                }
                else
                {
                    ret.aper1 = null;
                }
                if (textBoxAPer2.Text.Length > 0)
                {
                    ret.aper2 = int.Parse(textBoxAPer2.Text.Trim());
                }
                else
                {
                    ret.aper2 = null;
                }
                if (textBoxADopPer.Text.Length > 0)
                {
                    ret.adopper = int.Parse(textBoxADopPer.Text.Trim());
                }
                else
                {
                    ret.adopper = null;
                }
                if (textBoxAF1.Text.Length > 0)
                {
                    ret.ateamfouls1 = int.Parse(textBoxAF1.Text.Trim());
                }
                else
                {
                    ret.ateamfouls1 = null;
                }
                if (textBoxAF2.Text.Length > 0)
                {
                    ret.ateamfouls2 = int.Parse(textBoxAF2.Text.Trim());
                }
                else
                {
                    ret.ateamfouls2 = null;
                }
                if (textBoxAF3.Text.Length > 0)
                {
                    ret.ateamfouls3 = int.Parse(textBoxAF3.Text.Trim());
                }
                else
                {
                    ret.ateamfouls3 = null;
                }
                if (textBoxAF4.Text.Length > 0)
                {
                    ret.ateamfouls4 = int.Parse(textBoxAF4.Text.Trim());
                }
                else
                {
                    ret.ateamfouls4 = null;
                }

                if (textBoxBPer1.Text.Length > 0)
                {
                    ret.bper1 = int.Parse(textBoxBPer1.Text.Trim());
                }
                else
                {
                    ret.bper1 = null;
                }
                if (textBoxBPer2.Text.Length > 0)
                {
                    ret.bper2 = int.Parse(textBoxBPer2.Text.Trim());
                }
                else
                {
                    ret.bper2 = null;
                }
                if (textBoxBDopPer.Text.Length > 0)
                {
                    ret.bdopper = int.Parse(textBoxBDopPer.Text.Trim());
                }
                else
                {
                    ret.bdopper = null;
                }
                if (textBoxBF1.Text.Length > 0)
                {
                    ret.bteamfouls1 = int.Parse(textBoxBF1.Text.Trim());
                }
                else
                {
                    ret.bteamfouls1 = null;
                }
                if (textBoxBF2.Text.Length > 0)
                {
                    ret.bteamfouls2 = int.Parse(textBoxBF2.Text.Trim());
                }
                else
                {
                    ret.bteamfouls2 = null;
                }
                if (textBoxBF3.Text.Length > 0)
                {
                    ret.bteamfouls3 = int.Parse(textBoxBF3.Text.Trim());
                }
                else
                {
                    ret.bteamfouls3 = null;
                }
                if (textBoxBF4.Text.Length > 0)
                {
                    ret.bteamfouls4 = int.Parse(textBoxBF4.Text.Trim());
                }
                else
                {
                    ret.bteamfouls4 = null;
                }

                if (textBoxAPoints1.Text.Length > 0)
                {
                    ret.apointsper1 = int.Parse(textBoxAPoints1.Text.Trim());
                }
                else
                {
                    ret.apointsper1 = null;
                }
                if (textBoxAPoints2.Text.Length > 0)
                {
                    ret.apointsper2 = int.Parse(textBoxAPoints2.Text.Trim());
                }
                else
                {
                    ret.apointsper2 = null;
                }
                if (textBoxAPoints3.Text.Length > 0)
                {
                    ret.apointsper3 = int.Parse(textBoxAPoints3.Text.Trim());
                }
                else
                {
                    ret.apointsper3 = null;
                }
                if (textBoxAPoints4.Text.Length > 0)
                {
                    ret.apointsper4 = int.Parse(textBoxAPoints4.Text.Trim());
                }
                else
                {
                    ret.apointsper4 = null;
                }
                if (textBoxADopPoints.Text.Length > 0)
                {
                    ret.apointsdopper = int.Parse(textBoxADopPoints.Text.Trim());
                }
                else
                {
                    ret.apointsdopper = null;
                }
                if (textBoxAPoints.Text.Length > 0)
                {
                    ret.apoints = int.Parse(textBoxAPoints.Text.Trim());
                }
                else
                {
                    ret.apoints = null;
                }

                if (textBoxBPoints1.Text.Length > 0)
                {
                    ret.bpointsper1 = int.Parse(textBoxBPoints1.Text.Trim());
                }
                else
                {
                    ret.bpointsper1 = null;
                }
                if (textBoxBPoints2.Text.Length > 0)
                {
                    ret.bpointsper2 = int.Parse(textBoxBPoints2.Text.Trim());
                }
                else
                {
                    ret.bpointsper2 = null;
                }
                if (textBoxBPoints3.Text.Length > 0)
                {
                    ret.bpointsper3 = int.Parse(textBoxBPoints3.Text.Trim());
                }
                else
                {
                    ret.bpointsper3 = null;
                }
                if (textBoxBPoints4.Text.Length > 0)
                {
                    ret.bpointsper4 = int.Parse(textBoxBPoints4.Text.Trim());
                }
                else
                {
                    ret.bpointsper4 = null;
                }
                if (textBoxBDopPoints.Text.Length > 0)
                {
                    ret.bpointsdopper = int.Parse(textBoxBDopPoints.Text.Trim());
                }
                else
                {
                    ret.bpointsdopper = null;
                }
                if (textBoxBPoints.Text.Length > 0)
                {
                    ret.bpoints = int.Parse(textBoxBPoints.Text.Trim());
                }
                else
                {
                    ret.bpoints = null;
                }
                /* флаг технического результата */
                if (checkBoxTeh.Checked == true)
                {
                    ret.flagteh = 1;
                }
                else
                {
                    ret.flagteh = 0;
                }

                /* команда - победитель */
                if (ret.apoints > ret.bpoints)
                {
                    ret.idteamwins = ret.idteam1;
                }
                else if (ret.apoints < ret.bpoints)
                {
                    ret.idteamwins = ret.idteam2;
                }
                else
                {
                    ret.idteamwins = null;
                }

                /* судьи */
                if (comboBoxStReferee.Text.Length > 0)
                {
                    ret.idstreferee = get_referee(comboBoxStReferee.Text.Trim());
                }
                else
                {
                    ret.idstreferee = null;
                }
                if (comboBoxReferee1.Text.Length > 0)
                {
                    ret.idreferee1 = get_referee(comboBoxReferee1.Text.Trim());
                }
                else
                {
                    ret.idreferee1 = null;
                }
                if (comboBoxReferee2.Text.Length > 0)
                {
                    ret.idreferee2 = get_referee(comboBoxReferee2.Text.Trim());
                }
                else
                {
                    ret.idreferee2 = null;
                }
                /* оценки судь¤м */
                if (textBoxPointsStrefree.Text.Length > 0)
                {
                    ret.srrefereepoints = double.Parse(textBoxPointsStrefree.Text.Trim());
                }
                else
                {
                    ret.srrefereepoints = null;
                }
                if (textBoxPointsReferee1.Text.Length > 0)
                {
                    ret.referee1points = double.Parse(textBoxPointsReferee1.Text.Trim());
                }
                else
                {
                    ret.referee1points = null;
                }
                if (textBoxPointsReferee2.Text.Length > 0)
                {
                    ret.referee2points = double.Parse(textBoxPointsReferee2.Text.Trim());
                }
                else
                {
                    ret.referee2points = null;
                }

                /* секретарь */
                if (comboBoxSecretar.Text.Length > 0)
                {
                    ret.idwriting = get_participant(comboBoxSecretar.Text.Trim());
                }
                else
                {
                    ret.idwriting = null;
                }
                /* секретарь */
                if (comboBoxOperPanel.Text.Length > 0)
                {
                    ret.idoperpanel = get_participant(comboBoxOperPanel.Text.Trim());
                }
                else
                {
                    ret.idoperpanel = null;
                }
                /* видеооператор */
                if (comboBoxOperVideo.Text.Length > 0)
                {
                    ret.idopervideo = get_participant(comboBoxOperVideo.Text.Trim());
                }
                else
                {
                    ret.idopervideo = null;
                }
                /* врач */
                if (comboBoxMedic.Text.Length > 0)
                {
                    ret.idmedical = get_participant(comboBoxMedic.Text.Trim());
                }
                else
                {
                    ret.idmedical = null;
                }
                /* диктор */
                if (comboBoxDiktor.Text.Length > 0)
                {
                    ret.iddiktor = get_participant(comboBoxDiktor.Text.Trim());
                }
                else
                {
                    ret.iddiktor = null;
                }
                /* подсчЄт статистики */
                if (comboBoxStatist.Text.Length > 0)
                {
                    ret.idstatister = get_participant(comboBoxStatist.Text.Trim());
                }
                else
                {
                    ret.idstatister = null;
                }

                /* остальна¤ статистика */
                if (textBoxCntLook.Text.Length > 0)
                {
                    ret.cntlook = int.Parse(textBoxCntLook.Text.Trim());
                }
                else
                {
                    ret.cntlook = null;
                }
                if (textBoxChangeLider.Text.Length > 0)
                {
                    ret.changelider = int.Parse(textBoxChangeLider.Text.Trim());
                }
                else
                {
                    ret.changelider = null;
                }
                if (textBoxMaxPointsA.Text.Length > 0)
                {
                    ret.maxpointsteam1 = int.Parse(textBoxMaxPointsA.Text.Trim());
                }
                else
                {
                    ret.maxpointsteam1 = null;
                }
                if (textBoxMaxPointsB.Text.Length > 0)
                {
                    ret.maxpointsteam2 = int.Parse(textBoxMaxPointsB.Text.Trim());
                }
                else
                {
                    ret.maxpointsteam2 = null;
                }
                if (textBoxEqualsResult.Text.Length > 0)
                {
                    ret.equalsresult = int.Parse(textBoxEqualsResult.Text.Trim());
                }
                else
                {
                    ret.equalsresult = null;
                }
                if (textBoxMaxDiff.Text.Length > 0)
                {
                    ret.maxdiff = int.Parse(textBoxMaxDiff.Text.Trim());
                }
                else
                {
                    ret.maxdiff = null;
                }

                fread = true;
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); fread = false; }

            return(ret);
        }
Пример #14
0
        private void PrepareEditGame(STGame data)
        {
            string text;

            try
            {
                /* номер игры */
                textBoxNum.Text = data.idgame.ToString();
                /* дата\врем¤ игры */
                if (data.datetime != null)
                {
                    dateTimePickerDate.Value = new DateTime(data.datetime.Value.Year, data.datetime.Value.Month,
                                                            data.datetime.Value.Day, 0, 0, 0, 0);
                    dateTimePickerTime.Value = new DateTime(data.datetime.Value.Year, data.datetime.Value.Month,
                                                            data.datetime.Value.Day, data.datetime.Value.Hour, data.datetime.Value.Minute, 0, 0);
                }
                /* дивизион */
                if (data.iddivision != null)
                {
                    clDivision            = new CDivision(connect, IS.idseason, (int)data.iddivision);
                    comboBoxDivision.Text = clDivision.stDiv.name;
                }
                /* стади¤ */
                if (data.idstage != null)
                {
                    clScheme           = new CScheme(connect, IS.idseason, (int)data.iddivision, (int)data.idstage);
                    comboBoxStage.Text = clScheme.stScheme.namestage;
                }
                /* группа */
                if (data.idgroup != null)
                {
                    clGroup            = new CGroup(connect, IS.idseason, (int)data.iddivision, (int)data.idgroup);
                    comboBoxGroup.Text = clGroup.stGroup.namegroup;
                }
                /* номер тура */
                if (data.round != null)
                {
                    comboBoxRound.Text = data.round.ToString();
                }
                /* площадка */
                if (data.idplace != null)
                {
                    clPlace            = new CPlace(connect, (int)data.idplace);
                    comboBoxPlace.Text = clPlace.stPlace.name;
                }
                /* команда 1 */
                if (data.idteam1 != null)
                {
                    clTeam             = new CTeam(connect, (int)data.idteam1);
                    comboBoxTeam1.Text = clTeam.stTeam.name;
                }
                /* команда 2 */
                if (data.idteam2 != null)
                {
                    clTeam             = new CTeam(connect, (int)data.idteam2);
                    comboBoxTeam2.Text = clTeam.stTeam.name;
                }

                /* данный команд */
                if (data.aper1 != null)
                {
                    textBoxAPer1.Text = data.aper1.ToString();
                }
                if (data.aper2 != null)
                {
                    textBoxAPer2.Text = data.aper2.ToString();
                }
                if (data.adopper != null)
                {
                    textBoxADopPer.Text = data.adopper.ToString();
                }
                if (data.ateamfouls1 != null)
                {
                    textBoxAF1.Text = data.ateamfouls1.ToString();
                }
                if (data.ateamfouls2 != null)
                {
                    textBoxAF2.Text = data.ateamfouls2.ToString();
                }
                if (data.ateamfouls3 != null)
                {
                    textBoxAF3.Text = data.ateamfouls3.ToString();
                }
                if (data.ateamfouls4 != null)
                {
                    textBoxAF4.Text = data.ateamfouls4.ToString();
                }

                if (data.bper1 != null)
                {
                    textBoxBPer1.Text = data.bper1.ToString();
                }
                if (data.bper2 != null)
                {
                    textBoxBPer2.Text = data.bper2.ToString();
                }
                if (data.bdopper != null)
                {
                    textBoxBDopPer.Text = data.bdopper.ToString();
                }
                if (data.bteamfouls1 != null)
                {
                    textBoxBF1.Text = data.bteamfouls1.ToString();
                }
                if (data.bteamfouls2 != null)
                {
                    textBoxBF2.Text = data.bteamfouls2.ToString();
                }
                if (data.bteamfouls3 != null)
                {
                    textBoxBF3.Text = data.bteamfouls3.ToString();
                }
                if (data.bteamfouls4 != null)
                {
                    textBoxBF4.Text = data.bteamfouls4.ToString();
                }

                if (data.apointsper1 != null)
                {
                    textBoxAPoints1.Text = data.apointsper1.ToString();
                }
                if (data.apointsper2 != null)
                {
                    textBoxAPoints2.Text = data.apointsper2.ToString();
                }
                if (data.apointsper3 != null)
                {
                    textBoxAPoints3.Text = data.apointsper3.ToString();
                }
                if (data.apointsper4 != null)
                {
                    textBoxAPoints4.Text = data.apointsper4.ToString();
                }
                if (data.apointsdopper != null)
                {
                    textBoxADopPoints.Text = data.apointsdopper.ToString();
                }
                if (data.apoints != null)
                {
                    textBoxAPoints.Text = data.apoints.ToString();
                }

                if (data.bpointsper1 != null)
                {
                    textBoxBPoints1.Text = data.bpointsper1.ToString();
                }
                if (data.bpointsper2 != null)
                {
                    textBoxBPoints2.Text = data.bpointsper2.ToString();
                }
                if (data.bpointsper3 != null)
                {
                    textBoxBPoints3.Text = data.bpointsper3.ToString();
                }
                if (data.bpointsper4 != null)
                {
                    textBoxBPoints4.Text = data.bpointsper4.ToString();
                }
                if (data.bpointsdopper != null)
                {
                    textBoxBDopPoints.Text = data.bpointsdopper.ToString();
                }
                if (data.bpoints != null)
                {
                    textBoxBPoints.Text = data.bpoints.ToString();
                }
                /* флаг технического результата */
                if (data.flagteh != null)
                {
                    if (data.flagteh == 1)
                    {
                        checkBoxTeh.Checked = true;
                    }
                }

                /* команда - победитель */
                if (data.idteamwins != null)
                {
                    clTeam             = new CTeam(connect, (int)data.idteamwins);
                    labelTeamWins.Text = clTeam.stTeam.name;
                }

                /* судьи */
                if (data.idstreferee != null)
                {
                    clReferee = new CReferee(connect, (int)data.idstreferee);
                    text      = string.Format("{0} {1}", clReferee.stRef.family, clReferee.stRef.name);
                    comboBoxStReferee.Text = text;
                }
                if (data.idreferee1 != null)
                {
                    clReferee             = new CReferee(connect, (int)data.idreferee1);
                    text                  = string.Format("{0} {1}", clReferee.stRef.family, clReferee.stRef.name);
                    comboBoxReferee1.Text = text;
                }
                if (data.idreferee2 != null)
                {
                    clReferee             = new CReferee(connect, (int)data.idreferee2);
                    text                  = string.Format("{0} {1}", clReferee.stRef.family, clReferee.stRef.name);
                    comboBoxReferee2.Text = text;
                }
                /* оценки судь¤м */
                if (data.srrefereepoints != null)
                {
                    textBoxPointsStrefree.Text = data.srrefereepoints.ToString();
                }
                if (data.referee1points != null)
                {
                    textBoxPointsReferee1.Text = data.referee1points.ToString();
                }
                if (data.referee2points != null)
                {
                    textBoxPointsReferee2.Text = data.referee2points.ToString();
                }

                /* секретарь */
                if (data.idwriting != null)
                {
                    clParticipant         = new CParticipant(connect, (int)data.idwriting);
                    text                  = string.Format("{0} {1}", clParticipant.stPart.family, clParticipant.stPart.name);
                    comboBoxSecretar.Text = text;
                }
                /* секретарь */
                if (data.idoperpanel != null)
                {
                    clParticipant          = new CParticipant(connect, (int)data.idoperpanel);
                    text                   = string.Format("{0} {1}", clParticipant.stPart.family, clParticipant.stPart.name);
                    comboBoxOperPanel.Text = text;
                }
                /* видеооператор */
                if (data.idopervideo != null)
                {
                    clParticipant          = new CParticipant(connect, (int)data.idopervideo);
                    text                   = string.Format("{0} {1}", clParticipant.stPart.family, clParticipant.stPart.name);
                    comboBoxOperVideo.Text = text;
                }
                /* врач */
                if (data.idmedical != null)
                {
                    clParticipant      = new CParticipant(connect, (int)data.idmedical);
                    text               = string.Format("{0} {1}", clParticipant.stPart.family, clParticipant.stPart.name);
                    comboBoxMedic.Text = text;
                }
                /* диктор */
                if (data.iddiktor != null)
                {
                    clParticipant       = new CParticipant(connect, (int)data.iddiktor);
                    text                = string.Format("{0} {1}", clParticipant.stPart.family, clParticipant.stPart.name);
                    comboBoxDiktor.Text = text;
                }
                /* подсчЄт статистики */
                if (data.idstatister != null)
                {
                    clParticipant        = new CParticipant(connect, (int)data.idstatister);
                    text                 = string.Format("{0} {1}", clParticipant.stPart.family, clParticipant.stPart.name);
                    comboBoxStatist.Text = text;
                }

                /* остальна¤ статистика */
                if (data.cntlook != null)
                {
                    textBoxCntLook.Text = data.cntlook.ToString();
                }
                if (data.changelider != null)
                {
                    textBoxChangeLider.Text = data.changelider.ToString();
                }
                if (data.maxpointsteam1 != null)
                {
                    textBoxMaxPointsA.Text = data.maxpointsteam1.ToString();
                }
                if (data.maxpointsteam2 != null)
                {
                    textBoxMaxPointsB.Text = data.maxpointsteam2.ToString();
                }
                if (data.equalsresult != null)
                {
                    textBoxEqualsResult.Text = data.equalsresult.ToString();
                }
                if (data.maxdiff != null)
                {
                    textBoxMaxDiff.Text = data.maxdiff.ToString();
                }
            }
            catch (Exception ex) { MessageBox.Show(ex.Message, ex.Source); }
        }