private void BindData()
{
DataTable list = NewslistHelper.SelectNewsPublishedForView(0, pageSize);
grdListNews.DataSource = list;
grdListNews.DataBind();
}
protected void grdListNews_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView data = e.Row.DataItem as DataRowView;
Literal ltrInfo = e.Row.FindControl("ltrInfo") as Literal;
CheckBox chkIsFocus = e.Row.FindControl("chkIsFocus") as CheckBox;
DropDownList cboIsHot = e.Row.FindControl("cboIsHot") as DropDownList;
HtmlAnchor aIconUpdate = (HtmlAnchor)e.Row.FindControl("aIconUpdate");
if (aIconUpdate != null)
{
aIconUpdate.HRef = "/ajax/DifferentOfContent.aspx?nid=" + DataBinder.Eval(e.Row.DataItem, "News_ID");
//aIconUpdate.Attributes["onclick"] = "GoToEditPublisheNews('" +DataBinder.Eval(e.Row.DataItem, "News_ID") +"'); return false;";
aIconUpdate.Visible =
NewslistHelper.IsHaveNewUpdateNewsPublished(
DataBinder.Eval(e.Row.DataItem, "News_ID").ToString());
}
string datetime = data["ModifiedDate"] == DBNull.Value ? string.Empty : ((DateTime)data["ModifiedDate"]).ToString("dd/MM/yyyy HH:mm");
string approver = data["News_Approver"] == DBNull.Value ? string.Empty : (string)data["News_Approver"];
string senderId = data["Sender_ID"] == DBNull.Value ? string.Empty : (string)data["Sender_ID"];
switch (CpMode)
{
case "approvalwaitlist":
case "approvalwaitspeciallist":
ltrInfo.Text = "Người đưa: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
String News_ID = Request.QueryString["News_ID"];
ActionRow objActionRow = NewslistHelper.getLastestAction(Convert.ToInt64(News_ID));
txtComment_Title.Text = objActionRow.Comment_Title;
txtComment_Content.Text = objActionRow.Content;
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(txtKey.Text.Trim()) || ddlChuyenmuc.SelectedValue != "0")
{
DataTable list = NewslistHelper.SelectNewsPublishedForViewSearch("0", pageSize.ToString(), txtKey.Text, ddlChuyenmuc.SelectedValue);
grdListNews.AllowPaging = false;
grdListNews.DataSource = list;
grdListNews.DataBind();
}
}
protected void grdTopClick_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView data = e.Row.DataItem as DataRowView;
Literal ltrInfo = e.Row.FindControl("ltrInfo") as Literal;
TextBox txtThuTu = e.Row.FindControl("txtThuTu") as TextBox;
if (txtThuTu != null)
{
txtThuTu.Text = (((DataRowView)e.Row.DataItem)["ThuTu"]).ToString();
}
ltrInfo.Text = "Người đưa: <b>{0}</b>, Ngày gửi: {1}";
ltrInfo.Text = string.Format(ltrInfo.Text, NewslistHelper.GetSenderIDByNewsID(((DataRowView)e.Row.DataItem)["News_ID"].ToString()), ((DateTime)data["News_PublishDate"]).ToString("dd/MM/yyyy hh:mm tt"));
}
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
List <int> thutu = new List <int>();
List <long> newsIdSelected = new List <long>();
string newsIdNotSelected = string.Empty;
foreach (GridViewRow row in grdTopClick.Rows)
{
CheckBox chk = row.FindControl("chk") as CheckBox;
if (chk != null)
{
if (chk.Checked)
{
newsIdSelected.Add((long)grdTopClick.DataKeys[row.RowIndex].Value);
TextBox txtThuTu = row.FindControl("txtThuTu") as TextBox;
if (string.IsNullOrEmpty(txtThuTu.Text))
{
txtThuTu.Text = "1"; // giá trị mặc định
}
thutu.Add(int.Parse(txtThuTu.Text));
}
else
{
newsIdNotSelected += "," + grdTopClick.DataKeys[row.RowIndex].Value.ToString();
}
}
}
if (newsIdNotSelected.StartsWith(","))
{
newsIdNotSelected = newsIdNotSelected.Substring(1);
}
if (Session["EditionType"] != null && Session["EditionType"] != "")
{
NewslistHelper.BaiNoiBat_BaiNoiBat_Update(newsIdSelected.ToArray(), thutu.ToArray(), newsIdNotSelected, Session["EditionType"].ToString());
}
else
{
Response.Redirect("/login.aspx");
}
bindData();
lblMessage.Text = "Bạn đã cập nhật thành công !";
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
MainSecurity objSecu = new MainSecurity();
Role objRole = objSecu.GetRole(Page.User.Identity.Name, DFISYS.API.Config.CurrentChannel);
Permission objPermission = objSecu.GetPermission(Page.User.Identity.Name);
// Check permission doi voi tung loai thong ke
if (objPermission.isXuat_Ban_Bai)
{
ltrSumNewsPublished.Text = NewslistHelper.GetCountNews("publishedlist", false).ToString();
hplPublished.NavigateUrl = "/office/publishedlist.aspx";
}
else
{
hplPublished.Visible = false;
}
if (objPermission.isDuyet_Bai)
{
ltrSumNewsWaitingApprove.Text = NewslistHelper.GetCountNews("approvalwaitlist", false).ToString();
hplNewsWaitingApprove.NavigateUrl = "/office/approvalwaitlist.aspx";
}
else
{
hplNewsWaitingApprove.Visible = false;
}
if (objPermission.isBien_Tap_Bai)
{
ltrSumNewsWaitingEdit.Text = NewslistHelper.GetCountNews("editwaitlist", false).ToString();
hplNewsWaitingEdit.NavigateUrl = "/office/editwaitlist.aspx";
}
else
{
hplNewsWaitingEdit.Visible = false;
}
}
}
protected void bindData()
{
if (Session["EditionType"] != null && Session["EditionType"].ToString() != "")
{
DataTable dtData = NewslistHelper.BaiNoiBat_BaiNoiBat_Select(Session["EditionType"].ToString());
grdTopClick.DataSource = dtData;
grdTopClick.DataBind();
if (dtData != null && dtData.Rows.Count > 0)
{
btnUpdate.Visible = true;
}
else
{
btnUpdate.Visible = false;
}
}
else
{
Response.Redirect("/login.aspx");
}
}
public static string getNewsCountStr(string cpMode, bool isClear)
{
string strCpMode = cpMode.ToString().ToLower();
string cacheName = string.Empty, str = string.Empty;
switch (strCpMode)
{
case "allnewstemplist":
cacheName = "allnewstemplist";
if (isClear)
{
HttpContext.Current.Cache.Remove(cacheName);
}
str = HttpContext.Current.Cache.Get(cacheName) as string;
if (str == null)
{
str = DFISYS.BO.Editoral.Newslist.NewslistHelper.News_GetAllNewsTemplistCount("").ToString();
//HttpContext.Current.Cache.Insert(cacheName, str, null, DateTime.Now.AddMinutes(cacheTime), Cache.NoSlidingExpiration);
}
break;
case "approvalwaitspeciallist":
//cacheName = "approvalwaitspeciallist";
//if (isClear) HttpContext.Current.Cache.Remove(cacheName);
//str = HttpContext.Current.Cache.Get(cacheName) as string;
//if (str == null)
//{
str = DFISYS.BO.Editoral.Newslist.NewslistHelper.GetRowsCountOfNewsSpecialListControl(" News_status = 2 and IsUserRate =1 ").ToString();
//HttpContext.Current.Cache.Insert(cacheName, str, null, DateTime.Now.AddMinutes(cacheTime), Cache.NoSlidingExpiration);
// }
break;
default:
str = NewslistHelper.GetCountNews(Convert.ToString(cpMode), isClear).ToString();
break;
}
return(str.Equals("0") ? str : int.Parse(str).ToString("#,###"));
}
protected void grdListNews_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
DataRowView data = e.Row.DataItem as DataRowView;
Literal ltrInfo = e.Row.FindControl("ltrInfo") as Literal;
CheckBox chkIsFocus = e.Row.FindControl("chkIsFocus") as CheckBox;
DropDownList cboIsHot = e.Row.FindControl("cboIsHot") as DropDownList;
HtmlAnchor aIconUpdate = (HtmlAnchor)e.Row.FindControl("aIconUpdate");
if (aIconUpdate != null)
{
aIconUpdate.HRef = "/ajax/DifferentOfContent.aspx?nid=" + DataBinder.Eval(e.Row.DataItem, "News_ID");
aIconUpdate.Visible = NewslistHelper.IsHaveNewUpdateNewsPublished(DataBinder.Eval(e.Row.DataItem, "News_ID").ToString());
}
string datetime = data["ModifiedDate"] == DBNull.Value ? string.Empty : ((DateTime)data["ModifiedDate"]).ToString("dd/MM/yyyy HH:mm");
string approver = data["News_Approver"] == DBNull.Value ? string.Empty : (string)data["News_Approver"];
string senderId = data["Sender_ID"] == DBNull.Value ? string.Empty : (string)data["Sender_ID"];
switch (CpMode)
{
case "templist":
ltrInfo.Text = "Lần sửa cuối: <b>{0}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, datetime);
break;
case "sendlist":
ltrInfo.Text = "Ngày gửi: <b>{0}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, datetime);
chkIsFocus.Enabled = false;
cboIsHot.Enabled = false;
break;
case "sendapprovallist":
ltrInfo.Text = "Ngày gửi: <b>{0}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, datetime);
chkIsFocus.Enabled = false;
cboIsHot.Enabled = false;
break;
case "dellist":
ltrInfo.Text = "Lần sửa cuối: <b>{0}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, datetime);
break;
//Cung la waitlist nhung voi quyen khac nhau thi status nhan dc la khac nhau:
//Neu la BTV thi trang thai la 1 va mode la editwaitlist.
case "editwaitlist":
ltrInfo.Text = "Người đưa: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
case "editinglist":
ltrInfo.Text = "Người đưa: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
case "approvinglist":
ltrInfo.Text = "Người đưa: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
case "approvalwaitlist":
ltrInfo.Text = "Người đưa: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
case "publishedlist":
if ((DateTime)data["ModifiedDate"] > DateTime.Now)
{
ltrInfo.Text = "Người viết: <b>{0}</b>, NXB: <span style=\"color:red; text-decoration:underline;\">{1}</span>, sửa cuối: <b>{2}</b>";
}
else
{
ltrInfo.Text = "Người viết: <b>{0}</b>, NXB: {1}, sửa cuối: <b>{2}</b>";
}
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime, approver);
if (isAllowChamNhuanBut)
{
grdListNews.Columns[2].Visible = false;
}
break;
case "backlist":
ltrInfo.Text = "Người trả: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
case "removedlist":
ltrInfo.Text = "Người gỡ: <b>{0}</b>, Lần sửa cuối: <b>{1}</b>";
ltrInfo.Text = string.Format(ltrInfo.Text, senderId, datetime);
break;
}
}
}
