public Text_blocks Select_text_blocks_id(int nid, string nconnection_string) { SqlConnection conn = new SqlConnection(nconnection_string); conn.Open(); string z = "SELECT * FROM Text_blocks WHERE id =" + nid; SqlCommand command2 = new SqlCommand(z, conn); SqlDataReader reader = command2.ExecuteReader(); //int k = 0; //int c = 0; reader.Read(); Text_blocks m = new Text_blocks(Convert.ToInt32(reader.GetValue(0)), Convert.ToInt32(reader.GetValue(1)), Convert.ToString(reader.GetValue(2)), Convert.ToString(reader.GetValue(3)), Convert.ToInt32(reader.GetValue(4)), Convert.ToString(reader.GetValue(5)), Convert.ToString(reader.GetValue(6)), Convert.ToString(reader.GetValue(7)), Convert.ToInt32(reader.GetValue(10)), Convert.ToInt32(reader.GetValue(11)), Convert.ToInt32(reader.GetValue(8)), Convert.ToInt32(reader.GetValue(9)) ); conn.Close(); return(m); }
public List <Text_blocks> Select_text_blocks(string nconnection_string, int Maquette_id) { SqlConnection conn = new SqlConnection(nconnection_string); List <Text_blocks> m = new List <Text_blocks>(); conn.Open(); string s = "SELECT * FROM Text_blocks WHERE id_maquette_fk = " + Maquette_id; SqlCommand command = new SqlCommand(s, conn); SqlDataReader reader = command.ExecuteReader(); int k = 0; //int c = 0; while (reader.Read()) { Text_blocks maq = new Text_blocks(Convert.ToInt32(reader.GetValue(0)), Convert.ToInt32(reader.GetValue(1)), Convert.ToString(reader.GetValue(2)), Convert.ToString(reader.GetValue(3)), Convert.ToInt32(reader.GetValue(4)), Convert.ToString(reader.GetValue(5)), Convert.ToString(reader.GetValue(6)), Convert.ToString(reader.GetValue(7)), Convert.ToInt32(reader.GetValue(8)), Convert.ToInt32(reader.GetValue(9)), Convert.ToInt32(reader.GetValue(10)), Convert.ToInt32(reader.GetValue(11)) ); m.Add(maq); k++; } return(m); }
public Text_blocks Select_text_block(int nid, string nconnection_string) { SqlConnection conn = new SqlConnection(nconnection_string); conn.Open(); string s = "SELECT * FROM Text_blocks WHERE id =" + nid; SqlCommand command = new SqlCommand(s, conn); SqlDataReader reader = command.ExecuteReader(); Text_blocks m = null; while (reader.Read()) { m = new Text_blocks(Convert.ToInt32(reader.GetValue(0)), Convert.ToInt32(reader.GetValue(1)), Convert.ToString(reader.GetValue(2)), Convert.ToString(reader.GetValue(3)), Convert.ToInt32(reader.GetValue(4)), Convert.ToString(reader.GetValue(5)), Convert.ToString(reader.GetValue(6)), Convert.ToString(reader.GetValue(7)), Convert.ToInt32(reader.GetValue(8)), Convert.ToInt32(reader.GetValue(9)), Convert.ToInt32(reader.GetValue(10)), Convert.ToInt32(reader.GetValue(11)) ); } return(m); }
public Report Create_maquette_fasrreport(int nid) { Maquette m = new Maquette(); m = m.Select_maquette_id(nid, connection_string); Format f = new Format(); f = f.Select_format_id(m.id_fk_format, connection_string); Add_report_page(f.Width, f.Height); report.Pages.Add(page[0]); page[0].ReportTitle = new ReportTitleBand(); page[0].ReportTitle.Name = "lkjhljkhlhnljkn"; // set its height to 1.5cm page[0].ReportTitle.Height = Units.Millimeters * f.Height; PictureObject picture = new PictureObject(); //picture.ForceLoadImage("C://Users//Svetlana//Desktop//1.jpg"); float w = Convert.ToSingle(Math.Round(f.Width * 3.8)); float h = Convert.ToSingle(Math.Round(f.Height * 3.8)); picture.Bounds = new RectangleF(0, 0, w, h); //Set object bounds String s = Environment.CurrentDirectory + "\\Maquette\\" + m.Background_image; // Bitmap b1 = new Bitmap(s); // Bitmap b2 = new Bitmap(b1, new Size(f.Width*4, f.Height*4)); // picture.Image = b2; //Set picture picture.Image = new Bitmap(s); //Set picture page[0].ReportTitle.Objects.Add(picture); Text_blocks t = new Text_blocks(); List <Text_blocks> tb = t.Select_text_blocks(connection_string, nid); for (int i = 0; i < tb.Count; i++) { TextObject txt = new TextObject(); float wt = Convert.ToSingle(Math.Round(tb[i].Width * 3.8)); float ht = Convert.ToSingle(Math.Round(tb[i].Height * 3.8)); txt.Bounds = new RectangleF(tb[i].X, tb[i].Y, wt, ht); txt.Text = tb[i].Content; if (tb[i].Alignment_text.Trim() == "По левому краю") { txt.HorzAlign = HorzAlign.Left; /*По левому краю*/ } else if (tb[i].Alignment_text.Trim() == "По центру") { txt.HorzAlign = HorzAlign.Center; //По центру } else if (tb[i].Alignment_text.Trim() == "По правому краю") { txt.HorzAlign = HorzAlign.Right; //По правому краю } else if (tb[i].Alignment_text.Trim() == "По ширине") { txt.HorzAlign = HorzAlign.Justify; //По ширине } FontStyle styl = FontStyle.Regular; if (tb[i].Mark_text.Trim() == "Bold") { styl = FontStyle.Bold; } else if (tb[i].Mark_text.Trim() == "Italic") { styl = FontStyle.Italic; } else if (tb[i].Mark_text.Trim() == "Underline") { styl = FontStyle.Underline; } else if (tb[i].Mark_text.Trim() == "Regular") { styl = FontStyle.Regular; } else if (tb[i].Mark_text.Trim() == "Strikeout") { styl = FontStyle.Strikeout; } FontFamily fam = new FontFamily(tb[i].Font_type); txt.Font = new Font(fam, tb[i].Font_size, styl); page[0].ReportTitle.Objects.Add(txt); } Image_blocks im = new Image_blocks(); List <Image_blocks> bl = im.Select_image_blocks(connection_string, nid); for (int i = 0; i < bl.Count; i++) { PictureObject pict = new PictureObject(); //picture.ForceLoadImage("C://Users//Svetlana//Desktop//1.jpg"); float wp = Convert.ToSingle(Math.Round(bl[i].Width * 3.8)); float hp = Convert.ToSingle(Math.Round(bl[i].Height * 3.8)); pict.Bounds = new RectangleF(0, 0, wp, hp); //Set object bounds String sp = Environment.CurrentDirectory + "\\Image_blocks\\" + bl[i].Image_content; // Bitmap b1 = new Bitmap(s); // Bitmap b2 = new Bitmap(b1, new Size(f.Width*4, f.Height*4)); // picture.Image = b2; //Set picture pict.Image = new Bitmap(sp); //Set picture page[0].ReportTitle.Objects.Add(pict); } return(report); }