public void Asztal_click(object sender, EventArgs e) { Asztal_Button tmp_a = (Asztal_Button)sender; retA = tmp_a.aObj; this.DialogResult = DialogResult.OK; this.Close(); }
public Asztal GetItem(int iASZTAL_ID) { Asztal _ret = new Asztal(); var ret_asztal = from c in lASZTAL where c.fASZTAL_ID == iASZTAL_ID select c; ret_asztal.Each(c => _ret = c); return (_ret); //IEnumerable<Asztal> r = lASZTAL.Where(p => p.fASZTAL_ID == iASZTAL_ID); //foreach (var n in r) //{ // ret = n; //} }
public Asztal_List(int aHelyId) { SqlConnection sc = new SqlConnection(DEFS.ConSTR); sc.Open(); SqlCommand cmd = new SqlCommand(); cmd.Connection = sc; cmd.CommandType = CommandType.Text; cmd.CommandText = "SELECT a.ASZTAL_ID, a.ASZTAL_SZAM, a.ASZTAL_TIPUS_ID, a.ASZTAL_POS_X, a.ASZTAL_POS_Y, " + " a.ASZTAL_ROTATE, isnull((select max(RENDELES_ID) from RENDELES_FEJ f where f.ASZTAL_ID = a.ASZTAL_ID and isnull(f.FIZETVE,0) = 0 and isnull(AKTIV,1) = 1 ),-1) as RENDELES_ID, " + " isnull(USEABLE,1) as USEABLE, isnull(NAME_VISIBLE,1) as NAME_VISIBLE " + " FROM ASZTAL a WHERE a.HELY_ID =" + aHelyId.ToString(); SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { Asztal t = new Asztal((int)rdr["ASZTAL_ID"], rdr["ASZTAL_SZAM"].ToString(), (int)rdr["ASZTAL_TIPUS_ID"], (int)rdr["ASZTAL_POS_X"], (int)rdr["ASZTAL_POS_Y"], false, (int)rdr["ASZTAL_ROTATE"]); t.fRENDELES_ID = (int)rdr["RENDELES_ID"]; t.fNAME_VISIBLE = (int)rdr["NAME_VISIBLE"]; t.fUSEABLE = (int)rdr["USEABLE"]; lASZTAL.Add(t); } rdr.Close(); sc.Close(); }