102
{
if (!radioButton1.Checked && !radioButton2.Checked)
return;
if (comboBox1.SelectedIndex < 0)
return;
int colCnt = 16;
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";
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
where ";
if (radioButton1.Checked) // ПосостояниюМТО
{
string id_sos = hash[comboBox1.SelectedIndex].ToString();
sql += "a.id_sos=" + id_sos;
fMain.loadSQLinGridView(colCnt, sql, this.dataGridView1,
headers, hiddenCols, colSizes);