public OtherFButton(OTF aOtf)
{
_OTF = aOtf;
Appearance = Appearance.Button;
FlatStyle = FlatStyle.Flat;
FlatAppearance.MouseOverBackColor = Color.Transparent;
FlatAppearance.MouseDownBackColor = Color.Transparent;
FlatAppearance.CheckedBackColor = Color.Transparent;
FlatAppearance.BorderSize = 0;
ImageAlign = ContentAlignment.BottomRight;
BackgroundImage = global::GUI.Properties.Resources.al_off;
TextAlign = ContentAlignment.TopCenter;
BackgroundImageLayout = ImageLayout.Stretch;
BackColor = Color.Transparent;
}
public OTF_list(int pCIKKCSOP_ID, SqlConnection sc)
{
sc.Open();
SqlCommand cmd = new SqlCommand();
cmd.Connection = sc;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT OTHER_FILTER_ID ,CIKKCSOPORT_ID ,isnull(OTHER_NAME,'') as OTHER_NAME FROM CIKCSOP_OTHER_FILTER WHERE CIKKCSOPORT_ID = " + pCIKKCSOP_ID.ToString();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
if (rdr["OTHER_FILTER_ID"] != DBNull.Value)
{
OTF t = new OTF((int)rdr["OTHER_FILTER_ID"],
(int)rdr["CIKKCSOPORT_ID"],
(string)rdr["OTHER_NAME"]);
lOTF.Add(t);
}
}
rdr.Close();
sc.Close();
}
