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