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] + "'")));
}
}
