/// <summary>
/// 미니 메세지 게시판 정보 수정
/// </summary>
/// <param name="mstInfo">게시판 정보</param>
/// <returns>성공여부</returns>
public bool UpdateMemoMstInfo(MemoMstInfo mstInfo)
{
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "UpdateMemoMstInfo";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = mstInfo.progCode;
sqlCmd.Parameters.Add("@memoType", SqlDbType.Char, 1).Value = mstInfo.memoType;
sqlCmd.Parameters.Add("@pageRow", SqlDbType.Int).Value = mstInfo.pageRow;
sqlCmd.Parameters.Add("@tblColor", SqlDbType.VarChar, 7).Value = mstInfo.tblColor;
sqlCmd.Parameters.Add("@showType", SqlDbType.Char, 1).Value = mstInfo.showType;
sqlCmd.Parameters.Add("@topHTML", SqlDbType.Text).Value = mstInfo.topHtml;
return(SQLHelper.ExecuteNonQuery(sqlCmd));
}
protected void btnSave_Click(object sender, System.EventArgs e)
{
MemoMstInfo mstInfo = new MemoMstInfo();
mstInfo.progCode = this.progCode;
mstInfo.memoType = (memoType1.Checked) ? "1" : "2";
mstInfo.pageRow = int.Parse(pageRow.Text);
mstInfo.tblColor = hdnFontColor.Value;
mstInfo.showType = (showType1.Checked) ? "1" : "2";
mstInfo.topHtml = txtMiniBoardURL.Text;
NoteData data = new NoteData();
data.UpdateMemoMstInfo(mstInfo);
Response.Redirect(Request.RawUrl, true);
}
protected void Page_Load(object sender, EventArgs e)
{
this.progCode = IMBC.FW.Util.WebUtil.GetRequestQueryString("progCode", "");
if (!IsPostBack)
{
NoteData data = new NoteData();
if (data.IsAdminUser(this.progCode, new UserInfo().UserID) == false)
{
Response.Write("관리자가 아닙니다.");
Response.End();
}
MemoMstInfo mstInfo = data.RetrieveMemoMstInfo(this.progCode);
memoUrl.Text = "http://mini.imbc.com/UserNote/RetrieveMemoList.aspx?progCode=" + this.progCode;
if (mstInfo.memoType == "1")
{
memoType1.Checked = true;
}
else
{
memoType2.Checked = true;
}
pageRow.Text = mstInfo.pageRow.ToString();
tblColor.Style.Add("background-color", mstInfo.tblColor);
hdnFontColor.Value = mstInfo.tblColor;
if (mstInfo.showType == "1")
{
showType1.Checked = true;
}
else
{
showType2.Checked = true;
}
txtMiniBoardURL.Text = mstInfo.topHtml;
}
}
/// <summary>
/// 미니 메세지 게시판 정보 보기
/// </summary>
/// <param name="progCode">프로그램코드</param>
/// <returns>게시판 정보</returns>
public MemoMstInfo RetrieveMemoMstInfo(string progCode)
{
MemoMstInfo mstInfo = new MemoMstInfo();
try
{
SqlConnection conn = DbConnection.DbCon;
SQLHelper.OpenConnection(conn);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "dbowr_select.RetrieveMemoMstInfo";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode;
SqlDataReader reader = SQLHelper.ExecuteReader(conn, sqlCmd);
if (reader.Read())
{
mstInfo.progCode = progCode;
mstInfo.progTitle = reader["Prog_Title"].ToString();
mstInfo.memoType = reader["memoType"].ToString();
mstInfo.pageRow = (int)reader["pageRow"];
mstInfo.tblColor = reader["TblColor"].ToString();
mstInfo.showType = reader["ShowType"].ToString();
mstInfo.topHtml = reader["TopHTML"].ToString(); //미니 게시판 주소 입력으로 사용하기 위해 추가함 (문현선. 2007.03.07)
}
reader.Close();
SQLHelper.CloseConnection(conn);
}
catch (System.NullReferenceException exNull)
{
mstInfo = null;
}
return(mstInfo);
}
protected void Page_Load(object sender, EventArgs e)
{
this.progCode = WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("progCode", ""));
this.nCurPage = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage", "1"));
this.search = IMBC.FW.Util.WebUtil.EncodeHTML(WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("search", "")));
this.searchWord = IMBC.FW.Util.WebUtil.RemoveHTMLTag(WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("searchWord", ""))).Replace("+", "").Replace("%", "").Replace("'", "");
if (this.progCode.Substring(0, 4) == "RDMB")
{
this.progCode = NoteUtil.GetParentCode(this.progCode);
}
// Response.Cache.SetCacheability(HttpCacheability.Public);
// Response.Cache.SetExpires(DateTime.Now.AddSeconds(10));
// Response.Cache.VaryByParams["progCode"] = true;
// Response.Cache.VaryByParams["curPage"] = true;
// Response.Cache.VaryByParams["search"] = true;
// Response.Cache.VaryByParams["searchWord"] = true;
this.uInfo = new UserInfo();
this.data = new NoteData();
if (IMBC.FW.Util.WebUtil.GetSession("IsAdmin_" + progCode) == "TRUE")
{
this.IsAdmin = true;
}
else if (IMBC.FW.Util.WebUtil.GetSession("IsAdmin_" + progCode) == "FALSE")
{
this.IsAdmin = false;
}
//else
//{
// this.IsAdmin = data.IsAdminUserDB(this.progCode, uInfo.UserID);
//}
if (this.uInfo.IsLogin == false)
{
imgSave.Src = "http://img.imbc.com/mini/UserNote/images/mini_memo_login.jpg";
System.Web.HttpContext httpContext = System.Web.HttpContext.Current;
httpContext.Response.Cookies["IMBCURL"].Value = httpContext.Server.UrlEncode("http://" + httpContext.Request.ServerVariables["SERVER_NAME"] + httpContext.Request.RawUrl);
httpContext.Response.Cookies["IMBCURL"].Domain = "imbc.com";
httpContext.Response.Cookies["IMBCURL"].Path = "/";
httpContext.Response.Cookies["IMBCURL"].Secure = false;
imgSave.Attributes.Add("onclick", "location.href='http://member.imbc.com/Login/Login.aspx?TemplateId=Popup'; return false;");
txtComment.Enabled = false;
}
else
{
this.IsAdmin = data.IsAdminUserDB(this.progCode, uInfo.UserID);
imgSave.Attributes.Add("onclick", "doSave();");
//if (!this.uInfo.IsIdentity())
//{
// if (!this.IsAdmin)
// imgSave.Attributes.Add("onclick", "fIdentity();");
// else
// imgSave.Attributes.Add("onclick", "doSave();");
//}
//else
//{
// imgSave.Attributes.Add("onclick", "doSave();");
//}
}
if (this.IsAdmin)
{
string script = "<script>function fNewWin(strUsrId, strUserNo)";
script += "{ window.open('http://member.imbc.com/admin/BbsUserInfo.aspx?uno='+strUserNo+'&uid='+strUsrId, 'usrinfo', 'resizable=no,scrollbars=no,x=100,y=200,width=400,height=120'); }";
script += "</script>";
Response.Write(script);
}
if (!IsPostBack)
{
this.mstInfo = data.RetrieveMemoMstInfo(this.progCode);
this.progTitle.Text = mstInfo.progTitle;
this.tblColor.BgColor = mstInfo.tblColor;
this.tblColor2.BgColor = mstInfo.tblColor;
this.nPageRow = mstInfo.pageRow;
if (this.mstInfo.memoType == "2")
{
imgSave.Visible = false;
txtComment.Text = "mini 에서만 작성하실 수 있습니다.";
txtComment.Enabled = false;
}
try
{
if (this.progCode == "STFM000001715" || this.progCode == "STFM000001746")
{
pnlList.Visible = false;
this.listRepeater.Visible = false;
pnlNoMsgList.Visible = true;
}
else
{
pnlList.Visible = true;
pnlNoMsgList.Visible = false;
this.listRepeater.Visible = true;
ListDataView ldv = data.RetrieveMemoList(this.progCode, this.nCurPage, this.nPageRow, this.search, this.searchWord);
this.nTotalRecord = ldv.TotalCount;
this.listRepeater.DataSource = ldv.DV;
this.listRepeater.DataBind();
string pagingURL = "RetrieveMemoList.aspx?curPage={0}&progCode=" + this.progCode + "&search=" + this.search + "&searchWord=" + this.searchWord;
this.pageNavigator.Text = NoteUtil.SetNavigator(this.nCurPage, this.nTotalRecord, this.nPageRow, pagingURL);
}
}
catch (System.Exception ex)
{
throw ex;
// Response.Write("잠시만 기다려 주십시오..");
// Response.End();
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.nCurPage = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage", "1"));
this.nCurPage2 = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage2", "1"));
this.search = IMBC.FW.Util.WebUtil.EncodeHTML(WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("search", "")));
this.search2 = IMBC.FW.Util.WebUtil.EncodeHTML(WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("search2", "")));
this.searchWord = IMBC.FW.Util.WebUtil.RemoveHTMLTag(WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("searchWord", ""))).Replace("+", "").Replace("%", "").Replace("'", "");
this.searchWord2 = IMBC.FW.Util.WebUtil.RemoveHTMLTag(WebUtil.replaceSQLInjections(IMBC.FW.Util.WebUtil.GetRequestQueryString("searchWord2", ""))).Replace("+", "").Replace("%", "").Replace("'", "");
this.uInfo = new UserInfo();
this.data = new NoteData();
if (this.uInfo.IsLogin == false)
{
imgSave.Src = "http://img.imbc.com/mini/UserNote/images/mini_memo_login.jpg";
img1.Src = "http://img.imbc.com/mini/UserNote/images/mini_memo_login.jpg";
System.Web.HttpContext httpContext = System.Web.HttpContext.Current;
httpContext.Response.Cookies["IMBCURL"].Value = httpContext.Server.UrlEncode("http://" + httpContext.Request.ServerVariables["SERVER_NAME"] + httpContext.Request.RawUrl);
httpContext.Response.Cookies["IMBCURL"].Domain = "imbc.com";
httpContext.Response.Cookies["IMBCURL"].Path = "/";
httpContext.Response.Cookies["IMBCURL"].Secure = false;
imgSave.Attributes.Add("onclick", "location.href='http://member.imbc.com/Login/Login.aspx?TemplateId=Popup'; return false;");
txtComment.Enabled = false;
img1.Attributes.Add("onclick", "location.href='http://member.imbc.com/Login/Login.aspx?TemplateId=Popup'; return false;");
txtComment1.Enabled = false;
}
else
{
this.IsAdmin = data.IsAdminUserDB(this.progCode_STFM, uInfo.UserID);
imgSave.Attributes.Add("onclick", "doSave();");
img1.Attributes.Add("onclick", "doSave();");
}
if (!IsPostBack)
{
// 현재 시간의 편성 정보 가져오기
ScheduleMBCList STFM = new NoteData().RetrieveScheduleListForMBC("STFM");
List <ScheduleMBC> newSTFM = new List <ScheduleMBC>();
newSTFM = STFM.FindAll(
delegate(ScheduleMBC sc)
{
return(DateTime.Parse(sc.EndTime) > DateTime.Parse(DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString()) && sc.Day == GetDayOfWeek(DateTime.Now));
}
);
newSTFM = newSTFM.GetRange(0, 1);
foreach (ScheduleMBC sc in newSTFM)
{
progCode_STFM = new NoteData().GetProgCode(sc.BroadCastID, sc.GroupID).Trim();
progTitle.Text = sc.ProgramTitle + progCode_STFM;
// Response.Write(sc.ProgramTitle + " : " + sc.BroadCastID + " :" + sc.GroupID);
}
try
{
this.mstInfo = data.RetrieveMemoMstInfo(this.progCode_STFM);
this.progTitle.Text = mstInfo.progTitle;
this.tblColor.BgColor = mstInfo.tblColor;
this.nPageRow = mstInfo.pageRow;
if (this.mstInfo.memoType == "2")
{
imgSave.Visible = false;
txtComment.Text = "mini 에서만 작성하실 수 있습니다.";
txtComment.Enabled = false;
}
}
catch { }
try
{
ListDataView ldv = data.RetrieveMemoList(this.progCode_STFM, this.nCurPage, this.nPageRow, this.search, this.searchWord);
if (ldv != null)
{
this.nTotalRecord = ldv.TotalCount;
this.listRepeater.DataSource = ldv.DV;
this.listRepeater.DataBind();
string pagingURL = "MiniMsgMor.aspx?curPage={0}&progCode=" + this.progCode_STFM + "&search=" + this.search + "&searchWord=" + this.searchWord;
this.pageNavigator.Text = NoteUtil.SetNavigator(this.nCurPage, this.nTotalRecord, this.nPageRow, pagingURL);
}
}
catch { }
ScheduleMBCList FM4U = new NoteData().RetrieveScheduleListForMBC("FM4U");
List <ScheduleMBC> newFM4U = new List <ScheduleMBC>();
newFM4U = FM4U.FindAll(
delegate(ScheduleMBC sc)
{
return(DateTime.Parse(sc.EndTime) > DateTime.Parse(DateTime.Now.ToShortDateString() + " " + DateTime.Now.ToShortTimeString()) && sc.Day == GetDayOfWeek(DateTime.Now));
}
);
newFM4U = newFM4U.GetRange(0, 1);
foreach (ScheduleMBC sc in newFM4U)
{
progCode_FM4U = new NoteData().GetProgCode(sc.BroadCastID, sc.GroupID).Trim();
Label1.Text = sc.ProgramTitle;
//Response.Write(sc.ProgramTitle + ":" + sc.BroadCastID + " :" + sc.GroupID);
}
try
{
this.mstInfo2 = data.RetrieveMemoMstInfo(this.progCode_FM4U);
this.tblColor.BgColor = mstInfo2.tblColor;
this.tblColor2.BgColor = mstInfo2.tblColor;
this.nPageRow2 = mstInfo2.pageRow;
if (this.mstInfo2.memoType == "2")
{
img1.Visible = false;
txtComment1.Text = "mini 에서만 작성하실 수 있습니다.";
txtComment1.Enabled = false;
}
}
catch { }
try
{
ListDataView ldv2 = data.RetrieveMemoList(this.progCode_FM4U, this.nCurPage2, this.nPageRow2, this.search2, this.searchWord2);
this.nTotalRecord2 = ldv2.TotalCount;
this.listRepeater2.DataSource = ldv2.DV;
this.listRepeater2.DataBind();
string pagingURL2 = "MiniMsgMor.aspx?curPage2={0}&progCode=" + this.progCode_FM4U + "&search2=" + this.search + "&searchWord2=" + this.searchWord;
this.Label2.Text = NoteUtil.SetNavigator(this.nCurPage2, this.nTotalRecord2, this.nPageRow2, pagingURL2);
}
catch { }
}
}
