public static void printWriteOff(int id)
{
DataTable dtDataHead = readSQL.getActWriteOff(DateTime.Now, DateTime.Now, id);
DataTable dtDataBody = readSQL.getContentWriteOff(id);
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad();
int indexRow = 1;
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue("Акт списания оборудования", indexRow, 1);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1);
report.SetFontBold(indexRow, 1, indexRow, 1);
report.SetFontSize(indexRow, 1, indexRow, 1, 16);
indexRow++;
indexRow++;
report.Merge(indexRow, 5, indexRow, 6);
report.AddSingleValue("Дата: " + ((DateTime)dtDataHead.Rows[0]["Date"]).ToShortDateString(), indexRow, 5);
indexRow++;
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue("Причина: " + dtDataHead.Rows[0]["Reason"].ToString(), indexRow, 1);
report.SetWrapText(indexRow, 1, indexRow, 1);
//report.SetAutoFit(indexRow, 1, indexRow, 1);
report.SetRowHeight(indexRow, 1, indexRow, 1, 60);
indexRow++;
indexRow++;
report.AddSingleValue("№ п\\п", indexRow, 1);
report.AddSingleValue("Наименование", indexRow, 2);
report.AddSingleValue("Инвентарный номер", indexRow, 3);
report.AddSingleValue("EAN", indexRow, 4);
report.AddSingleValue("Местоположение", indexRow, 5);
report.AddSingleValue("Комментарий", indexRow, 6);
report.SetFontBold(indexRow, 1, indexRow, 6);
report.SetBorders(indexRow, 1, indexRow, 6);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 6);
indexRow++;
foreach (DataRow row in dtDataBody.Rows)
{
report.AddSingleValue(row["npp"].ToString(), indexRow, 1);
report.AddSingleValue(row["cName"].ToString(), indexRow, 2);
report.AddSingleValue(row["InventoryNumber"].ToString(), indexRow, 3);
report.AddSingleValue(row["EAN"].ToString(), indexRow, 4);
report.AddSingleValue(row["nameLocation"].ToString(), indexRow, 5);
//report.AddSingleValue(row[""].ToString(), indexRow, 6);
report.SetBorders(indexRow, 1, indexRow, 6);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 6);
indexRow++;
}
indexRow++;
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue("ОЭЭС:", indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue("РБ5:", indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue("О1:", indexRow, 1);
indexRow++;
report.SetColumnAutoSize(5, 1, indexRow, 6);
report.SetPageSetup(1, 9999, false);
report.Show();
}
private void btExcel_Click(object sender, EventArgs e)
{
Logging.StartFirstLevel(79);
Logging.Comment("Произведена выгрузка в Excel отчета «Отчет по сканерам»");
Logging.Comment("Операцию выполнил: ID:" + Nwuram.Framework.Settings.User.UserSettings.User.Id
+ " ; ФИО:" + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername);
Logging.StopFirstLevel();
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad("Лист - 1");
report.SetPageOrientationToLandscape();
int indexRow = 1;
report.Merge(indexRow, 1, indexRow, 9);
report.AddSingleValue("Отчёт по сканерам", indexRow, 1);
report.SetCellAlignmentToJustify(indexRow, 1, indexRow, 3);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 3);
report.SetFontSize(indexRow, 1, indexRow, 1, 16);
indexRow++;
report.Merge(indexRow, 1, indexRow, 9);
report.AddSingleValue("Период с : " + dtpStart.Value.ToShortDateString() + " по: " + dtpEnd.Value.ToShortDateString(), indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, 9);
report.AddSingleValue("Выгрузил: " + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername, indexRow, 1);
indexRow++;
report.Merge(indexRow, 1, indexRow, 9);
report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), indexRow, 1);
indexRow++;
indexRow++;
indexRow++;
int indexColum = 1;
foreach (DataGridViewColumn col in dgvScaner.Columns)
{
report.AddSingleValue(col.HeaderText, indexRow, indexColum);
indexColum++;
if (col.Name.Equals("cTimeDrop"))
{
report.AddSingleValue("Сканер Выдал", indexRow, indexColum);
indexColum++;
}
}
//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.SetCellAlignmentToCenter(indexRow, 1, indexRow, indexColum - 1);
report.SetBorders(indexRow, 1, indexRow, indexColum - 1);
indexRow++;
foreach (DataRowView r in dtJournalScaner.DefaultView)
{
report.AddSingleValue(r["InventoryNumber"].ToString(), indexRow, 1);
report.AddSingleValue(r["EAN"].ToString(), indexRow, 2);
report.AddSingleValue(r["cName"].ToString(), indexRow, 3);
report.AddSingleValue(r["nameOut"].ToString(), indexRow, 4);
report.AddSingleValue(r["nameDeps"].ToString(), indexRow, 5);
report.AddSingleValue(r["DateOut"].ToString(), indexRow, 6);
report.AddSingleValue(r["FIO"].ToString(), indexRow, 7);
report.AddSingleValue(r["nameGet"].ToString(), indexRow, 8);
report.AddSingleValue(r["DateGet"].ToString(), indexRow, 9);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 9);
report.SetBorders(indexRow, 1, indexRow, 9);
indexRow++;
}
report.SetColumnAutoSize(1, 1, indexRow - 1, 9);
report.Show();
}
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 void btPrint_Click(object sender, EventArgs e)
{
Logging.StartFirstLevel(79);
Logging.Comment("Произведена выгрузка отчета с превышения процента наценки");
Logging.Comment($"Количество выгруженных записей: {dtResult.Rows.Count}");
Logging.Comment($"Настройка процента наценки: {tbPrcn.Text}");
Logging.StopFirstLevel();
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad("list-1");
int rIndex = 1;
int maxMerge = 0;
foreach (DataGridViewColumn col in dgvData.Columns)
{
if (col.Visible)
{
maxMerge++;
}
}
report.Merge(rIndex, 1, rIndex, maxMerge);
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, 1, rIndex, 2);
report.Merge(rIndex, 5, rIndex, 7);
report.AddSingleValue("Дата: " + date.ToShortDateString(), rIndex, 1);
report.AddSingleValue("Выгрузил: " + UserSettings.User.FullUsername, rIndex, 3);
report.SetCellAlignmentToRight(rIndex, 3, rIndex, 3);
rIndex++;
string shotName = "";
if (Nwuram.Framework.Settings.Connection.ConnectionSettings.GetServer().ToLower().Contains("k21"))
{
shotName = "Косыгина 21";
}
else
{
shotName = "Хошимина 14";
}
report.Merge(rIndex, 1, rIndex, 2);
report.Merge(rIndex, 3, rIndex, 4);
report.Merge(rIndex, 5, rIndex, 7);
report.AddSingleValue("Процент наценки: " + tbPrcn.Text, rIndex, 1);
report.AddSingleValue("Магазин: " + shotName, rIndex, 3);
report.AddSingleValue("Дата выгрузки: " + DateTime.Now.ToString(), rIndex, 5);
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);
report.SetWrapText(rIndex, 1, rIndex, cIndex);
rIndex++;
foreach (DataRowView row in dtResult.DefaultView)
{
cIndex = 0;
foreach (DataGridViewColumn col in dgvData.Columns)
{
if (col.Visible)
{
cIndex++;
report.AddSingleValue(row[col.DataPropertyName].ToString(), rIndex, cIndex);
}
}
report.SetBorders(rIndex, 1, rIndex, cIndex);
report.SetCellAlignmentToCenter(rIndex, 1, rIndex, cIndex);
rIndex++;
}
report.SetColumnAutoSize(1, 1, rIndex, maxMerge);
report.Show();
}
private void getReport()
{
DoOnUIThread(delegate()
{
this.Enabled = false;
DataTable dtReport = proc.GetTenantReport((int)cbObjects.SelectedValue, (int)cbLandlord.SelectedValue, (int)cbActivties.SelectedValue);
if (dtReport.Rows.Count == 0)
{
MessageBox.Show("Нет данных для выгрузки", "Нет данных", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Enabled = true;
return;
}
else
{
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad();
int indexRow = 1;
report.SetPageOrientationToLandscape();
///Заголовок
report.Merge(indexRow, 1, indexRow, 11);
report.AddSingleValue("ОТЧЕТ О ВИДАХ ДЕЯТЕЛЬНОСТИ АРЕНДАТОРОВ", indexRow, 1);
report.SetCellAlignmentToJustify(indexRow, 1, indexRow + 1, 11);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow + 1, 11);
report.SetFontBold(indexRow, 1, indexRow, 11);
report.SetFontSize(indexRow, 1, indexRow, 11, 16);
indexRow++;
indexRow++;
///Параметры
report.AddSingleValue("Объект:", indexRow, 2);
report.SetFontBold(indexRow, 2, indexRow, 2);
report.AddSingleValue(cbObjects.Text.Trim(), indexRow, 3);
indexRow++;
report.AddSingleValue("Арендодатель:", indexRow, 2);
report.SetFontBold(indexRow, 2, indexRow, 2);
report.AddSingleValue(cbLandlord.Text.Trim(), indexRow, 3);
indexRow++;
report.AddSingleValue("Вид деятельности:", indexRow, 2);
report.SetFontBold(indexRow, 2, indexRow, 2);
report.AddSingleValue(cbActivties.Text.Trim(), indexRow, 3);
indexRow++;
indexRow++;
report.AddSingleValue("Выгрузил:", indexRow, 2);
report.SetFontBold(indexRow, 2, indexRow, 2);
report.AddSingleValue(Nwuram.Framework.Settings.User.UserSettings.User.FullUsername.Trim(), indexRow, 3);
indexRow++;
report.AddSingleValue("Дата:", indexRow, 2);
report.SetFontBold(indexRow, 2, indexRow, 2);
report.AddSingleValue(proc.GetDate().ToString(), indexRow, 3);
indexRow++;
indexRow++;
///Названия столбцов
report.Merge(indexRow, 1, indexRow + 1, 1);
report.AddSingleValue("Объект", indexRow, 1);
report.Merge(indexRow, 2, indexRow + 1, 2);
report.AddSingleValue("Арендодатель", indexRow, 2);
report.Merge(indexRow, 3, indexRow + 1, 3);
report.AddSingleValue("Вид деятельности", indexRow, 3);
report.Merge(indexRow, 4, indexRow + 1, 4);
report.AddSingleValue("№ п/п", indexRow, 4);
report.SetWrapText(indexRow, 4, indexRow + 1, 4);
report.Merge(indexRow, 5, indexRow + 1, 5);
report.AddSingleValue("Арендатор", indexRow, 5);
report.Merge(indexRow, 6, indexRow + 1, 6);
report.AddSingleValue("Вид договора", indexRow, 6);
report.Merge(indexRow, 7, indexRow, 9);
report.AddSingleValue("Местоположение", indexRow, 7);
report.AddSingleValue("Здание", indexRow + 1, 7);
report.AddSingleValue("Этаж", indexRow + 1, 8);
report.AddSingleValue("№ секции", indexRow + 1, 9);
report.Merge(indexRow, 10, indexRow + 1, 10);
report.AddSingleValue("Телефон", indexRow, 10);
report.Merge(indexRow, 11, indexRow + 1, 11);
report.AddSingleValue("Эл.почта", indexRow, 11);
report.SetCellAlignmentToJustify(indexRow, 1, indexRow + 1, 11);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow + 1, 11);
report.SetBorders(indexRow, 1, indexRow + 1, 11);
report.SetFontBold(indexRow, 1, indexRow + 1, 11);
report.SetFontSize(indexRow, 1, indexRow + 1, 11, 14);
indexRow++;
indexRow++;
int ObjIndexStart = indexRow, ActIndexStart = indexRow, LandlordIndexStart = indexRow;
int NumPP = 1;///Номер строки
var dtObject = dtReport.AsEnumerable().Select(r => r.Field <int>("IdObject")).Distinct();;
foreach (var obj in dtObject)
{
ObjIndexStart = indexRow;
EnumerableRowCollection <DataRow> rcObj = dtReport.AsEnumerable().Where(r => r.Field <int>("IdObject") == obj);
report.AddSingleValue(rcObj.First()["Object"].ToString(), indexRow, 1);
var dtLandlord = rcObj.AsEnumerable().Select(r => r.Field <int>("IdLandlord")).Distinct();
foreach (var Landlord in dtLandlord)
{
LandlordIndexStart = indexRow;
EnumerableRowCollection <DataRow> rcLandlord = dtReport.AsEnumerable().Where(r => r.Field <int>("IdObject") == obj && r.Field <int>("IdLandlord") == Landlord);
report.AddSingleValue(rcLandlord.First()["Landlord"].ToString(), indexRow, 2);
var dtActivities = rcLandlord.AsEnumerable().Select(r => r.Field <int>("IdActivities")).Distinct();
foreach (var act in dtActivities)
{
ActIndexStart = indexRow;
EnumerableRowCollection <DataRow> rcAct = dtReport.AsEnumerable().Where(r => r.Field <int>("IdObject") == obj && r.Field <int>("IdLandlord") == Landlord && r.Field <int>("IdActivities") == act);
report.AddSingleValue(rcAct.First()["Activities"].ToString(), indexRow, 3);
foreach (var dr in rcAct)
{
report.AddSingleValue(NumPP.ToString(), indexRow, 4);
report.AddSingleValue(dr["Tenant"].ToString(), indexRow, 5);
report.AddSingleValue(dr["TypeContract"].ToString(), indexRow, 6);
report.AddSingleValue(dr["Building"].ToString(), indexRow, 7);
report.AddSingleValue(dr["Floor"].ToString(), indexRow, 8);
report.AddSingleValue(dr["Section"].ToString(), indexRow, 9);
report.AddSingleValue(dr["Work_phone"].ToString(), indexRow, 10);
report.AddSingleValue(dr["email"].ToString(), indexRow, 11);
report.SetCellAlignmentToLeft(indexRow, 4, indexRow, 11);
report.SetCellAlignmentToJustify(indexRow, 4, indexRow, 11);
report.SetBorders(indexRow, 4, indexRow, 11);
NumPP++;
indexRow++;
}
report.Merge(ActIndexStart, 3, indexRow - 1, 3);
report.SetCellAlignmentToLeft(ActIndexStart, 3, indexRow - 1, 3);
report.SetCellAlignmentToJustify(ActIndexStart, 3, indexRow - 1, 3);
report.SetBorders(ActIndexStart, 3, indexRow - 1, 3);
}
report.Merge(LandlordIndexStart, 2, indexRow - 1, 2);
report.SetCellAlignmentToLeft(LandlordIndexStart, 2, indexRow - 1, 2);
report.SetCellAlignmentToJustify(LandlordIndexStart, 2, indexRow - 1, 2);
report.SetBorders(LandlordIndexStart, 2, indexRow - 1, 2);
}
report.Merge(ObjIndexStart, 1, indexRow - 1, 1);
report.SetCellAlignmentToLeft(ObjIndexStart, 1, indexRow - 1, 1);
report.SetCellAlignmentToJustify(ObjIndexStart, 1, indexRow - 1, 1);
report.SetBorders(ObjIndexStart, 1, indexRow - 1, 1);
}
report.SetColumnAutoSize(1, 1, indexRow - 1, 11);
report.SetColumnWidth(10, 4, 11, 4, 5); ///Для № п/п
report.SetWrapText(12, 1, indexRow - 1, 11); ///Перенос текста для всех данных кроме телефон и почта
report.SetPageSetup(1, 1, true);
report.Show();
}
this.Enabled = true;
});
}
private void buttonPrint_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 grdPrices.Columns)
{
if (col.Visible)
{
maxColumns++;
/*if (col.Name.Equals(cDeps.Name)) setWidthColumn(indexRow, maxColumns, 18, report);
* if (col.Name.Equals(cPost.Name)) setWidthColumn(indexRow, maxColumns, 18, report);
* if (col.Name.Equals(cFIO.Name)) setWidthColumn(indexRow, maxColumns, 20, report);
* if (col.Name.Equals(cPass.Name)) setWidthColumn(indexRow, maxColumns, 15, report);
* if (col.Name.Equals(cDatePrintPass.Name)) setWidthColumn(indexRow, maxColumns, 17, report);
* if (col.Name.Equals(cPhone.Name)) setWidthColumn(indexRow, maxColumns, 17, 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++;
//report.Merge(indexRow, 1, indexRow, maxColumns);
//report.AddSingleValue($"Отдел: {cmbDeps.Text}", indexRow, 1);
//indexRow++;
//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 grdPrices.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 pricesTable.DefaultView)
{
indexCol = 1;
report.SetWrapText(indexRow, indexCol, indexRow, maxColumns);
foreach (DataGridViewColumn col in grdPrices.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);
indexRow++;
}
report.SetColumnAutoSize(6, 1, indexRow, maxColumns);
report.Show();
//if (grdPrices.DataSource != null)
//{
// //Logging.StartFirstLevel(472);
// //Logging.Comment("Выгрузка данных по товарам группы");
// string[] filePath = (Application.StartupPath + "\\tmp").Split(new char[] { '\\' });
// grdPrices.Refresh();
// DataTable printTable = pricesTable.Copy();
// if (stFilter != null)
// {
// printTable.DefaultView.RowFilter = stFilter;
// }
// Print(printTable.DefaultView.ToTable(), filePath[filePath.Length - 1]);
//}
}
private void createReport(bool isCart)
{
string nameFile = DateTime.Now.ToShortDateString() + " - " + (isCart ? "Нал." : "БезНал.");
DataTable dtTmp = Config.hCntMain.getReportPayment(true, isCart);
if (dtTmp == null || dtTmp.Rows.Count == 0)
{
MessageBox.Show("Данных для печати нет"); return;
}
;
var groupedData
= from b in dtTmp.AsEnumerable()
group b by new { id_Department = b.Field <Int32>("id_Department") } into g
select new
{
id_Department = g.Key.id_Department
// netto = g.Sum(x => x.Field<decimal>("netto"))
};
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad("Лист - 1");
int indexRow = 1;
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue("Отчёт по выданным " + (isCart ? "Безнал." : "Нал.") + " ДС ", indexRow, 1);
report.SetCellAlignmentToJustify(indexRow, 1, indexRow, 1);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1);
report.SetFontSize(indexRow, 1, indexRow, 1, 16);
report.SetFontBold(indexRow, 1, indexRow, 1);
indexRow++;
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++;
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.SetCellAlignmentToCenter(indexRow, 1, indexRow, 6);
report.SetBorders(indexRow, 1, indexRow, 6);
indexRow++;
foreach (var grp in groupedData)
{
DataRow[] row = dtTmp.Select(string.Format("id_Department = {0}", grp.id_Department));
report.Merge(indexRow, 1, indexRow, 6);
report.AddSingleValue(row[0]["nameDeps"].ToString(), indexRow, 1);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 6);
report.SetBorders(indexRow, 1, indexRow, 6);
indexRow++;
foreach (DataRow r in row)
{
report.AddSingleValue(r["Number"].ToString(), indexRow, 1);
report.AddSingleValue(r["Description"].ToString(), indexRow, 2);
report.AddSingleValue(r["FIO"].ToString(), indexRow, 3);
report.AddSingleValue(r["Summa"].ToString(), indexRow, 4);
report.AddSingleValue(r["DataSumma"].ToString(), indexRow, 5);
//report.AddSingleValue(r["Summa"].ToString(), indexRow, 6);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 4);
report.SetBorders(indexRow, 1, indexRow, 6);
indexRow++;
}
}
report.SetColumnAutoSize(6, 1, indexRow - 1, 6);
//report.Show();
report.SaveToFile(@"Report\" + nameFile + ".xlsx");
}
private void createSZMoney(bool isCart)
{
Logging.StartFirstLevel(79);
Logging.Comment("Запрос на выдачу " + (isCart ? "Безнал." : "Нал.") + " ДС за " + DateTime.Now.ToShortDateString());
Logging.Comment("Операцию выполнил: ID:" + Nwuram.Framework.Settings.User.UserSettings.User.Id
+ " ; ФИО:" + Nwuram.Framework.Settings.User.UserSettings.User.FullUsername);
Logging.StopFirstLevel();
DataTable dtTmp = Config.hCntMain.getReportPayment(false, isCart);
if (dtTmp == null || dtTmp.Rows.Count == 0)
{
return;
}
var groupedData
= from b in dtTmp.AsEnumerable()
group b by new { id_Department = b.Field <Int32>("id_Department") } into g
select new
{
id_Department = g.Key.id_Department
// netto = g.Sum(x => x.Field<decimal>("netto"))
};
for (int i = dtTmp.Rows.Count - 1; i >= 0; i--)
{
DataRow dr = dtTmp.Rows[i];
if (dr["type"].ToString().Equals("2"))
{
dr.Delete();
}
}
Nwuram.Framework.ToExcelNew.ExcelUnLoad report = new Nwuram.Framework.ToExcelNew.ExcelUnLoad("Лист - 1");
int indexRow = 1;
report.Merge(indexRow, 1, indexRow, 4);
report.AddSingleValue("Запрос на выдачу " + (isCart ? "Безнал." : "Нал.") + " ДС за " + DateTime.Now.ToShortDateString(), indexRow, 1);
report.SetCellAlignmentToJustify(indexRow, 1, indexRow, 1);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 1);
report.SetFontSize(indexRow, 1, indexRow, 1, 16);
report.SetFontBold(indexRow, 1, indexRow, 1);
report.SetRowHeight(indexRow, 1, indexRow, 4, 40);
indexRow++;
indexRow++;
report.AddSingleValue("№ СЗ", indexRow, 1);
report.AddSingleValue("Описание", indexRow, 2);
report.AddSingleValue("Должность", indexRow, 3);
report.AddSingleValue("Сумма", indexRow, 4);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 4);
report.SetBorders(indexRow, 1, indexRow, 4);
indexRow++;
foreach (var grp in groupedData)
{
DataRow[] row = dtTmp.Select(string.Format("id_Department = {0}", grp.id_Department));
report.Merge(indexRow, 1, indexRow, 4);
report.AddSingleValue(row[0]["nameDeps"].ToString(), indexRow, 1);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 4);
report.SetBorders(indexRow, 1, indexRow, 4);
indexRow++;
foreach (DataRow r in row)
{
report.AddSingleValue(r["Number"].ToString(), indexRow, 1);
report.AddSingleValue(r["Description"].ToString(), indexRow, 2);
report.AddSingleValue(r["FIO"].ToString(), indexRow, 3);
report.AddSingleValue(r["Summa"].ToString(), indexRow, 4);
report.SetCellAlignmentToCenter(indexRow, 1, indexRow, 4);
report.SetBorders(indexRow, 1, indexRow, 4);
indexRow++;
}
}
report.SetColumnAutoSize(3, 1, indexRow - 1, 4);
report.Show();
}
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();
}