public void otZaMes() { Documentacia configurationForm = new Documentacia(); configurationForm.Documentacia_Load(null, null); switch (Registry_Class.DirPath == "Empry" || Registry_Class.OrganizationName == "Empty" || Registry_Class.DocBM == 0.0 || Registry_Class.DocTM == 0.0 || Registry_Class.DocRM == 0.0 || Registry_Class.DocLM == 0.0) { case (true): configurationForm.ShowDialog(); break; case (false): DataBaseTables data = new DataBaseTables(); data.qrChek = "SELECT dbo.Chek.INN, dbo.Sotr.Surname_Sotr + ' ' + dbo.Sotr.Name_Sotr + ' ' + dbo.Sotr.Middle_name_Sotr, 'Фирма: ' + dbo.Firma.NaimFir + ', Вид: ' + dbo.Vidi_Tov.Naim + ', Пол: ' + dbo.Pol.Pol + ', Цвет: ' + dbo.Cvet_Tov.Cvet + ', Наименование товара: ' + dbo.Tovar.Naim AS 'Наименование товара', dbo.Chek.Kol_Vo* dbo.Tovar.Cena FROM dbo.Chek INNER JOIN dbo.Sotr ON dbo.Chek.Login_Sotr = dbo.Sotr.Login_Sotr INNER JOIN dbo.Tovar ON dbo.Chek.ID_Tovar = dbo.Tovar.ID_Tovar INNER JOIN dbo.Firma ON dbo.Tovar.Firm_ID = dbo.Firma.ID_Firm INNER JOIN dbo.Pol ON dbo.Tovar.ID_Pol = dbo.Pol.ID_Pol INNER JOIN dbo.Cvet_Tov ON dbo.Tovar.ID_Cvet = dbo.Cvet_Tov.ID_Cvet INNER JOIN dbo.Vidi_Tov ON dbo.Tovar.ID_Vid = dbo.Vidi_Tov.ID_Vid where SUBSTRING(Data_Pech,4,2) = MONTH(GETDATE())"; data.dtChekFill(); WordDocument document = new WordDocument(); command.CommandText = "SELECT Sum(dbo.Chek.Kol_Vo* dbo.Tovar.Cena) FROM dbo.Chek INNER JOIN dbo.Sotr ON dbo.Chek.Login_Sotr = dbo.Sotr.Login_Sotr INNER JOIN dbo.Tovar ON dbo.Chek.ID_Tovar = dbo.Tovar.ID_Tovar INNER JOIN dbo.Firma ON dbo.Tovar.Firm_ID = dbo.Firma.ID_Firm INNER JOIN dbo.Pol ON dbo.Tovar.ID_Pol = dbo.Pol.ID_Pol INNER JOIN dbo.Cvet_Tov ON dbo.Tovar.ID_Cvet = dbo.Cvet_Tov.ID_Cvet INNER JOIN dbo.Vidi_Tov ON dbo.Tovar.ID_Vid = dbo.Vidi_Tov.ID_Vid where SUBSTRING(Data_Pech,4,2) = MONTH(GETDATE())"; Registry_Class.sqlConnection.Open(); Itog = (decimal)command.ExecuteScalar(); Registry_Class.sqlConnection.Close(); document.table = data.dtChek; document.table2 = Itog.ToString(); document.CheckOtch2(); break; } }
private void otch() { Documentacia configurationForm = new Documentacia(); configurationForm.Documentacia_Load(null, null); switch (Registry_Class.DirPath == "Empry" || Registry_Class.OrganizationName == "Empty" || Registry_Class.DocBM == 0.0 || Registry_Class.DocTM == 0.0 || Registry_Class.DocRM == 0.0 || Registry_Class.DocLM == 0.0) { case (true): configurationForm.ShowDialog(); break; case (false): DataBaseTables data = new DataBaseTables(); data.qrSklad = "SELECT 'Фирма: ' + dbo.Firma.NaimFir + ', Вид: ' + dbo.Vidi_Tov.Naim + ', Пол: ' + dbo.Pol.Pol + ', Цвет: ' + dbo.Cvet_Tov.Cvet + ', Наимнование товара: ' + dbo.Tovar.Naim AS 'Наименование товара', dbo.Sklad.Kol_vo_Tov FROM dbo.Cvet_Tov INNER JOIN dbo.Tovar ON dbo.Cvet_Tov.ID_Cvet = dbo.Tovar.ID_Cvet INNER JOIN dbo.Firma ON dbo.Tovar.Firm_ID = dbo.Firma.ID_Firm INNER JOIN dbo.Pol ON dbo.Tovar.ID_Pol = dbo.Pol.ID_Pol INNER JOIN dbo.Sklad ON dbo.Tovar.ID_Tovar = dbo.Sklad.ID_Tovar INNER JOIN dbo.Vidi_Tov ON dbo.Tovar.ID_Vid = dbo.Vidi_Tov.ID_Vid "; data.dtSkladFill(); PDFDocument document = new PDFDocument(); document.dtDannieSklada = data.dtSklad; document.Docum(); break; } }
public void otch() { Documentacia configurationForm = new Documentacia(); configurationForm.Documentacia_Load(null, null); switch (Registry_Class.DirPath == "Empry" || Registry_Class.OrganizationName == "Empty" || Registry_Class.DocBM == 0.0 || Registry_Class.DocTM == 0.0 || Registry_Class.DocRM == 0.0 || Registry_Class.DocLM == 0.0) { case (true): configurationForm.ShowDialog(); break; case (false): DataBaseTables data = new DataBaseTables(); data.qrSotr = "SELECT dbo.Sotr.Surname_Sotr + ' ' + dbo.Sotr.Name_Sotr + ' ' + dbo.Sotr.Middle_name_Sotr, dbo.Sotr.The_date_of_the_Rojd, dbo.Access_rights.Dolj FROM dbo.Access_rights INNER JOIN dbo.Profile ON dbo.Access_rights.ID_Access_rights = dbo.Profile.Access_rights_ID INNER JOIN dbo.Sotr ON dbo.Profile.Login_Profile = dbo.Sotr.Login_Sotr ORDER BY dbo.Access_rights.Dolj ASC"; data.dtSotrFill(); ExcelDocument document = new ExcelDocument(); document.dtDannieSklada = data.dtSotr; document.SpisokSotr(); break; } }
private void НастройкаОтчетностиToolStripMenuItem_Click(object sender, EventArgs e) { Documentacia documentacia = new Documentacia(); documentacia.Show(); }