public void LoadCombox()
{
_Anphamdefault = UltilFunc.GetColumnValuesOne("T_AnPham", " Ma_AnPham", "Ma_QT=" + _Ma_QTBT);
UltilFunc.BindCombox(cbo_Anpham, "Ma_Anpham", "Ten_Anpham", "T_Anpham", " Ma_QT in (select Ma_QTBT from T_NguoidungQTBT where Ma_Nguoidung=" + _user.UserID + ")", (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonanpham"));
if (_Anphamdefault > 0)
cbo_Anpham.SelectedValue = _Anphamdefault.ToString();
cbo_chuyenmuc.Items.Clear();
cboSoBao.Items.Clear();
if (cbo_Anpham.SelectedIndex > 0)
{
UltilFunc.BindComboxSoBao(cboSoBao, int.Parse(cbo_Anpham.SelectedValue.ToString()), 0);
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cbo_Anpham.SelectedValue, (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
cboSoBao.DataSource = null;
cboSoBao.DataBind();
}
bintrang(int.Parse(cbo_Anpham.SelectedValue));
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Menu_ID"] != null && Request["Menu_ID"].ToString() != "" && Request["Menu_ID"].ToString() != String.Empty)
{
if (CommonLib.IsNumeric(Request["Menu_ID"]) == true)
{
if (!HPCSecurity.IsAccept(Convert.ToInt32(Request["Menu_ID"])))
Response.Redirect("~/Errors/AccessDenied.aspx");
_user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name);
_Role = _NguoidungDAL.GetRole4UserMenu(_user.UserID, Convert.ToInt32(Request["Menu_ID"]));
if (!IsPostBack)
{
LoadCombox();
cbo_anpham.SelectedValue = Global.DefaultCombobox;
cbo_chuyenmuc.Items.Clear();
if (cbo_anpham.SelectedIndex > 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cbo_anpham.SelectedValue, CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
}
}
}
}
}
private void LoadCombox()
{
UltilFunc.BindCombox(ddlLang, "ID", "TenNgonNgu", "T_NgonNgu", " Hoatdong=1 and ID=" + HPCComponents.Global.DefaultCombobox + " and ID in (select Ma_Ngonngu from T_Nguoidung_NgonNgu where Ma_Nguoidung=" + _user.UserID + ")", "---Tất cả---");
ddlLang.SelectedIndex = UltilFunc.GetIndexControl(ddlLang, HPCComponents.Global.DefaultCombobox);
if (ddlLang.SelectedIndex != 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + ddlLang.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha");
}
}
protected void cbo_AnPham_SelectedIndexChanged(object sender, EventArgs e)
{
cbo_chuyenmuc.Items.Clear();
if (cbo_AnPham.SelectedIndex > 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cbo_AnPham.SelectedValue, (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
}
}
protected void ddlLang_SelectedIndexChanged(object sender, EventArgs e)
{
cbo_chuyenmuc.Items.Clear();
if (ddlLang.SelectedIndex > 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + ddlLang.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha");
cbo_chuyenmuc.UpdateAfterCallBack = true;
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
cbo_chuyenmuc.UpdateAfterCallBack = true;
}
}
protected void cbo_anpham_SelectedIndexChanged(object sender, EventArgs e)
{
cbo_chuyenmuc.Items.Clear();
if (cbo_anpham.SelectedIndex > 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cbo_anpham.SelectedValue, CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
}
}
private void LoadComboBox()
{
int id = int.Parse(Page.Request.QueryString["ID"].ToString());
T_Idiea obj = new T_Idiea();
HPCBusinessLogic.DAL.T_IdieaDAL dal = new HPCBusinessLogic.DAL.T_IdieaDAL();
int _curentID = dal.GetOneFromT_IdieaByID(id).User_Created;
UltilFunc.BindCombox(ddlLang, "ID", "TenNgonNgu", "T_NgonNgu", " Hoatdong=1 and ID=" + HPCComponents.Global.DefaultCombobox + " and ID in (select Ma_Ngonngu from T_Nguoidung_NgonNgu where Ma_Nguoidung=" + _user.UserID + ")", "---Tất cả---");
ddlLang.SelectedIndex = UltilFunc.GetIndexControl(ddlLang, HPCComponents.Global.DefaultCombobox);
if (ddlLang.SelectedIndex != 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + ddlLang.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha");
}
UltilFunc.BindCombox(ddlGroup, "Ma_nhom", "Ten_nhom", "T_Nhom", " 1=1 Order by Ten_Nhom", "");
BindComboxNguoiNhan(0);
}
protected void cboAnPham_SelectedIndexChanged(object sender, EventArgs e)
{
cbo_chuyenmuc.Items.Clear();
cboSoBao.Items.Clear();
if (cboAnPham.SelectedIndex > 0)
{
UltilFunc.BindComboxSoBao(cboSoBao, int.Parse(cboAnPham.SelectedValue.ToString()), 1);
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cboAnPham.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
cboSoBao.DataSource = null;
cboSoBao.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Menu_ID"] != null && Request["Menu_ID"].ToString() != "" && Request["Menu_ID"].ToString() != String.Empty)
{
if (CommonLib.IsNumeric(Request["Menu_ID"]) == true)
{
if (!HPCSecurity.IsAccept(Convert.ToInt32(Request["Menu_ID"])))
{
Response.Redirect("~/Errors/AccessDenied.aspx");
}
_user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name);
_Role = _NguoidungDAL.GetRole4UserMenu(_user.UserID, Convert.ToInt32(Request["Menu_ID"]));
Ma_QTBT = UltilFunc.GetColumnValuesOne("T_NguoidungQTBT", "Ma_QTBT", "Ma_Nguoidung=" + _user.UserID);
if (!IsPostBack)
{
if (Ma_QTBT == 0)
{
Page.Response.Redirect("~/login.aspx", true);
}
LoadCombox();
cbo_chuyenmuc.Items.Clear();
cboSoBao.Items.Clear();
if (cboAnPham.SelectedIndex > 0)
{
UltilFunc.BindComboxSoBao(cboSoBao, int.Parse(cboAnPham.SelectedValue.ToString()), 1);
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cboAnPham.SelectedValue, CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
cboSoBao.DataSource = null;
cboSoBao.DataBind();
}
LoadData();
}
}
}
}
protected void PopulateItem(int _ID)
{
T_Idiea obj_Idiea = new T_Idiea();
HPCBusinessLogic.DAL.T_IdieaDAL obj_DAL = new HPCBusinessLogic.DAL.T_IdieaDAL();
obj_Idiea = obj_DAL.GetOneFromT_IdieaByID(_ID);
Txt_tieude.Text = obj_Idiea.Title;
ddlLang.SelectedValue = obj_Idiea.Lang_ID.ToString();
cbo_chuyenmuc.Items.Clear();
if (ddlLang.SelectedIndex > 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + ddlLang.SelectedValue, "-Chọn chuyên mục-", "Ma_Chuyenmuc_Cha");
cbo_chuyenmuc.SelectedIndex = CommonLib.GetIndexControl(cbo_chuyenmuc, obj_Idiea.Cat_ID.ToString());
}
else
{
this.cbo_chuyenmuc.DataSource = null;
this.cbo_chuyenmuc.DataBind();
}
txt_noidung.Text = obj_Idiea.Comment;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Menu_ID"] != null && Request["Menu_ID"].ToString() != "" && Request["Menu_ID"].ToString() != String.Empty)
{
if (CommonLib.IsNumeric(Request["Menu_ID"]) == true)
{
if (!HPCSecurity.IsAccept(Convert.ToInt32(Request["Menu_ID"])))
{
Response.Redirect("~/Errors/AccessDenied.aspx");
}
_user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name);
_Role = _NguoidungDAL.GetRole4UserMenu(_user.UserID, Convert.ToInt32(Request["Menu_ID"]));
this.btn_chamnhuanbut.Attributes.Add("onclick", "return CheckConfirmGuiTinbai('Are you sure you want royalties photo?',ctl00_MainContent_DataGrid_tinbaiAnh_ctl01_chkAll);");
if (!IsPostBack)
{
LoadCombox();
cbo_chuyenmuc.Items.Clear();
cboSoBao.Items.Clear();
if (cboAnPham.SelectedIndex > 0)
{
UltilFunc.BindComboxSoBao(cboSoBao, int.Parse(cboAnPham.SelectedValue.ToString()), 1);
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cboAnPham.SelectedValue, CommonLib.ReadXML("lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
cboSoBao.DataSource = null;
cboSoBao.DataBind();
}
LoadData();
}
}
}
}
public void LoadCombox()
{
UltilFunc.BindCombox(cboAnPham, "Ma_Anpham", "Ten_Anpham", "T_Anpham", "1=1", CommonLib.ReadXML("lblTatca"));
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") ", CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha");
}
public void LoadCombox()
{
UltilFunc.BindCombox(cbo_Anpham, "Ma_Anpham", "Ten_Anpham", "T_Anpham", " Ma_QT in (select Ma_QTBT from T_NguoidungQTBT where Ma_Nguoidung=" + _user.UserID + ")", (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonanpham"));
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ")", (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
}
protected void Page_Load(object sender, EventArgs e)
{
if (Request["Menu_ID"] != null && Request["Menu_ID"].ToString() != "" && Request["Menu_ID"].ToString() != String.Empty)
{
if (CommonLib.IsNumeric(Request["Menu_ID"]) == true)
{
if (!HPCSecurity.IsAccept(Convert.ToInt32(Request["Menu_ID"])))
Response.Redirect("~/Errors/AccessDenied.aspx");
_user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name);
_Role = _NguoidungDAL.GetRole4UserMenu(_user.UserID, Convert.ToInt32(Request["Menu_ID"]));
_Ma_QTBT = UltilFunc.GetColumnValuesOne("T_NguoidungQTBT", " Ma_QTBT", "Ma_Nguoidung=" + _user.UserID);
this.LinkAdd.Visible = _Role.R_Read;
this.LinkDelete.Visible = _Role.R_Delete;
Pager7.PageIndex = 0;
if (!IsPostBack)
{
if (_user != null)
{
LoadCombox();
if (Session["LoaibaoE"] != null && Session["SobaoE"] != null)
{
cbo_Anpham.SelectedValue = Session["LoaibaoE"].ToString();
if (cbo_Anpham.SelectedIndex > 0)
{
UltilFunc.BindComboxSoBao(cboSoBao, int.Parse(cbo_Anpham.SelectedValue.ToString()), 0);
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cbo_Anpham.SelectedValue, (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
bintrang(int.Parse(cbo_Anpham.SelectedValue.ToString()));
}
cboSoBao.SelectedValue = Session["SobaoE"].ToString();
if (Session["TrangE"] != null)
cboPage.SelectedValue = Session["TrangE"].ToString();
}
int tab_id = 0;
if (Session["CurrentPage"] != null)
Pager7.PageIndex = int.Parse(Session["CurrentPage"].ToString());
if (Request["Tab"] != null)
{
tab_id = Convert.ToInt32(Request["Tab"].ToString());
}
if (tab_id == -1)
{
this.TabContainer1.ActiveTabIndex = 0;
this.TabContainer1_ActiveTabChanged(sender, e);
}
else
{
this.TabContainer1.ActiveTabIndex = tab_id;
this.TabContainer1_ActiveTabChanged(sender, e);
}
GetTotalRecordTinBai();
BindDoiTuongGuiBai();
}
else
Page.Response.Redirect("~/login.aspx", true);
}
}
}
}
private void PopulateItem(int _id)
{
T_TinBai _obj = new T_TinBai();
ChuyenmucDAL _dalcm = new ChuyenmucDAL();
_obj = _Daltinbai.load_T_news(_id);
Txt_tieude.Text = _obj.Tieude;
Ma_QTBT = _obj.Ma_QTBT;
DataTable dtnguoitao = _Daltinbai.Sp_SelectOneNguoitaoTinBai(_id).Tables[0];
if (dtnguoitao != null && dtnguoitao.Rows.Count > 0)
{
if (int.Parse(dtnguoitao.Rows[0][0].ToString()) != _user.UserID)
{
txt_PVCTV.Text = _obj.TacGia;
HiddenFieldTacgiatin.Text = _obj.Ma_TacGia.ToString();
txt_PVCTV.ReadOnly = true;
}
else
{
txt_PVCTV.Text = _obj.TacGia;
HiddenFieldTacgiatin.Text = _obj.Ma_TacGia.ToString();
}
}
else
{
txt_PVCTV.Text = _obj.TacGia;
HiddenFieldTacgiatin.Text = _obj.Ma_TacGia.ToString();
}
if (_obj.GhiChu != "")
{
Txt_Comments.Text = _obj.GhiChu;
}
else
{
Txt_Comments.Text = "";
}
if (_obj.Ma_Anpham > 0)
{
cbo_AnPham.SelectedIndex = CommonLib.GetIndexControl(cbo_AnPham, _obj.Ma_Anpham.ToString());
}
cbo_chuyenmuc.Items.Clear();
if (cbo_AnPham.SelectedIndex > 0)
{
UltilFunc.BindCombox_CategoryDequy(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", " WHERE Hoatdong=1 and Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _user.UserID.ToString() + ") and Ma_AnPham= " + cbo_AnPham.SelectedValue, (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
cbo_chuyenmuc.SelectedIndex = CommonLib.GetIndexControl(cbo_chuyenmuc, _obj.Ma_Chuyenmuc.ToString());
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
}
checkbaoonline.Checked = _obj.VietNamNews;
checkbizbub.Checked = _obj.Bizhub;
LoadDataImage();
}