protected void Email_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); string name = "", id = "", kol = ""; string name1 = "", id1 = "", kol1 = ""; string name2 = "", id2 = "", kol2 = ""; string name3 = "", id3 = "", kol3 = ""; string name4 = "", id4 = "", kol4 = ""; string dat = DateTime.Now.Date.ToLongDateString(); string dd = DateTime.Now.Day.ToString(); string mm = DateTime.Now.Month.ToString(); string yy = DateTime.Now.Year.ToString(); string hh = DateTime.Now.Hour.ToString() + "час." + DateTime.Now.Minute.ToString() + "мин."; // _wz = Int32.Parse(EventId.Text); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); // DataTable data = db.GetEvent(_wz); DataTable dt = db.GetPartsList(_wz); try { name = dt.Rows[0]["Name"].ToString(); id = dt.Rows[0]["NumID"].ToString(); kol = dt.Rows[0]["Kol"].ToString(); } catch { } try { name1 = dt.Rows[1]["Name"].ToString(); id1 = dt.Rows[1]["NumID"].ToString(); kol1 = dt.Rows[1]["Kol"].ToString(); } catch { } try { name2 = dt.Rows[2]["Name"].ToString(); id2 = dt.Rows[2]["NumID"].ToString(); kol2 = dt.Rows[2]["Kol"].ToString(); } catch { } try { name3 = dt.Rows[3]["Name"].ToString(); id3 = dt.Rows[3]["NumID"].ToString(); kol3 = dt.Rows[3]["Kol"].ToString(); } catch { } try { name4 = dt.Rows[4]["Name"].ToString(); id4 = dt.Rows[4]["NumID"].ToString(); kol4 = dt.Rows[4]["Kol"].ToString(); } catch { } BaseFont baseFont = BaseFont.CreateFont(@"C:\Windows\Fonts\Arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED); PdfReader template = new PdfReader(@"C:\temp\kp.pdf"); // файл шаблона PdfStamper stamper = new PdfStamper(template, new FileStream(@"C:\temp\zkp.pdf", FileMode.Create)); AcroFields fields = stamper.AcroFields; fields.AddSubstitutionFont(baseFont); fields.SetField("dd", dd); fields.SetField("mm", mm); fields.SetField("yy", yy); if (name != "") { fields.SetField("npp1", " 1."); } fields.SetField("name", name); if (name1 != "") { fields.SetField("npp2", " 2."); } fields.SetField("name1", name1); if (name2 != "") { fields.SetField("npp3", " 3."); } fields.SetField("name2", name2); if (name3 != "") { fields.SetField("npp4", " 4."); } fields.SetField("name3", name3); if (name4 != "") { fields.SetField("npp5", " 5."); } fields.SetField("name4", name4); fields.SetField("id", id); fields.SetField("id1", id1); fields.SetField("id2", id2); fields.SetField("id3", id3); fields.SetField("id4", id4); fields.SetField("kol", kol); fields.SetField("kol1", kol1); fields.SetField("kol2", kol2); fields.SetField("kol3", kol3); fields.SetField("kol4", kol4); // fields.SetField("kol1", kol1); fields.SetField("dni", "один"); stamper.FormFlattening = false; // ложь - открыт для записи, истина - закрыт stamper.Close(); // запись в БД FileStream fs = new FileStream(@"C:\temp\zkp.pdf", FileMode.Open); Byte[] pdf = new byte[fs.Length]; fs.Read(pdf, 0, pdf.Length); SqlCommand cmd = new SqlCommand("insert into Documents (Name, NumEvent, Image, NameFile, Status) values (@name, @nev, @img, @namefile, @st )", conn); cmd.Parameters.AddWithValue("name", "запрос КП"); cmd.Parameters.AddWithValue("nev", Id.Text); cmd.Parameters.Add("img", SqlDbType.Image).Value = pdf; cmd.Parameters.Add("namefile", SqlDbType.NVarChar).Value = Id.Text + "/ЗКП.pdf"; cmd.Parameters.AddWithValue("st", "отправлен"); cmd.ExecuteNonQuery(); fs.Close(); // Response.ContentType = "image"; //image/Jpeg // Response.BinaryWrite(pdf); } string text = "Здравствуйте! Вышлите пожалуйста коммерческое предложение на перечень запчастей во вложенном файле"; if (!IsAllSelected(Post)) { List <string> sel = GetSelectedEmails(Post); for (int i = 0; i < sel.Count; i++) { Send(sel[i], text); } } Msg.Text = "Запрос нв КП разослан по выбранным адресам!"; }
protected void Parts_Click(object sender, EventArgs e) { using (SqlConnection conn = new SqlConnection(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString())) { conn.Open(); SqlCommand cmd = new SqlCommand("insert into PartsList (NumEvent, Foto, namefoto, Name, NumID, Kol, Obz) values (@nev, @foto, @namefoto, @name, @numid, @kol, @obz) ", conn); //выбор фото из устройства string namePhoto = FileUpload.FileName; //преобразование в двоичный код byte[] photo = FileUpload.FileBytes; cmd.Parameters.AddWithValue("nev", NumEvent.Text); cmd.Parameters.Add("foto", SqlDbType.Image).Value = photo; cmd.Parameters.Add("namefoto", SqlDbType.NVarChar).Value = namePhoto; cmd.Parameters.AddWithValue("name", Text1.Text); cmd.Parameters.AddWithValue("obz", TextBox1.Text); cmd.Parameters.AddWithValue("numid", Text2.Text); cmd.Parameters.AddWithValue("kol", Text3.Text); cmd.ExecuteNonQuery(); int ei = int.Parse(NumEvent.Text); App_Code.Base db = new App_Code.Base(WebConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()); DataTable dt = db.GetPartsList(ei); try { Name1.Text = dt.Rows[0]["Name"] is DBNull ? "" : dt.Rows[0]["Name"].ToString(); Obz1.Text = dt.Rows[0]["Obz"] is DBNull ? "" : dt.Rows[0]["Obz"].ToString(); ID1.Text = dt.Rows[0]["NumID"] is DBNull ? "" : dt.Rows[0]["NumID"].ToString(); Kol1.Text = dt.Rows[0]["Kol"] is DBNull ? "" : dt.Rows[0]["Kol"].ToString(); } catch { } try { Name2.Text = dt.Rows[1]["Name"] is DBNull ? "" : dt.Rows[1]["Name"].ToString(); Obz2.Text = dt.Rows[1]["Obz"] is DBNull ? "" : dt.Rows[1]["Obz"].ToString(); ID2.Text = dt.Rows[1]["NumID"] is DBNull ? "" : dt.Rows[1]["NumID"].ToString(); Kol2.Text = dt.Rows[1]["Kol"] is DBNull ? "" : dt.Rows[1]["Kol"].ToString(); } catch { } try { Name3.Text = dt.Rows[2]["Name"] is DBNull ? "" : dt.Rows[2]["Name"].ToString(); Obz3.Text = dt.Rows[2]["Obz"] is DBNull ? "" : dt.Rows[2]["Obz"].ToString(); ID3.Text = dt.Rows[2]["NumID"] is DBNull ? "" : dt.Rows[2]["NumID"].ToString(); Kol3.Text = dt.Rows[2]["Kol"] is DBNull ? "" : dt.Rows[2]["Kol"].ToString(); } catch { } try { Name4.Text = dt.Rows[3]["Name"] is DBNull ? "" : dt.Rows[3]["Name"].ToString(); Obz4.Text = dt.Rows[3]["Obz"] is DBNull ? "" : dt.Rows[3]["Obz"].ToString(); ID4.Text = dt.Rows[3]["NumID"] is DBNull ? "" : dt.Rows[3]["NumID"].ToString(); Kol4.Text = dt.Rows[3]["Kol"] is DBNull ? "" : dt.Rows[3]["Kol"].ToString(); } catch { } try { Name5.Text = dt.Rows[4]["Name"].ToString(); Obz5.Text = dt.Rows[4]["Obz"].ToString(); ID5.Text = dt.Rows[4]["NumID"].ToString(); Kol5.Text = dt.Rows[4]["Kol"].ToString(); } catch { } } Text1.Text = ""; Text2.Text = ""; Text3.Text = ""; TextBox1.Text = ""; }