private void btnEskiTamam_Click(object sender, EventArgs e) { if (_pekpanDal.ExecuteScalarStr("select Sifre from TARA_Kullanicilar where KullaniciAdi = '" + txbEskiKullanici.Text + "'") == txbEskiEskiSifre.Text && txbEskiYeniSifre.Text == txbEskiYeniSifreTekrar.Text) { _pekpanDal.ExecuteNonQuerySilent("update TARA_Kullanicilar set Sifre=" + txbEskiYeniSifre.Text + " where KullaniciAdi='" + txbEskiKullanici.Text + "'"); } pnlEski.Visible = false; }
private void saveDesign() { _pekpanDal.ExecuteNonQuerySilent("Insert Into TARA_PalDesign(RecTime, Aciklama, XBaslangic, YBaslangic, XOffset, YOffset, PaletZ, BoyMin, BoyMax, GenislikMin, GenislikMax, Tork, Tasarlayan) Values (GETDATE(),'" + txAd.Text + "', " + udbx.Value + ", " + udby.Value + ", " + udox.Value + ", " + udoy.Value + ", " + udz.Value + ", " + udboy1.Value + ", " + udboy2.Value + ", " + udgen1.Value + ", " + udgen2.Value + ", " + udTork.Value + ", '" + _kullaniciAdi + "')"); //" + katProdCount() + ", int designID = Convert.ToInt32(_pekpanDal.ExecuteScalarStr("select ID from TARA_PalDesign where Aciklama ='" + txAd.Text + "'")); for (int i = 0; i < Convert.ToInt32(_pekpanDal.ExecuteScalarStr("select count(*) from TARA_Markalar")); i++) { if (gv.Rows[i].Cells[1].Value != null) { _pekpanDal.ExecuteNonQuerySilent("Insert Into TARA_PalMarka (DesignID,MarkaAciklama) values (" + designID + ",'" + gv.Rows[i].Cells[1].Value + "')"); } } for (int i = 1; i <= 12; i++) { CheckBox cb = ProdCheckBox(i); if (cb != null) { if (cb.Checked) { NumericUpDown ud = ProdUpDown(i); int pno = (int)ud.Value; Button bRot = ProdButton(i); int rot = Convert.ToInt32(bRot.Text); int row = i % 4; int col = 1; if ((i >= 5) && (i < 9)) { col = 2; } else if ((i >= 9) && (i < 13)) { col = 3; } else if (i >= 13) { col = 4; } _pekpanDal.ExecuteNonQuerySilent("Insert Into TARA_PalCells(DesignID, PanelNo, RowNo, ColNo, ProdNo, Rot) Values (" + designID + ", " + i + ", " + row + ", " + col + ", " + pno + ", " + rot + ")"); } } DialogResult = DialogResult.OK; } }
private void btnSil_Click(object sender, EventArgs e) { DialogResult dialog = MessageBox.Show("Seçili dizayn silinecektir!\n Emin misniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dialog == DialogResult.Yes) { int designKimlik = Convert.ToInt32(_pekpanDal.ExecuteScalarStr("select ID from TARA_PalDesign where Aciklama= '" + grDesigns.CurrentRow.Cells[1].Value.ToString() + "'")); _pekpanDal.ExecuteNonQuerySilent("DELETE TARA_PalCells where DesignID =" + designKimlik); _pekpanDal.ExecuteNonQuerySilent("DELETE TARA_PalDesign where Aciklama='" + grDesigns.CurrentRow.Cells[1].Value.ToString() + "'"); _pekpanDal.ExecuteNonQuerySilent("DELETE TARA_PalMarka where DesignID =" + designKimlik); listDesigns(); } }
public PaletDesigner(PekpanDal pekpanDal, string kullaniciAdi, int designID, List <string> designList) { InitializeComponent(); _pekpanDal = pekpanDal; _kullaniciAdi = kullaniciAdi; _designID = designID; txAd.Text = designList[0]; udbx.Value = Convert.ToInt32(designList[1]); udby.Value = Convert.ToInt32(designList[2]); udox.Value = Convert.ToInt32(designList[3]); udoy.Value = Convert.ToInt32(designList[4]); udz.Value = Convert.ToInt32(designList[5]); udTork.Value = Convert.ToInt32(designList[6]); udgen1.Value = Convert.ToInt32(designList[7]); udgen2.Value = Convert.ToInt32(designList[8]); udboy1.Value = Convert.ToInt32(designList[9]); udboy2.Value = Convert.ToInt32(designList[10]); using (SqlDataReader rdr = _pekpanDal.GetDataReader("select MarkaAciklama from TARA_Markalar")) { if (rdr != null) { while (rdr.Read()) { DataGridViewRow row = new DataGridViewRow(); row.CreateCells(gv); row.Cells[0].Value = rdr["MarkaAciklama"].ToString(); gv.Rows.Add(row); } } } for (int i = 1; i <= 12; i++) { List <string> cells = _pekpanDal.GetDataReaderListColumn2("select PanelNo,ProdNo,Rot from TARA_PalCells where DesignID=" + _designID + " and PanelNo=" + i + "", 3); if (cells.Count != 0) { CheckBox cb = ProdCheckBox(i); cb.CheckState = CheckState.Checked; NumericUpDown ud = ProdUpDown(i); ud.Value = Convert.ToInt32(cells[1]); Button bRot = ProdButton(i); if (cells[2] == "90") { btnPalet_Click(bRot, EventArgs.Empty); } else if (cells[2] == "180") { for (int j = 0; j < 2; j++) { btnPalet_Click(bRot, EventArgs.Empty); } } else if (cells[2] == "270") { for (int j = 0; j < 3; j++) { btnPalet_Click(bRot, EventArgs.Empty); } } } } List <string> markaAciklamas = _pekpanDal.GetDataReaderList("SELECT MarkaAciklama FROM TARA_PalMarka WHERE DesignID = '" + _designID + "'"); for (int i = 0; i < markaAciklamas.Count; i++) { gvEkleForUpdate(Convert.ToInt32(_pekpanDal.ExecuteScalarStr("SELECT Y.Satir FROM ( SELECT ROW_NUMBER() OVER(ORDER BY MarkaKod) AS Satir,* FROM TARA_Markalar ) Y WHERE Y.MarkaAciklama= '" + markaAciklamas[i] + "'"))); } }