private void BTN_Del_Click(object sender, EventArgs e)
{
if (MessageBox.Show("Вы действительно хотите удалить элемент?", "Удаление", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
BNKSEEK.ExecuteNonQ("delete from bnkseek where newnum='" + dataGridView1.CurrentRow.Cells["newnum"].Value.ToString() + "';");
RefreshDataGrid(dataGridView1.CurrentRow.Index - 1);
}
}
private void BTN_OK_Click(object sender, EventArgs e)
{
Dictionary <string, string> Params = new Dictionary <string, string>();
string date_izm = DateTime.Now.Date.ToString().Substring(0, 10), date_in = DateTime.Now.Date.ToString().Substring(0, 10);
if (Validation())
{
string cmd, pzn, tnp;
if (CMB_PZN.SelectedItem == null)
{
pzn = "";
}
else
{
pzn = BNKSEEK.pzn[CMB_PZN.SelectedItem.ToString()];
}
if (CMB_TNP.SelectedItem == null)
{
tnp = "";
}
else
{
tnp = BNKSEEK.tnp[CMB_TNP.SelectedItem.ToString()];
}
Params["real"] = TB_REAL.Text;
Params["nnp"] = TB_NNP.Text;
Params["srok"] = TB_SROK.Text;
Params["pzn"] = pzn;
Params["adr"] = TB_ADR.Text;
Params["telef"] = TB_TELEF.Text;
Params["uer"] = BNKSEEK.uer[CMB_UER.SelectedItem.ToString()];
Params["rkc"] = TB_RKC.Text;
Params["regn"] = TB_REGN.Text;
Params["rgn"] = BNKSEEK.rgn[CMB_RGN.SelectedItem.ToString()];
Params["namep"] = TB_NAMEP.Text;
Params["okpo"] = TB_OKPO.Text;
Params["ind"] = TB_IND.Text;
Params["namen"] = TB_NAMEN.Text;
Params["dt_izm"] = date_izm;
Params["tnp"] = tnp;
Params["newnum"] = TB_BIK.Text;
Params["ksnp"] = TB_KSNP.Text;
Params["date_in"] = date_in;
if (DTP_DateCh.Enabled)
{
Params["date_ch"] = DTP_DateCh.Value.ToString().Substring(0, 10);
}
//if (DTP_DateCh.Enabled)
//{
// if (index == -1)
// cmd = String.Format("insert into bnkseek ([real],[pzn],[uer],[rgn],[ind],[tnp],[nnp],[adr],[rkc],[namep],[namen],[newnum],[srok],[telef],[regn],[okpo],[dt_izm],[ksnp],[date_in],[date_ch]) values " +
// "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}');", TB_REAL.Text, pzn, BNKSEEK.uer[CMB_UER.SelectedItem.ToString()],
// BNKSEEK.rgn[CMB_RGN.SelectedItem.ToString()], TB_IND.Text, tnp, TB_NNP.Text, TB_ADR.Text, TB_RKC.Text, TB_NAMEP.Text, TB_NAMEN.Text,
// TB_BIK.Text, TB_SROK.Text, TB_TELEF.Text, TB_REGN.Text, TB_OKPO.Text, date_izm, TB_KSNP.Text, date_in, DTP_DateCh.Value.ToString().Substring(0, 10));
// else
// cmd = String.Format("update bnkseek set [real]='{0}',[pzn]='{1}',[uer]='{2}',[rgn]='{3}',[ind]='{4}',[tnp]='{5}',[nnp]='{6}',[adr]='{7}',[rkc]='{8}',[namep]='{9}',[namen]='{10}',[newnum]='{11}',[srok]='{12}',[telef]='{13}',[regn]='{14}',[okpo]='{15}'," +
// "[dt_izm]='{16}',[ksnp]='{17}',[date_ch]='{18}' where [newnum]='{19}';", TB_REAL.Text, BNKSEEK.pzn[CMB_PZN.SelectedItem.ToString()], BNKSEEK.uer[CMB_UER.SelectedItem.ToString()],
// BNKSEEK.rgn[CMB_RGN.SelectedItem.ToString()], TB_IND.Text, BNKSEEK.tnp[CMB_TNP.SelectedItem.ToString()], TB_NNP.Text, TB_ADR.Text, TB_RKC.Text, TB_NAMEP.Text, TB_NAMEN.Text,
// TB_BIK.Text, TB_SROK.Text, TB_TELEF.Text, TB_REGN.Text, TB_OKPO.Text, date_izm, TB_KSNP.Text, DTP_DateCh.Value.ToString().Substring(0, 10), row.Cells["newnum"].Value.ToString());
//}
//else
//{
// if (index == -1)
// cmd = String.Format("insert into bnkseek ([real],[pzn],[uer],[rgn],[ind],[tnp],[nnp],[adr],[rkc],[namep],[namen],[newnum],[srok],[telef],[regn],[okpo],[dt_izm],[ksnp],[date_in]) values " +
// "('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}');", TB_REAL.Text, pzn, BNKSEEK.uer[CMB_UER.SelectedItem.ToString()],
// BNKSEEK.rgn[CMB_RGN.SelectedItem.ToString()], TB_IND.Text, tnp, TB_NNP.Text, TB_ADR.Text, TB_RKC.Text, TB_NAMEP.Text, TB_NAMEN.Text,
// TB_BIK.Text, TB_SROK.Text, TB_TELEF.Text, TB_REGN.Text, TB_OKPO.Text, date_izm, TB_KSNP.Text, date_in);
// else
// cmd = String.Format("update bnkseek set [real]='{0}',[pzn]='{1}',[uer]='{2}',[rgn]='{3}',[ind]='{4}',[tnp]='{5}',[nnp]='{6}',[adr]='{7}',[rkc]='{8}',[namep]='{9}',[namen]='{10}',[newnum]='{11}',[srok]='{12}',[telef]='{13}',[regn]='{14}',[okpo]='{15}'," +
// "[dt_izm]='{16}',[ksnp]='{17}' where [newnum]='{18}';", TB_REAL.Text, BNKSEEK.pzn[CMB_PZN.SelectedItem.ToString()], BNKSEEK.uer[CMB_UER.SelectedItem.ToString()],
// BNKSEEK.rgn[CMB_RGN.SelectedItem.ToString()], TB_IND.Text, BNKSEEK.tnp[CMB_TNP.SelectedItem.ToString()], TB_NNP.Text, TB_ADR.Text, TB_RKC.Text, TB_NAMEP.Text, TB_NAMEN.Text,
// TB_BIK.Text, TB_SROK.Text, TB_TELEF.Text, TB_REGN.Text, TB_OKPO.Text, date_izm, TB_KSNP.Text, row.Cells["newnum"].Value.ToString());
//}
try
{
BNKSEEK.ExecuteNonQ(fillcmd(Params, index));
//BNKSEEK.ExecuteNonQ(cmd);
BNKSEEK.refresh();
MainForm.RefreshDataGrid();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
FormAdd.ActiveForm.Hide();
}
}