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;
}
}
}
