protected void Page_Load(object sender, EventArgs e) { this.progCode = IMBC.FW.Util.WebUtil.GetRequestQueryString("progCode", ""); this.receiver = IMBC.FW.Util.WebUtil.GetRequestQueryString("receiver", ""); ArrayList al = this.getUser(); for (int i = 0; i < al.Count; i++) { if (receiverNm.Text != "") { receiverNm.Text += ", "; } receiverNm.Text += ((NoteUser)al[i]).userNm; } if (!IsPostBack) { NoteData data = new NoteData(); RadioProgramInfo prog = data.RetrieveProgramInfo(this.progCode); ViewState["subClassCode"] = prog.subClassCode; this.progTitle.Text = prog.progTitle; this.progImg.ImageUrl = NoteUtil.GetProgImg(this.progCode, prog.progImage); } }
/// <summary> /// 라디오 프로그램 정보 /// </summary> /// <param name="progCode">프로그램코드</param> /// <returns>프로그램 정보</returns> public RadioProgramInfo RetrieveProgramInfo(string progCode) { RadioProgramInfo prog = new RadioProgramInfo(); SqlConnection conn = DbConnection.DbCon; SQLHelper.OpenConnection(conn); SqlCommand sqlCmd = new SqlCommand(); sqlCmd.CommandText = "music_RetrieveProgramInfo"; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode; SqlDataReader reader = SQLHelper.ExecuteReader(conn, sqlCmd); if (reader.Read()) { prog.progCode = progCode; prog.subClassCode = reader["SUBCLASS_CODE"].ToString(); prog.progTitle = reader["prog_title"].ToString(); prog.progImage = reader["prog_image"].ToString(); } reader.Close(); SQLHelper.CloseConnection(conn); return(prog); }