コード例 #1
0
ファイル: bookuc.cs プロジェクト: Exell-pl/Artykuly
        private void ChooseLanguageButton_Click(object sender, EventArgs e)
        {
            SqlCommand Command = new SqlCommand();

            Command.CommandText = "EXEC ZwrocJezyki;";

            DataGridViewColumn[] Columns = new DataGridViewColumn[2];
            Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[0].DataPropertyName = "kod";
            Columns[0].Name             = "Kod";
            Columns[0].HeaderText       = _translationsDictionary.getStringFromDictionary("code", "Kod");

            Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[1].DataPropertyName = "jezyk";
            Columns[1].Name             = "Język";
            Columns[1].HeaderText       = _translationsDictionary.getStringFromDictionary("language", "Język");

            ShowForm SF = new ShowForm(Command, Columns);

            SF.Width = 400;

            if (SF.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                if (SF.Dt != null)
                {
                    LanguageTextBox.Text = SF.Dt.Cells["kod"].Value.ToString();
                }
            }
        }
コード例 #2
0
ファイル: bookuc.cs プロジェクト: Exell-pl/Artykuly
        private void ChooseBookButton_Click(object sender, EventArgs e)
        {
            WaitForm WF = new WaitForm();

            this.Invoke((MethodInvoker) delegate
            {
                WF.Show(this);
                WF.Update();
            });

            SqlCommand Command = new SqlCommand();

            Command.CommandText = "EXEC ZwrocListeKsiazek @id_rodzaj, @sort;";
            Command.Parameters.AddWithValue("@id_rodzaj", Settings.ID_rodzaj);
            Command.Parameters.AddWithValue("@sort", 1);

            DataGridViewColumn[] Columns = new DataGridViewColumn[3];
            Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[0].DataPropertyName = "tytul_gl";
            Columns[0].Name             = "tytul_gl";
            Columns[0].HeaderText       = _translationsDictionary.getStringFromDictionary("book_title", "Tytuł książki");
            Columns[0].AutoSizeMode     = DataGridViewAutoSizeColumnMode.Fill;

            Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[1].DataPropertyName = "syg";
            Columns[1].Name             = "syg";
            Columns[1].HeaderText       = _translationsDictionary.getStringFromDictionary("signature", "Sygnatura");
            Columns[1].Width            = 150;
            Columns[1].AutoSizeMode     = DataGridViewAutoSizeColumnMode.None;

            Columns[2] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[2].DataPropertyName = "kod";
            Columns[2].Name             = "kod";
            Columns[2].Visible          = false;
            Columns[2].Width            = 0;

            /*Columns[3] = new DataGridViewColumn(new DataGridViewTextBoxCell());
             * Columns[3].DataPropertyName = "wydawca";
             * Columns[3].Name = "wydawca";
             * Columns[3].Visible = false;
             * Columns[3].Width = 0;
             *
             * Columns[4] = new DataGridViewColumn(new DataGridViewTextBoxCell());
             * Columns[4].DataPropertyName = "miasto_w";
             * Columns[4].Name = "miasto_w";
             * Columns[4].Visible = false;
             * Columns[4].Width = 0;
             *
             * Columns[5] = new DataGridViewColumn(new DataGridViewTextBoxCell());
             * Columns[5].DataPropertyName = "rok_wyd";
             * Columns[5].Name = "rok_wyd";
             * Columns[5].Visible = false;
             * Columns[5].Width = 0;
             *
             * Columns[6] = new DataGridViewColumn(new DataGridViewTextBoxCell());
             * Columns[6].DataPropertyName = "autorzy";
             * Columns[6].Name = "autorzy";
             * Columns[6].Visible = false;
             * Columns[6].Width = 0;*/

            ShowForm SF = new ShowForm(Command, Columns);

            SF.ShowRadioButtons();

            WF.Close();

            if (SF.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                if (SF.Dt != null)
                {
                    Clear();

                    ID = SF.Dt.Cells["kod"].Value.ToString();

                    Command = new SqlCommand();
                    Command.Parameters.Clear();
                    Command.CommandText = "EXEC Artykuly_InformacjeOKsiazce @kod; ";
                    Command.Parameters.AddWithValue("@kod", ID);

                    DataTable Dt = CommonFunctions.ReadData(Command, ref Settings.Connection);

                    if (Dt.Rows.Count > 0)
                    {
                        if (!string.IsNullOrEmpty(Dt.Rows[0]["wydawca"].ToString()))
                        {
                            PublisherTextBoxValue = Dt.Rows[0]["wydawca"].ToString();
                        }

                        if (!string.IsNullOrEmpty(Dt.Rows[0]["miasto_w"].ToString()))
                        {
                            PlaceTextBoxValue = Dt.Rows[0]["miasto_w"].ToString();
                        }

                        if (!string.IsNullOrEmpty(Dt.Rows[0]["rok_wyd"].ToString()))
                        {
                            YearTextBoxValue = Dt.Rows[0]["rok_wyd"].ToString();
                        }

                        if (!string.IsNullOrEmpty(Dt.Rows[0]["tytul_gl"].ToString()))
                        {
                            SourceTitleRichTextBoxValue = Dt.Rows[0]["tytul_gl"].ToString();
                        }

                        if (!string.IsNullOrEmpty(Dt.Rows[0]["syg"].ToString()))
                        {
                            SygnaturaTextBoxValue = Dt.Rows[0]["syg"].ToString();
                        }

                        if (!string.IsNullOrEmpty(Dt.Rows[0]["autorzy"].ToString()))
                        {
                            BookAuhorsRichTextBoxValue = Dt.Rows[0]["autorzy"].ToString();
                        }

                        BookAuhorsRichTextBoxReadOnly = true;
                    }

                    SourceTitleRichTextBox.ReadOnly = true;

                    SygnaturaTextBox.ReadOnly        = true;
                    YearTextBox.ReadOnly             = true;
                    PlaceTextBox.ReadOnly            = true;
                    SourceTitleRichTextBox.BackColor = Color.FromArgb(BookAuhorsRichTextBox.BackColor.ToArgb());
                    PublisherTextBox.ReadOnly        = true;
                }
            }
        }
コード例 #3
0
        public static bool ShowAllArticles(ArtykulyForm.ModeEnum CurrentMode, Form mdiParent)
        {
            SqlCommand Command = new SqlCommand();

            Command.CommandText = "EXEC ZwrocListeArtykulow @id_rodzaj;";
            Command.Parameters.AddWithValue("@id_rodzaj", Settings.Search_ID_rodzaj);

            DataGridViewColumn[] Columns = new DataGridViewColumn[7];
            Columns[0] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[0].DataPropertyName = "tytul_artykulu";
            Columns[0].Name             = "tytul_artykulu";
            Columns[0].HeaderText       = _translationsDictionary.getStringFromDictionary("article_title", "Tytuł artykułu");
            Columns[0].MinimumWidth     = 500;

            Columns[1] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[1].DataPropertyName = "tytul_ksiazki";
            Columns[1].Name             = "Tytuł książki";
            Columns[1].HeaderText       = _translationsDictionary.getStringFromDictionary("book_title", "Tytuł książki");
            Columns[1].Width            = 242;

            Columns[2] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[2].DataPropertyName = "tytul_czasopisma";
            Columns[2].Name             = "Tytuł czasopisma";
            Columns[2].HeaderText       = _translationsDictionary.getStringFromDictionary("magazine_title", "Tytuł czasopisma");

            Columns[3] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[3].DataPropertyName = "rodzaj_zas";
            Columns[3].Name             = "rodzaj_zas";
            Columns[3].Visible          = false;

            Columns[4] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[4].DataPropertyName = "kod";
            Columns[4].Name             = "kod";
            Columns[4].Visible          = false;

            Columns[5] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[5].DataPropertyName = "kod_zas";
            Columns[5].Name             = "kod_zas";
            Columns[5].Visible          = false;

            Columns[6] = new DataGridViewColumn(new DataGridViewTextBoxCell());
            Columns[6].DataPropertyName = "id_rodzaj";
            Columns[6].Name             = "id_rodzaj";
            Columns[6].Visible          = false;

            ShowForm SF = new ShowForm(Command, Columns);

            if (SF.ShowDialog() == System.Windows.Forms.DialogResult.OK)
            {
                if (SF.Dt != null)
                {
                    Int32.TryParse(SF.Dt.Cells["id_rodzaj"].Value.ToString().Trim(), out Settings.ID_rodzaj);

                    if (SF.Dt.Cells["rodzaj_zas"].Value.ToString().ToLower().Trim() == "k")
                    {
                        ArtykulyForm AF = new ArtykulyForm(ArtykulyForm.KindEnum.Book, CurrentMode, SF.Dt.Cells["kod"].Value.ToString().Trim());
                        //AF.ShowDialog();

                        AF.MdiParent = mdiParent;
                        AF.Show();

                        return(AF.ShowList);
                    }
                    else if (SF.Dt.Cells["rodzaj_zas"].Value.ToString().ToLower().Trim() == "c")
                    {
                        ArtykulyForm AF = new ArtykulyForm(ArtykulyForm.KindEnum.Magazine, CurrentMode, SF.Dt.Cells["kod"].Value.ToString().Trim());
                        //AF.ShowDialog();
                        AF.MdiParent = mdiParent;
                        AF.Show();

                        return(AF.ShowList);
                    }
                }
            }

            return(false);
        }