1024 lines
42 KiB
C#
1024 lines
42 KiB
C#
using Mip.Models;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Data;
|
|
using System.Drawing;
|
|
using System.Windows.Forms;
|
|
using Excel = Microsoft.Office.Interop.Excel;
|
|
|
|
namespace Mip
|
|
{
|
|
public partial class frmZiadankaDoplnujuceInfo : Form
|
|
{
|
|
private int IDZiadankaDI = 0;
|
|
string TypFormulara = "";
|
|
//string NazovFirmy = "";
|
|
/*string = "";
|
|
string NazovFirmy = "";
|
|
string NazovFirmy = "";
|
|
string NazovFirmy = "";
|
|
*/
|
|
|
|
DataTable tabZiadanka;
|
|
List<ZiadankyInfo> ZoznamZiadaniek;
|
|
|
|
private AutoCompleteStringCollection acscPodmienky = new AutoCompleteStringCollection();
|
|
private AutoCompleteStringCollection acscPoznamky = new AutoCompleteStringCollection();
|
|
|
|
public frmZiadankaDoplnujuceInfo(List<ZiadankyInfo> zoznamZiadaniek, string typFormulara, string operacia, int doplnujuceinfoId = 0)
|
|
{
|
|
InitializeComponent();
|
|
ZoznamZiadaniek = zoznamZiadaniek;
|
|
|
|
TypFormulara = typFormulara;
|
|
this.Text = "Doplňujúce informácie pre žiadanku (Typ: " + TypFormulara + ")";
|
|
string cmd = "";
|
|
|
|
IDZiadankaDI = doplnujuceinfoId;
|
|
if (IDZiadankaDI > 0)
|
|
{
|
|
cmd = "select * from `tabziadankadoplnujuceinfo` where `IDZiadankaDoplnujuceInfo` = " + IDZiadankaDI.ToString() + ";";
|
|
classSQL.SQL(cmd, out tabZiadanka);
|
|
}
|
|
else
|
|
{
|
|
tabZiadanka = new DataTable();
|
|
}
|
|
|
|
if (tabZiadanka?.Rows?.Count > 0)
|
|
{
|
|
tabZiadanka.TableName = "Update";
|
|
|
|
var cmdCislo = $"SELECT Distinct `Cislo` from `pohladziadankadokument` where `IdDoplnujuceInfo` = {IDZiadankaDI.ToString()};";
|
|
string cisloDokumentu = string.Empty;
|
|
classSQL.SQL(cmdCislo, out cisloDokumentu);
|
|
|
|
textBox10.Text = cisloDokumentu;
|
|
textBox11.Text = tabZiadanka.Rows[0]["Adresa1"].ToString();
|
|
textBox12.Text = tabZiadanka.Rows[0]["Adresa2"].ToString();
|
|
textBox13.Text = tabZiadanka.Rows[0]["Adresa3"].ToString();
|
|
textBox14.Text = tabZiadanka.Rows[0]["Adresa4"].ToString();
|
|
textBox15.Text = tabZiadanka.Rows[0]["Adresa5"].ToString();
|
|
textBox20.Text = tabZiadanka.Rows[0]["Vyhotovil"].ToString();
|
|
textBox19.Text = tabZiadanka.Rows[0]["Variabilný symbol"].ToString();
|
|
textBox18.Text = tabZiadanka.Rows[0]["Konštantný symbol"].ToString();
|
|
textBox17.Text = tabZiadanka.Rows[0]["Špecifický symbol"].ToString();
|
|
textBox2.Text = tabZiadanka.Rows[0]["Poznámky1"].ToString();
|
|
textBox3.Text = tabZiadanka.Rows[0]["Poznámky2"].ToString();
|
|
textBox4.Text = tabZiadanka.Rows[0]["Poznámky3"].ToString();
|
|
textBox5.Text = tabZiadanka.Rows[0]["Poznámky4"].ToString();
|
|
textBox6.Text = tabZiadanka.Rows[0]["Poznámky5"].ToString();
|
|
textBox7.Text = tabZiadanka.Rows[0]["Poznámky6"].ToString();
|
|
textBox8.Text = tabZiadanka.Rows[0]["Poznámky7"].ToString();
|
|
textBox9.Text = tabZiadanka.Rows[0]["Poznámky8"].ToString();
|
|
}
|
|
else
|
|
{
|
|
tabZiadanka.TableName = "Insert";
|
|
}
|
|
|
|
this.Tag = operacia;
|
|
|
|
DataTable tabPoznamky;
|
|
cmd = @"select distinct `Poznámky1` as Poznámky from tabziadankadoplnujuceinfo
|
|
union select `Poznámky2` from tabziadankadoplnujuceinfo
|
|
union select `Poznámky3` from tabziadankadoplnujuceinfo
|
|
union select `Poznámky4` from tabziadankadoplnujuceinfo
|
|
union select `Poznámky5` from tabziadankadoplnujuceinfo
|
|
union select `Poznámky6` from tabziadankadoplnujuceinfo
|
|
union select `Poznámky7` from tabziadankadoplnujuceinfo
|
|
union select `Poznámky8` from tabziadankadoplnujuceinfo
|
|
order by Poznámky";
|
|
classSQL.SQL(cmd, out tabPoznamky);
|
|
foreach (DataRow dr in tabPoznamky.Rows) { acscPoznamky.Add(dr["Poznámky"].ToString()); }
|
|
|
|
DataTable tabPodmienky;
|
|
cmd = @"select distinct `Dodacie a platob. podmienky` as Podmienky from tabziadankadoplnujuceinfo order by Podmienky";
|
|
classSQL.SQL(cmd, out tabPodmienky);
|
|
foreach (DataRow dr in tabPodmienky.Rows) { acscPodmienky.Add(dr["Podmienky"].ToString()); }
|
|
|
|
textBox1.AutoCompleteCustomSource = acscPodmienky;
|
|
textBox2.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox3.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox4.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox5.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox6.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox7.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox8.AutoCompleteCustomSource = acscPoznamky;
|
|
textBox9.AutoCompleteCustomSource = acscPoznamky;
|
|
|
|
if (operacia == "Tlačiť") button1.Text = "Použiť a vytlačiť";
|
|
if (operacia == "Exportovať XLSX") button1.Text = "Použiť a uložiť Excel";
|
|
|
|
textBox20.Text = $"{classUser.Titul} {classUser.Meno} {classUser.Priezvisko}";
|
|
}
|
|
|
|
|
|
|
|
private void button2_Click(object sender, EventArgs e)
|
|
{
|
|
this.Close();
|
|
}
|
|
|
|
private void frmZiadankaDoplnujuceInfo_Shown(object sender, EventArgs e)
|
|
{
|
|
|
|
//tabziadankadoplnujuceinfo
|
|
if (tabZiadanka.Rows.Count > 0)
|
|
{
|
|
dateTimePicker1.Value = Convert.ToDateTime(tabZiadanka.Rows[0]["Dátum vyhotovenia"].ToString());
|
|
dateTimePicker2.Value = Convert.ToDateTime(tabZiadanka.Rows[0]["Dátum vyhotovenia"].ToString());
|
|
dateTimePicker3.Value = Convert.ToDateTime(tabZiadanka.Rows[0]["Dátum vyhotovenia"].ToString());
|
|
|
|
switch (tabZiadanka.Rows[0]["Forma úhrady"].ToString())
|
|
{
|
|
case "Prevodný príkaz":
|
|
label7.BackColor = Color.LightGreen;
|
|
label7.Enabled = true;
|
|
label4.BackColor = Color.LightGreen;
|
|
label4.Tag = label7.Text;
|
|
break;
|
|
case "Dobierka":
|
|
label8.BackColor = Color.LightGreen;
|
|
label8.Enabled = true;
|
|
label4.BackColor = Color.LightGreen;
|
|
label4.Tag = label8.Text;
|
|
break;
|
|
case "Hotovosť":
|
|
label9.BackColor = Color.LightGreen;
|
|
label9.Enabled = true;
|
|
label4.BackColor = Color.LightGreen;
|
|
label4.Tag = label9.Text;
|
|
break;
|
|
}
|
|
|
|
switch (tabZiadanka.Rows[0]["Spôsob dopravy"].ToString())
|
|
{
|
|
case "Dobierka":
|
|
label10.BackColor = Color.LightGreen;
|
|
label10.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label10.Text;
|
|
break;
|
|
case "DPD":
|
|
label11.BackColor = Color.LightGreen;
|
|
label11.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label11.Text;
|
|
break;
|
|
case "Osobný odber":
|
|
label12.BackColor = Color.LightGreen;
|
|
label12.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label12.Text;
|
|
break;
|
|
case "Poštou":
|
|
label13.BackColor = Color.LightGreen;
|
|
label13.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label13.Text;
|
|
break;
|
|
case "DHL":
|
|
label17.BackColor = Color.LightGreen;
|
|
label17.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label17.Text;
|
|
break;
|
|
case "UPC":
|
|
label16.BackColor = Color.LightGreen;
|
|
label16.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label16.Text;
|
|
break;
|
|
case "TNT":
|
|
label14.BackColor = Color.LightGreen;
|
|
label14.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label14.Text;
|
|
break;
|
|
case "Rozvoz dodávateľom":
|
|
label15.BackColor = Color.LightGreen;
|
|
label15.Enabled = true;
|
|
label5.BackColor = Color.LightGreen;
|
|
label5.Tag = label15.Text;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
|
|
private void label23_Click(object sender, EventArgs e)
|
|
{
|
|
dateTimePicker1.Enabled = false;
|
|
label1.BackColor = Color.Empty;
|
|
label23.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label1_Click(object sender, EventArgs e)
|
|
{
|
|
dateTimePicker1.Enabled = true;
|
|
label1.BackColor = Color.LightGreen;
|
|
label23.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label2_Click(object sender, EventArgs e)
|
|
{
|
|
dateTimePicker2.Enabled = true;
|
|
label2.BackColor = Color.LightGreen;
|
|
label24.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label24_Click(object sender, EventArgs e)
|
|
{
|
|
dateTimePicker2.Enabled = false;
|
|
label2.BackColor = Color.Empty;
|
|
label24.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label3_Click(object sender, EventArgs e)
|
|
{
|
|
dateTimePicker3.Enabled = true;
|
|
label3.BackColor = Color.LightGreen;
|
|
label25.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label25_Click(object sender, EventArgs e)
|
|
{
|
|
dateTimePicker3.Enabled = false;
|
|
label3.BackColor = Color.Empty;
|
|
label25.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label4_Click(object sender, EventArgs e) { label4.BackColor = Color.LightGreen; label26.BackColor = Color.Coral; }
|
|
private void label4_BackColorChanged(object sender, EventArgs e)
|
|
{
|
|
if (label4.BackColor == Color.LightGreen)
|
|
{
|
|
label7.Enabled = true;
|
|
label8.Enabled = true;
|
|
label9.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
label7.Enabled = false;
|
|
label8.Enabled = false;
|
|
label9.Enabled = false;
|
|
}
|
|
}
|
|
|
|
private void label26_Click(object sender, EventArgs e)
|
|
{
|
|
label7.BackColor = Color.Empty;
|
|
label8.BackColor = Color.Empty;
|
|
label9.BackColor = Color.Empty;
|
|
label4.BackColor = Color.Empty;
|
|
label4.Tag = null;
|
|
label26.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label7_Click(object sender, EventArgs e)
|
|
{
|
|
label7.BackColor = Color.LightGreen;
|
|
label8.BackColor = Color.Empty;
|
|
label9.BackColor = Color.Empty;
|
|
label4.Tag = label7.Text;
|
|
}
|
|
|
|
private void label8_Click(object sender, EventArgs e)
|
|
{
|
|
label7.BackColor = Color.Empty;
|
|
label8.BackColor = Color.LightGreen;
|
|
label9.BackColor = Color.Empty;
|
|
label4.Tag = label8.Text;
|
|
}
|
|
|
|
private void label9_Click(object sender, EventArgs e)
|
|
{
|
|
label7.BackColor = Color.Empty;
|
|
label8.BackColor = Color.Empty;
|
|
label9.BackColor = Color.LightGreen;
|
|
label4.Tag = label9.Text;
|
|
}
|
|
|
|
private void label5_Click(object sender, EventArgs e) { label5.BackColor = Color.LightGreen; label27.BackColor = Color.Coral; }
|
|
private void label5_BackColorChanged(object sender, EventArgs e)
|
|
{
|
|
if (label5.BackColor == Color.LightGreen)
|
|
{
|
|
label10.Enabled = true;
|
|
label11.Enabled = true;
|
|
label12.Enabled = true;
|
|
label13.Enabled = true;
|
|
label14.Enabled = true;
|
|
label15.Enabled = true;
|
|
label16.Enabled = true;
|
|
label17.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
label10.Enabled = false;
|
|
label11.Enabled = false;
|
|
label12.Enabled = false;
|
|
label13.Enabled = false;
|
|
label14.Enabled = false;
|
|
label15.Enabled = false;
|
|
label16.Enabled = false;
|
|
label17.Enabled = false;
|
|
}
|
|
|
|
|
|
}
|
|
|
|
private void label27_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
|
|
label5.BackColor = Color.Empty;
|
|
label5.Tag = null;
|
|
label27.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label10_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.LightGreen;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label10.Text;
|
|
}
|
|
|
|
private void label11_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.LightGreen;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label11.Text;
|
|
}
|
|
|
|
private void label12_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.LightGreen;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label12.Text;
|
|
}
|
|
|
|
private void label13_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.LightGreen;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label13.Text;
|
|
}
|
|
|
|
private void label14_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.LightGreen;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label14.Text;
|
|
}
|
|
|
|
private void label15_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.LightGreen;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label15.Text;
|
|
}
|
|
|
|
private void label16_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.LightGreen;
|
|
label17.BackColor = Color.Empty;
|
|
label5.Tag = label16.Text;
|
|
}
|
|
|
|
private void label17_Click(object sender, EventArgs e)
|
|
{
|
|
label10.BackColor = Color.Empty;
|
|
label11.BackColor = Color.Empty;
|
|
label12.BackColor = Color.Empty;
|
|
label13.BackColor = Color.Empty;
|
|
label14.BackColor = Color.Empty;
|
|
label15.BackColor = Color.Empty;
|
|
label16.BackColor = Color.Empty;
|
|
label17.BackColor = Color.LightGreen;
|
|
label5.Tag = label17.Text;
|
|
}
|
|
|
|
private void label6_Click(object sender, EventArgs e)
|
|
{
|
|
textBox1.Enabled = true;
|
|
label6.BackColor = Color.LightGreen;
|
|
label28.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label28_Click(object sender, EventArgs e)
|
|
{
|
|
textBox1.Enabled = false;
|
|
textBox1.Text = "";
|
|
label6.BackColor = Color.Empty;
|
|
label28.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label18_Click(object sender, EventArgs e) { label18.BackColor = Color.LightGreen; label29.BackColor = Color.Coral; }
|
|
private void label18_BackColorChanged(object sender, EventArgs e)
|
|
{
|
|
if (label18.BackColor == Color.LightGreen)
|
|
{
|
|
label19.Enabled = true;
|
|
label20.Enabled = true;
|
|
label21.Enabled = true;
|
|
}
|
|
else
|
|
{
|
|
label19.Enabled = false;
|
|
label20.Enabled = false;
|
|
label21.Enabled = false;
|
|
}
|
|
}
|
|
|
|
private void label29_Click(object sender, EventArgs e)
|
|
{
|
|
label19.BackColor = Color.Empty;
|
|
label20.BackColor = Color.Empty;
|
|
label21.BackColor = Color.Empty;
|
|
|
|
label18.BackColor = Color.Empty;
|
|
label18.Tag = null;
|
|
label29.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label19_Click(object sender, EventArgs e)
|
|
{
|
|
label19.BackColor = Color.LightGreen;
|
|
label20.BackColor = Color.Empty;
|
|
label21.BackColor = Color.Empty;
|
|
label18.Tag = label19.Text;
|
|
}
|
|
|
|
private void label20_Click(object sender, EventArgs e)
|
|
{
|
|
label19.BackColor = Color.Empty;
|
|
label20.BackColor = Color.LightGreen;
|
|
label21.BackColor = Color.Empty;
|
|
label18.Tag = label20.Text;
|
|
}
|
|
|
|
private void label21_Click(object sender, EventArgs e)
|
|
{
|
|
label19.BackColor = Color.Empty;
|
|
label20.BackColor = Color.Empty;
|
|
label21.BackColor = Color.LightGreen;
|
|
label18.Tag = label21.Text;
|
|
}
|
|
|
|
private void label22_Click(object sender, EventArgs e)
|
|
{
|
|
if (TypFormulara == "Objednávka SK" || TypFormulara == "Objednávka ENG")
|
|
{
|
|
textBox8.Enabled = true;
|
|
textBox9.Enabled = true;
|
|
}
|
|
textBox2.Enabled = true;
|
|
textBox3.Enabled = true;
|
|
textBox4.Enabled = true;
|
|
textBox5.Enabled = true;
|
|
textBox6.Enabled = true;
|
|
textBox7.Enabled = true;
|
|
label22.BackColor = Color.LightGreen;
|
|
label30.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label30_Click(object sender, EventArgs e)
|
|
{
|
|
if (MessageBox.Show("Vymazať všetky textové polia?", "Upozornenie!", MessageBoxButtons.YesNo) == DialogResult.Yes)
|
|
{
|
|
textBox2.Text = "";
|
|
textBox3.Text = "";
|
|
textBox4.Text = "";
|
|
textBox5.Text = "";
|
|
textBox6.Text = "";
|
|
textBox7.Text = "";
|
|
textBox8.Text = "";
|
|
textBox9.Text = "";
|
|
|
|
textBox2.Enabled = false;
|
|
textBox3.Enabled = false;
|
|
textBox4.Enabled = false;
|
|
textBox5.Enabled = false;
|
|
textBox6.Enabled = false;
|
|
textBox7.Enabled = false;
|
|
textBox8.Enabled = false;
|
|
textBox9.Enabled = false;
|
|
label22.BackColor = Color.Empty;
|
|
label30.BackColor = Color.LightGray;
|
|
}
|
|
}
|
|
|
|
private void label31_Click(object sender, EventArgs e) { textBox2.Text = ""; label31.BackColor = Color.LightGray; }
|
|
private void label32_Click(object sender, EventArgs e) { textBox3.Text = ""; label32.BackColor = Color.LightGray; }
|
|
private void label33_Click(object sender, EventArgs e) { textBox4.Text = ""; label33.BackColor = Color.LightGray; }
|
|
private void label34_Click(object sender, EventArgs e) { textBox5.Text = ""; label34.BackColor = Color.LightGray; }
|
|
private void label35_Click(object sender, EventArgs e) { textBox6.Text = ""; label35.BackColor = Color.LightGray; }
|
|
private void label36_Click(object sender, EventArgs e) { textBox7.Text = ""; label36.BackColor = Color.LightGray; }
|
|
private void label37_Click(object sender, EventArgs e) { textBox8.Text = ""; label37.BackColor = Color.LightGray; }
|
|
private void label38_Click(object sender, EventArgs e) { textBox9.Text = ""; label38.BackColor = Color.LightGray; }
|
|
|
|
private void button1_Click(object sender, EventArgs e)
|
|
{
|
|
string strFormaUh = "";
|
|
string strSposobDop = "";
|
|
string strMena = "";
|
|
//Int32 doplnujuceInfoId;
|
|
|
|
if (label4.Tag != null) strFormaUh = label4.Tag.ToString();
|
|
if (label5.Tag != null) strSposobDop = label5.Tag.ToString();
|
|
if (label18.Tag != null) strMena = label18.Tag.ToString();
|
|
|
|
string cmd = "";
|
|
if (tabZiadanka.TableName == "Insert")
|
|
{
|
|
cmd = $@"insert into `tabziadankadoplnujuceinfo` (`Dátum záznamu`, `Dátum vyhotovenia`, `Dátum predpokl. dodania`, `Dátum dodania`, `Forma úhrady`, `Spôsob dopravy`, `Dodacie a platob. podmienky`,
|
|
`Mena`, `Poznámky1`, `Poznámky2`, `Poznámky3`, `Poznámky4`, `Poznámky5`, `Poznámky6`, `Poznámky7`, `Poznámky8`,
|
|
`Adresa1`, `Adresa2`, `Adresa3`, `Adresa4`, `Adresa5`, `Vyhotovil`, `Variabilný symbol`, `Konštantný symbol`, `Špecifický symbol`) VALUES(
|
|
'{DateTime.Now.Year.ToString()}-{DateTime.Now.Month.ToString()}-{DateTime.Now.Day.ToString()}',
|
|
'{dateTimePicker1.Value.Year.ToString()}-{dateTimePicker1.Value.Month.ToString()}-{dateTimePicker1.Value.Day.ToString()}',
|
|
'{dateTimePicker2.Value.Year.ToString()}-{dateTimePicker2.Value.Month.ToString()}-{dateTimePicker2.Value.Day.ToString()}',
|
|
'{dateTimePicker3.Value.Year.ToString()}-{dateTimePicker3.Value.Month.ToString()}-{dateTimePicker3.Value.Day.ToString()}',
|
|
'{strFormaUh}',
|
|
'{strSposobDop}',
|
|
'{textBox1.Text}',
|
|
'{strMena}',
|
|
'{textBox2.Text}',
|
|
'{textBox3.Text}',
|
|
'{textBox4.Text}',
|
|
'{textBox5.Text}',
|
|
'{textBox6.Text}',
|
|
'{textBox7.Text}',
|
|
'{textBox8.Text}',
|
|
'{textBox9.Text}',
|
|
'{textBox11.Text}',
|
|
'{textBox12.Text}',
|
|
'{textBox13.Text}',
|
|
'{textBox14.Text}',
|
|
'{textBox15.Text}',
|
|
'{textBox20.Text}',
|
|
'{textBox19.Text}',
|
|
'{textBox18.Text}',
|
|
'{textBox17.Text}');";
|
|
classSQL.SQL(cmd, out IDZiadankaDI);
|
|
|
|
var lastNumberCmd = $"SELECT MAX(`CisloDokumentu`) from `tabziadankadokument`;";
|
|
string lastNumber = string.Empty;
|
|
classSQL.SQL(lastNumberCmd, out lastNumber);
|
|
Int32 nextNumber = Convert.ToInt32(lastNumber) + 1;
|
|
textBox10.Text = $"CDZ-{nextNumber.ToString().PadLeft(7, '0')}-{DateTime.Now.Year.ToString()}";
|
|
|
|
foreach (var item in ZoznamZiadaniek)
|
|
{
|
|
var cmdInsertDocumentInfo = $"INSERT INTO `mip`.`tabziadankadokument` (`DatumVytvorenia`, `IdZiadanka`, `IdDoplnujuceInfo`, `CisloDokumentu`) VALUES (NOW(), '{item.IDZiadanka}', {IDZiadankaDI}, {nextNumber});";
|
|
classSQL.SQL(cmdInsertDocumentInfo);
|
|
}
|
|
}
|
|
else
|
|
{
|
|
cmd = $@"update `mip`.`tabziadankadoplnujuceinfo` SET
|
|
`Dátum vyhotovenia` = '{dateTimePicker1.Value.Year.ToString()}-{dateTimePicker1.Value.Month.ToString()}-{dateTimePicker1.Value.Day.ToString()}',
|
|
`Dátum predpokl. dodania` = '{dateTimePicker2.Value.Year.ToString()}-{dateTimePicker2.Value.Month.ToString()}-{dateTimePicker2.Value.Day.ToString()}',
|
|
`Dátum dodania` = '{dateTimePicker3.Value.Year.ToString()}-{dateTimePicker3.Value.Month.ToString()}-{dateTimePicker3.Value.Day.ToString()}',
|
|
`Forma úhrady` = '{strFormaUh}',
|
|
`Spôsob dopravy` = '{strSposobDop}',
|
|
`Dodacie a platob. podmienky` = '{textBox1.Text}',
|
|
`Mena` = '{strMena}',
|
|
`Poznámky1` = '{textBox2.Text}',
|
|
`Poznámky2` = '{textBox3.Text}',
|
|
`Poznámky3` = '{textBox4.Text}',
|
|
`Poznámky4` = '{textBox5.Text}',
|
|
`Poznámky5` = '{textBox6.Text}',
|
|
`Poznámky6` = '{textBox7.Text}',
|
|
`Poznámky7` = '{textBox8.Text}',
|
|
`Poznámky8` = '{textBox9.Text}',
|
|
`Adresa1` = '{textBox11.Text}',
|
|
`Adresa2` = '{textBox12.Text}',
|
|
`Adresa3` = '{textBox13.Text}',
|
|
`Adresa4` = '{textBox14.Text}',
|
|
`Adresa5` = '{textBox15.Text}',
|
|
`Vyhotovil` = '{textBox20.Text}',
|
|
`Variabilný symbol` = '{textBox19.Text}',
|
|
`Konštantný symbol` = '{textBox18.Text}',
|
|
`Špecifický symbol` = '{textBox17.Text}'
|
|
WHERE `tabziadankadoplnujuceinfo`= {IDZiadankaDI.ToString()};";
|
|
}
|
|
|
|
string strNazovFormulara = TypFormulara;
|
|
classGlobal.DeleteRamDisk(); classGlobal.CreateRamDisk();
|
|
|
|
classSQL.ExportFormToHDD(TypFormulara + ".xlsx", @"W:\" + TypFormulara + ".xlsx");
|
|
|
|
Excel.Application xlApp;
|
|
Excel.Workbook xlWorkBook;
|
|
Excel.Worksheet xlWorkSheet;
|
|
Excel.Range range;
|
|
|
|
xlApp = new Excel.Application();
|
|
xlWorkBook = xlApp.Workbooks.Open(@"W:\" + TypFormulara + ".xlsx");
|
|
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
|
|
range = xlWorkSheet.UsedRange;
|
|
|
|
xlWorkSheet.Range["AB2"].Value = textBox10.Text; //dopyt cislo
|
|
xlWorkSheet.Range["T7"].Value = textBox11.Text; //adresa riadok 1
|
|
xlWorkSheet.Range["T9"].Value = textBox12.Text; //adresa riadok 2
|
|
xlWorkSheet.Range["T11"].Value = textBox13.Text; //adresa riadok 3
|
|
xlWorkSheet.Range["T13"].Value = textBox14.Text; //adresa riadok 4
|
|
xlWorkSheet.Range["T15"].Value = textBox15.Text; //adresa riadok 5
|
|
xlWorkSheet.Range["G16"].Value = textBox20.Text; //vyhotovil
|
|
xlWorkSheet.Range["V22"].Value = textBox19.Text; //variabilny symbol
|
|
xlWorkSheet.Range["AA22"].Value = textBox18.Text; //konstantny symbol
|
|
xlWorkSheet.Range["AF22"].Value = textBox17.Text; //specificky symbol
|
|
xlWorkSheet.Range["J18"].Value = dateTimePicker1.Value; //datum vyhotovenia
|
|
xlWorkSheet.Range["J19"].Value = dateTimePicker2.Value; //Dátum predpoklad. dodania:
|
|
xlWorkSheet.Range["J20"].Value = dateTimePicker3.Value; //Dátum dodania:
|
|
xlWorkSheet.Range["J21"].Value = strFormaUh; //forma uhrady
|
|
xlWorkSheet.Range["J22"].Value = strSposobDop; //sposob dopravy
|
|
xlWorkSheet.Range["J23"].Value = textBox1.Text; //dodacie podmienky
|
|
xlWorkSheet.Range["B28"].Value = "1"; //poradove cislo 1
|
|
xlWorkSheet.Range["B29"].Value = "2"; //poradove cislo 2
|
|
xlWorkSheet.Range["B30"].Value = "3"; //poradove cislo 3
|
|
xlWorkSheet.Range["B31"].Value = "4"; //poradove cislo 4
|
|
xlWorkSheet.Range["B32"].Value = "5"; //poradove cislo 5
|
|
xlWorkSheet.Range["B33"].Value = "6"; //poradove cislo 6
|
|
xlWorkSheet.Range["B34"].Value = "7"; //poradove cislo 7
|
|
xlWorkSheet.Range["B35"].Value = "8"; //poradove cislo 8
|
|
xlWorkSheet.Range["B36"].Value = "9"; //poradove cislo 9
|
|
xlWorkSheet.Range["B37"].Value = "10"; //poradove cislo 10
|
|
|
|
for (int i = 0; i < ZoznamZiadaniek.Count; i++)
|
|
{
|
|
switch (i)
|
|
{
|
|
case 0:
|
|
xlWorkSheet.Range["D28"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 1
|
|
xlWorkSheet.Range["H28"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 1
|
|
xlWorkSheet.Range["AF28"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 1
|
|
xlWorkSheet.Range["AI28"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 1
|
|
break;
|
|
|
|
case 1:
|
|
xlWorkSheet.Range["D29"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 2
|
|
xlWorkSheet.Range["H29"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 2
|
|
xlWorkSheet.Range["AF29"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 2
|
|
xlWorkSheet.Range["AI29"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 2
|
|
|
|
break;
|
|
|
|
case 2:
|
|
xlWorkSheet.Range["AF30"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 3
|
|
xlWorkSheet.Range["D30"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 3
|
|
xlWorkSheet.Range["H30"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 3
|
|
xlWorkSheet.Range["AI30"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 3
|
|
|
|
break;
|
|
|
|
case 3:
|
|
xlWorkSheet.Range["D31"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 4
|
|
xlWorkSheet.Range["H31"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 4
|
|
xlWorkSheet.Range["AF31"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 4
|
|
xlWorkSheet.Range["AI31"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 4
|
|
|
|
break;
|
|
|
|
case 4:
|
|
xlWorkSheet.Range["D32"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 5
|
|
xlWorkSheet.Range["H32"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 5
|
|
xlWorkSheet.Range["AF32"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 5
|
|
xlWorkSheet.Range["AI32"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 5
|
|
|
|
break;
|
|
|
|
case 5:
|
|
xlWorkSheet.Range["D33"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 6
|
|
xlWorkSheet.Range["H33"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 6
|
|
xlWorkSheet.Range["AF33"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 6
|
|
xlWorkSheet.Range["AI33"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 6
|
|
|
|
break;
|
|
|
|
case 6:
|
|
xlWorkSheet.Range["D34"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 7
|
|
xlWorkSheet.Range["H34"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 7
|
|
xlWorkSheet.Range["AF34"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 7
|
|
xlWorkSheet.Range["AI34"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 7
|
|
|
|
break;
|
|
|
|
case 7:
|
|
xlWorkSheet.Range["D35"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 8
|
|
xlWorkSheet.Range["H35"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 8
|
|
xlWorkSheet.Range["AF35"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 8
|
|
xlWorkSheet.Range["AI35"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 8
|
|
|
|
break;
|
|
|
|
case 8:
|
|
xlWorkSheet.Range["D36"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 9
|
|
xlWorkSheet.Range["H36"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 9
|
|
xlWorkSheet.Range["AF36"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 9
|
|
xlWorkSheet.Range["AI36"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 9
|
|
|
|
break;
|
|
|
|
case 9:
|
|
xlWorkSheet.Range["D37"].Value = ZoznamZiadaniek[i]?.Typ; //kod polozky 10
|
|
xlWorkSheet.Range["H37"].Value = ZoznamZiadaniek[i]?.Nazov; //popis 10
|
|
xlWorkSheet.Range["AF37"].Value = ZoznamZiadaniek[i]?.PocetKs; //mnozstvo 10
|
|
xlWorkSheet.Range["AI37"].Value = ZoznamZiadaniek[i]?.Jednotka; //merna jednotka 10
|
|
|
|
break;
|
|
default:
|
|
break;
|
|
}
|
|
}
|
|
xlWorkSheet.Range["C40"].Value = textBox2.Text; //poznamka riadok 1
|
|
xlWorkSheet.Range["C41"].Value = textBox3.Text; //poznamka riadok 2
|
|
xlWorkSheet.Range["C42"].Value = textBox4.Text; //poznamka riadok 3
|
|
xlWorkSheet.Range["C43"].Value = textBox5.Text; //poznamka riadok 4
|
|
xlWorkSheet.Range["C44"].Value = textBox6.Text; //poznamka riadok 5
|
|
xlWorkSheet.Range["C45"].Value = textBox7.Text; //poznamka riadok 6
|
|
xlWorkSheet.Range["C46"].Value = textBox8.Text; //poznamka riadok 7
|
|
xlWorkSheet.Range["C47"].Value = textBox9.Text; //poznamka riadok 8
|
|
|
|
|
|
if (this.Tag.ToString() == "Tlačiť")
|
|
{
|
|
xlApp.Visible = true;
|
|
xlApp.ActiveWindow.Activate();
|
|
xlWorkSheet.PrintPreview();
|
|
xlApp.Visible = false;
|
|
|
|
xlWorkBook.Save();
|
|
xlWorkBook.Close(false, null, null);
|
|
xlApp.Quit();
|
|
classGlobal.DeleteRamDisk();
|
|
}
|
|
else
|
|
{
|
|
var saveExcel = new SaveFileDialog();
|
|
if (saveExcel.ShowDialog() == DialogResult.OK)
|
|
{
|
|
xlApp.ActiveWindow.Activate();
|
|
xlApp.Visible = false;
|
|
xlWorkBook.Save();
|
|
xlWorkBook.SaveCopyAs(saveExcel.FileName);
|
|
xlWorkBook.Close(false, null, null);
|
|
xlApp.Quit();
|
|
}
|
|
}
|
|
|
|
this.Close();
|
|
}
|
|
|
|
private void label42_Click(object sender, EventArgs e)
|
|
{
|
|
textBox11.Enabled = true;
|
|
label42.BackColor = Color.LightGreen;
|
|
label41.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label41_Click(object sender, EventArgs e)
|
|
{
|
|
textBox11.Enabled = false;
|
|
textBox11.Text = "";
|
|
label42.BackColor = Color.Empty;
|
|
label41.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label44_Click(object sender, EventArgs e)
|
|
{
|
|
textBox12.Enabled = true;
|
|
label44.BackColor = Color.LightGreen;
|
|
label43.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label43_Click(object sender, EventArgs e)
|
|
{
|
|
textBox12.Enabled = false;
|
|
textBox12.Text = "";
|
|
label44.BackColor = Color.Empty;
|
|
label43.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label46_Click(object sender, EventArgs e)
|
|
{
|
|
textBox13.Enabled = true;
|
|
label46.BackColor = Color.LightGreen;
|
|
label45.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label45_Click(object sender, EventArgs e)
|
|
{
|
|
textBox13.Enabled = false;
|
|
textBox13.Text = "";
|
|
label46.BackColor = Color.Empty;
|
|
label45.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label48_Click(object sender, EventArgs e)
|
|
{
|
|
textBox14.Enabled = true;
|
|
label48.BackColor = Color.LightGreen;
|
|
label47.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label47_Click(object sender, EventArgs e)
|
|
{
|
|
textBox14.Enabled = false;
|
|
textBox14.Text = "";
|
|
label48.BackColor = Color.Empty;
|
|
label47.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label50_Click(object sender, EventArgs e)
|
|
{
|
|
textBox15.Enabled = true;
|
|
label50.BackColor = Color.LightGreen;
|
|
label49.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label49_Click(object sender, EventArgs e)
|
|
{
|
|
textBox15.Enabled = false;
|
|
textBox15.Text = "";
|
|
label50.BackColor = Color.Empty;
|
|
label49.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label60_Click(object sender, EventArgs e)
|
|
{
|
|
//textBox20.Enabled = true;
|
|
label60.BackColor = Color.LightGreen;
|
|
label59.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label59_Click(object sender, EventArgs e)
|
|
{
|
|
//textBox20.Enabled = false;
|
|
//textBox20.Text = "";
|
|
label60.BackColor = Color.Empty;
|
|
label59.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label58_Click(object sender, EventArgs e)
|
|
{
|
|
textBox19.Enabled = true;
|
|
label58.BackColor = Color.LightGreen;
|
|
label57.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label57_Click(object sender, EventArgs e)
|
|
{
|
|
textBox19.Enabled = false;
|
|
textBox19.Text = "";
|
|
label58.BackColor = Color.Empty;
|
|
label57.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label56_Click(object sender, EventArgs e)
|
|
{
|
|
textBox18.Enabled = true;
|
|
label56.BackColor = Color.LightGreen;
|
|
label55.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label55_Click(object sender, EventArgs e)
|
|
{
|
|
textBox18.Enabled = false;
|
|
textBox18.Text = "";
|
|
label56.BackColor = Color.Empty;
|
|
label55.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void label54_Click(object sender, EventArgs e)
|
|
{
|
|
textBox17.Enabled = true;
|
|
label54.BackColor = Color.LightGreen;
|
|
label53.BackColor = Color.Coral;
|
|
}
|
|
|
|
private void label53_Click(object sender, EventArgs e)
|
|
{
|
|
textBox17.Enabled = false;
|
|
textBox17.Text = "";
|
|
label54.BackColor = Color.Empty;
|
|
label53.BackColor = Color.LightGray;
|
|
}
|
|
|
|
private void textBox2_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (textBox2.Text == string.Empty)
|
|
{
|
|
label31.BackColor = Color.LightGray;
|
|
}
|
|
else
|
|
{
|
|
label31.BackColor = Color.Coral;
|
|
}
|
|
}
|
|
|
|
private void textBox3_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (textBox3.Text == string.Empty)
|
|
{
|
|
label32.BackColor = Color.LightGray;
|
|
}
|
|
else
|
|
{
|
|
label32.BackColor = Color.Coral;
|
|
}
|
|
}
|
|
|
|
private void textBox4_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (textBox4.Text == string.Empty)
|
|
{
|
|
label33.BackColor = Color.LightGray;
|
|
}
|
|
else
|
|
{
|
|
label33.BackColor = Color.Coral;
|
|
}
|
|
}
|
|
|
|
private void textBox5_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (textBox5.Text == string.Empty)
|
|
{
|
|
label34.BackColor = Color.LightGray;
|
|
}
|
|
else
|
|
{
|
|
label34.BackColor = Color.Coral;
|
|
}
|
|
}
|
|
|
|
private void textBox6_TextChanged(object sender, EventArgs e)
|
|
{
|
|
if (textBox6.Text == string.Empty)
|
|
{
|
|
label35.BackColor = Color.LightGray;
|
|
}
|
|
else
|
|
{
|
|
label35.BackColor = Color.Coral;
|
|
}
|
|
}
|
|
|
|
private void textBox7_TextChanged(object sender, EventArgs e)
|
|
{
|
|
|
|
}
|
|
}
|
|
}
|