private void LoadData_TinBaiTheoDeTai() { string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL(); DataSet _ds; _ds = _T_newsDAL.BindGridT_NewsEditor(pages.PageIndex, pages.PageSize, GetWhereTinBai(2, sOrder)); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _T_newsDAL.BindGridT_NewsEditor(pages.PageIndex - 1, pages.PageSize, GetWhereTinBai(2, sOrder)); } dgr_tintuc1.DataSource = _ds; dgr_tintuc1.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; Session["PageIndex"] = pages.PageIndex; GetTotalRecordTinBai(); }
public static string GetTieuDeBaiGac(Object ID) { UltilFunc ulti = new UltilFunc(); string _Trangthai = string.Empty; string _tieudetin = string.Empty; HPCBusinessLogic.DAL.TinBaiDAL _daltinbai = new HPCBusinessLogic.DAL.TinBaiDAL(); string str = ""; try { if (ID != DBNull.Value) { _tieudetin = _daltinbai.load_T_news(double.Parse(ID.ToString())).Tieude; _Trangthai = UltilFunc.GetColumnValuesOne("T_PhienBan", "Trangthai", "Trangthai=5 and Ma_Tinbai=" + ID.ToString()).ToString(); if (_Trangthai == "0") { str = _tieudetin; } else { str = "<img border=0 height='12px' src='" + Global.ApplicationPath + "/Dungchung/Images/baigac.gif' alt='Bài gác' title=' Bài gác'> <br/>" + _tieudetin; } } } catch (Exception ex) { throw ex; } return(str); }
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); }
public static void Backup_fileDoc(double NewsID, string _UserName, string _Chucnang) { string _noidung = string.Empty; string _tieude = string.Empty; string _loaibao = string.Empty; string _sobao = string.Empty; int _lb = 0; int _sb = 0; string strFileName = string.Empty; string strHTML = string.Empty; AnPhamDAL _dalanpham = new AnPhamDAL(); ChuyenmucDAL dalcm = new ChuyenmucDAL(); SobaoDAL dalsb = new SobaoDAL(); HPCBusinessLogic.DAL.TinBaiDAL dalnews = new HPCBusinessLogic.DAL.TinBaiDAL(); _tieude += dalnews.load_T_news(NewsID).Tieude; _tieude += System.Environment.NewLine; _noidung += dalnews.load_T_news(NewsID).Noidung; _noidung += System.Environment.NewLine; if (dalnews.load_T_news(NewsID).Ma_NgonNgu != 0) { _lb = dalnews.load_T_news(NewsID).Ma_Anpham; _loaibao += _dalanpham.GetOneFromT_AnPhamByID(_lb).Ten_AnPham; } if (dalnews.load_T_news(NewsID).Ma_Chuyenmuc != 0) { _lb = dalnews.load_T_news(NewsID).Ma_Chuyenmuc; _loaibao += _dalanpham.GetOneFromT_AnPhamByID(dalcm.GetOneFromT_ChuyenmucByID(_lb).Ma_AnPham).Ten_AnPham; } if (dalnews.load_T_news(NewsID).Ma_Sobao != 0) { _sb = dalnews.load_T_news(NewsID).Ma_Sobao; _sobao += dalsb.GetOneFromT_SobaoByID(_sb).Ten_Sobao; } if (_noidung.Length > 0) { strHTML += "<html><BODY>"; strHTML += _tieude; strHTML += "<br />"; strHTML += "<br />"; strHTML += _noidung; strHTML += "</BODY></html>"; DirectoryInfo r = new DirectoryInfo(HttpContext.Current.Server.MapPath("~" + System.Configuration.ConfigurationManager.AppSettings["BackupDoc"].ToString())); if (File.Exists(r.ToString())) { FileInfo[] file; file = r.GetFiles("*.doc"); foreach (FileInfo i in file) { File.Delete(r.FullName + "\\" + i.Name); } } strFileName = _UserName + _Chucnang + "_" + string.Format("{0:dd-MM-yyyy_hh-mm-ss}", System.DateTime.Now); string pathStore = HttpContext.Current.Server.MapPath("~" + System.Configuration.ConfigurationManager.AppSettings["BackupDoc"].ToString() + _Chucnang + "/" + _loaibao + "/" + _sobao + "/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day); string path = HttpContext.Current.Server.MapPath("~" + System.Configuration.ConfigurationManager.AppSettings["BackupDoc"].ToString() + _Chucnang + "/" + _loaibao + "/" + _sobao + "/" + DateTime.Now.Year + "/" + DateTime.Now.Month + "/" + DateTime.Now.Day + "/" + strFileName + ".doc"); if (!File.Exists(pathStore)) { Directory.CreateDirectory(pathStore); } try { StreamWriter wr = new StreamWriter(path, false, System.Text.Encoding.Unicode); wr.Write(strHTML); wr.Close(); } catch (Exception ex) { throw ex; } } }