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(); } } } }
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"); } }
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); }
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)); }
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); }
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); }
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(); }
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>"; } }
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(); } }
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; } } } } } }
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"]); }
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); }
public int InsertT_Tinbai_WordOnline(T_TinBai obj) { return(HPCDataProvider.Instance().InsertObjectReturn(obj, "Sp_InsertT_TinBai_WordOnline")); }
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; }
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 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(); } } }
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(); }
public int SP_UpdateT_TinBai_WordOnline(T_TinBai obj) { return(HPCDataProvider.Instance().InsertObjectReturn(obj, "SP_UpdateT_TinBai_WordOnline")); }