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(); } }