/// <summary> /// Запрашивает статью из DB и возвращает <see cref="Statiya"/> /// </summary> /// <param name="ArticleName">Точное название статьи</param> /// <returns><see cref="Statiya"/> полученная из DB</returns> public static Statiya GetStatiyaFromArticleName(string ArticleName) { MySqlCommand cmd = new MySqlCommand("SELECT Header, Author, Category, Text, Picture FROM " + Tables.ARTICLES + " WHERE `Header` = '" + ArticleName + "'", SQLClass.CONN); MySqlDataReader rdr = cmd.ExecuteReader(); rdr.Read(); Statiya Stat = new Statiya { ArticleName = rdr[0].ToString(), AuthorName = rdr[1].ToString(), Category = rdr[2].ToString(), Text = rdr[3].ToString() }; if (rdr[4].ToString() != "") { Stat.PictureURL = rdr[4].ToString(); } else { Stat.PictureURL = null; } rdr.Close(); return(Stat); }
public static void Label3_Click(object sender, EventArgs e) { Statiya stat = Statiya.GetStatiyaFromArticleName(((Label)sender).Text); StatiyaForm form = new StatiyaForm(stat); form.ShowDialog(); }
private void ArticleClick(object sender, EventArgs e) { foreach (LinkLabel lab in arts) { if (sender.Equals(lab)) { List <String> ArticleInfo = SQLClass.Select( "SELECT Header, Author, Category, Text, Picture FROM " + Tables.ARTICLES + " WHERE header = '" + lab.Text + "'"); for (int artIndex = 0; artIndex < ArticleInfo.Count; artIndex += 5) { Statiya stat = new Statiya(); stat.ArticleName = ArticleInfo[artIndex].ToString(); stat.AuthorName = ArticleInfo[artIndex + 1].ToString(); stat.Category = ArticleInfo[artIndex + 2].ToString(); stat.Text = ArticleInfo[artIndex + 3].ToString(); //FIXME!!! Show ternarny operator stat.PictureURL = (ArticleInfo[artIndex + 4].ToString() != "") ? ArticleInfo[artIndex + 4].ToString() : null; StatiyaForm OknoStatiya = new StatiyaForm(stat, true); OknoStatiya.ShowDialog(); } } } }
private void label1_MouseEnter(object sender, EventArgs e) { Statiya stat = Statiya.GetStatiyaFromArticleName(((Label)sender).Text); pictureBox1.Visible = true; pictureBox1.Load(stat.PictureURL); pictureBox1.Size = new Size(100, 100); }
public VipStatiy(Statiya stat) { InitializeComponent(); name.Text = stat.ArticleName; kategoriy.Text = stat.Category; s = stat.Text; label2.Text = stat.AuthorName; }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { try { new StatiyaForm(Statiya.GetStatiyaFromArticleName(Article)).ShowDialog(); } catch { MessageBox.Show("Такой статьи нет!"); } }
void Label_Click(object sender, EventArgs e) { /* foreach (newPage Label_ in ListOfPages) * {*/ Statiya stat = Statiya.GetStatiyaFromArticleName(((Label)sender).Text); StatiyaForm form = new StatiyaForm(stat); form.ShowDialog(); // } }
private static void label1_MouseEnter(object sender, EventArgs e) { pictureBox1.Location = new Point(((Label)sender).Location.X + 120, ((Label)sender).Location.Y); Statiya stat = Statiya.GetStatiyaFromArticleName(((Label)sender).Text); if (!String.IsNullOrEmpty(stat.PictureURL) && stat.PictureURL != null) { pictureBox1.Visible = true; pictureBox1.ImageLocation = stat.PictureURL; pictureBox1.Load(); pictureBox1.Size = new Size(90, 70); } }
public StatiyaForm(Statiya stat, bool YaAvtor = false) { InitializeComponent(); mainTableLayoutPanel.Controls.RemoveByKey("UCref"); UCFunctions.AddUC(this); avtor = YaAvtor; Kategoriatext.Enabled = avtor; Stattext.Enabled = avtor; redact.Visible = avtor; Head = stat.ArticleName; Maintext.Text = stat.ArticleName; Kategoriatext.Text = stat.Category; Stattext.Text = stat.Text; Kategoriatext.Font = Configs.ZAGOLOVOK_FONT; Authortext.Font = Configs.ZAGOLOVOK_FONT; /*List<String> ids = SQLClass.Select("SELECT MAX(Artic_ID + 1) FROM " + Tables.ARTICLES); * id = ids[0]; * * SQLClass.Insert("INSERT INTO " + Tables.ARTICLES + * "(Header, Category, Author, Text)" + * " VALUES ('" + Maintext.Text + "'," + * "'" + Kategoriatext.Text + "'," + * "'" + Stattext.Text + "'," + * " 1)"); * SQLClass.Update("UPDATE " + Tables.AUTHORS + "'");*/ GetStata(labelLike, labeldis, Maintext.Text); try { pictureBox1.LoadAsync(stat.PictureURL); } catch (Exception) { pictureBox1.Image = new Bitmap("defolt_statiy.jpg"); } Authortext.Text = stat.AuthorName; pictureBoxLike.Image = Properties.Resources.like; pictureBoxDislike.Image = Properties.Resources.Dislike; }
private void ArticleClick(object sender, EventArgs e) { foreach (LinkLabel lab in arts) { if (sender.Equals(lab)) { Statiya stat = Statiya.GetStatiyaFromArticleName(((Label)sender).Text); StatiyaForm OknoStatiya = new StatiyaForm(stat); OknoStatiya.ShowDialog(); LAST_SEARCH = textBox_search.Text; formloader(sender, e); break; } } }
private void clik_na_pic(object sender, EventArgs e) { GC.Collect(); GC.WaitForPendingFinalizers(); foreach (PictureBox lab in piccc) { if (sender.Equals(lab)) { Statiya stat = Statiya.GetStatiyaFromArticleName(lab.Tag.ToString()); //StatiyaForm OknoStatiya = new StatiyaForm(stat); VipStatiy OknoStatiya = new VipStatiy(stat); OknoStatiya.ShowDialog(); formloader(sender, e); break; } } }