private void listDesigns()
{
grDesigns.Rows.Clear();
string sql = "SELECT *, (SELECT COUNT(*) FROM TARA_PalMarka WHERE DesignID = TARA_PalDesign.ID) MarkaCounter FROM TARA_PalDesign";
using (SqlDataReader rdr = _pekpanDal.GetDataReader(sql))
{
if (rdr != null)
{
while (rdr.Read())
{
DataGridViewRow row = new DataGridViewRow();
row.CreateCells(grDesigns);
row.Cells[0].Value = rdr["ID"].ToString();
row.Cells[1].Value = rdr["Aciklama"].ToString();
row.Cells[2].Value = rdr["XBaslangic"].ToString();
row.Cells[3].Value = rdr["YBaslangic"].ToString();
row.Cells[4].Value = rdr["XOffset"].ToString();
row.Cells[5].Value = rdr["YOffset"].ToString();
row.Cells[6].Value = rdr["PaletZ"].ToString();
row.Cells[7].Value = rdr["GenislikMin"].ToString();
row.Cells[8].Value = rdr["GenislikMax"].ToString();
row.Cells[9].Value = rdr["BoyMin"].ToString();
row.Cells[10].Value = rdr["BoyMax"].ToString();
row.Cells[11].Value = rdr["Tork"].ToString();
row.Cells[12].Value = rdr["MarkaCounter"]; // 12. Cell aşağıda setlenecek
row.Cells[13].Value = rdr["Tasarlayan"].ToString();
row.Cells[14].Value = rdr["RecTime"].ToString();
row.Cells[15].Value = rdr["Degistiren"].ToString();
row.Cells[16].Value = rdr["DegistirmeTarihi"].ToString();
grDesigns.Rows.Add(row);
}
}
}
}
public PaletDesigner(PekpanDal pekpanDal, string kullaniciAdi, int designID = 0)
{
InitializeComponent();
_pekpanDal = pekpanDal;
_kullaniciAdi = kullaniciAdi;
_designID = designID;
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);
}
}
}
}
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] + "'")));
}
}
