/// <summary>
/// 사용자 보낸 쪽지함 목록
/// </summary>
/// <param name="uno">사용자번호</param>
/// <param name="curPage">현재페이지</param>
/// <param name="pageRow">페이지크기</param>
/// <returns>보낸 쪽지함 목록</returns>
public ListDataView RetrieveUserReplyNoteList(int uno, int curPage, int pageRow)
{
ListDataView ldv = new ListDataView();
// SqlConnection conn = DbConnection.DbCon;
SqlConnection conn = DbConnection.DbCon;
SQLHelper.OpenConnection(conn);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "CountUserReplyNoteList";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@uno", SqlDbType.Int).Value = uno;
ldv.TotalCount = SQLHelper.ExecuteScalarRetInt(conn, sqlCmd);
sqlCmd.CommandText = "RetrieveUserReplyNoteList";
sqlCmd.Parameters.Add("@curPage", SqlDbType.Int).Value = curPage;
sqlCmd.Parameters.Add("@pageRow", SqlDbType.Int).Value = pageRow;
ldv.DV = SQLHelper.FillDataAdapter(conn, sqlCmd, (curPage - 1) * pageRow, pageRow);
SQLHelper.CloseConnection(conn);
return(ldv);
}
protected void Page_Load(object sender, EventArgs e)
{
this.nCurPage = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage", "1"));
this.uInfo = new UserInfo();
if (this.uInfo.IsLogin == false)
{
this.uInfo.RedirectLoginPagePopup();
Response.End();
}
if (!IsPostBack)
{
NoteData data = new NoteData();
ListDataView ldv = data.RetrieveUserReplyNoteList(this.uInfo.Uno, this.nCurPage, this.nPageRow);
this.nTotalRecord = ldv.TotalCount;
this.listRepeater.DataSource = ldv.DV;
this.listRepeater.DataBind();
string pagingURL = "RetrieveUserReplyNoteList.aspx?curPage={0}";
this.pageNavigator.Text = NoteUtil.SetNavigator(this.nCurPage, this.nTotalRecord, this.nPageRow, pagingURL);
}
}
/// <summary>
/// 게시물 목록 (관리자용)
/// </summary>
/// <param name="progCode">프로그램코드</param>
/// <param name="memoType">게시물 종류(1:웹, 2:쪽지, 3:사연)</param>
/// <param name="search">검색방식</param>
/// <param name="searchWord">검색어</param>
/// <param name="stDt">시작일</param>
/// <param name="spDt">종료일</param>
/// <param name="curPage">현재페이지</param>
/// <param name="pageRow">페이지크기</param>
/// <returns>게시물 목록, 총 레코드 수</returns>
public ListDataView RetrieveMemoAdminList(string progCode, int memoType, string search, string searchWord, string stDt, string spDt, int curPage, int pageRow)
{
ListDataView ldv = new ListDataView();
SqlConnection conn = DbConnection.DbCon;
SQLHelper.OpenConnection(conn);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "CountMemoAdminList";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode;
sqlCmd.Parameters.Add("@memoType", SqlDbType.Int).Value = memoType;
sqlCmd.Parameters.Add("@search", SqlDbType.Char, 1).Value = search;
sqlCmd.Parameters.Add("@searchWord", SqlDbType.VarChar, 50).Value = searchWord;
sqlCmd.Parameters.Add("@stDt", SqlDbType.VarChar, 8).Value = stDt;
sqlCmd.Parameters.Add("@spDt", SqlDbType.VarChar, 8).Value = spDt;
ldv.TotalCount = SQLHelper.ExecuteScalarRetInt(conn, sqlCmd);
sqlCmd.CommandText = "RetrieveMemoAdminList";
sqlCmd.Parameters.Add("@curPage", SqlDbType.Int).Value = curPage;
sqlCmd.Parameters.Add("@pageRow", SqlDbType.Int).Value = pageRow;
ldv.DV = SQLHelper.FillDataAdapter(conn, sqlCmd, (curPage - 1) * pageRow, pageRow);
SQLHelper.CloseConnection(conn);
return(ldv);
}
/// <summary>
/// 게시판 목록 (사용자용)
/// </summary>
/// <param name="progCode">프로그램코드</param>
/// <param name="curPage">현재페이지</param>
/// <param name="pageRow">페이지크기</param>
/// <param name="search">검색방식</param>
/// <param name="searchWord">검색어</param>
/// <returns>게시판 목록, 총 레코드 수</returns>
public ListDataView RetrieveMemoList(string progCode, int curPage, int pageRow, string search, string searchWord)
{
ListDataView ldv = new ListDataView();
try
{
SqlConnection conn = DbConnection.DbCon;
SQLHelper.OpenConnection(conn);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "dbowr_select.CountMemoList";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode;
sqlCmd.Parameters.Add("@search", SqlDbType.Char, 1).Value = search;
sqlCmd.Parameters.Add("@searchWord", SqlDbType.VarChar, 20).Value = searchWord;
ldv.TotalCount = SQLHelper.ExecuteScalarRetInt(conn, sqlCmd);
sqlCmd.CommandText = "dbowr_select.RetrieveMemoList";
sqlCmd.Parameters.Add("@curPage", SqlDbType.Int).Value = curPage;
sqlCmd.Parameters.Add("@pageRow", SqlDbType.Int).Value = pageRow;
ldv.DV = SQLHelper.FillDataAdapter(conn, sqlCmd);
SQLHelper.CloseConnection(conn);
}
catch (System.NullReferenceException exNull)
{
ldv = null;
}
return(ldv);
}
/// <summary>
/// 게시판 목록 - 보이는 라디오 용
/// </summary>
/// <param name="progCode"></param>
/// <param name="curPage"></param>
/// <param name="pageRow"></param>
/// <returns></returns>
public ListDataView RetrieveMemoListForBora(string progCode, int curPage, int pageRow)
{
ListDataView ldv = new ListDataView();
SqlConnection conn = DbConnection.DbCon;
SQLHelper.OpenConnection(conn);
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandText = "CountMemoList";
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.Add("@progCode", SqlDbType.VarChar, 13).Value = progCode;
sqlCmd.Parameters.Add("@search", SqlDbType.Char, 1).Value = "";
sqlCmd.Parameters.Add("@searchWord", SqlDbType.VarChar, 20).Value = "";
ldv.TotalCount = SQLHelper.ExecuteScalarRetInt(conn, sqlCmd);
sqlCmd.CommandText = "RetrieveMiniMemoListForBora";
sqlCmd.Parameters.Add("@curPage", SqlDbType.Int).Value = curPage;
sqlCmd.Parameters.Add("@pageRow", SqlDbType.Int).Value = pageRow;
ldv.DV = SQLHelper.FillDataAdapter(conn, sqlCmd);
SQLHelper.CloseConnection(conn);
return(ldv);
}
protected void Page_Load(object sender, EventArgs e)
{
this.progCode = IMBC.FW.Util.WebUtil.GetRequestQueryString("progCode", "RAMFM300");
this.nCurPage = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage", "1"));
this.memoType = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("memoType", "0"));
this.search = IMBC.FW.Util.WebUtil.GetRequestQueryString("search", "");
this.searchWord = IMBC.FW.Util.WebUtil.GetRequestQueryString("searchWord", "");
this.stDt = IMBC.FW.Util.WebUtil.GetRequestQueryString("stDt", "");
this.spDt = IMBC.FW.Util.WebUtil.GetRequestQueryString("spDt", "");
this.newCnt.Text = IMBC.FW.Util.WebUtil.GetRequestQueryString("newCnt", "");
if (this.progCode.Substring(0, 4) == "RDMB")
{
this.progCode = NoteUtil.GetParentCode(this.progCode);
}
if (!IsPostBack)
{
NoteData data = new NoteData();
UserInfo uInfo = new UserInfo();
if (data.IsAdminUserDB(this.progCode, uInfo.UserID) == false)
{
Response.Write("관리자가 아닙니다.");
Response.End();
}
this.progTitle.Text = data.RetrieveProgramInfo(this.progCode).progTitle;
if (newCnt.Text == "")
{
this.newCnt.Text = data.CountMemoNewInfo(this.progCode).ToString();
}
ListDataView ldv = data.RetrieveMemoAdminList(this.progCode, this.memoType, search, searchWord, stDt, spDt, this.nCurPage, this.nPageRow);
this.nTotalRecord = ldv.TotalCount;
this.listRepeater.DataSource = ldv.DV;
this.listRepeater.DataBind();
string pagingURL = "RetrieveMemoAdminList.aspx?curPage={0}&progCode=" + this.progCode + "&memoType=" + memoType + "&seach=" + search + "&searchWord=" + searchWord + "&stDt=" + stDt + "&spDt=" + spDt + "&newCnt=" + this.newCnt.Text;
this.pageNavigator.Text = NoteUtil.SetNavigator(this.nCurPage, this.nTotalRecord, this.nPageRow, pagingURL);
}
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
var form = new Form();
var gridView = new DataGridView {
Dock = DockStyle.Fill, Parent = form
};
gridView.DataSource = ListDataView.Create(GetData(), null, p =>
{
if (p.PropertyType == typeof(ComplexDataWrapper))
{
return(ChildPropertyDescriptor.Create(p, "Name", "Complex Name"));
}
return(p);
});
Application.Run(form);
}
protected void Page_Load(object sender, EventArgs e)
{
this.progCode = IMBC.FW.Util.WebUtil.GetRequestQueryString("progCode", "");
this.nCurPage = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage", "1"));
if (!IsPostBack)
{
NoteData data = new NoteData();
ListDataView ldv = data.RetrieveAdminNoteList(this.progCode, nCurPage, nPageRow);
this.nTotalRecord = ldv.TotalCount;
this.listRepeater.DataSource = ldv.DV;
this.listRepeater.DataBind();
string pagingURL = "RetrieveAdminNoteList.aspx?curPage={0}&progCode=" + this.progCode;
this.pageNavigator.Text = NoteUtil.SetNavigator(this.nCurPage, this.nTotalRecord, this.nPageRow, pagingURL);
}
}
protected void Page_Load(object sender, EventArgs e)
{
this.nCurPage = int.Parse(IMBC.FW.Util.WebUtil.GetRequestQueryString("curPage", "1"));
this.uInfo = new UserInfo();
if (this.uInfo.IsLogin == false)
{
this.uInfo.RedirectLoginPagePopup();
Response.End();
}
if (System.Web.Configuration.WebConfigurationManager.AppSettings["pmstart"].ToString() == "ON")
{
Response.Redirect("http://imbc.com/broad/radio/minimbc/new_notice/notice_con/index.html");
Response.End();
}
if (!IsPostBack)
{
NoteData data = new NoteData();
if (this.nCurPage == 1)
{
this.logRepeater.DataSource = data.RetrieveScriptLogList();
this.logRepeater.DataBind();
}
ListDataView ldv = data.RetrieveUserNoteList(this.uInfo.Uno, "N", this.nCurPage, this.nPageRow);
this.nTotalRecord = ldv.TotalCount;
this.listRepeater.DataSource = ldv.DV;
this.listRepeater.DataBind();
string pagingURL = "RetrieveUserNoteList.aspx?curPage={0}";
this.pageNavigator.Text = NoteUtil.SetNavigator(this.nCurPage, this.nTotalRecord, this.nPageRow, pagingURL);
}
}
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 { }
}
}
