private void button5_Click(object sender, EventArgs e)
{
saveFileDialog1.ShowDialog();
KURS.allDataSet kursDataSet = new KURS.allDataSet();
KURS.allDataSetTableAdapters.TovarTableAdapter TovarTableAdapter = new KURS.allDataSetTableAdapters.TovarTableAdapter();
TovarTableAdapter.Fill(kursDataSet.Tovar);
TextDocument textdocument = new TextDocument();
textdocument.New();
Paragraph headerText1 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
headerText1.TextContent.Add(new SimpleText(textdocument, "firma kosmetics"));
textdocument.Content.Add(headerText1);
Paragraph headerText2 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
headerText2.TextContent.Add(new SimpleText(textdocument, "Ulyanovsk, Russian Federation"));
textdocument.Content.Add(headerText2);
Paragraph headerText3 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
headerText3.TextContent.Add(new SimpleText(textdocument, "Кому: " + listBox1.Text));
textdocument.Content.Add(headerText3);
var d = from price in kursDataSet.Tovar.AsEnumerable() where price.kolvo == 0 select price;
Paragraph maintext = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
maintext.TextContent.Add(new SimpleText(textdocument, "ID--name--srok--price" + Environment.NewLine));
textdocument.Content.Add(maintext);
foreach (var obj in d)
{
Paragraph maintext2 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
maintext2.TextContent.Add(new SimpleText(textdocument, obj.id.ToString() + "--" + obj.name.ToString() + "--" + obj.srok.ToString() + "--" + obj.price.ToString() + Environment.NewLine));
textdocument.Content.Add(maintext2);
}
Paragraph footerText = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
footerText.TextContent.Add(new SimpleText(textdocument, "Подпись продавца:_____________"));
textdocument.Content.Add(footerText);
textdocument.SaveTo(saveFileDialog1.FileName);
}
private void button5_Click(object sender, EventArgs e)
{
saveFileDialog1.ShowDialog();
KURS.allDataSet kursDataSet = new KURS.allDataSet();
KURS.allDataSetTableAdapters.TovarTableAdapter TovarTableAdapter = new KURS.allDataSetTableAdapters.TovarTableAdapter();
TovarTableAdapter.Fill(kursDataSet.Tovar);
TextDocument textdocument = new TextDocument();
textdocument.New();
Paragraph headerText1 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
headerText1.TextContent.Add(new SimpleText(textdocument, "firma kosmetics"));
textdocument.Content.Add(headerText1);
Paragraph headerText2 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
headerText2.TextContent.Add(new SimpleText(textdocument, "Ulyanovsk, Russian Federation"));
textdocument.Content.Add(headerText2);
Paragraph headerText3 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
headerText3.TextContent.Add(new SimpleText(textdocument, "Кому: " + listBox1.Text));
textdocument.Content.Add(headerText3);
var d = from price in kursDataSet.Tovar.AsEnumerable() where price.kolvo == 0 select price;
Paragraph maintext = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
maintext.TextContent.Add(new SimpleText(textdocument, "ID--name--srok--price"+Environment.NewLine));
textdocument.Content.Add(maintext);
foreach (var obj in d)
{
Paragraph maintext2 = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
maintext2.TextContent.Add(new SimpleText(textdocument, obj.id.ToString() + "--" + obj.name.ToString() + "--" + obj.srok.ToString() + "--" + obj.price.ToString() + Environment.NewLine));
textdocument.Content.Add(maintext2);
}
Paragraph footerText = ParagraphBuilder.CreateStandardTextParagraph(textdocument);
footerText.TextContent.Add(new SimpleText(textdocument, "Подпись продавца:_____________"));
textdocument.Content.Add(footerText);
textdocument.SaveTo(saveFileDialog1.FileName);
}
private void diagram_Click(object sender, EventArgs e)
{
KURS.allDataSet kursds = new KURS.allDataSet();
KURS.allDataSetTableAdapters.ZakazTableAdapter zta = new KURS.allDataSetTableAdapters.ZakazTableAdapter();
zta.Fill(kursds.Zakaz);
//
object misValue = System.Reflection.Missing.Value;
//
Excel.Application excelapp = new Excel.Application();
excelapp.Visible = true;
excelapp.SheetsInNewWorkbook = 1;
excelapp.Workbooks.Add(misValue);
Excel.Workbooks excelappworkbooks = excelapp.Workbooks;
Excel.Workbook excelappworkbook = excelappworkbooks[1];
Excel.Sheets excelsheets = excelappworkbook.Worksheets;
Excel.Worksheet excelworksheet = (Excel.Worksheet)excelsheets.get_Item(1);
//excelworksheet.Activate();
//
var c = from p in kursds.Zakaz.AsEnumerable() where p.Data.Month == dateTimePicker1.Value.Month select p;
int count = 0;
excelapp.Cells[1][1] = "date";
excelapp.Cells[2][1] = "summ";
foreach (var p in c)
{
count++;
}
//
int[] a = new int[count]; double[] b = new double[count]; int i = 0; double sum = 0;
while (i < count)
{
foreach (var p in c)
{
a[i] = p.Data.Day;
if (i == 0)
{
sum += p.Summ;
}
if (i > 0)
{
if (a[i] == a[i - 1])
{
sum += p.Summ;
}
else
{
b[i - 1] = sum; sum = p.Summ; i++;
}
}
else
{
i++;
}
}
b[i - 1] = sum;
count = i; i = 0;
break;
}
Dictionary <int, double> dic = new Dictionary <int, double>();
while (i < count)
{
excelapp.Cells[1][i + 2] = a[i];
excelapp.Cells[2][i + 2] = b[i];
dic.Add(a[i], b[i]);
i++;
}
//
string str = (count + 1).ToString();
//
//Excel.Window excelWindow = null;
Excel.Range excelcells = null;
//Определяем диаграммы как объекты Excel.ChartObjects
Excel.ChartObjects chartsobjrcts = (Excel.ChartObjects)excelworksheet.ChartObjects(Type.Missing);
//Добавляем одну диаграмму в Excel.ChartObjects - диаграмма пока не выбрана, но место для нее выделено в методе Add
Excel.ChartObject chartsobjrct = chartsobjrcts.Add(100, 40, 300, 300);
Excel.Chart chartPage = chartsobjrct.Chart;
excelcells = excelworksheet.get_Range("B1", "B" + str);
chartPage.SetSourceData(excelcells, misValue);
chartPage.ChartType = Excel.XlChartType.xlColumnClustered;
Excel.Axis axis = (Excel.Axis)chartPage.Axes(Excel.XlAxisType.xlCategory, Excel.XlAxisGroup.xlPrimary);
axis.HasTitle = true;
axis.AxisTitle.Text = "Data";
//
Excel.SeriesCollection seriesCollection = (Excel.SeriesCollection)chartPage.SeriesCollection(Type.Missing);
Excel.Series series = seriesCollection.Item(1);
series.XValues = a;
//
excelappworkbook.SaveAs(@"D:\siple.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
excelappworkbook.Close(true, misValue, misValue);
excelapp.Quit();
this.chart1.Titles.Add("Отчет за месяц");
this.chart1.Series[0].Points.Clear();
Series ser = this.chart1.Series[0];
ser.LegendText = "Summ";
foreach (KeyValuePair <int, double> pair in dic)
{
ser.Points.AddXY(pair.Key, pair.Value);
}
//
}
private void diagram_Click(object sender, EventArgs e)
{
KURS.allDataSet kursds = new KURS.allDataSet();
KURS.allDataSetTableAdapters.ZakazTableAdapter zta = new KURS.allDataSetTableAdapters.ZakazTableAdapter();
zta.Fill(kursds.Zakaz);
//
object misValue = System.Reflection.Missing.Value;
//
Excel.Application excelapp = new Excel.Application();
excelapp.Visible = true;
excelapp.SheetsInNewWorkbook = 1;
excelapp.Workbooks.Add(misValue);
Excel.Workbooks excelappworkbooks = excelapp.Workbooks;
Excel.Workbook excelappworkbook = excelappworkbooks[1];
Excel.Sheets excelsheets = excelappworkbook.Worksheets;
Excel.Worksheet excelworksheet = (Excel.Worksheet)excelsheets.get_Item(1);
//excelworksheet.Activate();
//
var c = from p in kursds.Zakaz.AsEnumerable()where p.Data.Month==dateTimePicker1.Value.Month select p;
int count=0;
excelapp.Cells[1][1] = "date";
excelapp.Cells[2][1] = "summ";
foreach (var p in c)
{
count++;
}
//
int[] a = new int[count]; double[] b = new double[count]; int i = 0; double sum=0;
while (i < count)
{
foreach (var p in c)
{
a[i] = p.Data.Day;
if (i == 0) { sum += p.Summ; }
if (i > 0)
{
if (a[i] == a[i - 1]) sum += p.Summ;
else { b[i - 1] = sum; sum = p.Summ; i++; }
}
else i++;
}
b[i-1] = sum;
count = i; i = 0;
break;
}
Dictionary<int, double> dic = new Dictionary<int, double>();
while (i < count)
{
excelapp.Cells[1][i+2] = a[i];
excelapp.Cells[2][i+2] = b[i];
dic.Add(a[i], b[i]);
i++;
}
//
string str = (count+1).ToString();
//
//Excel.Window excelWindow = null;
Excel.Range excelcells = null;
//Определяем диаграммы как объекты Excel.ChartObjects
Excel.ChartObjects chartsobjrcts = (Excel.ChartObjects)excelworksheet.ChartObjects(Type.Missing);
//Добавляем одну диаграмму в Excel.ChartObjects - диаграмма пока не выбрана, но место для нее выделено в методе Add
Excel.ChartObject chartsobjrct = chartsobjrcts.Add(100, 40, 300, 300);
Excel.Chart chartPage = chartsobjrct.Chart;
excelcells = excelworksheet.get_Range("B1", "B"+str);
chartPage.SetSourceData(excelcells, misValue);
chartPage.ChartType = Excel.XlChartType.xlColumnClustered;
Excel.Axis axis = (Excel.Axis)chartPage.Axes(Excel.XlAxisType.xlCategory,Excel.XlAxisGroup.xlPrimary);
axis.HasTitle = true;
axis.AxisTitle.Text = "Data";
//
Excel.SeriesCollection seriesCollection = (Excel.SeriesCollection)chartPage.SeriesCollection(Type.Missing);
Excel.Series series = seriesCollection.Item(1);
series.XValues = a;
//
excelappworkbook.SaveAs(@"D:\siple.xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
excelappworkbook.Close(true, misValue, misValue);
excelapp.Quit();
this.chart1.Titles.Add("Отчет за месяц");
this.chart1.Series[0].Points.Clear();
Series ser = this.chart1.Series[0];
ser.LegendText = "Summ";
foreach (KeyValuePair<int, double> pair in dic)
{
ser.Points.AddXY(pair.Key, pair.Value);
}
//
}