public static void createReport(int id_hardware, DateTime startDate, DateTime endDate, string strType, int type, List <string> listFilter) { DataTable dtReport = new DataTable(); if (id_hardware != 0) { dtReport = readSQL.getReportHistory(id_hardware, null, null, null); } else { dtReport = readSQL.getReportHistory(id_hardware, startDate, endDate, type); } if (dtReport == null) { MessageBox.Show("Нет данных для выгрузки!", "Информирование");; return; } if (dtReport.Rows.Count == 0) { MessageBox.Show("Нет данных для выгрузки!", "Информирование");; return; } if (listFilter != null) { EnumerableRowCollection <DataRow> rowsFind = dtReport.AsEnumerable().Where(r => listFilter.Contains(r.Field <string>("cName").Trim())); if (rowsFind.Count() == 0) { MessageBox.Show("Нет данных для выгрузки!", "Информирование");; return; } dtReport = rowsFind.CopyToDataTable(); } Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; string[] listTitle = new string[] { "Инв. номер", @"Оборудование\Комплектующее", @"Наименование оборуд.\комплект.", @"Дата добавления оборудования", "Параметр", "Значение До", "Значение после", "Время изменения", "Кто изменил" }; report.Merge(indexRow, 1, indexRow, listTitle.Length); report.AddSingleValue("Отчёт по изменению в оборудовании", indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetFontBold(indexRow, 1, indexRow, 1); indexRow++; if (id_hardware == 0) { report.Merge(indexRow, 1, indexRow, listTitle.Length); report.AddSingleValue("Период с " + startDate.ToShortDateString() + " по " + endDate.ToShortDateString() + "", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, listTitle.Length); report.AddSingleValue("Условие: " + strType, indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, listTitle.Length); report.AddSingleValue("Дата и время выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, listTitle.Length); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; indexRow++; int startPos = indexRow; for (int i = 0; i < listTitle.Length; i++) { report.AddSingleValue(listTitle[i], indexRow, i + 1); report.SetBorders(indexRow, i + 1, indexRow, i + 1); report.SetCellAlignmentToCenter(indexRow, i + 1, indexRow, i + 1); } indexRow++; //EnumerableRowCollection<DataRow> var rowCollect = from hosp in dtReport.AsEnumerable() group hosp by new { id_jHardware = hosp["id_jHardware"], id_Creator = hosp["id_Creator"], DateCreate = hosp["DateCreate"] } into grp orderby grp.Key.id_jHardware ascending, grp.Key.DateCreate ascending select new { id_jHardware = grp.Key.id_jHardware, id_Creator = grp.Key.id_Creator, DateCreate = grp.Key.DateCreate, }; foreach (var rC in rowCollect) { DataRow[] row = dtReport.Select(string.Format("id_jHardware = {0} and id_Creator = {1} AND DateCreate = '{2}'", rC.id_jHardware, rC.id_Creator, rC.DateCreate)); report.Merge(indexRow, 1, indexRow + row.Count() - 1, 1); report.Merge(indexRow, 2, indexRow + row.Count() - 1, 2); report.Merge(indexRow, 3, indexRow + row.Count() - 1, 3); report.Merge(indexRow, 8, indexRow + row.Count() - 1, 8); report.Merge(indexRow, 9, indexRow + row.Count() - 1, 9); report.AddSingleValue(row[0]["InventoryNumber"].ToString(), indexRow, 1); report.AddSingleValue(row[0]["TypeComponentsHardware"].ToString(), indexRow, 2); report.AddSingleValue(row[0]["nameOb"].ToString(), indexRow, 3); report.AddSingleValue(row[0]["DateCreate"].ToString(), indexRow, 8); report.AddSingleValue(row[0]["FIO"].ToString(), indexRow, 9); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, 9); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); report.SetCellAlignmentToCenter(indexRow, 2, indexRow, 2); report.SetCellAlignmentToCenter(indexRow, 3, indexRow, 3); report.SetCellAlignmentToCenter(indexRow, 8, indexRow, 8); report.SetCellAlignmentToCenter(indexRow, 9, indexRow, 9); foreach (DataRow r in row) { report.AddSingleValue(r["DateCreateHardWare"].ToString(), indexRow, 4); report.AddSingleValue(r["cName"].ToString(), indexRow, 5); report.AddSingleValue(r["valueOld"].ToString(), indexRow, 6); report.AddSingleValue(r["valueNew"].ToString(), indexRow, 7); report.SetCellAlignmentToCenter(indexRow, 4, indexRow, 4); if ((bool)r["isDeleteRow"]) { report.SetCellColor(indexRow, 1, indexRow, listTitle.Length, Color.Green); } report.SetBorders(indexRow, 1, indexRow, listTitle.Length); indexRow++; } } indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, Color.Green); report.AddSingleValue("Удалённые записи", indexRow, 2); /* * foreach (DataRow r in dtReport.Rows) * { * report.AddSingleValue(r["InventoryNumber"].ToString(), indexRow, 1); * report.AddSingleValue(r["TypeComponentsHardware"].ToString(), indexRow, 2); * report.AddSingleValue(r["nameOb"].ToString(), indexRow, 3); * report.AddSingleValue(r["cName"].ToString(), indexRow, 4); * report.AddSingleValue(r["valueOld"].ToString(), indexRow, 5); * report.AddSingleValue(r["valueNew"].ToString(), indexRow, 6); * report.AddSingleValue(r["DateCreate"].ToString(), indexRow, 7); * report.AddSingleValue(r["FIO"].ToString(), indexRow, 8); * report.SetBorders(indexRow, 1, indexRow, listTitle.Length); * indexRow++; * } */ report.SetColumnAutoSize(startPos, 1, indexRow, listTitle.Length); report.Show(); }
private async void btPrint_Click(object sender, EventArgs e) { if (dtData == null || dtData.Rows.Count == 0 || dtData.DefaultView.Count == 0) { MessageBox.Show("Нет данных для формирования отчёта.", "Печать", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; blockers.SaveControlsEnabledState(this); blockers.SetControlsEnabled(this, false); //progressBar1.Visible = true; var result = await Task <bool> .Factory.StartNew(() => { foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals(cName.Name)) { setWidthColumn(indexRow, maxColumns, 37, report); } if (col.Name.Equals(cUnit.Name)) { setWidthColumn(indexRow, maxColumns, 17, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, 1); report.SetRowHeight(indexRow, 1, indexRow, 1, 45); report.AddSingleValue($"{this.Text}", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; config.DoOnUIThread(() => { //report.Merge(indexRow, 1, indexRow, maxColumns); //report.AddSingleValue($"Период с {dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()} ", indexRow, 1); //indexRow++; //report.Merge(indexRow, 1, indexRow, maxColumns); //report.AddSingleValue($"Объект: {cmbObject.Text}", indexRow, 1); //indexRow++; //report.Merge(indexRow, 1, indexRow, maxColumns); //report.AddSingleValue($"Тип договора: {cmbTypeDoc.Text}", indexRow, 1); //indexRow++; if (tbName.Text.Trim().Length != 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтр: {(tbName.Text.Trim().Length != 0 ? $"EAN:{tbName.Text.Trim()} " : "")}", indexRow, 1); indexRow++; } }, this); report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dtData.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal || row[col.DataPropertyName] is double) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } if (!(bool)row["isActive"]) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel1.BackColor); } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; } indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbNotActive.Text}", indexRow, 2); config.DoOnUIThread(() => { blockers.RestoreControlEnabledState(this); //progressBar1.Visible = false; }, this); report.Show(); return(true); }); }
private async void btPrint_Click(object sender, EventArgs e) { report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; blockers.SaveControlsEnabledState(this); blockers.SetControlsEnabled(this, false); progressBar1.Visible = true; var result = await Task <bool> .Factory.StartNew(() => { foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals(cDeps.Name)) { setWidthColumn(indexRow, maxColumns, 13, report); } if (col.Name.Equals(cGrp1.Name)) { setWidthColumn(indexRow, maxColumns, 13, report); } if (col.Name.Equals(cGrp2.Name)) { setWidthColumn(indexRow, maxColumns, 14, report); } if (col.Name.Equals(cEan.Name)) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals(cName.Name)) { setWidthColumn(indexRow, maxColumns, 40, report); } if (col.Name.Equals(cPrice.Name)) { setWidthColumn(indexRow, maxColumns, 11, report); } if (col.Name.Equals(cGrp3.Name)) { setWidthColumn(indexRow, maxColumns, 11, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{this.Text}", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; Config.DoOnUIThread(() => { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Магазин: {cmbShop.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отдел: {cmbDeps.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Т/У группа: {cmbGrp1.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Инв. группа: {cmbGrp2.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Подгруппы: {cmbGrp3.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Новый товар: {(chbNewGoods.Checked ? "Да":"Нет")}", indexRow, 1); indexRow++; if (tbEan.Text.Trim().Length != 0 || tbName.Text.Trim().Length != 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтр: {(tbEan.Text.Trim().Length != 0 ? $"EAN:{tbEan.Text.Trim()} | " : "")} {(tbName.Text.Trim().Length != 0 ? $"Наименование:{tbName.Text.Trim()}" : "")}", indexRow, 1); indexRow++; } }, this); //report.Merge(indexRow, 1, indexRow, maxColumns); //report.AddSingleValue($"Должность: {cmbPost.Text}", indexRow, 1); //indexRow++; //report.Merge(indexRow, 1, indexRow, maxColumns); //report.AddSingleValue($"Место работы: {(rbOffice.Checked ? rbOffice.Text : rbUni.Text)}", indexRow, 1); //indexRow++; //report.Merge(indexRow, 1, indexRow, maxColumns); //report.AddSingleValue($"Статус сотрудника: {(rbWork.Checked ? rbWork.Text : rbUnemploy.Text)}", indexRow, 1); //indexRow++; //if (tbPostName.Text.Trim().Length != 0 || tbKadrName.Text.Trim().Length != 0) //{ // report.Merge(indexRow, 1, indexRow, maxColumns); // report.AddSingleValue($"Фильтр: {(tbPostName.Text.Trim().Length != 0 ? $"Должность:{tbPostName.Text.Trim()} | " : "")} {(tbKadrName.Text.Trim().Length != 0 ? $"ФИО:{tbKadrName.Text.Trim()}" : "")}", indexRow, 1); // indexRow++; //} report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dtData.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal || row[col.DataPropertyName] is double) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } if (chbReserv.Checked && new List <int>(new int[] { 1, 3 }).Contains((int)row["ntypetovar"])) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel1.BackColor); } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; } if (chbReserv.Checked) { indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbReserv.Text}", indexRow, 2); } Config.DoOnUIThread(() => { blockers.RestoreControlEnabledState(this); progressBar1.Visible = false; }, this); report.Show(); return(true); }); }
private void btPrint_Click(object sender, EventArgs e) { Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals("cName")) { setWidthColumn(indexRow, maxColumns, 20, report); } if (col.Name.Equals("cDeps")) { setWidthColumn(indexRow, maxColumns, 22, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Справочник подгрупп", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отдел: {cmbDeps.Text}", indexRow, 1); indexRow++; if (tbName.Text.Trim().Length > 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтр: {tbName.Text}", indexRow, 1); indexRow++; } //if (tbAgreements.Text.Trim().Length > 0 || tbTenant.Text.Trim().Length > 0 || tbPlace.Text.Trim().Length > 0) //{ // report.Merge(indexRow, 1, indexRow, maxColumns); // report.AddSingleValue($"Фильтры: " + // $"{(tbTenant.Text.Trim().Length == 0 ? "" : "Арендатор: " + tbTenant.Text.Trim())} " + // $"{(tbPlace.Text.Trim().Length == 0 ? "" : " Местоположение места аренды: " + tbPlace.Text.Trim())} " + // $"{(tbAgreements.Text.Trim().Length == 0 ? "" : " Номер договора: " + tbAgreements.Text.Trim())}", indexRow, 1); // indexRow++; //} report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dtData.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); if (!(bool)row["isActive"]) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel1.BackColor); } indexRow++; } indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbNotActive.Text}", indexRow, 2); report.Show(); }
private void addTabExcel(int id_otdel, string nameDep) { int indexRow = 1; int maxColumns = 0; DataTable dtReport = dtData.DefaultView.ToTable(); if (id_otdel != 0) { dtReport.DefaultView.RowFilter = $"id_otdel = {id_otdel}"; } if (dtReport.DefaultView.Count == 0) { return; } if (report == null) { report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); report.changeNameTab($"{nameDep}"); } else { report.GoToNextSheet($"{nameDep}"); } Config.DoOnUIThread(() => { foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals(cDeps.Name)) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals(cEan.Name)) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals(cName.Name)) { setWidthColumn(indexRow, maxColumns, 30, report); } if (col.Name.Equals(cPriceK21.Name)) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals(cPriceX14.Name)) { setWidthColumn(indexRow, maxColumns, 17, report); } if (col.Name.Equals(cDelta.Name)) { setWidthColumn(indexRow, maxColumns, 17, report); } } } }, this); #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отчёт по расхождениям продажных цен по товарам", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; Config.DoOnUIThread(() => { if (chbPeriod.Checked) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Продажи с {dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()}", indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отдел: {cmbDeps.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Т/У группа: {cmbGrp1.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Инв. группа: {cmbGrp2.Text}", indexRow, 1); indexRow++; if (tbEan.Text.Trim().Length != 0 || tbName.Text.Trim().Length != 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтр: {(tbEan.Text.Trim().Length != 0 ? $"EAN:{tbEan.Text.Trim()} | " : "")} {(tbName.Text.Trim().Length != 0 ? $"Наименование:{tbName.Text.Trim()}" : "")}", indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); }, this); indexRow++; indexRow++; #endregion int indexCol = 0; Config.DoOnUIThread(() => { foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } }, this); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dtReport.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal || row[col.DataPropertyName] is double) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); Config.DoOnUIThread(() => { if (new List <int>(new int[] { 1, 3 }).Contains((int)row["ntypetovar"])) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, pReserv.BackColor); } else if ((bool)row["isPromo"]) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, pPromo.BackColor); } }, this); indexRow++; } indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, pPromo.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbDiscount.Text}", indexRow, 2); indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, pReserv.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbReserv.Text}", indexRow, 2); }
private void btPrint_Click(object sender, EventArgs e) { Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals("nameTenant")) { setWidthColumn(indexRow, maxColumns, 20, report); } if (col.Name.Equals("cTypeContract")) { setWidthColumn(indexRow, maxColumns, 21, report); } if (col.Name.Equals("cAgreements")) { setWidthColumn(indexRow, maxColumns, 22, report); } if (col.Name.Equals("cPeriodCredit")) { setWidthColumn(indexRow, maxColumns, 22, report); } if (col.Name.Equals("cSummaCredit")) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals("cDatePay")) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals("cSumma")) { setWidthColumn(indexRow, maxColumns, 16, report); } if (col.Name.Equals("cCountDaysCredit")) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals("cPrcPenalty")) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals("cSummaPenalty")) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals("cItogPenalty")) { setWidthColumn(indexRow, maxColumns, 15, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Отчёт по начислению пени", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Период начисления {cmbPeriodCredit.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Объект аренды: {cmbObject.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Тип договора: {cmbTypeContract.Text}", indexRow, 1); indexRow++; if (tbAgreement.Text.Trim().Length > 0 || tbTenant.Text.Trim().Length > 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтры: " + $"{(tbTenant.Text.Trim().Length == 0 ? "" : "Арендатор: " + tbTenant.Text.Trim())} " + $"{(tbAgreement.Text.Trim().Length == 0 ? "" : "Номер договора: " + tbAgreement.Text.Trim())}", indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, 6); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, 6); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); indexRow++; indexCol = 0; int indexStartRow = indexRow; //foreach (DataGridViewRow row in dgvData.Rows) foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; indexRow = indexStartRow; int startMergRow = indexRow; object tmpValue = null; int preId = 0; //foreach (DataGridViewColumn col in dgvData.Columns) foreach (DataGridViewRow row in dgvData.Rows) { if ((int)dtData.DefaultView[row.Index]["id_StatusPenalty"] == 3) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel2.BackColor); } report.SetWrapText(indexRow, indexCol, indexRow, indexCol); if (new List <int>() { nameTenant.Index, cTypeContract.Index, cAgreements.Index, cPeriodCredit.Index, cItogPenalty.Index }.Contains(col.Index)) { if (indexRow == indexStartRow) { tmpValue = row.Cells[col.Index].Value; preId = (int)dtData.DefaultView[row.Index]["id"]; } else if (indexRow - indexStartRow == dgvData.Rows.Count - 1) { report.Merge(startMergRow, indexCol, indexRow, indexCol); if (tmpValue is DateTime) { report.AddSingleValue(((DateTime)tmpValue).ToShortDateString(), startMergRow, indexCol); } else { report.AddSingleValue(tmpValue.ToString(), startMergRow, indexCol); } } else if (indexRow != indexStartRow) { if (!tmpValue.Equals(row.Cells[col.Index].Value) || preId != (int)dtData.DefaultView[row.Index]["id"]) { report.Merge(startMergRow, indexCol, indexRow - 1, indexCol); if (tmpValue is DateTime) { report.AddSingleValue(((DateTime)tmpValue).ToShortDateString(), startMergRow, indexCol); } else { report.AddSingleValue(tmpValue.ToString(), startMergRow, indexCol); } startMergRow = indexRow; tmpValue = row.Cells[col.Index].Value; preId = (int)dtData.DefaultView[row.Index]["id"]; } } } else { if (row.Cells[col.Index].Value is DateTime) { report.AddSingleValue(((DateTime)row.Cells[col.Index].Value).ToShortDateString(), indexRow, indexCol); } else { report.AddSingleValue(row.Cells[col.Index].Value.ToString(), indexRow, indexCol); } } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; } } } report.SetCellColor(indexRow, 1, indexRow, 1, panel2.BackColor); report.Merge(indexRow, 2, indexRow, 4); report.AddSingleValue(chbCongressAccept.Text, indexRow, 2); report.SetFontBold(indexRow, maxColumns - 1, indexRow, maxColumns); report.SetBorders(indexRow, maxColumns - 1, indexRow, maxColumns); report.SetCellAlignmentToRight(indexRow, maxColumns - 1, indexRow, maxColumns); report.AddSingleValue("Итого", indexRow, maxColumns - 1); report.AddSingleValue(tbItogPenalty.Text, indexRow, maxColumns); report.Show(); }
private async void btOstPrint_Click(object sender, EventArgs e) { if (dtOst == null || dtOst.Rows.Count == 0 || dtOst.DefaultView.Count == 0) { MessageBox.Show("Нет данных для формирования отчёта.", "Печать", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; blockers.SaveControlsEnabledState(this); blockers.SetControlsEnabled(this, false); //progressBar1.Visible = true; var result = await Task <bool> .Factory.StartNew(() => { foreach (DataGridViewColumn col in dgvOst.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals(cMatName.Name)) { setWidthColumn(indexRow, maxColumns, 37, report); } if (col.Name.Equals(cMatMol.Name)) { setWidthColumn(indexRow, maxColumns, 17, report); } if (col.Name.Equals(cMatOstNow.Name)) { setWidthColumn(indexRow, maxColumns, 17, report); } if (col.Name.Equals(cMatOstDate.Name)) { setWidthColumn(indexRow, maxColumns, 17, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Остатки расходных материалов", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; config.DoOnUIThread(() => { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Остатки на дату {dtpOstDate.Value.ToShortDateString()} ", indexRow, 1); indexRow++; }, this); report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvOst.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dtOst.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvOst.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal || row[col.DataPropertyName] is double) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } if ((decimal)row["ostNow"] < 0) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel1.BackColor); } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; } indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbNotActive.Text}", indexRow, 2); config.DoOnUIThread(() => { blockers.RestoreControlEnabledState(this); //progressBar1.Visible = false; }, this); report.Show(); return(true); }); }
private void btPrint_Click(object sender, EventArgs e) { Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals("cName")) { setWidthColumn(indexRow, maxColumns, 20, report); } if (col.Name.Equals("cDeps")) { setWidthColumn(indexRow, maxColumns, 22, report); } if (col.Name.Equals("cUniGrp")) { setWidthColumn(indexRow, maxColumns, 22, report); } if (col.Name.Equals("cReglam")) { setWidthColumn(indexRow, maxColumns, 13, report); } if (col.Name.Equals("cLimitTovar")) { setWidthColumn(indexRow, maxColumns, 20, report); } if (col.Name.Equals("cLimitInut")) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals("cLimitDay")) { setWidthColumn(indexRow, maxColumns, 16, report); } if (col.Name.Equals("cUnit")) { setWidthColumn(indexRow, maxColumns, 10, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Справочник подгрупп", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отдел: {cmbDeps.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{label2.Text}: {cmbUniGrp.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{chbReglam.Text.Replace("-","")}: {(chbReglam.Checked ? "Да" : "Нет")}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{chbLimitTovar.Text.Replace("-", "")}: {(chbLimitTovar.Checked?"Да":"Нет")}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{gTypeGrp.Text}: {(rbAll.Checked ? rbAll.Text : rbNetto.Checked ? rbNetto.Text : rbUnit.Checked ? rbUnit.Text : "")}", indexRow, 1); indexRow++; if (tbName.Text.Trim().Length > 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтр: {tbName.Text}", indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dtData.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is bool) { report.AddSingleValue((bool)row[col.DataPropertyName] ? "Да" : "Нет", indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); if (!(bool)row["isActive"]) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel1.BackColor); } indexRow++; } indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbNotActive.Text}", indexRow, 2); report.Show(); }
private async void btnPrint_Click(object sender, EventArgs e) { if (!chbCancel.Checked && !chbComplete.Checked && !chbЕmployesОrder.Checked) { return; } int id_Shop = (int)cmbShop.SelectedValue; var outer = Task.Factory.StartNew(() => // внешняя задача { Config.DoOnUIThread(() => { blockers.SaveControlsEnabledState(this); blockers.SetControlsEnabled(this, false); //progressBar1.Visible = progressBar1.Enabled = true; fLoad = new Nwuram.Framework.UI.Forms.frmLoad(); fLoad.TopMost = false; fLoad.Owner = this; fLoad.TextWait = "Грузим отчётик!"; fLoad.Show(); }, this); Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); bool isShow = false; if (chbComplete.Checked) { DataTable dtDataStatus3 = Config.connect.getReportData(dtpStart.Value, dtpEnd.Value, 3, id_Shop); DataTable dtDataStatus3Body = (id_Shop == 1 ? Config.connect : Config.hCntSecond).getSumNotesOrderWithRCena(dtpStart.Value, dtpEnd.Value, 3, id_Shop); if (dtDataStatus3 != null && dtDataStatus3.Rows.Count > 0) { isShow = true; report.changeNameTab("Выполненные"); decimal sumOrder = 0, sumNote = 0, SummaDelivery = 0, sumPackage = 0, DeliveryCost = 0, valueOst = 0, valueDelta = 0; int indexRow = 1; int maxColumns = 12; setWidthColumn(indexRow, 1, 6, report); setWidthColumn(indexRow, 2, 10, report); setWidthColumn(indexRow, 3, 17, report); setWidthColumn(indexRow, 4, 11, report); setWidthColumn(indexRow, 5, 16, report); setWidthColumn(indexRow, 6, 22, report); setWidthColumn(indexRow, 7, 16, report); setWidthColumn(indexRow, 8, 12, report); setWidthColumn(indexRow, 9, 14, report); setWidthColumn(indexRow, 10, 16, report); setWidthColumn(indexRow, 11, 16, report); setWidthColumn(indexRow, 12, 13, report); #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отчёт об выполненных заказах с {dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()}", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion report.AddSingleValue("№ п/п", indexRow, 1); report.AddSingleValue("Номер заказа", indexRow, 2); report.AddSingleValue("Сумма заказа", indexRow, 3); report.AddSingleValue("Дата доставки", indexRow, 4); report.AddSingleValue("Сумма чека", indexRow, 5); report.AddSingleValue("№ чека", indexRow, 6); report.AddSingleValue("Стоимость доставки", indexRow, 7); report.AddSingleValue("Кол-во пакетов", indexRow, 8); report.AddSingleValue("Стоимость пакетов", indexRow, 9); report.AddSingleValue("Затраты на доставку", indexRow, 10); report.AddSingleValue("Остаток по доставке", indexRow, 11); report.AddSingleValue("∆ по чеку", indexRow, 12); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; int npp = 1; var groupOrder = dtDataStatus3.AsEnumerable() .GroupBy(r => new { id_tOrders = r.Field <int>("id_tOrders") }) .Select(g => new { g.Key.id_tOrders, sumNote = g.Sum(r => r.Field <decimal>("sumNote")) }); foreach (var g in groupOrder) { EnumerableRowCollection <DataRow> rowCollect = dtDataStatus3.AsEnumerable().Where(r => r.Field <int>("id_tOrders") == g.id_tOrders); DataRow row = rowCollect.First(); int startRow = indexRow; report.SetWrapText(indexRow, 1, indexRow + rowCollect.Count() - 1, maxColumns); report.Merge(indexRow, 1, indexRow + rowCollect.Count() - 1, 1); report.Merge(indexRow, 2, indexRow + rowCollect.Count() - 1, 2); report.Merge(indexRow, 3, indexRow + rowCollect.Count() - 1, 3); report.Merge(indexRow, 4, indexRow + rowCollect.Count() - 1, 4); report.Merge(indexRow, 5, indexRow + rowCollect.Count() - 1, 5); report.Merge(indexRow, 7, indexRow + rowCollect.Count() - 1, 7); report.Merge(indexRow, 8, indexRow + rowCollect.Count() - 1, 8); report.Merge(indexRow, 9, indexRow + rowCollect.Count() - 1, 9); report.Merge(indexRow, 10, indexRow + rowCollect.Count() - 1, 10); report.Merge(indexRow, 11, indexRow + rowCollect.Count() - 1, 11); report.Merge(indexRow, 12, indexRow + rowCollect.Count() - 1, 12); report.AddSingleValue(npp.ToString(), indexRow, 1); report.AddSingleValue(row["OrderNumber"].ToString(), indexRow, 2); report.AddSingleValueObject(row["sumOrder"], indexRow, 3); report.SetFormat(indexRow, 3, indexRow, 3, "0.00"); report.AddSingleValue(((DateTime)row["DeliveryDate"]).ToShortDateString(), indexRow, 4); report.AddSingleValueObject(g.sumNote, indexRow, 5); report.SetFormat(indexRow, 5, indexRow, 5, "0.00"); report.AddSingleValueObject(row["SummaDelivery"], indexRow, 7); report.SetFormat(indexRow, 7, indexRow, 7, "0.00"); report.AddSingleValueObject(row["CountPackage"], indexRow, 8); report.SetFormat(indexRow, 8, indexRow, 8, "0.00"); report.AddSingleValueObject(row["sumPackage"], indexRow, 9); report.SetFormat(indexRow, 9, indexRow, 9, "0.00"); report.AddSingleValueObject(row["DeliveryCost"], indexRow, 10); report.SetFormat(indexRow, 10, indexRow, 10, "0.00"); sumOrder += (decimal)row["sumOrder"]; sumNote += g.sumNote; SummaDelivery += (decimal)row["SummaDelivery"]; sumPackage += (decimal)row["sumPackage"]; DeliveryCost += (decimal)row["DeliveryCost"]; decimal value = (decimal)row["SummaDelivery"] - (decimal)row["sumPackage"] - (decimal)row["DeliveryCost"]; valueOst += value; report.AddSingleValueObject(value, indexRow, 11); report.SetFormat(indexRow, 11, indexRow, 11, "0.00"); if (dtDataStatus3Body != null) { decimal sum = dtDataStatus3Body.AsEnumerable().Where(r => r.Field <int>("id_tOrders") == (int)row["id_tOrders"]).Sum(r => r.Field <decimal>("resultSum")); report.AddSingleValueObject(g.sumNote - sum, indexRow, 12); valueDelta += g.sumNote - sum; } else { report.AddSingleValueObject(0, indexRow, 12); } report.SetFormat(indexRow, 12, indexRow, 12, "0.00"); foreach (DataRow rowSelect in rowCollect) { //report.AddSingleValueObject(rowSelect["sumNote"], indexRow, 5); //report.SetFormat(indexRow, 5, indexRow, 5, "0.00"); report.AddSingleValue($"Касса:{rowSelect["KassNumber"]} Чек:{rowSelect["CheckNumber"]}", indexRow, 6); indexRow++; } report.SetBorders(startRow, 1, indexRow - 1, maxColumns); report.SetCellAlignmentToCenter(startRow, 1, indexRow - 1, maxColumns); report.SetCellAlignmentToJustify(startRow, 1, indexRow - 1, maxColumns); //indexRow++; npp++; } report.SetFormat(indexRow, 2, indexRow, maxColumns, "0.00"); report.AddSingleValue($"Итого:", indexRow, 1); report.AddSingleValueObject(sumOrder, indexRow, 3); report.AddSingleValueObject(sumNote, indexRow, 5); report.AddSingleValueObject(SummaDelivery, indexRow, 7); report.AddSingleValueObject(sumPackage, indexRow, 9); report.AddSingleValueObject(DeliveryCost, indexRow, 10); report.AddSingleValueObject(valueOst, indexRow, 11); report.AddSingleValueObject(valueDelta, indexRow, 12); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); } } if (chbCancel.Checked) { DataTable dtData = Config.connect.getReportData(dtpStart.Value, dtpEnd.Value, 4, id_Shop); if (dtData != null && dtData.Rows.Count > 0) { if (!isShow) { isShow = true; report.changeNameTab("Отменённые"); } else { report.GoToNextSheet("Отменённые"); } int indexRow = 1; int maxColumns = 9; decimal sumOrder = 0; setWidthColumn(indexRow, 1, 9, report); setWidthColumn(indexRow, 2, 20, report); setWidthColumn(indexRow, 3, 20, report); setWidthColumn(indexRow, 4, 16, report); setWidthColumn(indexRow, 5, 20, report); setWidthColumn(indexRow, 6, 18, report); setWidthColumn(indexRow, 7, 16, report); setWidthColumn(indexRow, 8, 16, report); setWidthColumn(indexRow, 9, 40, report); #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отчёт об отменённых заказах с {dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()}", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion report.AddSingleValue("№ п/п", indexRow, 1); report.AddSingleValue("ФИО", indexRow, 2); report.AddSingleValue("Адрес", indexRow, 3); report.AddSingleValue("Телефон", indexRow, 4); report.AddSingleValue("e-mail", indexRow, 5); report.AddSingleValue("Номер заказа", indexRow, 6); report.AddSingleValue("Дата заказа", indexRow, 7); report.AddSingleValue("Сумма заказа", indexRow, 8); report.AddSingleValue("Комментарий об отмене заказа", indexRow, 9); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; int npp = 1; foreach (DataRowView row in dtData.DefaultView) { report.SetWrapText(indexRow, 1, indexRow, maxColumns); report.AddSingleValue(npp.ToString(), indexRow, 1); report.AddSingleValue(row["FIO"].ToString(), indexRow, 2); report.AddSingleValue(row["Address"].ToString(), indexRow, 3); report.AddSingleValue(row["Phone"].ToString(), indexRow, 4); report.AddSingleValue(row["Email"].ToString(), indexRow, 5); report.AddSingleValue(row["OrderNumber"].ToString(), indexRow, 6); report.AddSingleValue(((DateTime)row["DateOrder"]).ToShortDateString(), indexRow, 7); report.AddSingleValueObject(row["sumOrder"], indexRow, 8); report.SetFormat(indexRow, 4, indexRow, 4, "0.00"); report.AddSingleValue(row["Comment"].ToString(), indexRow, 9); sumOrder += (decimal)row["sumOrder"]; report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; npp++; } report.SetFormat(indexRow, 2, indexRow, maxColumns, "0.00"); report.AddSingleValue($"Итого:", indexRow, 1); report.AddSingleValueObject(sumOrder, indexRow, 8); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); } } if (chbЕmployesОrder.Checked) { DataTable dtData = Config.connect.reportЕmployesОrder(dtpStart.Value, dtpEnd.Value, id_Shop); if (dtData != null && dtData.Rows.Count > 0) { if (!isShow) { isShow = true; report.changeNameTab("Отчет по сотрудникам"); } else { report.GoToNextSheet("Отчет по сотрудникам"); } int indexRow = 1; int maxColumns = 8; decimal sumOrder = 0; setWidthColumn(indexRow, 1, 9, report); setWidthColumn(indexRow, 2, 25, report); setWidthColumn(indexRow, 3, 16, report); setWidthColumn(indexRow, 4, 16, report); setWidthColumn(indexRow, 5, 16, report); setWidthColumn(indexRow, 6, 12, report); setWidthColumn(indexRow, 7, 12, report); setWidthColumn(indexRow, 8, 12, report); #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отчет по сотрудникам с {dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()}", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion report.AddSingleValue("№ п/п", indexRow, 1); report.AddSingleValue("ФИО сотрудника", indexRow, 2); report.AddSingleValue("Дата заказа", indexRow, 3); report.AddSingleValue("Номер заказа", indexRow, 4); report.AddSingleValue("Позиций в заказе", indexRow, 5); report.AddSingleValue("Сборщик", indexRow, 6); report.AddSingleValue("Пробитие", indexRow, 7); report.AddSingleValue("Доставщик", indexRow, 8); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; var groupCountCollector = dtData.AsEnumerable() .Where(r => r.Field <bool>("Collector")) .GroupBy(g => new { OrderNumber = g.Field <int>("OrderNumber") }) .Select(s => new { s.Key.OrderNumber, countCollector = s.Count() }); var groupKadr = dtData.AsEnumerable().GroupBy(r => new { id_Kadr = r.Field <int>("id_Kadr"), FIO = r.Field <string>("FIO") }).Select(s => new { s.Key.id_Kadr, s.Key.FIO }); int npp = 1; Color cCompleted = Color.FromArgb(244, 255, 96); foreach (var gKadr in groupKadr) { EnumerableRowCollection <DataRow> rowCollect = dtData.AsEnumerable().Where(r => r.Field <int>("id_Kadr") == gKadr.id_Kadr).OrderBy(r => r.Field <int>("OrderNumber")); report.Merge(indexRow, 2, indexRow + rowCollect.Count() - 1, 2); setValueToCell(indexRow, 2, gKadr.FIO, report); var groupDate = rowCollect.AsEnumerable().GroupBy(g => new { DeliveryDate = g.Field <DateTime>("DeliveryDate") }).Select(s => new { s.Key.DeliveryDate }); decimal countCollector = 0; int countKassCheck = 0; int countDelivery = 0; foreach (var gDate in groupDate) { EnumerableRowCollection <DataRow> rowCollectDate = rowCollect.Where(r => r.Field <DateTime>("DeliveryDate") == gDate.DeliveryDate); report.Merge(indexRow, 3, indexRow + rowCollectDate.Count() - 1, 3); setValueToCell(indexRow, 3, gDate.DeliveryDate, report); foreach (DataRow row in rowCollectDate) { report.SetWrapText(indexRow, 1, indexRow, maxColumns); setValueToCell(indexRow, 1, npp, report); setValueToCell(indexRow, 4, row["OrderNumber"], report); setValueToCell(indexRow, 5, row["countRow"], report); if ((bool)row["Collector"]) { decimal valResult = Convert.ToDecimal((int)row["countRow"]) / Convert.ToDecimal(groupCountCollector.Where(r => r.OrderNumber == (int)row["OrderNumber"]).First().countCollector); countCollector += valResult; setValueToCell(indexRow, 6, valResult, report); } if ((bool)row["KassCheck"]) { setValueToCell(indexRow, 7, row["KassCheck"], report); countKassCheck++; } if ((bool)row["Delivery"]) { setValueToCell(indexRow, 8, row["Delivery"], report); countDelivery++; } if (!(bool)row["isCompleted"]) { report.SetCellColor(indexRow, 4, indexRow, maxColumns, cCompleted); } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; npp++; } } report.Merge(indexRow, 1, indexRow, 5); setValueToCell(indexRow, 1, $"Итого:", report); setValueToCell(indexRow, 6, countCollector, report); setValueToCell(indexRow, 7, countKassCheck, report); setValueToCell(indexRow, 8, countDelivery, report); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToRight(indexRow, 1, indexRow, 1); //report.SetCellAlignmentToRight(indexRow, 6, indexRow, maxColumns); indexRow++; } report.SetCellColor(indexRow + 1, 1, indexRow + 1, 1, cCompleted); setValueToCell(indexRow + 1, 2, "-заказ не выполнен", report); } } Config.DoOnUIThread(() => { blockers.RestoreControlEnabledState(this); fLoad.Dispose(); }, this); if (isShow) { report.SetPageSetup(1, 9999, true); report.Show(); } else { MessageBox.Show("Нет данных для отчёта", "Выгрузка отчёта", MessageBoxButtons.OK, MessageBoxIcon.Information); } #region логирование Logging.StartFirstLevel(79); Logging.Comment("Произведена выгрузка в Excel отчета по работе онлайн-магазина"); Logging.Comment($"Период с: {dtpStart.Value.ToShortDateString()} по: {dtpEnd.Value.ToShortDateString()}"); Logging.Comment($"Отчет о выполненых заказах: {(chbComplete.Checked ? "Да" : "Нет")}"); Logging.Comment($"Отчет об отмененных заказах: {(chbCancel.Checked ? "Да" : "Нет")}"); Logging.Comment("Завершение выгрузки отчета по работе онлайн магазина"); Logging.StopFirstLevel(); #endregion }); }
private void btPrint_Click(object sender, EventArgs e) { if (dgvData.Rows.Count == 0) { MessageBox.Show("Нет данных для формирования отчёта!", "Выгрузка отчёта", MessageBoxButtons.OK, MessageBoxIcon.Information); return; } Logging.StartFirstLevel(79); Logging.Comment($"Фомирование отчёта из \"{this.Text}\""); Logging.Comment($"Договор:{tbAgreement.Text}"); Logging.Comment($"Арендатор:{tbTenant.Text}"); Logging.Comment($"Арендодатель:{tbLandLord.Text}"); Logging.Comment($"Место:{tbNamePlace.Text}"); Logging.Comment($"Период с:{dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()}"); Logging.Comment($"Объект аренды ID:{cmbObject.SelectedValue}; Наименование:{cmbObject.Text}"); Logging.Comment($"Съезд подтвержден: {(chbCongressAccept.Checked ? "Да" : "Нет")}"); Logging.Comment($"Аннуляция поддтверждена/имеется расторжение договора: {(chbDropAgreements.Checked ? "Да" : "Нет")}"); Logging.StopFirstLevel(); Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; } } setWidthColumn(indexRow, 1, 25, report); setWidthColumn(indexRow, 2, 23, report); setWidthColumn(indexRow, 3, 14, report); setWidthColumn(indexRow, 4, 11, report); setWidthColumn(indexRow, 5, 50, report); setWidthColumn(indexRow, 6, 16, report); setWidthColumn(indexRow, 7, 13, report); setWidthColumn(indexRow, 8, 15, report); setWidthColumn(indexRow, 9, 13, report); #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Отчёт по съездам арендаторов", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Период с {dtpStart.Value.ToShortDateString()} по {dtpEnd.Value.ToShortDateString()}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Объект аренды: {cmbObject.Text}", indexRow, 1); indexRow++; if (tbLandLord.Text.Trim().Length > 0 || tbTenant.Text.Trim().Length > 0 || tbAgreement.Text.Trim().Length > 0 || tbNamePlace.Text.Trim().Length > 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтры: " + $"{(tbLandLord.Text.Trim().Length > 0 ? $"Арендодатель: {tbLandLord.Text.Trim()}" : "")}; " + $"{(tbLandLord.Text.Trim().Length > 0 ? $"Арендатор: {tbTenant.Text.Trim()}" : "")}; " + $"{(tbLandLord.Text.Trim().Length > 0 ? $"Номер договора: {tbAgreement.Text.Trim()}" : "")}; " + $"{(tbLandLord.Text.Trim().Length > 0 ? $"Местоположение места аренды: {tbNamePlace.Text.Trim()}" : "")}; ", indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexColumn = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexColumn++; report.AddSingleValue(col.HeaderText, indexRow, indexColumn); report.SetWrapText(indexRow, indexColumn, indexRow, indexColumn); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataGridViewRow row in dgvData.Rows) { Color rColor = Color.White; if ((!(bool)dtData.DefaultView[row.Index]["isLinkPetitionLeave"] || !(bool)dtData.DefaultView[row.Index]["isConfirmed_LinkPetitionLeave"]) && (bool)dtData.DefaultView[row.Index]["isConfirmed"]) { rColor = panel2.BackColor; } if ((bool)dtData.DefaultView[row.Index]["isLinkPetitionLeave"] && (bool)dtData.DefaultView[row.Index]["isConfirmed_LinkPetitionLeave"]) { rColor = panel3.BackColor; } else if (dtData.DefaultView[row.Index]["isCancelAgreements"] != DBNull.Value && (bool)dtData.DefaultView[row.Index]["isConfirmed"]) { rColor = panel3.BackColor; } report.SetCellColor(indexRow, 1, indexRow, maxColumns, rColor); indexColumn = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexColumn++; if (row.Cells[col.Index].Value is DateTime) { report.AddSingleValue(((DateTime)row.Cells[col.Index].Value).ToShortDateString(), indexRow, indexColumn); } else { report.AddSingleValue(row.Cells[col.Index].Value.ToString(), indexRow, indexColumn); } report.SetWrapText(indexRow, indexColumn, indexRow, indexColumn); if ((bool)dtData.DefaultView[row.Index]["isLinkPetitionLeave"] && col.Index == Date_of_Departure.Index) { report.SetCellColor(indexRow, indexColumn, indexRow, indexColumn, panel1.BackColor); } } } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; } indexRow++; report.Merge(indexRow, 2, indexRow, maxColumns); report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.AddSingleValue($"{label4.Text}", indexRow, 2); indexRow++; report.Merge(indexRow, 2, indexRow, maxColumns); report.SetCellColor(indexRow, 1, indexRow, 1, panel2.BackColor); report.AddSingleValue($"{chbCongressAccept.Text}", indexRow, 2); indexRow++; report.Merge(indexRow, 2, indexRow, maxColumns); report.SetCellColor(indexRow, 1, indexRow, 1, panel3.BackColor); report.AddSingleValue($"{chbDropAgreements.Text}", indexRow, 2); report.SetPageSetup(1, 9999, true); report.Show(); }
private async void btViewCartGoods_Click(object sender, EventArgs e) { report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); TabPage tp = tabControl1.SelectedTab; DataGridView grd = null; DataTable dt = null; switch (tabControl1.SelectedIndex) { case 0: grd = dgvData; dt = dgvData.DataSource as DataTable; break; case 1: grd = dgvDataPrice; dt = dgvDataPrice.DataSource as DataTable; break; case 2: grd = dgvDataNewGoods; dt = dgvDataNewGoods.DataSource as DataTable; break; } int indexRow = 1; int maxColumns = 0; blockers.SaveControlsEnabledState(this); blockers.SetControlsEnabled(this, false); progressBar1.Visible = true; var result = await Task <bool> .Factory.StartNew(() => { foreach (DataGridViewColumn col in grd.Columns) { if (col.Visible) { maxColumns++; if (new List <string>(new string[] { cDeps.Name, cNameDepPrice.Name, cNameDepNewGoods.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 13, report); } if (new List <string>(new string[] { cGrp1.Name, nameGrp1Atfer.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 13, report); } if (new List <string>(new string[] { cEan.Name, cEanPrice.Name, cEanNewGoods.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 15, report); } if (new List <string>(new string[] { cNameBefore.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 40, report); } if (new List <string>(new string[] { cNameAfter.Name, cNamePrice.Name, cNameNewGoods.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 40, report); } if (new List <string>(new string[] { cPriceBefore.Name, cPriceNewGoods.Name, cPriceAfter.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 11, report); } if (new List <string>(new string[] { cSell.Name, cOstMorning.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 11, report); } if (new List <string>(new string[] { cNdsBefore.Name, cNdsAfter.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 11, report); } if (new List <string>(new string[] { cUlBefore.Name, cUlAfter.Name, cUlNewGoods.Name }).Contains(col.Name)) { setWidthColumn(indexRow, maxColumns, 11, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{tp.Text}", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; Config.DoOnUIThread(() => { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Магазин: {cmbShop.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"{label4.Text}: {dtpDate.Value.ToShortDateString()}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Отдел: {cmbDeps.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Т/У группа: {cmbGrp1.Text}", indexRow, 1); indexRow++; //if (tbEan.Text.Trim().Length != 0 || tbName.Text.Trim().Length != 0) //{ // report.Merge(indexRow, 1, indexRow, maxColumns); // report.AddSingleValue($"Фильтр: {(tbEan.Text.Trim().Length != 0 ? $"EAN:{tbEan.Text.Trim()} | " : "")} {(tbName.Text.Trim().Length != 0 ? $"Наименование:{tbName.Text.Trim()}" : "")}", indexRow, 1); // indexRow++; //} }, this); report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in grd.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); report.SetWrapText(indexRow, 1, indexRow, maxColumns); indexRow++; foreach (DataRowView row in dt.DefaultView) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in grd.Columns) { if (col.Visible) { if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal || row[col.DataPropertyName] is double) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } if (chbReserv.Checked && (bool)row["isReserv"]) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel1.BackColor); } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); indexRow++; } if (chbReserv.Checked) { indexRow++; report.SetCellColor(indexRow, 1, indexRow, 1, panel1.BackColor); report.Merge(indexRow, 2, indexRow, maxColumns); report.AddSingleValue($"{chbReserv.Text}", indexRow, 2); } Config.DoOnUIThread(() => { blockers.RestoreControlEnabledState(this); progressBar1.Visible = false; }, this); report.SetPageSetup(1, 9999, true); report.Show(); return(true); }); }
private void btPrint_Click(object sender, EventArgs e) { Logging.StartFirstLevel(79); Logging.Comment("Выгрузка отчёта из справочника категорий"); if (!string.IsNullOrWhiteSpace(tbName.Text)) { Logging.Comment($"Фильтр по наименованию категорий: {tbName.Text}"); } Logging.StopFirstLevel(); Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad("list-1"); int rIndex = 1; report.Merge(rIndex, 1, rIndex, 5); report.AddSingleValue("Справочник категорий", rIndex, 1); report.SetCellAlignmentToCenter(rIndex, 1, rIndex, 1); report.SetFontBold(rIndex, 1, rIndex, 1); report.SetFontSize(rIndex, 1, rIndex, 1, 14); rIndex++; report.Merge(rIndex, 3, rIndex, 5); report.AddSingleValue("Выгрузил: " + UserSettings.User.FullUsername, rIndex, 3); report.SetCellAlignmentToRight(rIndex, 3, rIndex, 3); rIndex++; report.Merge(rIndex, 1, rIndex, 2); report.Merge(rIndex, 3, rIndex, 5); report.AddSingleValue("Фильтры: " + tbName.Text, rIndex, 1); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), rIndex, 3); report.SetCellAlignmentToRight(rIndex, 3, rIndex, 3); rIndex++; rIndex++; int cIndex = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { cIndex++; report.AddSingleValue(col.HeaderText, rIndex, cIndex); } } report.SetBorders(rIndex, 1, rIndex, cIndex); report.SetCellAlignmentToCenter(rIndex, 1, rIndex, cIndex); rIndex++; foreach (DataRowView row in dtData.DefaultView) { report.AddSingleValue(row["nameDep"].ToString(), rIndex, 1); report.AddSingleValue(row["cName"].ToString(), rIndex, 2); report.AddSingleValue(row["cNameParent"].ToString(), rIndex, 3); if (!(bool)row["isActive"]) { report.SetCellColor(rIndex, 1, rIndex, cIndex, panel1.BackColor); } report.SetBorders(rIndex, 1, rIndex, cIndex); report.SetCellAlignmentToCenter(rIndex, 1, rIndex, cIndex); rIndex++; } report.Merge(rIndex, 2, rIndex, 5); report.SetCellColor(rIndex, 1, rIndex, 1, panel1.BackColor); report.AddSingleValue("- не действующие", rIndex, 2); rIndex++; report.SetColumnAutoSize(1, 1, rIndex, 5); report.Show(); }
private void btPrint_Click(object sender, EventArgs e) { Logging.StartFirstLevel(79); Logging.Comment($"Фомирование отчёта из \"{this.Text}\""); Logging.Comment($"Договор:{tbAgreement.Text}"); Logging.Comment($"Арендатор:{tbTenant.Text}"); Logging.Comment($"Период начисления:{cmbPeriodCredit.Text}"); Logging.Comment($"Объект аренды:{cmbObject.Text}"); Logging.Comment($"Тип договора:{cmbTypeContract.Text}"); Logging.Comment($"Подтвержденные пени: {(chbCongressAccept.Checked ? "Да" : "Нет")}"); Logging.StopFirstLevel(); Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad(); int indexRow = 1; int maxColumns = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { maxColumns++; if (col.Name.Equals("nameTenant")) { setWidthColumn(indexRow, maxColumns, 20, report); } if (col.Name.Equals("cTypeContract")) { setWidthColumn(indexRow, maxColumns, 21, report); } if (col.Name.Equals("cAgreements")) { setWidthColumn(indexRow, maxColumns, 22, report); } if (col.Name.Equals("cPeriodCredit")) { setWidthColumn(indexRow, maxColumns, 22, report); } if (col.Name.Equals("cSummaCredit")) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals("cDatePay")) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals("cSumma")) { setWidthColumn(indexRow, maxColumns, 16, report); } if (col.Name.Equals("cCountDaysCredit")) { setWidthColumn(indexRow, maxColumns, 18, report); } if (col.Name.Equals("cPrcPenalty")) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals("cSummaPenalty")) { setWidthColumn(indexRow, maxColumns, 15, report); } if (col.Name.Equals("cItogPenalty")) { setWidthColumn(indexRow, maxColumns, 15, report); } } } #region "Head" report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue("Отчёт по начислению пени", indexRow, 1); report.SetFontBold(indexRow, 1, indexRow, 1); report.SetFontSize(indexRow, 1, indexRow, 1, 16); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1); indexRow++; indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Период начисления {cmbPeriodCredit.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Объект аренды: {cmbObject.Text}", indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Тип договора: {cmbTypeContract.Text}", indexRow, 1); indexRow++; if (tbAgreement.Text.Trim().Length > 0 || tbTenant.Text.Trim().Length > 0) { report.Merge(indexRow, 1, indexRow, maxColumns); report.AddSingleValue($"Фильтры: " + $"{(tbTenant.Text.Trim().Length == 0 ? "" : "Арендатор: " + tbTenant.Text.Trim())} " + $"{(tbAgreement.Text.Trim().Length == 0 ? "" : "Номер договора: " + tbAgreement.Text.Trim())}", indexRow, 1); indexRow++; } report.Merge(indexRow, 1, indexRow, 6); report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1); indexRow++; report.Merge(indexRow, 1, indexRow, 6); report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1); indexRow++; indexRow++; #endregion int indexCol = 0; foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { indexCol++; report.AddSingleValue(col.HeaderText, indexRow, indexCol); } } report.SetFontBold(indexRow, 1, indexRow, maxColumns); report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); indexRow++; var groupByPost = dtData.DefaultView.ToTable().AsEnumerable().GroupBy(r => new { id = r.Field <int>("id") }) .Select(s => new { s.Key.id }); foreach (var gPost in groupByPost) { EnumerableRowCollection <DataRow> rowCollect = dtData.DefaultView.ToTable().AsEnumerable().Where(r => r.Field <int>("id") == gPost.id); int startMergRow = indexRow; foreach (DataRow row in rowCollect) { indexCol = 1; report.SetWrapText(indexRow, indexCol, indexRow, maxColumns); foreach (DataGridViewColumn col in dgvData.Columns) { if (col.Visible) { if (new List <int>() { nameTenant.Index, cTypeContract.Index, cAgreements.Index, cPeriodCredit.Index, cItogPenalty.Index }.Contains(col.Index)) { indexCol++; continue; } if (row[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)row[col.DataPropertyName]).ToShortDateString(), indexRow, indexCol); } else if (row[col.DataPropertyName] is decimal) { report.AddSingleValueObject(row[col.DataPropertyName], indexRow, indexCol); report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); } else { report.AddSingleValue(row[col.DataPropertyName].ToString(), indexRow, indexCol); } indexCol++; } } report.SetBorders(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); if ((int)row["id_StatusPenalty"] == 3) { report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel2.BackColor); } indexRow++; } indexCol = 1; foreach (DataGridViewColumn col in dgvData.Columns) { if (new List <int>() { nameTenant.Index, cTypeContract.Index, cAgreements.Index, cPeriodCredit.Index, cItogPenalty.Index }.Contains(col.Index)) { report.Merge(startMergRow, indexCol, indexRow - 1, indexCol); if (rowCollect.First()[col.DataPropertyName] is DateTime) { report.AddSingleValue(((DateTime)rowCollect.First()[col.DataPropertyName]).ToShortDateString(), startMergRow, indexCol); } else if (rowCollect.First()[col.DataPropertyName] is decimal) { report.AddSingleValueObject(rowCollect.First()[col.DataPropertyName], startMergRow, indexCol); report.SetFormat(startMergRow, indexCol, startMergRow, indexCol, "0.00"); } else { report.AddSingleValue(rowCollect.First()[col.DataPropertyName].ToString(), startMergRow, indexCol); } } indexCol++; } } /* * indexCol = 0; * int indexStartRow = indexRow; * //foreach (DataGridViewRow row in dgvData.Rows) * foreach (DataGridViewColumn col in dgvData.Columns) * { * if (col.Visible) * { * indexCol++; * indexRow = indexStartRow; * int startMergRow = indexRow; * object tmpValue = null; * int preId = 0; * //foreach (DataGridViewColumn col in dgvData.Columns) * foreach (DataGridViewRow row in dgvData.Rows) * { * if ((int)dtData.DefaultView[row.Index]["id_StatusPenalty"] == 3) * report.SetCellColor(indexRow, 1, indexRow, maxColumns, panel2.BackColor); * * report.SetWrapText(indexRow, indexCol, indexRow, indexCol); * * if (new List<int>() { nameTenant.Index, cTypeContract.Index, cAgreements.Index, cPeriodCredit.Index, cItogPenalty.Index }.Contains(col.Index)) * { * if (indexRow == indexStartRow) * { * tmpValue = row.Cells[col.Index].Value; * preId = (int)dtData.DefaultView[row.Index]["id"]; * } * else if (indexRow - indexStartRow == dgvData.Rows.Count - 1) * { * report.Merge(startMergRow, indexCol, indexRow-1, indexCol); * * if (tmpValue is DateTime) * report.AddSingleValue(((DateTime)tmpValue).ToShortDateString(), startMergRow, indexCol); * if (tmpValue is decimal) * { * report.AddSingleValueObject(tmpValue, startMergRow, indexCol); * report.SetFormat(startMergRow, indexCol, startMergRow, indexCol, "0.00"); * } * else * report.AddSingleValue(tmpValue.ToString(), startMergRow, indexCol); * * * if (row.Cells[col.Index].Value is DateTime) * report.AddSingleValue(((DateTime)row.Cells[col.Index].Value).ToShortDateString(), indexRow, indexCol); * else * if (row.Cells[col.Index].Value is decimal) * { * report.AddSingleValueObject(row.Cells[col.Index].Value, indexRow, indexCol); * report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); * } * else * report.AddSingleValue(row.Cells[col.Index].Value.ToString(), indexRow, indexCol); * * } * else if (indexRow != indexStartRow) * { * if (!tmpValue.Equals(row.Cells[col.Index].Value) || preId != (int)dtData.DefaultView[row.Index]["id"]) * { * report.Merge(startMergRow, indexCol, indexRow - 1, indexCol); * * if (tmpValue is DateTime) * report.AddSingleValue(((DateTime)tmpValue).ToShortDateString(), startMergRow, indexCol); * else * if (tmpValue is decimal) * { * report.AddSingleValueObject(tmpValue, startMergRow, indexCol); * report.SetFormat(startMergRow, indexCol, startMergRow, indexCol, "0.00"); * } * else * report.AddSingleValue(tmpValue.ToString(), startMergRow, indexCol); * * startMergRow = indexRow; * tmpValue = row.Cells[col.Index].Value; * preId = (int)dtData.DefaultView[row.Index]["id"]; * } * } * } * else * { * if (row.Cells[col.Index].Value is DateTime) * report.AddSingleValue(((DateTime)row.Cells[col.Index].Value).ToShortDateString(), indexRow, indexCol); * else * if (row.Cells[col.Index].Value is decimal) * { * report.AddSingleValueObject(row.Cells[col.Index].Value, indexRow, indexCol); * report.SetFormat(indexRow, indexCol, indexRow, indexCol, "0.00"); * } * else * report.AddSingleValue(row.Cells[col.Index].Value.ToString(), indexRow, indexCol); * } * * * report.SetBorders(indexRow, 1, indexRow, maxColumns); * report.SetCellAlignmentToCenter(indexRow, 1, indexRow, maxColumns); * report.SetCellAlignmentToJustify(indexRow, 1, indexRow, maxColumns); * indexRow++; * } * } * } */ report.SetCellColor(indexRow, 1, indexRow, 1, panel2.BackColor); report.Merge(indexRow, 2, indexRow, 4); report.AddSingleValue(chbCongressAccept.Text, indexRow, 2); report.SetFontBold(indexRow, maxColumns - 1, indexRow, maxColumns); report.SetBorders(indexRow, maxColumns - 1, indexRow, maxColumns); report.SetCellAlignmentToRight(indexRow, maxColumns - 1, indexRow, maxColumns); report.AddSingleValue("Итого", indexRow, maxColumns - 1); report.AddSingleValue(tbItogPenalty.Text, indexRow, maxColumns); report.Show(); }