private void buttonX1_Click(object sender, EventArgs e) { string sqlUtmp = "UPDATE [P&R] SET Rname = N'" + txtNameMaharat.Text + "' WHERE (Rname = N'" + dataGridViewX1.CurrentRow.Cells[1].Value.ToString() + "')"; DataManagement.I_U_D(sqlAllReshte, sqlUtmp); string sqlIU = "UPDATE reshte SET code = N'" + txtCode.Text + "', name = N'" + txtNameMaharat.Text + "', onvan = N'" + txtOnvan.Text + "',modat = N'" + txtModat.Value.ToString() + "', dateShoroo = N'" + txtShoroo.Text + "',date = N'" + txtAzmoon.Text + "' where (code = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"; DataManagement.I_U_D(sqlAllReshte, sqlIU); }
private void buttonX3_Click(object sender, EventArgs e) { if (dataGridViewX1.RowCount == 0) { return; } if (FMessegeBox.FarsiMessegeBox.Show("آیا برای حذف مطمئن هستید؟", "اخطار", FMessegeBox.FMessegeBoxButtons.YesNo) != DialogResult.Yes) { return; } DataManagement.I_U_D("select * from reshte", "DELETE FROM person WHERE (codeMeli = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
private void btnSabt_Click(object sender, EventArgs e) { if (dataGridViewX2.RowCount == 0) { btnSabt.Enabled = false; return; } this.UseWaitCursor = true; string sqlUpdate = "UPDATE [P&R] SET nomreA = N'" + txtNomreA.Text + "', nomreN = N'" + txtNomreN.Text + "', dateSodoor = N'" + txtSodoor.Text + "', shGovahi = N'" + txtGovahi.Text + "' WHERE (Rname = N'" + txtNameMaharat.Text + "') AND (PID = N'" + dataGridViewX2.CurrentRow.Cells[0].Value.ToString() + "') AND (Ronvan = N'" + txtOnvan.Text + "')"; DataManagement.I_U_D(sqlAllPerson, sqlUpdate); dataGridViewX2.DataSource = DataManagement.Search(sqlAllPerson); FMessegeBox.FarsiMessegeBox.Show("اطلاعات با موفقیت ثبت شد"); this.UseWaitCursor = false; }
private void btnDel_Click(object sender, EventArgs e) { if (dataGridViewX1.RowCount == 0) { return; } if (FMessegeBox.FarsiMessegeBox.Show("آیا برای حذف مطمئن هستید؟", "توجه", FMessegeBox.FMessegeBoxButtons.YesNo) != DialogResult.Yes) { return; } string sqldel = "DELETE FROM reshte WHERE (code = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"; DataManagement.I_U_D(sqlAll, sqldel); sqldel = "DELETE FROM [P&R] WHERE (RID = N'" + dataGridViewX1.CurrentRow.Cells[0].Value.ToString() + "')"; DataManagement.I_U_D(sqlAll, sqldel); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); }
private void btnSabt_Click(object sender, EventArgs e) { string sqlIU = "", sqlUtmp = ""; if (DetectForm.F == 1) { sqlIU = "INSERT INTO reshte (code, name, onvan ,modat, dateShoroo, date, vamali, vnazari) VALUES(N'" + txtCode.Text + "', N'" + txtName.Text + "',N'" + txtonvan.Text + "', N'" + txtmodat.Value.ToString() + "', N'" + txtShoro.Text + "',N'" + txtDate.Text + "',N'" + txtamali.Text + "',N'" + txtnazari.Text + "')"; } else { sqlUtmp = "UPDATE [P&R] SET Rname = N'" + txtName.Text + "' WHERE (Rname = N'" + dataGridViewX1.CurrentRow.Cells[1].Value.ToString() + "')"; DataManagement.I_U_D(sqlAll, sqlUtmp); sqlIU = "UPDATE reshte SET code = N'" + txtCode.Text + "', name = N'" + txtName.Text + "', onvan = N'" + txtonvan.Text + "',modat = N'" + txtmodat.Value.ToString() + "', dateShoroo = N'" + txtShoro.Text + "',date = N'" + txtDate.Text + "',vamali = N'" + txtamali.Text + "',vnazari = N'" + txtnazari.Text + "' where (code = N'" + DetectForm.Cod + "')"; } DataManagement.I_U_D(sqlAll, sqlIU); dataGridViewX1.DataSource = DataManagement.Search(sqlAll); btnCancel_Click(null, null); }
private void btnUpdate_Click(object sender, EventArgs e) { if (!flag) { return; } string sql = "INSERT INTO person (codeMeli{0}{1}{2}{3}{4}{5}{6}{7}{8}{9})VALUES({10}{11}{12}{13}{14}{15}{16}{17}{18}{19}{20})"; try { int count = 0; DataTable ans; for (int i = 0; i < dataGridViewX1.RowCount; i++) { string Sql = string.Format(sql, (flagName ? ",name" : ""), (flagFamily ? ",family" : ""), (flagfather ? ",father" : ""), (flagShSh ? ",shsh" : ""), (flagmobile ? ",mobile" : ""), (flagtarikht ? ",tarikht" : ""), (flagsadere ? ",sadere" : ""), (flagmtavalod ? ",mtavalod" : ""), (flagsal ? ",sal" : ""), (flagmah ? ",mah" : ""), "N'" + dataGridViewX1.Rows[i].Cells["codeMeli"].Value.ToString() + "'", (flagName ? ",N'" + dataGridViewX1.Rows[i].Cells["name"].Value.ToString() + "'" : ""), (flagFamily ? ",N'" + dataGridViewX1.Rows[i].Cells["family"].Value.ToString() + "'" : ""), (flagfather ? ",N'" + dataGridViewX1.Rows[i].Cells["father"].Value.ToString() + "'" : ""), (flagShSh ? ",N'" + dataGridViewX1.Rows[i].Cells["shsh"].Value.ToString() + "'" : ""), (flagmobile ? ",N'" + dataGridViewX1.Rows[i].Cells["mobile"].Value.ToString() + "'" : ""), (flagtarikht ? ",N'" + dataGridViewX1.Rows[i].Cells["tarikht"].Value.ToString() + "'" : ""), (flagsadere ? ",N'" + dataGridViewX1.Rows[i].Cells["sadere"].Value.ToString() + "'" : ""), (flagmtavalod ? ",N'" + dataGridViewX1.Rows[i].Cells["mtavalod"].Value.ToString() + "'" : ""), (flagsal ? ",N'" + dataGridViewX1.Rows[i].Cells["sal"].Value.ToString() + "'" : ""), (flagmah ? ",N'" + dataGridViewX1.Rows[i].Cells["mah"].Value.ToString() + "'" : "")); if (dataGridViewX1.Rows[i].Cells["codeMeli"].Value.ToString() != "") { ans = DataManagement.I_U_D("select codeMeli from person where codeMeli = N'" + dataGridViewX1.Rows[i].Cells["codeMeli"].Value.ToString() + "'", Sql); if (ans.Rows.Count >= 0) { count++; } } } if (count > 0) { lblAns.Text = "تعداد " + count.ToString() + " ثبت شد"; } } catch (Exception ex) { FMessegeBox.FarsiMessegeBox.Show("مشکل در ثبت اطلاعات\n" + ex.Message, "خطا", FMessegeBox.FMessegeBoxButtons.Ok, FMessegeBox.FMessegeBoxIcons.Error); } }
private void buttonX1_Click(object sender, EventArgs e) { DataManagement.I_U_D("select * from setup", "UPDATE setup SET nazari = N'" + txtNazari.Text + "', amali = N'" + txtAmali.Text + "'"); btnSabt.Enabled = false; }
private void btnSabt_Click(object sender, EventArgs e) { DataManagement.I_U_D("select * from setup", "UPDATE setup SET usernamesms = N'" + txtUser.Text + "', passwordsms = N'" + txtPass.Text + "'"); btnSabt.Enabled = false; }
private void S_Click(object sender, EventArgs e) { this.UseWaitCursor = true; if (txtMeli.Text == "") { FMessegeBox.FarsiMessegeBox.Show("وارد کردن کد ملی اجباری است"); this.UseWaitCursor = false; return; } string str = "select codeMeli from person where codeMeli = N'" + txtMeli.Text + "' "; if (txtMeli.Text != oldCode) { if (DataManagement.Search(str).Rows.Count != 0) { FMessegeBox.FarsiMessegeBox.Show("کد ملی تکراری است"); this.UseWaitCursor = false; return; } } if (!MeliFunction()) { this.UseWaitCursor = false; return; } string sql = ""; if (DetectForm.F == 1) { sql = "INSERT INTO person (codeMeli, name, family, father, shsh, tarikht, sadere, mtavalod,sal,mah) VALUES (N'" + txtMeli.Text + "', N'" + txtName.Text + "', N'" + txtFamily.Text + "', N'" + txtFather.Text + "', N'" + txtShsh.Value.ToString() + "', N'" + txtTavalod.Text + "', N'" + txtSadere.Text + "', N'" + txtMtavalod.Text + "', N'" + txtsal.Text + "', N'" + txtmah.Text + "')"; DataManagement.I_U_D("select * from reshte", sql); if (listReshte.Rows.Count != 0) { for (int i = 0; i < listReshte.Rows.Count; i++) { DataManagement.DT = DataManagement.Search("SELECT code, name,onvan FROM reshte WHERE(name = N'" + listReshte.Rows[i].Cells[0].Value.ToString() + "')AND(onvan = N'" + listReshte.Rows[i].Cells[1].Value.ToString() + "')"); DataManagement.I_U_D("select * from reshte", "INSERT INTO [P&R] (PID, RID, Rname,Ronvan) VALUES (N'" + txtMeli.Text + "', N'" + DataManagement.DT.Rows[0][0].ToString() + "', N'" + listReshte.Rows[i].Cells[0].Value.ToString() + "', N'" + listReshte.Rows[i].Cells[1].Value.ToString() + "')"); } } } else { sql = "UPDATE person SET codeMeli = N'" + txtMeli.Text + "', name = N'" + txtName.Text + "', family = N'" + txtFamily.Text + "', father = N'" + txtFather.Text + "', shsh = N'" + txtShsh.Value.ToString() + "', tarikht = N'" + txtTavalod.Text + "', sadere = N'" + txtSadere.Text + "', mtavalod = N'" + txtMtavalod.Text + "', sal = N'" + txtsal.Text + "', mah = N'" + txtmah.Text + "' WHERE (codeMeli = N'" + oldCode + "')"; DataManagement.I_U_D("select name from reshte", sql); if (listReshte.Rows.Count != 0 && isChange) { DataManagement.I_U_D("select name from reshte", "DELETE FROM [P&R] WHERE (PID = N'" + oldCode + "')"); for (int i = 0; i < listReshte.Rows.Count; i++) { if (listReshte.Rows[i].Cells[0].ToString() == "") { continue; } DataManagement.DT = DataManagement.Search("SELECT code from reshte WHERE(name = N'" + listReshte.Rows[i].Cells[0].Value.ToString() + "') AND (onvan = N'" + listReshte.Rows[i].Cells[1].Value.ToString() + "')"); DataManagement.I_U_D("select name from reshte", "INSERT INTO [P&R] (PID, RID, Rname,Ronvan) VALUES (N'" + txtMeli.Text + "', N'" + DataManagement.DT.Rows[0][0].ToString() + "', N'" + listReshte.Rows[i].Cells[0].Value.ToString() + "', N'" + listReshte.Rows[i].Cells[1].Value.ToString() + "')"); } } } this.UseWaitCursor = false; FMessegeBox.FarsiMessegeBox.Show("اطلاعات با موفقیت ثبت شد"); this.Close(); }