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();
}
