private void listLogins() { List <string> logins = _pekpanDal.GetDataReaderList("Select KullaniciAdi From TARA_Kullanicilar Order By KullaniciAdi"); cbxUsers.Items.Clear(); foreach (string s in logins) { cbxUsers.Items.Add(s); } }
private void btnKaydet_Click(object sender, EventArgs e) { List <string> dizaynAdi = _pekpanDal.GetDataReaderList("select Aciklama from TARA_PalDesign order by Aciklama"); if (_designID == 0) { foreach (string s in dizaynAdi) { if (txAd.Text == s) { MessageBox.Show("Lütfen başka bir isim veriniz", "Bu isimde bir palet tasarımı zaten var", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } } saveDesign(); } else { updateDesign(); } }
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] + "'"))); } }