106
null);
}
private void мтоПоФилиаламToolStripMenuItem_Click(object sender,
EventArgs e)
{
fReport = new report(this, "МТОпофилиалам");
int colCnt = 16;
string sql = @"
select
c.id_fil, concat(c.kod, ' ', c.filial) as filial,
a.id_mto, a.naimenovanie, a.inventarniy_nomer,
b.id_kat, kategoriya,
date_format(a.data_vipuska, '%Y-%m-%d'),
f.id_sos, sostoyanie,
date_format(a.data_vvoda, '%Y-%m-%d'), a.stoimost, a.srok_pi,
date_format(a.data_spisaniya, '%Y-%m-%d'),
d.id_mol, concat('[', d.kod, '] ', d.fio, ' тел: ', d.tel) as mol
from mto as a
inner join kategorii as b on a.id_kat=b.id_kat
inner join filiali as c on a.id_fil=c.id_fil
inner join mol as d on a.id_mol=d.id_mol
inner join sostoyaniya as f on a.id_sos=f.id_sos
order by c.id_fil asc
";
string headers = "ID,Филиал,ID,Наименование,Инв. номер,ID,Категория
МТО,Дата выпуска,ID,Состояние,Дата ввода,Стоимость,Срок ПИ,Дата
списания,ID,МОЛ";
string hiddenCols = "0,2,5,8,14";
string colSizes = "0,190,0,130,80,0,250,75,0,180,75,70,40,75,0,250";
this.loadSQLinGridView(colCnt, sql, fReport.grid, headers,
hiddenCols, colSizes);
int old_fil =
int.Parse(fReport.grid.Rows[0].Cells[0].Value.ToString());
for (int i = 1; i < fReport.grid.RowCount; i++)
{
107
int new_fil =
int.Parse(fReport.grid.Rows[i].Cells[0].Value.ToString());
if (old_fil == new_fil)
fReport.grid.Rows[i].Cells[1].Value = "";
else
old_fil = new_fil;
}
fReport.ShowDialog();
}
private void
материальноОтветственныеЛицаПоФилиаламToolStripMenuItem_Click(object sender,
EventArgs e)
{
fReport = new report(this, "Материально ответственные лица по
филиалам");
int colCnt = 4;
string sql = @"
select distinct
c.id_fil, concat(c.kod, ' ', c.filial) as filial,
d.id_mol, concat('[', d.kod, '] ', d.fio, ' тел: ', d.tel) as mol
from mto as a
inner join filiali as c on a.id_fil=c.id_fil
inner join mol as d on a.id_mol=d.id_mol
order by c.id_fil asc
";
string headers = "ID,Филиал,ID,МОЛ";
string hiddenCols = "0,2";
string colSizes = "0,250,0,700";
this.loadSQLinGridView(colCnt, sql, fReport.grid, headers,
hiddenCols, colSizes);
int old_fil =
int.Parse(fReport.grid.Rows[0].Cells[0].Value.ToString());
for (int i = 1; i < fReport.grid.RowCount; i++)
{
int new_fil =
int.Parse(fReport.grid.Rows[i].Cells[0].Value.ToString());
108
if (old_fil == new_fil)
fReport.grid.Rows[i].Cells[1].Value = "";
else
old_fil = new_fil;
}
fReport.ShowDialog();
}