Exemplo n.º 1
0
        protected void linkSave_Click(object sender, EventArgs e)
        {
            string   Thaotac   = "";
            T_TinBai objtinbai = new T_TinBai();

            if (Page.IsValid)
            {
                if (checkform())
                {
                    objtinbai = SetItem("", 6);
                    if (Request["ID"] != null)
                    {
                        matinbai = Daltinbai.InsertT_Tinbai(objtinbai);
                        Thaotac  = "Thao tác sửa thông tin cá nhân - tiêu đề:" + Txt_tieude.Text;
                    }
                    else
                    {
                        matinbai = Daltinbai.InsertT_Tinbai(objtinbai);
                        Thaotac  = "Thao tác gửi thông tin cá nhân - tiêu đề:" + Txt_tieude.Text;
                    }
                    Daltinbai.Insert_Phienban_From_T_Tinbai(matinbai, _user.UserID, DateTime.Now, "email");
                    if (matinbai > 0)
                    {
                        SaveImagesAttach(matinbai);
                    }
                    if (SaveImagesAttachAll())
                    {
                        UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), Thaotac);
                        UltilFunc.AlertJS("Bạn đã gửi thành công!");
                        ClearForm();
                    }
                }
            }
        }
Exemplo n.º 2
0
        protected void linkSave_Click(object sender, EventArgs e)
        {
            string   Thaotac   = "";
            T_TinBai objtinbai = new T_TinBai();

            if (Page.IsValid)
            {
                objtinbai  = SetItem(Request["MaDoiTuong"].ToString(), 2);
                txtID.Text = _Daltinbai.SP_UpdateT_TinBai_WordOnline(objtinbai).ToString();
                _matinbai  = double.Parse(txtID.Text.Trim());
                if (Request["ID"] != null)
                {
                    Thaotac = "Thao tác sửa nội dung tin bài - tiêu đề:" + Txt_tieude.Text;
                }
                else
                {
                    Thaotac = "Thao tác thêm mới tin bài - tiêu đề:" + Txt_tieude.Text;
                }

                if (MaDetai != 0)
                {
                    _Daltinbai.InsertT_Vitri_Tinbai_FromT_Tinbai(0, 0, _matinbai, MaDetai);
                }

                UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), Thaotac);
                SaveImagesAttachAll();

                Response.Redirect("~/Quytrinh/Edit_PV.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&ID=" + _matinbai.ToString() + "&MaDoiTuong=" + Request["MaDoiTuong"].ToString() + "&Tab=0");
            }
        }
Exemplo n.º 3
0
        public static string GetStatusUpdateContents(Object ID)
        {
            HPCInfo.T_TinBai _obj = new T_TinBai();
            HPCBusinessLogic.DAL.TinBaiDAL _daltinbai = new HPCBusinessLogic.DAL.TinBaiDAL();
            string str = "";

            try
            {
                if (ID != DBNull.Value)
                {
                    _obj = _daltinbai.load_T_news(double.Parse(ID.ToString()));
                    if (_obj.UpdateContents == 0)
                    {
                        str = _obj.Tieude;
                    }
                    else
                    {
                        str = "<span style=\"font-family: arial; font-size: 14px; color: red; font-weight: bold;font-style: italic\">Tin mới</span></br>" + _obj.Tieude;
                    }
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(str);
        }
Exemplo n.º 4
0
    protected void Page_Load(object sender, EventArgs e)
    {
        _user = _NguoidungDAL.GetUserByUserName(HPCSecurity.CurrentUser.Identity.Name);
        if (Request["matinbai"] != null)
        {
            matinbai = double.Parse(Request["matinbai"].ToString());
        }

        obj                 = SetItem();
        matinbai            = Daltinbai.InsertT_Tinbai_WordOnline(obj);
        Session["matinbai"] = matinbai;
        Pathfolder          = Global.Pathfiledoc;
        if (freq.FileExtName == ".htm")
        {
            Filedoc = _user.UserID.ToString() + _user.UserName + matinbai.ToString() + "_" + Request["MaDoiTuong"].ToString() + ".htm";
        }
        else
        {
            Filedoc = _user.UserID.ToString() + _user.UserName + matinbai.ToString() + "_" + Request["MaDoiTuong"].ToString() + ".doc";
        }
        CreateFolderByUserName(Pathfolder);
        Filedoc = Server.MapPath("/" + Pathfolder + Filedoc);
        freq.SaveToFile(Filedoc);
        freq.Close();
        string filehtm     = _user.UserID.ToString() + _user.UserName + matinbai.ToString() + "_" + Request["MaDoiTuong"].ToString() + ".htm";
        string pathfilehtm = Server.MapPath("/" + Pathfolder + filehtm);

        Daltinbai.sp_updatenoidungtin(matinbai, ReadHtmlFile(pathfilehtm));
    }
Exemplo n.º 5
0
        private void GetDataNews(int IDQ)
        {
            T_TinBai _objSet = new T_TinBai();

            _objSet = Daltinbai.load_T_news(IDQ);
            Tieude  = _objSet.Tieude;
            Noidung = CleanStyle(_objSet.Noidung);
            Sapo    = CleanStyle(_objSet.Tomtat);
        }
Exemplo n.º 6
0
        private bool ResizeImages(string SourcePath, int Width, string Despath)
        {
            bool   success;
            string path = SourcePath;
            Bitmap _obj;

            System.Drawing.Image objImage;
            int imgwidth  = 0;
            int imgheight = 0;

            decimal lnRatio;

            try
            {
                objImage = System.Drawing.Image.FromFile(path);
                if (objImage.Width > objImage.Height)
                {
                    lnRatio  = (decimal)Width / objImage.Width;
                    imgwidth = Width;
                    decimal lnTemp = objImage.Height * lnRatio;
                    imgheight = (int)lnTemp;
                }
                else
                {
                    lnRatio  = (decimal)Width / objImage.Width;
                    imgwidth = Width;
                    decimal lnTemp = objImage.Height * lnRatio;
                    imgheight = (int)lnTemp;
                }
                // Create thumbnail
                _obj = new Bitmap(imgwidth, imgheight);

                Graphics grWatermark = Graphics.FromImage(_obj);
                grWatermark.InterpolationMode  = InterpolationMode.HighQualityBicubic;
                grWatermark.SmoothingMode      = SmoothingMode.HighQuality;
                grWatermark.PixelOffsetMode    = PixelOffsetMode.HighQuality;
                grWatermark.CompositingQuality = CompositingQuality.HighQuality;
                System.Drawing.Rectangle imageRectangle = new System.Drawing.Rectangle(0, 0, imgwidth, imgheight);
                grWatermark.DrawImage(objImage, imageRectangle);
                this.saveJpeg(Despath, _obj, 100L);
                grWatermark.Dispose();
                _obj.Dispose();
                objImage.Dispose();
                success = true;
            }
            catch //(Exception ex)
            {
                success = false;
                //throw ex;
            }
            return(success);
        }
Exemplo n.º 7
0
        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;
            CKE_Noidung.Text           = _obj.Noidung;
            txt_PVCTV.Text             = _obj.TacGia;
            HiddenFieldTacgiatin.Value = _obj.Ma_TacGia.ToString();
            Txt_Comments.Text          = _obj.GhiChu;
            LoadDataImage();
        }
Exemplo n.º 8
0
        private void GetDataNews(int IDQ)
        {
            T_TinBai _objSet = new T_TinBai();

            _objSet = Daltinbai.load_T_news(IDQ);
            Tieude  = _objSet.Tieude;
            Noidung = CleanStyle(_objSet.Noidung);
            Sapo    = CleanStyle(_objSet.Tomtat);
            if (Sapo.Trim() == "")
            {
                Sapo = "<div style=\"height:0;\" class=\"sapo\" id=\"convertSapo\">" + CleanStyle(_objSet.Tomtat) + "</div>";
            }
            else
            {
                Sapo = "<div  class=\"sapo\" id=\"convertSapo\">" + CleanStyle(_objSet.Tomtat) + "</div>";
            }
        }
Exemplo n.º 9
0
        protected void dgData_EditCommand(object source, DataGridCommandEventArgs e)
        {
            double _ID = double.Parse(dgr_tintuc.DataKeys[e.Item.ItemIndex].ToString());

            if (e.CommandArgument.ToString().ToLower() == "edit")
            {
                PnlDetail.Visible   = true;
                PanelLisTin.Visible = false;
                ViewState["id"]     = _ID;
                T_TinBai obj = new T_TinBai();
                obj       = Daltinbai.load_T_news(_ID);
                Chuyenmuc = dalcm.GetOneFromT_ChuyenmucByID(obj.Ma_Chuyenmuc).Ten_ChuyenMuc;
                Tieude    = obj.Tieude.ToString();
                Noidung   = obj.Noidung.ToString();
                BindGridPhotosByMatin();
            }
        }
Exemplo n.º 10
0
        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);
                    //btncopycontent1.Attributes.Add("onclick", "javascript:getvalue_exports()");
                    //btncopycontent2.Attributes.Add("onclick", "javascript:getvalue_exports()");
                    _ID = int.Parse(Page.Request.QueryString["ID"].ToString());


                    if (!IsPostBack)
                    {
                        if (_user == null)
                        {
                            Page.Response.Redirect("~/login.aspx", true);
                        }
                        else
                        {
                            T_TinBai obj = new T_TinBai();
                            obj       = Daltinbai.load_T_news(_ID);
                            Chuyenmuc = dalcm.GetOneFromT_ChuyenmucByID(obj.Ma_Chuyenmuc).Ten_ChuyenMuc;
                            Tieude    = obj.Tieude.ToString();
                            Noidung   = obj.Noidung.ToString();
                            BindGridPhotosByMatin();
                            if (DataListAnh.Items.Count != 0)
                            {
                                btn_downloadfile.Visible = true;
                            }
                            else
                            {
                                btn_downloadfile.Visible = false;
                            }
                        }
                    }
                }
            }
        }
Exemplo n.º 11
0
        private void GuiTinBai(string MaDoiTuong)
        {
            string Thaotac = "";
            string _trace  = string.Empty;

            _obj       = SetItem(MaDoiTuong, 1);
            txtID.Text = Convert.ToString(_Daltinbai.SP_UpdateT_TinBai_WordOnline(_obj));
            _matinbai  = double.Parse(txtID.Text.Trim());
            if (MaDetai != 0)
            {
                _Daltinbai.InsertT_Vitri_Tinbai_FromT_Tinbai(0, 0, _matinbai, MaDetai);
            }
            SaveImagesAttachAll();
            _trace = _Daltinbai.GetTrace(_matinbai) + Request["MaDoiTuong"] + "_" + _user.UserID + ";";
            _Daltinbai.Update_Status_tintuc(_matinbai, 1, _user.UserID, DateTime.Now, MaDoiTuong, _trace);
            _Daltinbai.Insert_Phienban_From_T_Tinbai(_matinbai, _user.UserID, DateTime.Now, Request["MaDoiTuong"].ToString());
            _Daltinbai.Insert_Tulieu_From_T_Tinbai(_matinbai);
            Thaotac = "Thao tác gửi tin bài từ " + CommonLib.GetTenDoiTuong(Request["MaDoiTuong"].ToString()) + " đến " + CommonLib.GetTenDoiTuong(MaDoiTuong.ToString()) + " - Tiêu đề:" + Txt_tieude.Text.Trim();
            UltilFunc.Log_Thaotactinbai(_user.UserID, _user.UserFullName, DateTime.Now, Thaotac, _matinbai);
            UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), Thaotac);

            if (checkbaoonline.Checked)
            {
                HPCBusinessLogic.DAL.T_NewsDAL _T_NewsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
                T_News _objT_News      = SetItemBaoDienTu(_matinbai);
                int    _returnvnonline = 0;
                // Insert sang bao dien tu
                if (_statusvnonline == int.Parse(CommonLib.ReadXML("Status_BDT")) || _statusvnonline == 0)
                {
                    _returnvnonline = _T_NewsDAL.InsertT_news(_objT_News);
                    _T_NewsDAL.Update_Status_tintuc(_returnvnonline, int.Parse(CommonLib.ReadXML("Status_BDT")), _user.UserID, DateTime.Now);
                    UltilFunc.Insert_News_Image(_objT_News.News_Body.Trim(), Convert.ToDouble(_returnvnonline.ToString()));
                }
                //end
            }

            Response.Redirect("~/Quytrinh/List_PV.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&MaDoiTuong=" + Request["MaDoiTuong"].ToString() + "&Tab=" + Request["Tab"]);
        }
Exemplo n.º 12
0
        private T_TinBai SetItem(string _Doituongxuly, int _status)
        {
            T_TinBai _obj = new T_TinBai();

            if (int.Parse(txtID.Text.Trim()) > 0)
            {
                _obj.Ma_Tinbai = int.Parse(txtID.Text.Trim());
            }
            else
            {
                _obj.Ma_Tinbai = 0;
            }
            _obj.Tieude        = UltilFunc.CleanFormatTags(Txt_tieude.Text.Trim());
            _obj.Noidung       = CKE_Noidung.Text;
            _obj.TacGia        = "";
            _obj.Ma_TacGia     = int.Parse(HiddenFieldTacgiatin.Value.ToString());
            _obj.Ma_NgonNgu    = 1;
            _obj.Ma_Chuyenmuc  = 0;
            _obj.NgayTao       = DateTime.Now;
            _obj.Ma_Nguoitao   = _user.UserID;
            _obj.Nguoi_Khoa    = _user.UserID;
            _obj.Sotu          = double.Parse(word_count.Value.ToString());
            _obj.Trangthai_Xoa = false;
            if (Txt_Comments.Text.Trim() != "Nhập góp ý")
            {
                _obj.GhiChu = UltilFunc.CleanFormatTags(Txt_Comments.Text);
            }
            else
            {
                _obj.GhiChu = "";
            }
            _obj.Trangthai         = _status;
            _obj.Doituong_DangXuly = _Doituongxuly;
            _obj.LuuVet            = Daltinbai.GetTrace(_obj.Ma_Tinbai);

            return(_obj);
        }
Exemplo n.º 13
0
 public int InsertT_Tinbai_WordOnline(T_TinBai obj)
 {
     return(HPCDataProvider.Instance().InsertObjectReturn(obj, "Sp_InsertT_TinBai_WordOnline"));
 }
Exemplo n.º 14
0
        private T_News SetItemBaoDienTu(double _id_newspaper)
        {
            T_ImageFiles _obj = new T_ImageFiles();
            ImageFilesDAL _dalimgfile = new ImageFilesDAL();
            DataTable _dt_img = new DataTable();
            T_News obj_news = new T_News();
            T_TinBai _objbaoin = new T_TinBai();
            _objbaoin = _daltinbai.load_T_news(_id_newspaper);
            double _id_newsonline = UltilFunc.GetColumnValuesOne("T_News", "News_ID", "News_CopyFrom=" + _id_newspaper);
            if (_id_newsonline == 0)
                obj_news.News_ID = 0;
            else
                obj_news.News_ID = _id_newsonline;
            obj_news.News_Tittle = _objbaoin.Tieude;
            obj_news.News_Summary = _objbaoin.Tomtat;
            obj_news.CAT_ID = _objbaoin.Ma_Chuyenmuc;
            obj_news.Lang_ID = _objbaoin.Ma_NgonNgu;

            string _sqlimg = string.Empty;
            _sqlimg = "select TenFile_Hethong,Duongdan_Anh,Chuthich from t_anh where ma_anh in (select Ma_Anh from T_Tinbai_Anh where Ma_TinBai=" + _id_newspaper + ")";
            _dt_img = ulti.ExecSqlDataSet(_sqlimg).Tables[0];
            string DesPath = string.Empty;
            string PathSource = string.Empty;
            string UrlImg = string.Empty;
            if (_dt_img != null && _dt_img.Rows.Count > 0)
            {
                for (int i = 0; i < _dt_img.Rows.Count; i++)
                {
                    if (_dt_img.Rows.Count > 1)
                    {
                        DesPath = System.Configuration.ConfigurationManager.AppSettings["UrlImageResize"].ToString() + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/";
                        DesPath = HttpContext.Current.Server.MapPath("/" + DesPath);
                        if (Directory.Exists(DesPath) == false)
                            Directory.CreateDirectory(DesPath);
                        PathSource = HttpContext.Current.Server.MapPath("/" + System.Configuration.ConfigurationManager.AppSettings["viewimg"].ToString() + _dt_img.Rows[i]["Duongdan_Anh"].ToString());
                        DesPath += Path.GetFileName(PathSource);
                        UrlImg = System.Configuration.ConfigurationManager.AppSettings["UrlImageResize"].ToString() + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/" + Path.GetFileName(PathSource);
                        ResizeImages(PathSource, Convert.ToInt32(HPCComponents.Global.VNPResizeImagesContent), DesPath);
                        if (i == 0)
                        {
                            string _strremove = "/" + UrlImg.Split('/').GetValue(1).ToString();
                            string _Images_Summary = UrlImg.Replace(_strremove, "");
                            obj_news.Images_Summary = _Images_Summary;
                            obj_news.News_Body = _objbaoin.Noidung;
                        }
                        //insert table T_ImageFiles
                        int _idImgFile = 0;

                        int startchar = UrlImg.Substring(1, UrlImg.Length - 1).IndexOf("/");
                        startchar += 1;
                        string _PathFile = UrlImg.Substring(startchar, UrlImg.Length - startchar);

                        _obj = SetItemImgFile(_dt_img.Rows[i]["TenFile_Hethong"].ToString(), 0, _PathFile, "", _user.UserID, 1, 0);
                        _idImgFile = _dalimgfile.InsertT_ImageFiles(_obj);

                        //end
                        obj_news.News_Body += "<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width: 450px;\"><tbody><tr><td><img border=\"0\" hspace=\"3\" id=\"" + _idImgFile + "\" src=\"" + UrlImg + "\" style=\"cursor-pointer\" vspace=\"3\" /></td></tr>";
                        obj_news.News_Body += "<tr><td>" + _dt_img.Rows[i]["Chuthich"].ToString() + "</tr></td></tbody></table>";
                    }
                    else
                    {
                        DesPath = System.Configuration.ConfigurationManager.AppSettings["UrlImageResize"].ToString() + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/";
                        DesPath = HttpContext.Current.Server.MapPath("/" + DesPath);
                        if (Directory.Exists(DesPath) == false)
                            Directory.CreateDirectory(DesPath);
                        PathSource = HttpContext.Current.Server.MapPath("/" + System.Configuration.ConfigurationManager.AppSettings["viewimg"].ToString() + _dt_img.Rows[i]["Duongdan_Anh"].ToString());
                        DesPath += Path.GetFileName(PathSource);
                        UrlImg = System.Configuration.ConfigurationManager.AppSettings["UrlImageResize"].ToString() + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/" + Path.GetFileName(PathSource);
                        ResizeImages(PathSource, Convert.ToInt32(HPCComponents.Global.VNPResizeImagesContent), DesPath);
                        int _idImgFile = 0;
                        //insert table T_ImageFiles
                        int startchar = UrlImg.Substring(1, UrlImg.Length - 1).IndexOf("/");
                        startchar += 1;
                        string _PathFile = UrlImg.Substring(startchar, UrlImg.Length - startchar);

                        _obj = SetItemImgFile(_dt_img.Rows[i]["TenFile_Hethong"].ToString(), 0, _PathFile, "", _user.UserID, 1, 0);
                        _idImgFile = _dalimgfile.InsertT_ImageFiles(_obj);

                        //end
                        string _strremove = "/" + UrlImg.Split('/').GetValue(1).ToString();
                        string _Images_Summary = UrlImg.Replace(_strremove, "");
                        obj_news.Images_Summary = _Images_Summary;
                        obj_news.News_Body = "<table border=\"0\" cellpadding=\"1\" cellspacing=\"1\" style=\"width: 450px;\"><tbody><tr><td><img border=\"0\" hspace=\"3\" id=\"" + _idImgFile + "\" src=\"" + UrlImg + "\" style=\"cursor-pointer\" vspace=\"3\" /></td></tr>";
                        obj_news.News_Body += "<tr><td>" + _dt_img.Rows[i]["Chuthich"].ToString() + "</tr></td></tbody></table>";
                        obj_news.News_Body += _objbaoin.Noidung;
                    }
                }
            }
            else
                obj_news.News_Body = _objbaoin.Noidung;
            obj_news.News_PublishNumber = int.Parse(DateTime.Now.Month.ToString());
            obj_news.News_PublishYear = int.Parse(DateTime.Now.Year.ToString());
            obj_news.News_DateCreated = DateTime.Now;
            obj_news.News_DateEdit = DateTime.Now;
            obj_news.News_DatePublished = DateTime.Now;
            obj_news.News_DateApproved = DateTime.Now;
            obj_news.News_AuthorID = int.Parse(_objbaoin.Ma_Nguoitao.ToString());
            obj_news.News_AprovedID = _user.UserID;
            obj_news.News_EditorID = _user.UserID;
            obj_news.News_PublishedID = _user.UserID;
            obj_news.News_CopyFrom = 0;
            obj_news.RefID = int.Parse(_id_newspaper.ToString());
            obj_news.News_Status = int.Parse(CommonLib.ReadXML("Status_BDT"));

            return obj_news;
        }
Exemplo n.º 15
0
        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());
            }
        }
Exemplo n.º 16
0
        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();
                }
            }
        }
Exemplo n.º 17
0
        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();
        }
Exemplo n.º 18
0
 public int SP_UpdateT_TinBai_WordOnline(T_TinBai obj)
 {
     return(HPCDataProvider.Instance().InsertObjectReturn(obj, "SP_UpdateT_TinBai_WordOnline"));
 }