public void LoadCombox()
{
UltilFunc.BindCombox(cboAnPham, "Ma_Anpham", "Ten_Anpham", "T_Anpham", "1=1", (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonanpham"));
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() + ") ", (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonchuyenmuc"), "Ma_Chuyenmuc_Cha");
}
private void LoadComboBox()
{
UltilFunc.BindCombox(cboNgonNgu, "Ma_AnPham", "Ten_AnPham", "T_AnPham", " 1=1 ", CommonLib.ReadXML("lblTatca"));
}
public void LoadCombox()
{
UltilFunc.BindCombox(cbokhachang, "Ma_KhachHang", "Ten_khachhang", "T_Khachhang", "1=1 and Loai_KH=1", "---Select all---");
UltilFunc.BindCombox(cbo_loaibao, "Ma_Anpham", "Ten_Anpham", "T_Anpham", "1=1", "---Select all---");
}
protected string BuildSQL(int status, string sOrder)
{
//dgr_tintuc1.Columns[8].Visible = false;
LinkButton_updateTT.Visible = false;
string sql = string.Empty;
string sClause = " 1=1 And News_DatePublished is NOT null AND News_Status=" + status + " and CAT_ID in (select DISTINCT(T_Nguoidung_Chuyenmuc.Ma_chuyenmuc) from T_Nguoidung_Chuyenmuc where Ma_Nguoidung = " + _userDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name).UserID + ") ";
string sWhere = string.Empty;
if (chkNewsIsBaidinh.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsHomePages=1 ";
}
if (chkNewsIsFocus.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsHot=1 ";
}
if (chkNewTieudiem.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsFocus=1 ";
}
if (chkNewFocusParent.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsCategoryParrent=1 ";
}
if (chkNewFocusChild.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsCategorys=1 ";
}
if (chkImageIsFocus.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsImages=1 ";
}
if (chkVideoIsFocus.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsVideo=1 ";
}
if (chkHosoIsFocus.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_IsHistory=1 ";
}
if (chDisplayMobi.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_DisplayMobile=1 ";
}
if (cbMoreViews.Checked)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_Delete=1 ";
}
if (txtTieuDetin.Text.Length > 0)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_Tittle LIKE " + string.Format("N'%{0}%'", UltilFunc.SqlFormatText(txtTieuDetin.Text.Trim()));
}
if (cbo_chuyenmuc.SelectedIndex > 0)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += "" + string.Format(" CAT_ID IN (SELECT * FROM [fn_Return_Category_Tree] ({0}))", this.cbo_chuyenmuc.SelectedValue);
}
if (cboNgonNgu.SelectedIndex > 0)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " Lang_ID=" + cboNgonNgu.SelectedValue.ToString();
}
if (txt_tungay.Text.Length > 0)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_DatePublished >= convert(datetime,'" + txt_tungay.Text.Trim() + " 00:00:00',103) ";
}
if (txt_denngay.Text.Length > 0)
{
if (sWhere.Trim().Length > 0)
{
sWhere += " AND ";
}
sWhere += " News_DatePublished <= convert(datetime,'" + txt_denngay.Text.Trim() + " 23:59:59',103) ";
}
sql += sClause;
if (sWhere.Trim().Length > 0)
{
sql += " AND" + sWhere;
}
return(sql + sOrder);
}
protected void LoadData_UnPublisher()
{
string sOrder = " Order by News_DateSend DESC ";
PagerUnPublish.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.T_NewsDAL _T_newsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
string tieude = txt_tieude.Text.Trim();
Session["searchvalueroot"] = null;
if (tieude != "")
{
Session["searchvalueroot"] = UltilFunc.SplitString(tieude);
}
DataSet _ds;
_ds = _T_newsDAL.BindGridT_NewsDynamic(PagerUnPublish.PageIndex, PagerUnPublish.PageSize, BuildSQL(ConstNews.NewsUnPublishing, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
for (int i = 1; i <= TotalRecords; i++)
{
_ds = _T_newsDAL.BindGridT_NewsDynamic(PagerUnPublish.PageIndex - i, PagerUnPublish.PageSize, BuildSQL(ConstNews.NewsUnPublishing, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
if (_ds.Tables[0].Rows.Count > 0)
{
break;
}
}
}
this.dgListNewsUnPublish.DataSource = _ds;
this.dgListNewsUnPublish.DataBind();
this.PagerUnPublish.TotalRecords = this.CurrentPageUnPublish.TotalRecords = TotalRecords;
this.CurrentPageUnPublish.TotalPages = this.PagerUnPublish.CalculateTotalPages();
this.CurrentPageUnPublish.PageIndex = this.PagerUnPublish.PageIndex;
GetTotal();
_ds.Clear();
}
private void LoadComboBox()
{
UltilFunc.BindCombox(cbo_lanquage, "Ma_AnPham", "Ten_AnPham", "T_AnPham", " 1=1 ", CommonLib.ReadXML("lblTatca"));
if (cbo_lanquage.Items.Count >= 3)
{
cbo_lanquage.SelectedIndex = HPCComponents.Global.DefaultLangID;
}
else
{
cbo_lanquage.SelectedIndex = UltilFunc.GetIndexControl(this.cbo_lanquage, HPCComponents.Global.DefaultCombobox);
}
if (cbo_lanquage.SelectedIndex != 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" 1=1 and HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.cbo_lanquage.SelectedValue + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
}
}
private void LoadData_DangXuly()
{
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.T_NewsDAL _T_newsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
string tieude = txt_tieude.Text.Trim();
Session["searchvalueroot"] = null;
if (tieude != "")
{
Session["searchvalueroot"] = UltilFunc.SplitString(tieude);
}
DataSet _ds;
_ds = _T_newsDAL.BindGridT_NewsDynamic(pages.PageIndex, pages.PageSize, BuildSQL(6, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
for (int i = 1; i <= TotalRecords; i++)
{
_ds = _T_newsDAL.BindGridT_NewsDynamic(pages.PageIndex - i, pages.PageSize, BuildSQL(6, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
if (_ds.Tables[0].Rows.Count > 0)
{
break;
}
}
}
dgr_tintuc1.DataSource = _ds;
dgr_tintuc1.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = TotalRecords;
CurrentPage2.TotalPages = pages.CalculateTotalPages();
CurrentPage2.PageIndex = pages.PageIndex;
GetTotal();
_ds.Clear();
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
context.Response.Expires = -1;
try
{
HttpPostedFile postedFile = context.Request.Files["Filedata"];
string[] sArrProdID = null;
char[] sep = { '?' };
string[] sArrVkey = null;
string strUserID = "";
char[] sep2 = { ',' };
sArrProdID = context.Request.QueryString["user"].ToString().Trim().Split(sep);
sArrVkey = sArrProdID[0].ToString().Trim().Split(sep2);
string _urlSave = "";
string FolderCat = "";
string savepath = "";
string tempPath = "";
string strRootPathVirtual = "";
_user = _userDAL.GetUserByUserName(sArrVkey[0].ToString());
strUserID = _user.UserID.ToString();
string vType = sArrVkey[1].ToString();
string AlbumID = sArrVkey[2].ToString();
if (vType == "1")
{
FolderCat = "/Article/";
}
else if (vType == "2")
{
FolderCat = "/Ads/";
}
else if (vType == "3")
{
FolderCat = "/Video/";
}
else if (vType == "4")
{
FolderCat = "/Photo24/";
}
else
{
FolderCat = "";
}
tempPath = System.Configuration.ConfigurationManager.AppSettings["UploadPathBDT"] + FolderCat + sArrVkey[0].ToString() + "/";
strRootPathVirtual = tempPath + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/";
savepath = context.Server.MapPath(strRootPathVirtual);
string filename = DateTime.Now.Millisecond.ToString() + "_" + postedFile.FileName;
string _extenfile = Path.GetExtension(filename.ToString().Trim()).Replace(".", "");
if (!Directory.Exists(savepath))
{
Directory.CreateDirectory(savepath);
}
postedFile.SaveAs(savepath + @"\" + filename);
string _logo = context.Server.MapPath("../Dungchung/Images/IconHPC/LoGoDongDau.png");
string _imagesEndWatermark = DateTime.Now.ToString("yyyyMMdd").ToString() + DateTime.Now.ToString("HHmmss") + DateTime.Now.Millisecond + UltilFunc.ReplaceCharsRewrite(filename.Replace(Path.GetExtension(filename.ToString().Trim()), "")) + "." + _extenfile;
_urlSave = UrlPathImage_RemoveUpload(strRootPathVirtual + _imagesEndWatermark);
// Begin BO CT EDIT Đóng dấu ảnh
if (Convert.ToBoolean(Convert.ToInt32(System.Configuration.ConfigurationManager.AppSettings["WatermarkImages"])))
{
HPCImageResize.SaveImage2Server(savepath, filename, "rez_" + filename, _imagesEndWatermark, _logo, Convert.ToInt32(HPCComponents.Global.VNPResizeImages), Convert.ToInt32(HPCComponents.Global.VNPResizeImages));
}
else// Không đóng dấu ảnh //END
{
HPCImageResize.SaveImage2Server(savepath, filename, _imagesEndWatermark, Convert.ToInt32(HPCComponents.Global.VNPResizeImages), Convert.ToInt32(HPCComponents.Global.VNPResizeImages));
}
// INSERT DATABASE
//phan insert co so du lieu
T_ImageFiles _objImage = new T_ImageFiles();
ImageFilesDAL _DAL = new ImageFilesDAL();
_objImage = SetItemImageFiles(filename, postedFile.ContentLength, _urlSave, _extenfile, Convert.ToInt16(strUserID), Convert.ToInt16(vType), 0);
int _idReturn = _DAL.InsertT_ImageFiles(_objImage);
//phan insert Anh phong su
T_Photo_EventDAL _cateDAL = new T_Photo_EventDAL();
T_Photo_Event _obj = new T_Photo_Event();
_obj = setItem(_urlSave, postedFile.FileName);
int _return = _cateDAL.InsertT_Photo_Events(_obj);
context.Response.Write(savepath + "/" + filename);
context.Response.StatusCode = 200;
}
catch (Exception ex)
{
context.Response.Write("Error: " + ex.Message);
}
}
protected void Search_Click(object sender, EventArgs e)
{
Session["where_chuyenmuc"] = null;
string where = " Ma_Chuyenmuc_Cha=0";
if (cbo_Anpham.SelectedIndex > 0)
{
where += " and Ma_AnPham=" + cbo_Anpham.SelectedValue.ToString();
}
if (!String.IsNullOrEmpty(this.txtSearch_ChuyenMuc.Text.Trim()))
{
where += " and " + string.Format(" Ten_ChuyenMuc like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_ChuyenMuc.Text.Trim()))
+ " or Ma_ChuyenMuc in( select Ma_Chuyenmuc_Cha from T_ChuyenMuc where Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_ChuyenMuc where " + string.Format(" Ten_ChuyenMuc like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_ChuyenMuc.Text.Trim())) + "))";
}
if (chk_Hoatdong.Checked)
{
where += " and Hoatdong=1";
}
if (!chk_Hoatdong.Checked)
{
where += " and Hoatdong=0";
}
if (CheckBoxBaoDT.Checked)
{
where += " and HienThi_BDT=1";
}
if (CheckBoxBaoIn.Checked)
{
where += " and HienThi_BaoIn=1";
}
Session["where_chuyenmuc"] = where;
pages.PageIndex = 0;
Danhsach_ChuyenMuc();
}
protected void linkSave_Click(object sender, EventArgs e)
{
//dung them vao de kiem tra dieu dau vao và để busybox khong bi dung trong IE
if (Txt_tieude.Text.Length <= 0)
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + CommonLib.ReadXML("lblXacnhanLuu") + "');", true);
return;
}
if (cbo_lanquage.SelectedIndex == 0)
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + CommonLib.ReadXML("lblXacnhanLuu") + "');", true);
return;
}
if (cbo_chuyenmuc.SelectedIndex == 0)
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + CommonLib.ReadXML("lblXacnhanLuu") + "');", true);
return;
}
if (!string.IsNullOrEmpty(txtTienNhuanBut.Text))
{
try { int.Parse(txtTienNhuanBut.Text.Replace(",", "")); }
catch
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + CommonLib.ReadXML("lblXacnhanTien") + "');", true);
return;
}
}
T_News _t_news = SetItem(ConstNews.NewsApproving_tb);
int id = 0;
T_NewsDAL _T_newsDAL = new T_NewsDAL();
//T_News _objSet = SetItem(ConstNews.NewsApproving_tb);
// Insert
id = _T_newsDAL.InsertT_news(_t_news);
// Insert keyword
InsertKeyword(id, _user.UserID);
UltilFunc.Insert_News_Image(txt_noidung.Text.Trim(), Convert.ToDouble(Page.Request["id"]));
int tab = 0;
if (Request["ID"] == null)
{
if (Page.Request["Tab"] != null && Page.Request["Tab"].ToString() != "-1")
{
tab = Convert.ToInt32(Page.Request["Tab"].ToString());
if (tab == 10)
{
WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, _t_news.News_Tittle,
Request["Menu_ID"].ToString(), "[Tin tức đang đăng] [Thao tác cập nhật]", id, ConstAction.BaoDT);
}
else
{
WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, _t_news.News_Tittle,
Request["Menu_ID"].ToString(), "[Biên tập tin bài] [Tin bài đang biên tập] [Thao tác cập nhật]", id, ConstAction.BaoDT);
}
}
else
{
WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, _t_news.News_Tittle,
Request["Menu_ID"].ToString(), "[Biên tập tin bài] [Tin tức đang chờ xuất bản:] [Thao tác cập nhật]", id, ConstAction.BaoDT);
}
}
else
{
if (Page.Request["Tab"] != null && Page.Request["Tab"].ToString() != "-1")
{
tab = Convert.ToInt32(Page.Request["Tab"].ToString());
if (tab == 10)
{
WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, _t_news.News_Tittle,
Request["Menu_ID"].ToString(), "[Tin tức đang đăng] [Thao tác cập nhật]", _t_news.News_ID, ConstAction.BaoDT);
}
else
{
WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, _t_news.News_Tittle,
Request["Menu_ID"].ToString(), "[Biên tập tin bài] [Tin bài đang biên tập] [Thao tác cập nhật]", _t_news.News_ID, ConstAction.BaoDT);
}
}
else
{
WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, _t_news.News_Tittle,
Request["Menu_ID"].ToString(), "[Biên tập tin bài] [Tin tức đang chờ xuất bản] [Thao tác cập nhật]", _t_news.News_ID, ConstAction.BaoDT);
}
}
if (_t_news.Images_Summary.Length > 0)
{
this.ImgTemp.Src = HPCComponents.Global.TinPathBDT + "/" + _t_news.Images_Summary;
}
_T_newsDAL.IsLock(double.Parse(_t_news.News_ID.ToString()), 1, _user.UserID);
if (Request["Tab"] != null && Request["Tab"].ToString() != "" && Request["Tab"].ToString() != String.Empty)
{
Response.Redirect("ArticleApproveEditTB.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&Tab=" + Page.Request["Tab"].ToString() + "&ID=" + id.ToString());
}
else
{
Response.Redirect("ArticleApproveEditTB.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&ID=" + id.ToString());
}
}
public override void DataBind()
{
if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty)
{
lblTitleCaption.Text = CommonLib.ReadXML("lblCapnhatbaiviet");
if (CommonLib.IsNumeric(Request["ID"]) == true)
{
int ChildID = Convert.ToInt32(Request["ID"].ToString());
PopulateItem(ChildID);
}
}
else
{
lblTitleCaption.Text = CommonLib.ReadXML("lblSuabaiviet");
this.ImgTemp.Attributes.CssStyle.Add("display", "none");
this.cbHienthiAnh.Checked = false;
//if (cbo_lanquage.SelectedIndex > 0)
//{
// cbo_chuyenmuc.Items.Clear();
// if (cbo_lanquage.SelectedIndex >= 0)
// {
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
cbo_chuyenmuc.UpdateAfterCallBack = true;
// }
// else
// {
// this.cbo_chuyenmuc.DataSource = null;
// this.cbo_chuyenmuc.DataBind();
// this.cbo_chuyenmuc.UpdateAfterCallBack = true;
// }
//}
}
}
private void PopulateItem(int _id)
{
//Lấy ID trong T_AutoSave
AutoSavesDAL _dal = new AutoSavesDAL();
int id_autoSave = _dal.Get_ID_AutoSave(_id, _user.UserID);
txtID.Text = id_autoSave.ToString();
//end
HPCBusinessLogic.DAL.T_NewsDAL _untilDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
HPCInfo.T_News _obj = new T_News();
_obj = _untilDAL.load_T_news(_id);
if (_obj != null)
{
this.txt_Author_name.Text = _obj.News_AuthorName;
this.Txt_tieude.Text = _obj.News_Tittle;
this.txt_TieuDePhu.Text = _obj.News_Sub_Title;
this.txt_noidung.Text = _obj.News_Body;
//this.ddlNews_Priority.SelectedValue = _obj.News_Priority.ToString();
this.chk_IsCategorys.Checked = _obj.News_IsCategorys;
this.chk_IsHomePages.Checked = _obj.News_IsHomePages;
this.chk_IsCategoryParrent.Checked = _obj.News_IsCategoryParrent;
this.chkHistorys.Checked = _obj.News_IsHistory;
this.chkImages.Checked = _obj.News_IsImages;
this.chkVideo.Checked = _obj.News_IsVideo;
if (_obj.News_TienNB > 0.0)
{
this.txtTienNhuanBut.Text = string.Format("{0:#,#}", _obj.News_TienNB).Replace(".", ",");
}
//this.ddlNews_IsType.SelectedValue = _obj.News_IsType.ToString();
this.chkNewsIsFocus.Checked = _obj.News_IsFocus;
this.chkNewsIsHot.Checked = _obj.News_IsHot;
if (_obj.Images_Summary.Length > 0)
{
this.ImgTemp.Src = HPCComponents.Global.UploadPathBDT + _obj.Images_Summary;
}
else
{
this.ImgTemp.Attributes.CssStyle.Add("display", "none");
}
this.Txt_Comments.Text = _obj.News_Comment;
this.txt_tomtat.Text = _obj.News_Summary;
this.txtThumbnail.Text = _obj.Images_Summary;
this.txtTukhoa.Text = _untilDAL.GetKeywordsByNewsID(_id);
this.cbo_lanquage.SelectedValue = _obj.Lang_ID.ToString();
this.cbo_chuyenmuc.Items.Clear();
if (cbo_lanquage.SelectedIndex > 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.cbo_lanquage.SelectedValue + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by Ten_ChuyenMuc ASC");
cbo_chuyenmuc.UpdateAfterCallBack = true;
cbo_chuyenmuc.SelectedIndex = CommonLib.GetIndexControl(cbo_chuyenmuc, _obj.CAT_ID.ToString());
}
else
{
this.cbo_chuyenmuc.DataSource = null;
this.cbo_chuyenmuc.DataBind();
this.cbo_chuyenmuc.UpdateAfterCallBack = true;
}
//bind bai viet lien quan
if (_obj.News_Realate.ToString().Trim() != "")
{
txtListID.Text = _obj.News_Realate.ToString().Trim().Replace(",0", "");
}
LoadNewRealation();
txtVideoPath.Text = _obj.News_PhotoAtt;
txtChuthichanh.Text = _obj.News_DescImages;
this.cbHienthiAnh.Checked = _obj.Image_Hot;
this.txtNguon.Text = _obj.News_Nguon;
this.cbDisplayMobile.Checked = _obj.News_DisplayMobile;
this.cbMoreViews.Checked = _obj.News_Delete;
//if (_obj.Image_Hot)
// this.cbHienthiAnh.Text = "Hiển thị trong tin chi tiết";
//else
// this.cbHienthiAnh.Text = "Không hiển thị trong tin chi tiết";
if (_untilDAL.Get_NewsVersion(_untilDAL.load_T_news(Convert.ToInt32(_id)).News_CopyFrom, 7, 92) ||
_untilDAL.Get_NewsVersion(_untilDAL.load_T_news(Convert.ToInt32(_id)).News_CopyFrom, 7, 82))
{
btn_Layout.Visible = true;
}
else
{
btn_Layout.Visible = false;
}
}
}
private void LoadComboBox()
{
UltilFunc.BindCombox(ddlLang, "Ma_AnPham", "Ten_AnPham", "T_AnPham", " 1=1 ", CommonLib.ReadXML("lblTatca"));
if (ddlLang.Items.Count >= 3)
{
ddlLang.SelectedIndex = Global.DefaultLangID;
}
else
{
ddlLang.SelectedIndex = UltilFunc.GetIndexControl(ddlLang, Global.DefaultCombobox);
}
if (ddlLang.SelectedIndex != 0)
{
UltilFunc.BindCombox(ddlCategorys, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham=" + this.ddlLang.SelectedValue.ToString() + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
}
else
{
UltilFunc.BindCombox(ddlCategorys, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham=" + this.ddlLang.SelectedValue.ToString() + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
}
}
public void LoadDetails(int NewsID, bool ViewHistory, bool chieu, int currentindex, bool clickgrid)
{
if (!ViewHistory)
{
T_News obj = new T_News();
T_NewsDAL dal = new T_NewsDAL();
ChuyenmucDAL caDal = new ChuyenmucDAL();
obj = dal.load_T_news(NewsID);
System.Text.StringBuilder _Builer = new System.Text.StringBuilder();
string _image = "";
if (obj != null && obj.News_ID > 0)
{
try
{
if (obj.News_DateEdit != null && obj.News_DateEdit.ToString().Length > 0)
{
this.litDateTime.Text = Convert.ToDateTime(obj.News_DateEdit.ToString()).ToString("dd/MM/yyyy HH:mm");
}
if (obj.News_DatePublished != null && obj.News_DatePublished.ToString().Length > 0)
{
this.litDateTime.Text = Convert.ToDateTime(obj.News_DatePublished.ToString()).ToString("dd/MM/yyyy HH:mm");
}
this.litTittle.Text = obj.News_Tittle.ToString();
this.litSapo.Text = obj.News_Summary.ToString();
this.litCategorys.Text = "<a href=\"#\">" + HPCBusinessLogic.UltilFunc.GetCategoryName(obj.CAT_ID) + "</a>";
if (obj.News_PhotoAtt != null && obj.News_PhotoAtt.ToString().Length > 0)
{
if (UltilFunc.CheckFrames(obj.News_PhotoAtt.ToString()) == false)
{
_Builer.Append("<div id=\"liveTV\"></div>");
_Builer.Append(" <script type=\"text/javascript\">jwplayer('liveTV').setup({ ");
_Builer.Append(" image: '" + HPCComponents.Global.TinPath + obj.Images_Summary.ToString() + "',");
_Builer.Append(" file: '" + HPCComponents.Global.TinPath + obj.News_PhotoAtt.ToString() + "', ");
_Builer.Append(" width: 665,height: 400,autostart: false,");
_Builer.Append(" backcolor: '#000000',frontcolor: '#ffffff',lightcolor: '#ffffff',screencolor: '#ffffff',");
_Builer.Append(" allowscriptaccess: true,allowfullscreen: true,controlbar: 'over',stretching:'fill'});</script>");
if (obj.News_DescImages != null && obj.News_DescImages.ToString().Length > 0)
{
_Builer.Append("<div class=\"title\"><span>" + obj.News_DescImages.ToString() + "</span></div>");
}
//this.litImage.Text = _Builer.ToString();
}
else
{
string _youReziHeigh = "";
try
{
string _youReziWith = UltilFunc.ReplapceYoutoubeWidth(obj.News_PhotoAtt.ToString(), "665");
_youReziHeigh = UltilFunc.ReplapceYoutoubeHight(_youReziWith.ToString(), "400");
}
catch
{
_youReziHeigh = "";
}
//this.litImage.Text = _youReziHeigh.ToString();
}
}
else
{
if (obj.Images_Summary != null && obj.Images_Summary.ToString().Length > 0)
{
_image = "<img style=\"width:665px;\" alt=\"" + obj.News_Tittle.ToString() + "\" title=\"" + obj.News_Tittle.ToString() + "\" src=\"" + HPCComponents.Global.TinPath + obj.Images_Summary.ToString() + "\" />";
if (obj.News_DescImages != null && obj.News_DescImages.ToString().Length > 0)
{
_image += "<div class=\"title\"><span>" + obj.News_DescImages.ToString() + "</span></div>";
}
}
//this.litImage.Text = _image.ToString();
}
this.litContents.Text = SearchImgTag(SearchSlideImg(obj.News_Body.ToString()));
//this.litCategorys.Text = "<a href=\"#\">" + dt.Rows[0]["Categorys_Name"] + "</a>";
if (obj.News_AuthorName != null && obj.News_AuthorName.ToString().Length > 0)
{
this.litAuthor.Text = "<div class=\"author\">" + obj.News_AuthorName.ToString() + "</div>";
}
//this.LitNhuanbut.Text = obj.News_TienNB.ToString();
if (obj.News_TienNB > 0.0)
{
this.LitNhuanbut.Text = string.Format("{0:#,#}", obj.News_TienNB).Replace(".", ",");
}
else
{
this.LitNhuanbut.Text = "";
}
//string count = string.Empty;
//count = this.litContents.Text;
//if (count != "")
// this.LitCount.Text = UltilFunc.WordCount(count) + " từ ";
//else
// this.LitCount.Text = "";
this.Literal_nguoinhap.Text = HPCBusinessLogic.UltilFunc.GetUserFullName(obj.News_AuthorID);
this.Literal_nguoiluu.Text = HPCBusinessLogic.UltilFunc.GetUserFullName(obj.News_EditorID);
this.Literal_ngayluu.Text = Convert.ToDateTime(obj.News_DateEdit).ToString("dd/MM/yyyy HH:mm");
ViewState["ver"] = -1;
}
catch {; }
}
}
else
{
T_News obj = new T_News();
T_NewsDAL dal = new T_NewsDAL();
ChuyenmucDAL caDal = new ChuyenmucDAL();
obj = dal.load_T_news(NewsID);
DataSet ds = dal.GetDetailHistory(NewsID);
System.Text.StringBuilder _Builer = new System.Text.StringBuilder();
string _image = "";
int gridview_index = 0;
if (ds != null)
{
try
{
DataTable dt = ds.Tables[0];
if (dt.Rows[0]["News_DateEdit"] != null && dt.Rows[0]["News_DateEdit"].ToString().Length > 0)
{
this.litDateTime.Text = Convert.ToDateTime(dt.Rows[0]["News_DateEdit"].ToString()).ToString("dd/MM/yyyy HH:mm");
}
if (dt.Rows[0]["News_DatePublished"] != null && dt.Rows[0]["News_DatePublished"].ToString().Length > 0)
{
this.litDateTime.Text = Convert.ToDateTime(dt.Rows[0]["News_DatePublished"].ToString()).ToString("dd/MM/yyyy HH:mm");
}
this.litTittle.Text = dt.Rows[0]["News_Tittle"].ToString();
this.litSapo.Text = dt.Rows[0]["News_Summary"].ToString();
this.litCategorys.Text = "<a href=\"#\">" + HPCBusinessLogic.UltilFunc.GetCategoryName(dt.Rows[0]["CAT_ID"]) + "</a>";
if (dt.Rows[0]["News_PhotoAtt"] != null && dt.Rows[0]["News_PhotoAtt"].ToString().Length > 0)
{
if (UltilFunc.CheckFrames(dt.Rows[0]["News_PhotoAtt"].ToString()) == false)
{
_Builer.Append("<div id=\"liveTV\"></div>");
_Builer.Append(" <script type=\"text/javascript\">jwplayer('liveTV').setup({ ");
_Builer.Append(" image: '" + HPCComponents.Global.TinPath + dt.Rows[0]["Images_Summary"].ToString() + "',");
_Builer.Append(" file: '" + HPCComponents.Global.TinPath + dt.Rows[0]["News_PhotoAtt"].ToString() + "', ");
_Builer.Append(" width: 665,height: 400,autostart: false,");
_Builer.Append(" backcolor: '#000000',frontcolor: '#ffffff',lightcolor: '#ffffff',screencolor: '#ffffff',");
_Builer.Append(" allowscriptaccess: true,allowfullscreen: true,controlbar: 'over',stretching:'fill'});</script>");
//this.litImage.Text = _Builer.ToString();
}
else
{
string _youReziHeigh = "";
try
{
string _youReziWith = UltilFunc.ReplapceYoutoubeWidth(dt.Rows[0]["News_PhotoAtt"].ToString(), "665");
_youReziHeigh = UltilFunc.ReplapceYoutoubeHight(_youReziWith.ToString(), "400");
}
catch
{
_youReziHeigh = "";
}
//this.litImage.Text = _youReziHeigh.ToString();
}
}
else
{
if (dt.Rows[0]["Images_Summary"] != null && dt.Rows[0]["Images_Summary"].ToString().Length > 0)
{
_image = "<img style=\"width:665px;\" alt=\"" + dt.Rows[0]["News_Tittle"].ToString() + "\" title=\"" + dt.Rows[0]["News_Tittle"].ToString() + "\" src=\"" + HPCComponents.Global.TinPath + dt.Rows[0]["Images_Summary"].ToString() + "\" />";
}
//this.litImage.Text = _image.ToString();
}
if (!string.IsNullOrEmpty(lbl_index.Text))
{
gridview_index = int.Parse(lbl_index.Text);
DataSet ds1 = dal.GetDetailHistory(int.Parse(this.dgr_tintuc1.DataKeys[gridview_index].ToString()));
if (clickgrid)
{
this.litContents.Text = MergeEngineCompare(ds1.Tables[0].Rows[0]["News_Body"].ToString(),
dt.Rows[0]["News_Body"].ToString());
}
else
{
this.litContents.Text = MergeEngineCompare(ds1.Tables[0].Rows[0]["News_Body"].ToString(), dt.Rows[0]["News_Body"].ToString());
}
}
else
{
this.litContents.Text = SearchImgTag(SearchSlideImg(dt.Rows[0]["News_Body"].ToString()));
}
if (dt.Rows[0]["News_AuthorName"] != null && dt.Rows[0]["News_AuthorName"].ToString().Length > 0)
{
this.litAuthor.Text = "<div class=\"author\">" + dt.Rows[0]["News_AuthorName"].ToString() + "</div>";
}
if (double.Parse(dt.Rows[0]["News_TienNB"].ToString()) > 0.0)
{
this.LitNhuanbut.Text = string.Format("{0:#,#}", dt.Rows[0]["News_TienNB"]).Replace(".", ",");
}
else
{
this.LitNhuanbut.Text = "";
}
//string count = string.Empty;
//count = this.litContents.Text;
//if (count != "")
// this.LitCount.Text = UltilFunc.WordCount(count) + " từ ";
//else
// this.LitCount.Text = "";
this.Literal_nguoinhap.Text = HPCBusinessLogic.UltilFunc.GetUserFullName(dt.Rows[0]["News_AuthorID"]);
this.Literal_nguoiluu.Text = HPCBusinessLogic.UltilFunc.GetUserFullName(dt.Rows[0]["News_EditorID"]);
this.Literal_ngayluu.Text = Convert.ToDateTime(dt.Rows[0]["News_DateEdit"]).ToString("dd/MM/yyyy HH:mm");
ViewState["ver"] = -1;
}
catch {; }
}
}
}
private void PopulateItem(int _id)
{
HPCInfo.T_Album_Categories _cateObj = new HPCInfo.T_Album_Categories();
HPCBusinessLogic.DAL.T_Album_CategoriesDAL _cateDAL = new HPCBusinessLogic.DAL.T_Album_CategoriesDAL();
_cateObj = _cateDAL.load_T_Album_Categories(_id);
if (_cateObj != null)
{
Txt_tieudeAbum.Text = _cateObj.Cat_Album_Name.ToString();
txt_noidungAlbum.Text = _cateObj.Cat_AlbumDesc.ToString();
txtOrder.Text = _cateObj.Possition.ToString();
lbl_status.Text = _cateObj.Cat_Album_Status_Approve.ToString();
this.cbo_lanquage.SelectedValue = _cateObj.Lang_ID.ToString();
this.cbo_chuyenmuc.Items.Clear();
if (cbo_lanquage.SelectedIndex > 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.cbo_lanquage.SelectedValue + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
cbo_chuyenmuc.UpdateAfterCallBack = true;
cbo_chuyenmuc.SelectedIndex = CommonLib.GetIndexControl(cbo_chuyenmuc, _cateObj.Cat_Album_CATID.ToString());
}
else
{
this.cbo_chuyenmuc.DataSource = null;
this.cbo_chuyenmuc.DataBind();
this.cbo_chuyenmuc.UpdateAfterCallBack = true;
}
//ddlnews_chatluong.SelectedIndex = _cateObj.Chatluong;
txt_Author_name.Text = _cateObj.Tacgia;
if (_cateObj.TongtienTT > 0)
{
if (_cateObj.TongtienTT > 0)
{
this.txt_tiennhanbut.Text = string.Format("{0:#,#}", _cateObj.TongtienTT).Replace(".", ",");
}
}
this.txtGhichu.Text = _cateObj.Comment;
HPCBusinessLogic.DAL.T_ButdanhDAL obj = new HPCBusinessLogic.DAL.T_ButdanhDAL();
this.txt_Author_name.Text = obj.GetBD_Name(_cateObj.AuthorID);
}
}
public void Danhsach_ChuyenMuc()
{
string where = " Ma_Chuyenmuc_Cha=0";
if (cbo_Anpham.SelectedIndex > 0)
{
where += " and Ma_AnPham=" + cbo_Anpham.SelectedValue.ToString();
}
if (!String.IsNullOrEmpty(this.txtSearch_ChuyenMuc.Text.Trim()))
{
where += " and " + string.Format(" Ten_ChuyenMuc like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_ChuyenMuc.Text.Trim()))
+ " or Ma_ChuyenMuc in( select Ma_Chuyenmuc_Cha from T_ChuyenMuc where Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_ChuyenMuc where " + string.Format(" Ten_ChuyenMuc like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_ChuyenMuc.Text.Trim())) + "))";
}
if (chk_Hoatdong.Checked)
{
where += " and Hoatdong=1";
}
if (!chk_Hoatdong.Checked)
{
where += " and Hoatdong=0";
}
if (CheckBoxBaoDT.Checked)
{
where += " and HienThi_BDT=1";
}
if (CheckBoxBaoIn.Checked)
{
where += " and HienThi_BaoIn=1";
}
pages.PageSize = Global.MembersPerPage;
ChuyenmucDAL _chuyenmucDAL = new ChuyenmucDAL();
DataSet _ds;
if (Session["where_chuyenmuc"] != null)
{
_ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex, pages.PageSize, Session["where_chuyenmuc"].ToString());
}
else
{
_ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex, pages.PageSize, where);
}
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
if (Session["where_chuyenmuc"] != null)
{
_ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex - 1, pages.PageSize, Session["where_chuyenmuc"].ToString());
}
else
{
_ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex - 1, pages.PageSize, where);
}
}
DataTable dt = _chuyenmucDAL.BindGridCategory(_ds.Tables[0]);
grdListCate.DataSource = dt;
grdListCate.DataBind();
_ds.Clear();
pages.TotalRecords = curentPages.TotalRecords = TotalRecords;
curentPages.TotalPages = pages.CalculateTotalPages();
curentPages.PageIndex = pages.PageIndex;
Session["PageIndex"] = pages.PageIndex;
}
public override void DataBind()
{
if (Request["ID"] != null && Request["ID"].ToString() != "" && Request["ID"].ToString() != String.Empty)
{
if (CommonLib.IsNumeric(Request["ID"]) == true)
{
HPCBusinessLogic.DAL.T_Album_CategoriesDAL dal = new HPCBusinessLogic.DAL.T_Album_CategoriesDAL();
int _id = Convert.ToInt32(Request["ID"].ToString());
if (CheckPermission(_id))
{
PopulateItem(_id);
if (dal.load_T_Album_Categories(_id).Lang_ID != 1)
{
cbo_lanquage.Enabled = false;
}
else
{
cbo_lanquage.Enabled = true;
}
}
}
}
else
{
if (cbo_lanquage.SelectedIndex > 0)
{
cbo_chuyenmuc.Items.Clear();
if (cbo_lanquage.SelectedIndex >= 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.cbo_lanquage.SelectedValue + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
cbo_chuyenmuc.UpdateAfterCallBack = true;
}
else
{
this.cbo_chuyenmuc.DataSource = null;
this.cbo_chuyenmuc.DataBind();
this.cbo_chuyenmuc.UpdateAfterCallBack = true;
}
}
}
}
public void LoadCombox()
{
UltilFunc.BindCombox(cbo_Anpham, "Ma_Anpham", "Ten_Anpham", "T_Anpham", " 1=1 ", (string)HttpContext.GetGlobalResourceObject("cms.language", "lblChonanpham"));
}
public DataTable BindGridT_Cagegorys(int LangID, int AdsLogoID)
{
DataSet _ds = null;
DataTable _dtChild = null;
DataTable _dtChild2 = null;
UltilFunc _untilDAL = new UltilFunc();
DataTable dt = new DataTable();
DataRow drtop;
DataRow dr;
DataRow dr2;
DataRow dr3;
dt.Columns.Add(new DataColumn("Ma_ChuyenMuc", typeof(string)));
dt.Columns.Add(new DataColumn("Ten_ChuyenMuc", typeof(string)));
dt.Columns.Add(new DataColumn("Role", typeof(bool)));
DataTable _dt = null;
try
{
_ds = HPCDataProvider.Instance().GetStoreDataSet("[CMS_getAllCategorysByLangID]", new string[] { "@LangID", "@AdsLogoID" }, new object[] { LangID, AdsLogoID });
if (_ds != null)
{
_dt = _ds.Tables[0];
drtop = dt.NewRow();
drtop[0] = "0";
drtop[1] = "<b>" + "Trang chủ";
drtop[2] = Check_RoleByAdvID(AdsLogoID, 0);
dt.Rows.Add(drtop);
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
dr = dt.NewRow();
dr[0] = _dt.Rows[i]["Ma_ChuyenMuc"].ToString();
dr[1] = "<b>" + _dt.Rows[i]["Ten_ChuyenMuc"].ToString();
if (_dt.Rows[i]["Role"].ToString() == "1")
{
dr[2] = true;
}
else
{
dr[2] = false;
}
dt.Rows.Add(dr);
DataSet ds2 = new DataSet();
ds2 = HPCDataProvider.Instance().GetStoreDataSet("[Get_ChildCAT_RoleAds]",
new string[] { "@ParentID", "@AdsLogoID" }, new object[] { _dt.Rows[i]["Ma_ChuyenMuc"], AdsLogoID });
if (ds2 != null && ds2.Tables.Count > 0)
{
_dtChild = ds2.Tables[0];
if (_dtChild.Rows.Count > 0)
{
for (int m = 0; m < _dtChild.Rows.Count; m++)
{
dr2 = dt.NewRow();
dr2[0] = _dtChild.Rows[m]["Ma_ChuyenMuc"].ToString();
dr2[1] = " " + _dtChild.Rows[m]["Ten_ChuyenMuc"].ToString();
dr2[2] = Check_RoleByAdvID(AdsLogoID, Convert.ToInt32(_dtChild.Rows[m]["Ma_ChuyenMuc"].ToString()));
dt.Rows.Add(dr2);
DataSet ds3 = new DataSet();
ds3 = HPCDataProvider.Instance().GetStoreDataSet("[Get_ChildCAT_RoleAds]",
new string[] { "@ParentID", "@AdsLogoID" }, new object[] { _dtChild.Rows[m]["Ma_ChuyenMuc"], AdsLogoID });
if (ds3 != null && ds3.Tables.Count > 0)
{
_dtChild2 = ds3.Tables[0];
if (_dtChild2.Rows.Count > 0)
{
for (int k = 0; k < _dtChild2.Rows.Count; k++)
{
dr3 = dt.NewRow();
dr3[0] = _dtChild2.Rows[k]["Ma_ChuyenMuc"].ToString();
dr3[1] = " " + _dtChild2.Rows[k]["Ten_ChuyenMuc"].ToString();
dr3[2] = Check_RoleByAdvID(AdsLogoID, Convert.ToInt32(_dtChild2.Rows[k]["Ma_ChuyenMuc"].ToString()));
dt.Rows.Add(dr3);
}
}
}
}
}
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
_ds = null;
_dt = null;
_dtChild = null;
_dtChild2 = null;
}
return(dt);
}
public void DataGridTacGiaTinBai_EditCommand(object source, DataGridCommandEventArgs e)
{
double news_id = double.Parse(Page.Request.QueryString["ID"].ToString());
double id_select = int.Parse(this.DataGridTacGiaTinBai.DataKeys[e.Item.ItemIndex].ToString());
double id_current = int.Parse(ViewState["ver"].ToString());
if (e.CommandArgument.ToString().ToLower() == "edit")
{
T_TinBai objtinbai = new T_TinBai();
objtinbai = Daltinbai.load_T_news(news_id);
if (dalcm.GetOneFromT_ChuyenmucByID(objtinbai.Ma_Chuyenmuc) != null)
{
Chuyenmuc = dalcm.GetOneFromT_ChuyenmucByID(objtinbai.Ma_Chuyenmuc).Ten_ChuyenMuc;
}
else
{
Chuyenmuc = "";
}
T_PhienBan objver_current = new T_PhienBan();
T_PhienBan objver_select = new T_PhienBan();
objver_current = Daltinbai.Sp_SelectOneFromT_PhienBan(id_current);
objver_select = Daltinbai.Sp_SelectOneFromT_PhienBan(id_select);
if (objver_select.Sotu != 0)
{
Sotu = objver_select.Sotu.ToString();
}
else
{
Sotu = "0";
}
if (objver_select.Tiennhuanbut > 0)
{
Nhuanbut = String.Format("{0:00,0}", Convert.ToDecimal(objver_select.Tiennhuanbut.ToString()));
}
else
{
Nhuanbut = String.Format("{0:00,0}", "0");
}
//string sqltien = "select Sotien,Ma_tacgia from T_NhuanBut where Ma_tacgia<>" + objver_select.Ma_TacGia + " and Ma_TinBai=" + news_id + " and Nguoicham=" + objver_select.Ma_Nguoitao;
//DataTable dtnhuanbut = _ulti.ExecSqlDataSet(sqltien).Tables[0];
//if (dtnhuanbut != null && dtnhuanbut.Rows.Count > 0)
//{
// for (int i = 0; i < dtnhuanbut.Rows.Count; i++)
// {
// if (i == 0)
// Nhuanbut += "; " + String.Format("{0:00,0}", Convert.ToDecimal(dtnhuanbut.Rows[i]["Sotien"].ToString())) + "; ";
// else
// Nhuanbut += String.Format("{0:00,0}", Convert.ToDecimal(dtnhuanbut.Rows[i]["Sotien"].ToString())) + "; ";
// }
//}
DataTable dttrangbaosobao = UltilFunc.GetTrangSoBaoFrom_T_VitriTiBai(int.Parse(news_id.ToString()));
if (dttrangbaosobao != null && dttrangbaosobao.Rows.Count > 0)
{
Sotrang = " Trang: " + dttrangbaosobao.Rows[0]["Trang"].ToString();
}
else
{
Sotrang = "";
}
if (checkversion.Checked == true)
{
if (id_select > id_current)
{
Tieude = MergeEngineCompare(objver_current.Tieude, objver_select.Tieude.ToString());
Noidung = MergeEngineCompare(objver_current.Noidung.ToString(), objver_select.Noidung.ToString());
}
else
{
Tieude = MergeEngineCompare(objver_select.Tieude, objver_current.Tieude.ToString());
Noidung = MergeEngineCompare(objver_select.Noidung.ToString(), objver_current.Noidung.ToString());
}
}
else
{
Noidung = UltilFunc.CleanWordHtml(objver_select.Noidung.ToString());
}
Ghichu = objver_select.GhiChu;
Tacgia = objver_select.TacGia;
if (_NguoidungDAL.GetUserByUserName_ID((int)objver_select.Ma_Nguoitao) != null)
{
nguoisua = _NguoidungDAL.GetUserByUserName_ID((int)objver_select.Ma_Nguoitao).UserFullName;
}
else
{
nguoisua = "User does not exist";
}
if (objver_current != null)
{
nguoisuaprev = _NguoidungDAL.GetUserByUserName_ID((int)objver_current.Ma_Nguoitao).UserFullName;
if (id_select > id_current)
{
checkversion.Text = nguoisuaprev + " <img src=\"../Dungchung/Images/rt1.gif\" /> " + nguoisua;
}
else
{
checkversion.Text = nguoisua + "<img src=\"../Dungchung/Images/lt1.gif\" /> " + nguoisuaprev;
}
}
ViewState["ver"] = objver_select.Ma_Phienban;
LoadDataImagePhienban(ViewState["ver"].ToString());
}
}
protected void GetTotal()
{
string sOrder = "";
if (TabContainer1.ActiveTabIndex == 0)
{
sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
}
else
{
sOrder = " ORDER BY News_DateSend DESC ";
}
string tieude = txt_tieude.Text.Trim();
Session["searchvalueroot"] = null;
if (tieude != "")
{
Session["searchvalueroot"] = UltilFunc.SplitString(tieude);
}
string _dangdang, _dsngungdang;
_dangdang = UltilFunc.GetTotalCountT_NewsStatus(BuildSQL(ConstNews.NewsPublishing, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"), "[CMS_ListCountT_News_FullTextSearch]").ToString();
_dsngungdang = UltilFunc.GetTotalCountT_NewsStatus(BuildSQL(ConstNews.NewsUnPublishing, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"), "[CMS_ListCountT_News_FullTextSearch]").ToString();
_dangdang = (string)HttpContext.GetGlobalResourceObject("cms.language", "lblTinxuatban") + " (" + _dangdang + ")";
_dsngungdang = (string)HttpContext.GetGlobalResourceObject("cms.language", "lblTinngungdang") + " (" + _dsngungdang + ")";
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "javascript", "javascript: SetInnerProcess('" + _dangdang + "','" + _dsngungdang + "');", true);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = int.Parse(Page.Request.QueryString["ID"].ToString());
if (Page.Request.QueryString["Menu_ID"] != null)
{
if (!IsPostBack)
{
T_TinBai obj = new T_TinBai();
obj = Daltinbai.load_T_news(id);
Tieude = obj.Tieude;
if (obj.Sotu != 0)
{
Sotu = obj.Sotu.ToString();
}
else
{
Sotu = "0";
}
if (obj.Tiennhuanbut > 0)
{
Nhuanbut = String.Format("{0:00,0}", Convert.ToDecimal(obj.Tiennhuanbut.ToString()));
}
else
{
Nhuanbut = String.Format("{0:00,0}", "0");
}
//string sqltien = "select Sotien,Ma_tacgia from T_NhuanBut where Ma_tacgia<>" + obj.Ma_TacGia + " and Ma_TinBai=" + id;
//DataTable dtnhuanbut = _ulti.ExecSqlDataSet(sqltien).Tables[0];
//if (dtnhuanbut != null && dtnhuanbut.Rows.Count > 0)
//{
// for (int i = 0; i < dtnhuanbut.Rows.Count; i++)
// {
// if (i == 0)
// Nhuanbut += "; " + String.Format("{0:00,0}", Convert.ToDecimal(dtnhuanbut.Rows[i]["Sotien"].ToString())) + "; ";
// else
// Nhuanbut += String.Format("{0:00,0}", Convert.ToDecimal(dtnhuanbut.Rows[i]["Sotien"].ToString())) + "; ";
// }
//}
if (dalcm.GetOneFromT_ChuyenmucByID(obj.Ma_Chuyenmuc) != null)
{
Chuyenmuc = dalcm.GetOneFromT_ChuyenmucByID(obj.Ma_Chuyenmuc).Ten_ChuyenMuc;
}
else
{
Chuyenmuc = "";
}
Tieude = obj.Tieude.ToString();
Noidung = obj.Noidung.ToString();
Ghichu = obj.GhiChu;
Tacgia = obj.TacGia;
DataTable dttrangbaosobao = UltilFunc.GetTrangSoBaoFrom_T_VitriTiBai(id);
if (dttrangbaosobao != null && dttrangbaosobao.Rows.Count > 0)
{
Sotrang = " Trang: " + dttrangbaosobao.Rows[0]["Trang"].ToString();
}
else
{
Sotrang = "";
}
if (_NguoidungDAL.GetUserByUserName_ID((int)obj.Ma_Nguoitao) != null)
{
nguoisua = _NguoidungDAL.GetUserByUserName_ID((int)obj.Ma_Nguoitao).UserFullName;
}
else
{
nguoisua = "User does not exist";
}
DataTable dtphienban = Daltinbai.GetOneFromT_PhienbanByNews_ID(id, -1, false).Tables[0];
if (dtphienban != null && dtphienban.Rows.Count > 0)
{
ViewState["ver"] = dtphienban.Rows[0]["Ma_Phienban"].ToString();
}
else
{
ViewState["ver"] = -1;
}
LoadDataImageTinBai(id.ToString());
BindGrid();
}
}
}
protected void cbo_lanquage_SelectedIndexChanged(object sender, EventArgs e)
{
cbo_chuyenmuc.Items.Clear();
if (cboNgonNgu.SelectedIndex > 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), (string)HttpContext.GetGlobalResourceObject("cms.language", "lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
cbo_chuyenmuc.UpdateAfterCallBack = true;
}
else
{
cbo_chuyenmuc.DataSource = null;
cbo_chuyenmuc.DataBind();
cbo_chuyenmuc.UpdateAfterCallBack = true;
}
}
public DataTable BindGridMenuByGroup(int GroupID, string langid)
{
UltilFunc _untilDAL = new UltilFunc();
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new DataColumn("Ma_Chucnang", typeof(int)));
dt.Columns.Add(new DataColumn("Ten_chucnang", typeof(string)));
dt.Columns.Add(new DataColumn("STT", typeof(string)));
dt.Columns.Add(new DataColumn("URL_Chucnang", typeof(string)));
dt.Columns.Add(new DataColumn("Mota", typeof(string)));
dt.Columns.Add(new DataColumn("Role_Menu", typeof(bool)));
dt.Columns.Add(new DataColumn("Doc", typeof(bool)));
dt.Columns.Add(new DataColumn("Ghi", typeof(bool)));
dt.Columns.Add(new DataColumn("Xoa", typeof(bool)));
DataTable _dt = _untilDAL.GetStoreDataSet("sp_BindGridMenuByGroup", new string[] { "@Parrent_ID", "@Group_ID", "@lang_ID" }, new object[] { 0, GroupID, langid }).Tables[0];
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
dr = dt.NewRow();
dr[0] = _dt.Rows[i]["Ma_Chucnang"].ToString();
dr[1] = _dt.Rows[i]["Ten_chucnang"].ToString();
dr[2] = _dt.Rows[i]["STT"].ToString();
dr[3] = _dt.Rows[i]["URL_Chucnang"].ToString();
dr[4] = _dt.Rows[i]["Mota"].ToString();
dr[5] = Convert.ToBoolean(_dt.Rows[i]["role"]);
if (_dt.Rows[i]["Doc"] != DBNull.Value)
{
dr[6] = Convert.ToBoolean(_dt.Rows[i]["Doc"]);
}
else
{
dr[6] = false;
}
if (_dt.Rows[i]["Ghi"] != DBNull.Value)
{
dr[7] = Convert.ToBoolean(_dt.Rows[i]["Ghi"]);
}
else
{
dr[7] = false;
}
if (_dt.Rows[i]["Xoa"] != DBNull.Value)
{
dr[8] = Convert.ToBoolean(_dt.Rows[i]["Xoa"]);
}
else
{
dr[8] = false;
}
dt.Rows.Add(dr);
//Kiem tra xem chuc nang co chuyen muc con hay khong
if (HPCBusinessLogic.UltilFunc.GetLatestID("T_Chucnang", "Ma_Chucnang", "WHERE Ma_Chucnang_Cha=" + _dt.Rows[i].ItemArray[0].ToString()) > 0)
{
DataTable _dtChild = _untilDAL.GetStoreDataSet("sp_BindGridMenuByGroup", new string[] { "@Parrent_ID", "@Group_ID", "@lang_ID" }, new object[] { _dt.Rows[i].ItemArray[0], GroupID, langid }).Tables[0];
if (_dtChild.Rows.Count > 0)
{
for (int j = 0; j < _dtChild.Rows.Count; j++)
{
dr = dt.NewRow();
dr[0] = _dtChild.Rows[j]["Ma_Chucnang"].ToString();
dr[1] = " " + _dtChild.Rows[j]["Ten_chucnang"].ToString();
dr[2] = _dtChild.Rows[j]["STT"].ToString();
dr[3] = _dtChild.Rows[j]["URL_Chucnang"].ToString();
dr[4] = _dtChild.Rows[j]["Mota"].ToString();
dr[5] = Convert.ToBoolean(_dtChild.Rows[j]["role"]);
if (_dtChild.Rows[j]["Doc"] != DBNull.Value)
{
dr[6] = Convert.ToBoolean(_dtChild.Rows[j]["Doc"]);
}
else
{
dr[6] = false;
}
if (_dtChild.Rows[j]["Ghi"] != DBNull.Value)
{
dr[7] = Convert.ToBoolean(_dtChild.Rows[j]["Ghi"]);
}
else
{
dr[7] = false;
}
if (_dtChild.Rows[j]["Xoa"] != DBNull.Value)
{
dr[8] = Convert.ToBoolean(_dtChild.Rows[j]["Xoa"]);
}
else
{
dr[8] = false;
}
dt.Rows.Add(dr);
//// Kiem tra xem chuc nang hien tai co chuyen muc cap 3 hay khong
if (HPCBusinessLogic.UltilFunc.GetLatestID("T_chucnang", "Ma_chucnang", "WHERE Ma_chucnangcha=" + _dtChild.Rows[j].ItemArray[0].ToString()) > 0)
{
DataTable _dtChild1 = _untilDAL.GetStoreDataSet("sp_BindGridMenuByGroup", new string[] { "@Parrent_ID", "@Group_ID", "@lang_ID" }, new object[] { _dtChild.Rows[j].ItemArray[0], GroupID, langid }).Tables[0];
for (int j1 = 0; j1 < _dtChild1.Rows.Count; j1++)
{
dr = dt.NewRow();
dr[0] = _dtChild1.Rows[j1]["Ma_chucnang"].ToString();
dr[1] = " " + _dtChild1.Rows[j1]["Ten_chucnang"].ToString();
dr[2] = _dtChild1.Rows[j1]["STT"].ToString();
dr[3] = _dtChild1.Rows[j1]["URL_Chucnang"].ToString();
dr[4] = _dtChild1.Rows[j1]["Mota"].ToString();
dr[5] = Convert.ToBoolean(_dtChild1.Rows[j1]["role"]);
if (_dtChild1.Rows[j1]["Doc"] != DBNull.Value)
{
dr[6] = Convert.ToBoolean(_dtChild1.Rows[j1]["Doc"]);
}
else
{
dr[6] = false;
}
if (_dtChild1.Rows[j1]["Ghi"] != DBNull.Value)
{
dr[7] = Convert.ToBoolean(_dtChild1.Rows[j1]["Ghi"]);
}
else
{
dr[7] = false;
}
if (_dtChild1.Rows[j1]["Xoa"] != DBNull.Value)
{
dr[8] = Convert.ToBoolean(_dtChild1.Rows[j1]["Xoa"]);
}
else
{
dr[8] = false;
}
dt.Rows.Add(dr);
}
}
}
}
}
}
}
return(dt);
}
public void LoadCombox()
{
UltilFunc.BindCombox(cboNgonNgu, "Ma_AnPham", "Ten_AnPham", "T_AnPham", " 1=1 ", CommonLib.ReadXML("lblTatca"));
if (cboNgonNgu.Items.Count >= 3)
{
cboNgonNgu.SelectedIndex = Global.DefaultLangID;
}
else
{
cboNgonNgu.SelectedIndex = UltilFunc.GetIndexControl(cboNgonNgu, Global.DefaultCombobox);
}
if (cboNgonNgu.SelectedIndex != 0)
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.cboNgonNgu.SelectedValue + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), (string)HttpContext.GetGlobalResourceObject("cms.language", "lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
}
else
{
UltilFunc.BindCombox(cbo_chuyenmuc, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.cboNgonNgu.SelectedValue + " and Ma_AnPham in (" + UltilFunc.GetLanguagesByUser(_user.UserID) + ") AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), (string)HttpContext.GetGlobalResourceObject("cms.language", "lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
}
}
public DataTable BindGridCategoryByGroup(int Group_ID, int MaAnPham)
{
UltilFunc _untilDAL = new UltilFunc();
DataTable dt = new DataTable();
DataRow dr;
dt.Columns.Add(new DataColumn("Ma_Chuyenmuc", typeof(int)));
dt.Columns.Add(new DataColumn("Ten_Chuyenmuc", typeof(string)));
dt.Columns.Add(new DataColumn("Role", typeof(string)));
dt.Columns.Add(new DataColumn("CategoryParrent", typeof(string)));
dt.Columns.Add(new DataColumn("OnClick_Event", typeof(string)));
DataTable _dt = _untilDAL.GetStoreDataSet("sp_BindGridCategoryByGroup", new string[] { "@Ma_AnPham", "@Category_ParrentID", "@Group_ID" }, new object[] { MaAnPham, 0, Group_ID }).Tables[0];
if (_dt.Rows.Count > 0)
{
for (int i = 0; i < _dt.Rows.Count; i++)
{
dr = dt.NewRow();
dr[0] = _dt.Rows[i]["Ma_chuyenmuc"].ToString();
dr[1] = "<b>" + _dt.Rows[i]["Ten_chuyenmuc"].ToString();
if (Convert.ToBoolean(_dt.Rows[i]["Role"]))
{
dr[2] = "checked";
}
else
{
dr[2] = "";
}
dr[3] = "Parrent" + _dt.Rows[i]["Ma_chuyenmuc"].ToString();
if (UltilFunc.GetLatestID("T_ChuyenMuc", "Ma_chuyenmuc", " WHERE Ma_Chuyenmuc_Cha=" + _dt.Rows[i]["Ma_chuyenmuc"].ToString()) > 0)
{
dr[4] = " ParrentClick(" + _dt.Rows[i]["Ma_chuyenmuc"].ToString() + ")";
}
else
{
dr[4] = " ChildeClick(" + _dt.Rows[i]["Ma_chuyenmuc"].ToString() + ")";
}
dt.Rows.Add(dr);
//Kiem tra xem chuc nang co chuyen muc con hay khong
if (HPCBusinessLogic.UltilFunc.GetLatestID("T_Chuyenmuc", "Ma_chuyenmuc", "WHERE Ma_Chuyenmuc_Cha=" + _dt.Rows[i]["Ma_chuyenmuc"].ToString()) > 0)
{
DataTable _dtChild = _untilDAL.GetStoreDataSet("sp_BindGridCategoryByGroup", new string[] { "@Ma_AnPham", "@Category_ParrentID", "@Group_ID" }, new object[] { MaAnPham, _dt.Rows[i]["Ma_chuyenmuc"].ToString(), Group_ID }).Tables[0];
if (_dtChild.Rows.Count > 0)
{
for (int j = 0; j < _dtChild.Rows.Count; j++)
{
dr = dt.NewRow();
dr[0] = _dtChild.Rows[j]["Ma_chuyenmuc"].ToString();
dr[1] = " " + _dtChild.Rows[j]["Ten_chuyenmuc"].ToString();
if (Convert.ToBoolean(_dtChild.Rows[j]["Role"]))
{
dr[2] = "checked";
}
else
{
dr[2] = "";
}
dr[3] = "Parrent" + _dtChild.Rows[j]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild.Rows[j]["Ma_chuyenmuc"].ToString();
if (UltilFunc.GetLatestID("T_ChuyenMuc", "Ma_chuyenmuc", " WHERE Ma_Chuyenmuc_Cha=" + _dtChild.Rows[j]["Ma_chuyenmuc"].ToString()) > 0)
{
dr[4] = " ParrentClick(" + _dtChild.Rows[j]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild.Rows[j]["Ma_chuyenmuc"].ToString() + ")";
}
else
{
dr[4] = " ChildeClick(" + _dtChild.Rows[j]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild.Rows[j]["Ma_chuyenmuc"].ToString() + ")";
}
dt.Rows.Add(dr);
//// Kiem tra xem chuc nang hien tai co chuyen muc cap 3 hay khong
if (HPCBusinessLogic.UltilFunc.GetLatestID("T_Chuyenmuc", "Ma_chuyenmuc", "WHERE Ma_Chuyenmuc_Cha=" + _dtChild.Rows[j]["Ma_chuyenmuc"].ToString()) > 0)
{
DataTable _dtChild1 = _untilDAL.GetStoreDataSet("sp_BindGridCategoryByGroup", new string[] { "@Ma_AnPham", "@Category_ParrentID", "@Group_ID" }, new object[] { MaAnPham, _dtChild.Rows[j]["Ma_chuyenmuc"].ToString(), Group_ID }).Tables[0];
for (int j1 = 0; j1 < _dtChild1.Rows.Count; j1++)
{
dr = dt.NewRow();
dr[0] = _dtChild1.Rows[j1]["Ma_chuyenmuc"].ToString();
dr[1] = " " + _dtChild1.Rows[j1]["Ten_chuyenmuc"].ToString();
if (Convert.ToBoolean(_dtChild1.Rows[j1]["Role"]))
{
dr[2] = "checked";
}
else
{
dr[2] = "";
}
dr[3] = "Parrent" + _dtChild.Rows[j]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild1.Rows[j1]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild1.Rows[j1]["Ma_chuyenmuc"].ToString();
dr[4] = " ChildeClick(" + _dtChild.Rows[j]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild1.Rows[j1]["Ma_Chuyenmuc_Cha"].ToString() + _dtChild1.Rows[j1]["Ma_chuyenmuc"].ToString() + ")";
dt.Rows.Add(dr);
}
}
}
}
}
}
}
return(dt);
}
public void BindCombo()
{
ddl_Anpham.Items.Clear();
UltilFunc.BindCombox(ddl_Anpham, "Ma_AnPham", "Ten_AnPham", "T_AnPham", " 1=1 ");
}
private HPCInfo.T_Album_Categories GetObject()
{
HPCInfo.T_Album_Categories _objCate = new HPCInfo.T_Album_Categories();
if (Page.Request.Params["id"] != null)
{
_objCate.Cat_Album_ID = int.Parse(Page.Request["id"].ToString());
}
else
{
_objCate.Cat_Album_ID = 0;
}
_objCate.Cat_Album_Name = Txt_tieudeAbum.Text;
_objCate.Lang_ID = Convert.ToInt32(cbo_lanquage.SelectedValue);
_objCate.Status = true;// this.chkDisplay.Checked;
if (txtOrder.Text.Length > 0)
{
if (UltilFunc.IsNumeric(this.txtOrder.Text.Trim()))
{
_objCate.Possition = Convert.ToInt32(this.txtOrder.Text.Trim());
}
}
_objCate.Links = "";
_objCate.Cat_AlbumDesc = this.txt_noidungAlbum.Text.Trim();
_objCate.Target = true;
_objCate.Copy_From = 0;
_objCate.Cat_Album_DateCreate = DateTime.Now;
_objCate.DateModify = DateTime.Now;
_objCate.UserCreated = _user.UserID;
_objCate.UserModify = _user.UserID;
_objCate.Cat_Album_DateSend = DateTime.Now;
_objCate.Cat_Album_DateApprove = DateTime.Now;
_objCate.Cat_Album_UserIDApprove = _user.UserID;
int statusid = 1;
try { statusid = int.Parse(lbl_status.Text); }
catch {; }
_objCate.Cat_Album_Status_Approve = statusid;
if (this.cbo_chuyenmuc.SelectedIndex > 0)
{
_objCate.Cat_Album_CATID = int.Parse(cbo_chuyenmuc.SelectedValue);
}
else
{
_objCate.Cat_Album_CATID = 0;
}
_objCate.Tacgia = txt_Author_name.Text;
//_objCate.Chatluong = ddlnews_chatluong.SelectedIndex;
HPCBusinessLogic.DAL.T_ButdanhDAL obj = new HPCBusinessLogic.DAL.T_ButdanhDAL();
T_Butdanh obj_BD = new T_Butdanh();
int butdanhID = 0;
if (!string.IsNullOrEmpty(txt_Author_name.Text.Trim()))
{
obj_BD.BD_ID = 0;
obj_BD.BD_Name = txt_Author_name.Text.Trim();
obj_BD.UserID = _user.UserID;
butdanhID = obj.Insert_Butdang(obj_BD);
}
_objCate.AuthorID = butdanhID;
if (!string.IsNullOrEmpty(txt_tiennhanbut.Text))
{
_objCate.TongtienTT = int.Parse(txt_tiennhanbut.Text.Replace(",", ""));
}
else
{
_objCate.TongtienTT = 0;
}
//_objCate.Theloai = int.Parse(ddlNews_IsType.SelectedValue);
//if (ddlnews_chatluong.SelectedIndex > 0)
// _objCate.Loaihinh = int.Parse(Drop_loaihinh.SelectedValue);
//else
// _objCate.Loaihinh = 0;
//_objCate.NguoichamNBID = _user.UserID;
//_objCate.NgaychamNB = DateTime.Now;
//_objCate.HesoTT = 0.0;
_objCate.Comment = txtGhichu.Text;
return(_objCate);
}
protected void ddlLang_SelectedIndexChanged(object sender, EventArgs e)
{
ddlCategorysAll.Items.Clear();
if (ddlLang.SelectedIndex > 0)
{
UltilFunc.BindCombox(ddlCategorysAll, "Ma_ChuyenMuc", "Ten_ChuyenMuc", "T_ChuyenMuc", string.Format(" HoatDong = 1 and HienThi_BDT = 1 and Ma_AnPham= " + this.ddlLang.SelectedValue + " AND Ma_ChuyenMuc IN ({0})", UltilFunc.GetCategory4User(_user.UserID)), CommonLib.ReadXML("lblTatca"), "Ma_Chuyenmuc_Cha", " Order by ThuTuHienThi ASC");
ddlCategorysAll.UpdateAfterCallBack = true;
}
else
{
ddlCategorysAll.DataSource = null;
ddlCategorysAll.DataBind();
ddlCategorysAll.UpdateAfterCallBack = true;
}
}
string BuildSQL(string sOrder)
{
string sWhere = " Trangthai_xoa=0 and Doituong_DangXuly=N'" + Global.MaXuatBan + "' ";
if (txt_tieude.Text.Length > 0 && txt_tieude.Text.Trim() != "")
{
if (sWhere.Trim() != "")
{
sWhere += " AND ";
}
sWhere += " Tieude LIKE " + string.Format("N'%{0}%'", UltilFunc.SqlFormatText(txt_tieude.Text.Trim()));
}
if (cboAnPham.SelectedIndex > 0)
{
if (sWhere.Trim() != "")
{
sWhere += " AND ";
}
sWhere += " Ma_AnPham=" + cboAnPham.SelectedValue;
}
if (cboSoBao.SelectedIndex > 0)
{
if (sWhere.Trim() != "")
{
sWhere += " AND ";
}
sWhere += " Ma_Sobao=" + cboSoBao.SelectedValue;
}
if (txt_tungay.Text.Trim() != "" && txt_denngay.Text.Trim() != "")
{
if (UltilFunc.ToDate(txt_tungay.Text.Trim(), "dd/MM/yyyy") > UltilFunc.ToDate(txt_denngay.Text.Trim(), "dd/MM/yyyy"))
{
FuncAlert.AlertJS(this, "Từ ngày phải nhỏ hơn đến ngày");
return(" and 1=0");
}
else
{
if (sWhere.Trim() != "")
{
sWhere += " AND ";
}
sWhere += " Ma_Sobao in (select Ma_Sobao from T_Sobao where Ngay_Xuatban>='" + txt_tungay.Text.Trim() + " 00:00:00' and Ngay_Xuatban<='" + txt_denngay.Text.Trim() + " 23:59:59')";
}
}
if (cbo_chuyenmuc.SelectedIndex > 0)
{
if (sWhere.Trim() != "")
{
sWhere += " AND ";
}
sWhere += " Ma_Chuyenmuc=" + cbo_chuyenmuc.SelectedValue.ToString();
}
if (txt_PVCTV.Text.Trim() == "")
{
HiddenFieldTacgiatin.Value = "";
}
if (HiddenFieldTacgiatin.Value != "")
{
sWhere += " AND Ma_Tinbai in (select Ma_Tinbai from T_Nhuanbut where Ma_tacgia=" + HiddenFieldTacgiatin.Value + ")";
}
return(sWhere + sOrder);
}