private void button1_Click(object sender, EventArgs e)
{
openFileDialog1.ShowDialog();
FileStream f = new FileStream(openFileDialog1.FileName, FileMode.Open);
StreamReader rd = new StreamReader(f);
allDataSet dataset = new allDataSet();
allDataSetTableAdapters.KlientTableAdapter klientTA = new allDataSetTableAdapters.KlientTableAdapter();
klientTA.Fill(dataset.Klient);
string inpstr;
string output = "";
string[] str; int i = 0;
while (((inpstr = rd.ReadLine()) != null) && (i < 20))
{
str = inpstr.Split('\n');
string[] s = str[0].Split('=');
if (i == 16)
{
output += "Номер счета: " + s[1] + Environment.NewLine;
}
if (i == 17)
{
output += "Дата: " + s[1] + Environment.NewLine;
}
if (i == 18)
{
output += "Сумма: " + s[1] + Environment.NewLine;
}
if (i == 19)
{
var c = from obj in dataset.Klient.AsEnumerable() where obj.schet == Convert.ToInt32(s[1]) select obj; foreach (var obj in c)
{
output += "Плательщик: " + obj.SIF + Environment.NewLine;
}
}
i++;
}
MessageBox.Show(output);
}
private void button1_Click(object sender, EventArgs e)
{
openFileDialog1.ShowDialog();
FileStream f = new FileStream(openFileDialog1.FileName, FileMode.Open);
StreamReader rd = new StreamReader(f);
allDataSet dataset = new allDataSet();
allDataSetTableAdapters.KlientTableAdapter klientTA = new allDataSetTableAdapters.KlientTableAdapter();
klientTA.Fill(dataset.Klient);
string inpstr;
string output = "";
string[] str; int i = 0;
while (((inpstr = rd.ReadLine()) != null) && (i < 20))
{
str = inpstr.Split('\n');
string[] s = str[0].Split('=');
if (i == 16) output += "Номер счета: " + s[1] + Environment.NewLine;
if (i == 17) output += "Дата: " + s[1] + Environment.NewLine;
if (i == 18) output += "Сумма: " + s[1] + Environment.NewLine;
if (i == 19) { var c = from obj in dataset.Klient.AsEnumerable() where obj.schet == Convert.ToInt32(s[1]) select obj; foreach (var obj in c) { output += "Плательщик: " + obj.SIF + Environment.NewLine; } }
i++;
}
MessageBox.Show(output);
}
private void button1_Click(object sender, EventArgs e)
{
saveFileDialog1.ShowDialog();
var doc = new Document();
PdfWriter.GetInstance(doc, new FileStream(saveFileDialog1.FileName, FileMode.Create));
doc.Open();
BaseFont baseFont = BaseFont.CreateFont(@"C:\Windows\Fonts\Arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
Paragraph a1 = new Paragraph();
a1.Alignment = Element.ALIGN_LEFT;
a1.SpacingAfter = 20;
a1.Add(new Phrase("firma kosmetics", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
a1.Add(Environment.NewLine + Environment.NewLine);
a1.Add(new Phrase("Ulyanovsk, Russian Federation", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
a1.Add(Environment.NewLine);
Paragraph a2 = new Paragraph();
a2.Alignment = Element.ALIGN_CENTER;
a2.SpacingAfter = 20;
a2.Add(new Phrase("Рекомендуемый товар ", new iTextSharp.text.Font(baseFont, 16, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
a2.Add(new Phrase(" от " + System.DateTime.Now.Date.ToShortDateString() + " г.", new iTextSharp.text.Font(baseFont, 16, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
a2.Add(Environment.NewLine);
PdfPTable table = new PdfPTable(3);
table.HorizontalAlignment = Element.ALIGN_MIDDLE;
table.AddCell(new Phrase("ID", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
table.AddCell(new Phrase("наименование", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
table.AddCell(new Phrase("цена", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
allDataSet ds = new allDataSet();
allDataSetTableAdapters.TovarTableAdapter ta = new allDataSetTableAdapters.TovarTableAdapter();
ta.Fill(ds.Tovar);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
var d = from price in ds.Tovar.AsEnumerable() where price.Field <string>("name") == dataGridView1[1, i].Value.ToString() select price;
foreach (var obj in d)
{
table.AddCell(new Phrase(obj.id.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.name.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.price.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
}
var d2 = from price in ds.Tovar.AsEnumerable() where price.Field <string>("name") == dataGridView1[2, i].Value.ToString() select price;
foreach (var obj in d2)
{
table.AddCell(new Phrase(obj.id.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.name.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.price.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
}
var d3 = from price in ds.Tovar.AsEnumerable() where price.Field <string>("name") == dataGridView1[3, i].Value.ToString() select price;
foreach (var obj in d3)
{
table.AddCell(new Phrase(obj.id.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.name.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.price.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
}
}
Paragraph a6 = new Paragraph(new Phrase("Подпись продавца:_____________", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
a6.Alignment = Element.ALIGN_LEFT;
a6.SpacingBefore = 40;
doc.Add(a1);
doc.Add(a2);
doc.Add(table);
doc.Add(a6);
doc.Close();
MessageBox.Show("Файл сохранен!");
//System.Diagnostics.Process command = new System.Diagnostics.Process();
//command.StartInfo.FileName = @"C:\Program Files\Adobe\Reader 11.0\Reader\acrord32.exe";
//command.StartInfo.Arguments = saveFileDialog1.FileName;
//command.Start();
//command.WaitForExit(3100);
//command.Close();
Vibor v = new Vibor();
v.Show();
}
private void button1_Click(object sender, EventArgs e)
{
saveFileDialog1.ShowDialog();
var doc = new Document();
PdfWriter.GetInstance(doc, new FileStream(saveFileDialog1.FileName, FileMode.Create));
doc.Open();
BaseFont baseFont = BaseFont.CreateFont(@"C:\Windows\Fonts\Arial.ttf", BaseFont.IDENTITY_H, BaseFont.NOT_EMBEDDED);
Paragraph a1 = new Paragraph();
a1.Alignment = Element.ALIGN_LEFT;
a1.SpacingAfter = 20;
a1.Add(new Phrase("firma kosmetics", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
a1.Add(Environment.NewLine + Environment.NewLine);
a1.Add(new Phrase("Ulyanovsk, Russian Federation", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
a1.Add(Environment.NewLine);
Paragraph a2 = new Paragraph();
a2.Alignment = Element.ALIGN_CENTER;
a2.SpacingAfter = 20;
a2.Add(new Phrase("Рекомендуемый товар ", new iTextSharp.text.Font(baseFont, 16, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
a2.Add(new Phrase(" от " + System.DateTime.Now.Date.ToShortDateString() + " г.", new iTextSharp.text.Font(baseFont, 16, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
a2.Add(Environment.NewLine);
PdfPTable table = new PdfPTable(3);
table.HorizontalAlignment = Element.ALIGN_MIDDLE;
table.AddCell(new Phrase("ID", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
table.AddCell(new Phrase("наименование", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
table.AddCell(new Phrase("цена", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.BOLD, new BaseColor(Color.Black))));
allDataSet ds = new allDataSet();
allDataSetTableAdapters.TovarTableAdapter ta = new allDataSetTableAdapters.TovarTableAdapter();
ta.Fill(ds.Tovar);
for (int i = 0; i < dataGridView1.Rows.Count; i++)
{
var d = from price in ds.Tovar.AsEnumerable() where price.Field<string>("name") == dataGridView1[1, i].Value.ToString() select price;
foreach (var obj in d)
{
table.AddCell(new Phrase(obj.id.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.name.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.price.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
}
var d2 = from price in ds.Tovar.AsEnumerable() where price.Field<string>("name") == dataGridView1[2, i].Value.ToString() select price;
foreach (var obj in d2)
{
table.AddCell(new Phrase(obj.id.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.name.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.price.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
}
var d3 = from price in ds.Tovar.AsEnumerable() where price.Field<string>("name") == dataGridView1[3, i].Value.ToString() select price;
foreach (var obj in d3)
{
table.AddCell(new Phrase(obj.id.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.name.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
table.AddCell(new Phrase(obj.price.ToString(), new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
}
}
Paragraph a6 = new Paragraph(new Phrase("Подпись продавца:_____________", new iTextSharp.text.Font(baseFont, 14, iTextSharp.text.Font.NORMAL, new BaseColor(Color.Black))));
a6.Alignment = Element.ALIGN_LEFT;
a6.SpacingBefore = 40;
doc.Add(a1);
doc.Add(a2);
doc.Add(table);
doc.Add(a6);
doc.Close();
MessageBox.Show("Файл сохранен!");
//System.Diagnostics.Process command = new System.Diagnostics.Process();
//command.StartInfo.FileName = @"C:\Program Files\Adobe\Reader 11.0\Reader\acrord32.exe";
//command.StartInfo.Arguments = saveFileDialog1.FileName;
//command.Start();
//command.WaitForExit(3100);
//command.Close();
Vibor v = new Vibor();
v.Show();
}
