/// <summary>
/// Выделение букета при нажатии ЛКМ и заполнение текстбоксов значениями этого букета. Запоминает выбранный букет.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void listview_Bouquet_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
Clear_Control_SpecialDeals();
try
{
oBouquet = listview_Bouquet.SelectedItem as Bouquets;
button_SpecialDeal_Create.IsEnabled = true;
numericUD_SpecialDeal_Percent.IsEnabled = true;
datepicker.IsEnabled = true;
}
catch
{
System.Windows.Forms.MessageBox.Show("Клиент не выбран!");
}
}
/// <summary>
/// Выделение букета при нажатии ЛКМ и заполнение текстбоксов значениями этого букета. Запоминает выбранный букет.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private async void listview_Bouquet_MouseLeftButtonUp(object sender, MouseButtonEventArgs e)
{
try
{
bouquet = listview_Bouquet.SelectedItem as Bouquets;
grid_Bouquet.DataContext = bouquet;
button_CreateBouquet.IsEnabled = false;
button_UpdateBouquet.IsEnabled = true;
grid_Content.IsEnabled = true;
await Update_ListView_Contents();
Clear_Control_Content();
}
catch
{
System.Windows.Forms.MessageBox.Show("Клиент не выбран!");
}
}
public async Task Delete_Bouquets_Async(Bouquets bouquets)
{
await conn.DeleteAsync(bouquets);
}
public async Task Update_Bouquets_Async(Bouquets bouquets)
{
await conn.UpdateAsync(bouquets);
}
public async Task Insert_Bouquets_Async(Bouquets bouquets)
{
await conn.InsertAsync(bouquets);
}
private async void button_create_stat_Click(object sender, RoutedEventArgs e)
{
for (int i = 0; i < stat_chart.Series.Count; i++)
{
stat_chart.Series.Remove(stat_chart.Series[i]);
}
values = null;
list_pie = new List <PieData>();
List <Orders> list_orders = await oOrdersRepository.Select_All_Orders_Async();
for (int i = 0; i < list_orders.Count; i++)
{
PieData pd = new PieData();
List <Carts> list_carts = await oCartsRepository.Select_Carts_Async("select count,bouquets_id from Carts where orders_id=" + list_orders[i].orders_id);
foreach (var n in list_carts)
{
pd.count = (int)n.count;
pd.bouqet_id = n.bouquets_id;
Bouquets b = await conn.GetAsync <Bouquets>(n.bouquets_id);
pd.name = b.name;
list_pie.Add(pd);
}
}
int min_id = 0;
int max = 0;
int min = 1000000;
int max_id = 0;
for (int i = 0; i < list_pie.Count; i++)
{
if (list_pie[i].count > max)
{
max = list_pie[i].count;
max_id = i;
}
}
for (int i = 0; i < list_pie.Count; i++)
{
if (list_pie[i].count < min)
{
min = list_pie[i].count;
min_id = i;
}
}
List <Bouquets> list_bouq = await oBouquetsRepository.Select_All_Bouquets_Async();
pie_values = new List <KeyValuePair <string, int> >();
string min_name = "";
string max_name = "";
for (int j = 0; j < list_pie.Count; j++)
{
if (j == min_id || j == max_id)
{
pie_values.Add(new KeyValuePair <string, int>(list_pie[j].name, list_pie[j].count));
if (j == min_id)
{
min_name = list_pie[j].name;
}
if (j == max_id)
{
max_name = list_pie[j].name;
}
}
}
createPieSeries_Stat(pie_values);
button_create_stat.IsEnabled = false;
button_excel_stat.IsEnabled = true;
}
/// <summary>
/// создание Excel отчета за день/неделю/месяц/квартал
/// </summary>
/// <param name="values"></param>
/// <param name="win"></param>
/// <param name="conn"></param>
/// <param name="list_day_data"></param>
/// <param name="list_week_data"></param>
/// <param name="list_month_data"></param>
/// <param name="list_quater_data"></param>
public async void Create_Excel_Doc(List <Flovers_WPF.Reply_Window.Data> values, Reply_Window win, SQLite.SQLiteAsyncConnection conn, List <Flovers_WPF.Reply_Window.Data> list_day_data,
List <Flovers_WPF.Reply_Window.Data> list_week_data, List <Flovers_WPF.Reply_Window.Data> list_month_data, List <Flovers_WPF.Reply_Window.Data> list_quater_data)
{
Excel.Application exapp = new Excel.Application();
exapp.SheetsInNewWorkbook = 1;
exapp.Workbooks.Add(Type.Missing);
exapp.DisplayAlerts = true;
exapp.Visible = true;
Excel.Workbooks exappworkbooks = exapp.Workbooks;
Excel.Workbook exappworkbook = exappworkbooks[1];
exappworkbook.Saved = false;
Excel.Sheets excellsheets = exappworkbook.Worksheets;
Excel.Worksheet excellworksheet = (Excel.Worksheet)excellsheets.get_Item(1);
excellworksheet.Activate();
Excel.Range excelcells;
for (int j = 1; j < 4; j++)
{
if (j == 1)
{
excelcells = (Excel.Range)excellworksheet.Cells[1, j];
excelcells.Value2 = "время/дата";
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = true;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (j == 2)
{
excelcells = (Excel.Range)excellworksheet.Cells[1, j];
excelcells.Value2 = "Количество";
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = true;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (j == 3)
{
excelcells = (Excel.Range)excellworksheet.Cells[1, j];
excelcells.Value2 = "Букет";
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = true;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
}
if (values != null)
{
for (int m = 2; m < values.Count + 2; m++)
{
for (int n = 1; n < 4; n++)
{
if (n == 1)
{
excelcells = (Excel.Range)excellworksheet.Cells[m, n];
excelcells.Value2 = values[m - 2].time.ToString();
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = false;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (n == 2)
{
excelcells = (Excel.Range)excellworksheet.Cells[m, n];
excelcells.Value2 = values[m - 2].count.ToString();
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = false;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
if (n == 3)
{
Bouquets b = await conn.GetAsync <Bouquets>(values[m - 2].bouqet_id);
excelcells = (Excel.Range)excellworksheet.Cells[m, n];
excelcells.Value2 = b.name.ToString();
excelcells.Font.Size = 12;
excelcells.Font.Italic = true;
excelcells.Font.Bold = false;
excelcells.HorizontalAlignment = Excel.Constants.xlCenter;
excelcells.VerticalAlignment = Excel.Constants.xlCenter;
}
}
}
Excel.ChartObjects chartsobjrcts = (Excel.ChartObjects)excellworksheet.ChartObjects(Type.Missing);
Excel.ChartObject chartsobj = chartsobjrcts.Add(10, 200, 500, 300);
Excel.Chart excelchart = chartsobj.Chart;
excelcells = excellworksheet.get_Range("A1", "B" + (values.Count + 1).ToString());
excelchart.SetSourceData(excelcells, Type.Missing);
excelchart.ChartType = Excel.XlChartType.xlLine;
excelchart.HasTitle = true;
if (values == list_day_data)
{
excelchart.ChartTitle.Text = "Продажи за день";
}
if (values == list_week_data)
{
excelchart.ChartTitle.Text = "Продажи за неделю";
}
if (values == list_month_data)
{
excelchart.ChartTitle.Text = "Продажи за месяц";
}
if (values == list_quater_data)
{
excelchart.ChartTitle.Text = "Продажи за квартал";
}
excelchart.ChartTitle.Font.Size = 14;
excelchart.ChartTitle.Font.Color = 255;
excelchart.ChartTitle.Shadow = true;
}
else
{
System.Windows.MessageBox.Show("нет данных для отчета");
exapp.Quit();
}
}
