//aktualizacj naglowka WZ
public void fAktualizujWZGlowka(string sIDWz, string sNetto, string sVat, string sBrutto)
{
//string sReturn = "Error";
string query = "update GM_WZ set " +
"WAL_WARTOSC_NETTO = " + sNetto.Replace(",", ".") + ", " +
"WAL_KWOTA_VAT = " + sVat.Replace(",", ".") + ", " +
"WAL_WARTOSC_BRUTTO = " + sBrutto.Replace(",", ".") + ", " +
"PLN_WARTOSC_NETTO = " + sNetto.Replace(",", ".") + ", " +
"WARTOSC_ROZRACHUNKU = " + sBrutto.Replace(",", ".") + ", " +
"PLN_KWOTA_VAT = " + sVat.Replace(",", ".") + ", " +
"PLN_WARTOSC_BRUTTO = " + sBrutto.Replace(",", ".") + " " +
" where (ID = " + sIDWz + ") ";
//Open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
FbCommand cmd = new FbCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
fbLogowanie = new fblog();
fbLogowanie.sLOG(settings.IDLogin, settings.osoba, "2", settings.login, settings.pass, query);
}
private void button1_Click(object sender, EventArgs e)
{
if (textBox1.Text == "" || textBox2.Text == "")
{
MessageBox.Show("Brak nazwy (loginu) lub hasła. Nie można zapisać takiego użytkownika");
return;
}
string sAktywny = "0";
fbLogowanie = new fblog();
if (checkBox1.Checked == true) sAktywny = "1";
if (textBox4.Text != "")
fbLogowanie.fAktualizujUser(textBox1.Text, textBox2.Text, textBox3.Text, sAktywny);
else
{
if (fbLogowanie.fCzyJestLogin(textBox1.Text) == "0")
fbLogowanie.fDodajUserRAKS(textBox1.Text, textBox3.Text, textBox2.Text, sAktywny);
else
MessageBox.Show("Już jest użytkownik o identyfikatorze(Login): " + textBox1.Text + "", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
fUserList();
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
checkBox1.Checked = false;
textBox1.Enabled = true;
}
public void fSpisMagazynow()
{
fbLogowanie = new fblog();
List<string>[] lstDokumenty = fbLogowanie.fUPRMAg(settings.IDLogin);
dataGridView3.Rows.Clear();
dataGridView4.Rows.Clear();
for (int i = 0; i < lstDokumenty[0].Count; i++)
{
int number = dataGridView4.Rows.Add();
dataGridView4.Rows[number].Cells[0].Value = lstDokumenty[0][i].ToString();
dataGridView4.Rows[number].Cells[1].Value = lstDokumenty[1][i].ToString();
dataGridView4.Rows[number].Cells[2].Value = lstDokumenty[2][i].ToString();
}
}
private void fUserList()
{
fbLogowanie = new fblog();
List<string>[] lstUsers = fbLogowanie.fUsers();
dataGridView2.Rows.Clear();
for (int i = 0; i < lstUsers[0].Count; i++)
{
int number = dataGridView2.Rows.Add();
dataGridView2.Rows[number].Cells[0].Value = lstUsers[0][i].ToString();
dataGridView2.Rows[number].Cells[1].Value = lstUsers[1][i].ToString();
dataGridView2.Rows[number].Cells[2].Value = lstUsers[2][i].ToString();
dataGridView2.Rows[number].Cells[3].Value = lstUsers[3][i].ToString();
dataGridView2.Rows[number].Cells[4].Value = lstUsers[4][i].ToString();
if (lstUsers[2][i].ToString() == "") dataGridView2.Rows[number].DefaultCellStyle.BackColor = Color.Tomato;
}
}
private void checkBox1_Click(object sender, EventArgs e)
{
//MessageBox.Show(checkBox1.Checked.ToString(), "");
string sBlokadaPZ = "0";
if (checkBox1.Checked) sBlokadaPZ = "1";
fbLogowanie = new fblog();
fbLogowanie.fAktualizujBlokadaPZ(sBlokadaPZ);
}
private void dataGridView4_Click(object sender, EventArgs e)
{
try
{
textBox8.Text = dataGridView4.CurrentRow.Cells[0].Value.ToString();
textBox6.Text = dataGridView4.CurrentRow.Cells[1].Value.ToString();
textBox3.Text = "";
try
{
string sIdMag = dataGridView4.CurrentRow.Cells[0].Value.ToString();
fbLogowanie = new fblog();
List<string>[] lstDokumenty = fbLogowanie.fUPRKodDlaMAg(settings.IDLogin, sIdMag);
dataGridView3.Rows.Clear();
for (int i = 0; i < lstDokumenty[0].Count; i++)
{
int number = dataGridView3.Rows.Add();
dataGridView3.Rows[number].Cells[0].Value = lstDokumenty[0][i].ToString();
dataGridView3.Rows[number].Cells[1].Value = lstDokumenty[1][i].ToString();
dataGridView3.Rows[number].Cells[2].Value = lstDokumenty[2][i].ToString();
}
}
catch (NullReferenceException) { }
}
catch (NullReferenceException) { }
}
public void fAktualizujWZPoz(string sIDPoz, string sNetto, string sBrutto)
{
//string sReturn = "Error";
string query = "update GM_WZPOZ set " +
"CENA_SPRZEDAZY_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_NETTO_SPRZ_PO_RAB_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_SPRZ_WAL_PO_RAB_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_SP_NETTO_ALT_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_SP_PLN_ALT_PO = " + sNetto.Replace(",", ".") + ", " +
"CENA_KATALOGOWA = " + sNetto.Replace(",", ".") + ", " +
"CENA_BRUTTO_SPRZ_PO_RAB_PO = " + sBrutto.Replace(",", ".") + ", " +
"CENA_SP_BRUTTO_ALT_PO = " + sBrutto.Replace(",", ".") + " " +
" where (ID = " + sIDPoz + ") ";
//Open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
FbCommand cmd = new FbCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
fbLogowanie = new fblog();
fbLogowanie.sLOG(settings.IDLogin, settings.osoba, "2", settings.login, settings.pass, query);
}
public void fAktualizujWZStawkiVat(string sIDWz, string sNetto, string sVat, string sBrutto)
{
//string sReturn = "Error";
string query = "update GM_SPRZEDAZ_VAT set " +
"NETTO = " + sNetto.Replace(",",".") + ", " +
"VAT = " + sVat.Replace(",", ".") + ", " +
"BRUTTO = " + sBrutto.Replace(",", ".") + " " +
" where (ID_WZ = " + sIDWz + ") ";
//Open connection
if (this.OpenConnection() == true)
{
//create command and assign the query and connection from the constructor
FbCommand cmd = new FbCommand(query, connection);
//Execute command
cmd.ExecuteNonQuery();
//close connection
this.CloseConnection();
}
fbLogowanie = new fblog();
fbLogowanie.sLOG(settings.IDLogin, settings.osoba, "2", settings.login, settings.pass, query);
}
private void button2_Click(object sender, EventArgs e)
{
//InitializeConnStr();
string sLogin = ""; string sPass = "";
//if (textBox3.Text != "0")
//{
// sLogin = "******";
// sPass = "******";
//}
//else
//{
sLogin = textBox1.Text;
sPass = textBox2.Text;
//}
fbLogowanie = new fblog();
List<string>[] lstLogin = fbLogowanie.sLogowanie(sLogin, sPass);
if (lstLogin[0].Count == 0)
{
MessageBox.Show("Nie znaleziono użytkownika. \r\n Spróbuj ponownie.");
fbLogowanie.sLOGErr(sLogin, sPass);
textBox2.Text = "";
return;
}
if (lstLogin[4][0].ToString() == "0")
{
MessageBox.Show("Użytkownik " + sLogin + " ma wyłaczone konto\nSkontaktuj się z administratorem");
fbLogowanie.sLOGErr(sLogin, sPass, true);
textBox2.Text = "";
return;
}
fbLogowanie.sLOG(lstLogin[0][0].ToString(),lstLogin[3][0].ToString(),"1",sLogin, sPass);
settings.IDLogin = lstLogin[0][0].ToString();
settings.osoba = lstLogin[3][0].ToString();
settings.login = sLogin;
settings.pass = sPass;
settings.Save();
//frmWZ = new zt();
//frmWZ.Show();
frmZnaczniki = new znaczniki();
frmZnaczniki.Show();
this.Visible = false;
//this.Close();
}
private void dataGridView3_DoubleClick(object sender, EventArgs e)
{
try
{
if (textBox4.Text == "")
{
MessageBox.Show("Wybierz użytkownika, któremu chcesz dodać obsługę magazynu", "Błąd", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
//DialogResult dlr;
string sID = dataGridView3.CurrentRow.Cells[0].Value.ToString();
string sNumer = dataGridView3.CurrentRow.Cells[1].Value.ToString();
string sNazwa = dataGridView3.CurrentRow.Cells[2].Value.ToString();
string sMaska = dataGridView3.CurrentRow.Cells[3].Value.ToString();
string sDok = dataGridView3.CurrentRow.Cells[4].Value.ToString();
fbLogowanie = new fblog();
if (fbLogowanie.fCzyJestMagazyn(sID) == "0")
{
//dodawanie do spisu
fbLogowanie.fDodajMagazyn(sID, sNumer, sNazwa, sMaska, sDok);
}
else
{
//edycja
/*zmiana w programie. poniewaz nie używam tabeli pośredniej dla magazynów aktualizację trzeba zrobićbez pytania */
//dlr = MessageBox.Show("Już dodano magazyn o ID: " + sID + "\nCzy aktualizowac istniejący wpis?","",MessageBoxButtons.YesNo,MessageBoxIcon.Warning);
//if (dlr == DialogResult.Yes)
//{
//aktualizacja wpisu
fbLogowanie.fAktualizujMagazyn(sID, sNumer, sNazwa, sMaska, sDok);
//}
}
/*Zmiana w programie. poniewaz nie używam tabeli pośredniej dla magazynów to po dodaniu magazynu od razu musze dodać uprawnienia do wybranego magazynu*/
string sIdUser = ""; //, sIdMag = "";
if (textBox4.Text != "")
{
sIdUser = textBox4.Text;
//sIdMag = dataGridView5.CurrentRow.Cells[0].Value.ToString();
fbLogowanie = new fblog();
if (fbLogowanie.fCzyJestUPR(sIdUser, sID) == "0")
fbLogowanie.fDodajUPRMag(sIdUser, sID);
}
fMagazynyListUPR(textBox4.Text);
//fMagazynyList();
}
catch (NullReferenceException) { }
}
private void fBlokadaPZLoad()
{
fbLogowanie = new fblog();
fbLogowanie._TableSERIA();
string sBlokadaPZ = fbLogowanie.fBlokadaPZ();
fBlokPZ = sBlokadaPZ;
if (sBlokadaPZ == "1")
checkBox1.Checked = true;
else
checkBox1.Checked = false;
}
private void dataGridView1_DoubleClick(object sender, EventArgs e)
{
try
{
DialogResult dlr;
//string sID = dataGridView1.CurrentRow.Cells[0].Value.ToString();
string sLogin = dataGridView1.CurrentRow.Cells[0].Value.ToString();
//string sPass = dataGridView1.CurrentRow.Cells[2].Value.ToString();
string sNazwisko = dataGridView1.CurrentRow.Cells[1].Value.ToString();
//string sAktywny = dataGridView2.CurrentRow.Cells[4].Value.ToString();
fbLogowanie = new fblog();
if (fbLogowanie.fCzyJestLogin(sLogin) == "0")
{
//dodawanie do spisu
fbLogowanie.fDodajUserRAKS(sLogin, sNazwisko);
}
else
{
//edycja
dlr = MessageBox.Show("Już jest użytkownik o identyfikatorze(Login): " + sLogin + "", "", MessageBoxButtons.OK, MessageBoxIcon.Warning);
if (dlr == DialogResult.Yes)
{
//aktualizacja wpisu
//fbLogowanie.fAktualizujMagazyn(sID, sNumer, sNazwa, sMaska, sDok);
}
}
fUserList();
}
catch (NullReferenceException) { }
}
//druga zakłaka
private void fRodzajDOK()
{
fbLogowanie = new fblog();
textBox5.Text = fbLogowanie.fIDRodzajuDOK();
}
private void fMagazynyListUPR(string sIDUser)
{
fbLogowanie = new fblog();
List<string>[] lstMagazyny = fbLogowanie.fUPRMAg(sIDUser);
dataGridView4.Rows.Clear();
for (int i = 0; i < lstMagazyny[0].Count; i++)
{
int number = dataGridView4.Rows.Add();
dataGridView4.Rows[number].Cells[0].Value = lstMagazyny[0][i].ToString();
dataGridView4.Rows[number].Cells[1].Value = lstMagazyny[1][i].ToString();
dataGridView4.Rows[number].Cells[2].Value = lstMagazyny[2][i].ToString();
}
}
private void dataGridView6_DoubleClick(object sender, EventArgs e)
{
try
{
string sID = dataGridView6.CurrentRow.Cells[0].Value.ToString();
string sKod = dataGridView6.CurrentRow.Cells[1].Value.ToString();
string sNazwa = dataGridView6.CurrentRow.Cells[2].Value.ToString();
string sMaska = dataGridView6.CurrentRow.Cells[3].Value.ToString();
fbLogowanie = new fblog();
//dodawanie kodu do spisu kodów w programie
if (fbLogowanie.fCzyJestKOD(sID) == "0")
fbLogowanie.fDodajKOD(sID, sKod, sNazwa, sMaska);
if (textBox6.Text != "")
{
//dodawania uprawnienia user->magazyn->koddokumentu
if (fbLogowanie.fCzyJestUPRKodMag(textBox4.Text, textBox6.Text, sID) == "0")
fbLogowanie.fDodajUPRKodMag(textBox4.Text, textBox6.Text, sID);
//odświeżanie listy kodów dla magazynu
List<string>[] lstDokumenty = fbLogowanie.fUPRKodDlaMAg(textBox4.Text, textBox6.Text);
dataGridView5.Rows.Clear();
for (int i = 0; i < lstDokumenty[0].Count; i++)
{
int number = dataGridView5.Rows.Add();
dataGridView5.Rows[number].Cells[0].Value = lstDokumenty[0][i].ToString();
dataGridView5.Rows[number].Cells[1].Value = lstDokumenty[1][i].ToString();
dataGridView5.Rows[number].Cells[2].Value = lstDokumenty[2][i].ToString();
}
}
else
MessageBox.Show("Wybierz magazyn do którego chcesz przyłaczyć kod dokumentu");
}
catch (NullReferenceException) { }
}
private void dataGridView5_DoubleClick(object sender, EventArgs e)
{
try
{
fbLogowanie = new fblog();
fbLogowanie.fUsunUPRKodMag(textBox4.Text, textBox6.Text, dataGridView5.CurrentRow.Cells[0].Value.ToString());
try
{
textBox6.Text = dataGridView4.CurrentRow.Cells[0].Value.ToString();
fbLogowanie = new fblog();
List<string>[] lstDokumenty = fbLogowanie.fUPRKodDlaMAg(textBox4.Text, textBox6.Text);
dataGridView5.Rows.Clear();
for (int i = 0; i < lstDokumenty[0].Count; i++)
{
int number = dataGridView5.Rows.Add();
dataGridView5.Rows[number].Cells[0].Value = lstDokumenty[0][i].ToString();
dataGridView5.Rows[number].Cells[1].Value = lstDokumenty[1][i].ToString();
dataGridView5.Rows[number].Cells[2].Value = lstDokumenty[2][i].ToString();
}
}
catch (NullReferenceException) { }
}
catch (NullReferenceException) { }
}
private void dataGridView4_DoubleClick(object sender, EventArgs e)
{
string sIdUser = "", sIdMag = "";
if (textBox4.Text != "")
{
sIdUser = textBox4.Text;
sIdMag = dataGridView4.CurrentRow.Cells[0].Value.ToString();
fbLogowanie = new fblog();
fbLogowanie.fUsunUPRMag(sIdUser, sIdMag);
}
fMagazynyListUPR(textBox4.Text);
}
private void fSpisDokProgram()
{
fbLogowanie = new fblog();
List<string>[] lstDokumenty = fbLogowanie.fKody();
dataGridView3.Rows.Clear();
for (int i = 0; i < lstDokumenty[0].Count; i++)
{
int number = dataGridView3.Rows.Add();
dataGridView3.Rows[number].Cells[0].Value = lstDokumenty[1][i].ToString();
dataGridView3.Rows[number].Cells[1].Value = lstDokumenty[2][i].ToString();
}
}
private void button4_Click(object sender, EventArgs e)
{
fbLogowanie = new fblog();
fbLogowanie.fAktualizujRodzajDOK(textBox5.Text);
}