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);
}
protected void AceoffixCtrl1_Load(object sender, EventArgs e)
{
AceoffixCtrl_Noidung.ServerPage = "../aceoffix-runtime/server.aspx";
// Create custom menu
//AceoffixCtrl_Noidung.
AceoffixCtrl_Noidung.Caption = "WORD-EDITOR ONLINE";
AceoffixCtrl_Noidung.Menubar = false;
AceoffixCtrl_Noidung.CustomToolbar = false;
AceoffixCtrl_Noidung.OfficeToolbars = true;
if (Request["ID"] != null)
{
AceoffixCtrl_Noidung.SaveFilePage = "../word/savefile.aspx?matinbai=" + Request["ID"].ToString() + "&MaDoiTuong=" + Request["MaDoiTuong"].ToString();
}
else
{
AceoffixCtrl_Noidung.SaveFilePage = "../word/savefile.aspx?MaDoiTuong=" + Request["MaDoiTuong"].ToString();
}
if (Request["ID"] != null)
{
string pathfile = _Daltinbai.load_T_news(double.Parse(Request["ID"].ToString())).PathFileDocuments;
if (pathfile != "" && pathfile != DBNull.Value.ToString())
{
if (File.Exists(Server.MapPath("/" + System.Configuration.ConfigurationManager.AppSettings["viewimg"].ToString() + pathfile)))
{
AceoffixCtrl_Noidung.OpenDocument(Global.TinPath + pathfile, Aceoffix.OpenModeType.docNormalEdit, _user.UserName);
}
else
{
AceoffixCtrl_Noidung.CreateNewDocument(_user.UserName, Aceoffix.DocumentVersion.Word2007);
}
}
else
{
AceoffixCtrl_Noidung.CreateNewDocument(_user.UserName, Aceoffix.DocumentVersion.Word2007);
}
}
else
{
AceoffixCtrl_Noidung.CreateNewDocument(_user.UserName, Aceoffix.DocumentVersion.Word2007);
}
}
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 DataGrid_EditCommand(object source, DataGridCommandEventArgs e)
{
string Thaotac = "";
string _ID = string.Empty;
if (TabContainer1.ActiveTabIndex == 0)
_ID = DataGrid_Dangxuly.DataKeys[e.Item.ItemIndex].ToString();
if (TabContainer1.ActiveTabIndex == 1)
_ID = DataGrid_TinTraLai.DataKeys[e.Item.ItemIndex].ToString();
int tab = 0;
tab = TabContainer1.ActiveTabIndex;
if (e.CommandArgument.ToString().ToLower() == "edit")
{
HPCBusinessLogic.DAL.TinBaiDAL Dal = new HPCBusinessLogic.DAL.TinBaiDAL();
double Nguoikhoa = Dal.load_T_news(int.Parse(_ID)).Nguoi_Khoa;
if (Nguoikhoa > 0)
if (Nguoikhoa != _user.UserID)
Response.Redirect("~/Quytrinh/List_PV.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&ID=" + _ID.ToString() + "&MaDoiTuong=" + Request["MaDoiTuong"].ToString() + "&Tab=" + tab);
else
{
Dal.IsLock(double.Parse(_ID), _user.UserID);
Response.Redirect("~/Quytrinh/Reporter.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&ID=" + _ID.ToString() + "&MaDoiTuong=" + Request["MaDoiTuong"].ToString() + "&Tab=" + tab);
}
else
{
Dal.IsLock(double.Parse(_ID), _user.UserID);
Response.Redirect("~/Quytrinh/Reporter.aspx?Menu_ID=" + Request["Menu_ID"].ToString() + "&ID=" + _ID.ToString() + "&MaDoiTuong=" + Request["MaDoiTuong"].ToString() + "&Tab=" + tab);
}
}
if (e.CommandArgument.ToString().ToLower() == "delete")
{
HPCBusinessLogic.DAL.TinBaiDAL DalTinbai = new HPCBusinessLogic.DAL.TinBaiDAL();
DalTinbai.Sp_DeleteT_Tinbai_WithTrangthai_Xoa(int.Parse(_ID), _user.UserID);
this.TabContainer1_ActiveTabChanged(null, null);
Thaotac = "Thao tác xóa tin bài tại: " + Request["MaDoiTuong"].ToString() + " - Tiêu đề:" + DalTinbai.load_T_news(int.Parse(_ID.ToString())).Tieude;
DalTinbai.IsLock(int.Parse(_ID), 0);
}
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), Thaotac);
this.TabContainer1.ActiveTabIndex = tab;
this.TabContainer1_ActiveTabChanged(source, e);
}
//end
//VietnamNews newspapers
public static string GetTrangThaiFrom_T_version(Object ID)
{
string str = "";
string Doituongdangxuly = "";
double Trangthai = 0;
HPCBusinessLogic.DAL.TinBaiDAL Dal = new HPCBusinessLogic.DAL.TinBaiDAL();
if (Dal.load_T_news(Convert.ToInt32(ID)) != null)
{
Doituongdangxuly = Dal.load_T_news(Convert.ToInt32(ID)).Doituong_DangXuly;
Trangthai = Dal.load_T_news(Convert.ToInt32(ID)).Trangthai;
}
switch (Doituongdangxuly)
{
case "PVHCM":
if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusReporterHCMBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #DAA520\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusReporterHCMTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #DAA520\"></div>";
}
break;
case "PVHN":
if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusReporterHNBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FFD700\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusReporterHNTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FFD700\"></div>";
}
break;
case "MOREINFO":
if (Trangthai == 1)
{
str = CommonLib.ReadXML("lblSatusMoreInfoTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #20B2AA\"></div>";
}
else if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusMoreInBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #20B2AA\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusMoreInTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #20B2AA\"></div>";
}
else if (Trangthai == 4)
{
str = CommonLib.ReadXML("lblThungrac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FF3030\"></div>";
}
break;
case "EXPATHN":
if (Trangthai == 1)
{
str = CommonLib.ReadXML("lblSatusExpatHNTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #CD853F\"></div>";
}
else if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusExpatHNBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #CD853F\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusExpatHNTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #CD853F\"></div>";
}
else if (Trangthai == 4)
{
str = CommonLib.ReadXML("lblThungrac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FF3030\"></div>";
}
break;
case "EXPATHCM":
if (Trangthai == 1)
{
str = CommonLib.ReadXML("lblSatusExpatHCMTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #F4A460\"></div>";
}
else if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusExpatHCMBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #F4A460\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusExpatHCMTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #F4A460\"></div>";
}
else if (Trangthai == 4)
{
str = CommonLib.ReadXML("lblThungrac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FF3030\"></div>";
}
break;
case "DESKHN":
if (Trangthai == 1)
{
str = CommonLib.ReadXML("lblSatusDeskHNTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #0000FF\"></div>";
}
else if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusDeskHNBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #0000FF\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusDeskHNTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #0000FF\"></div>";
}
else if (Trangthai == 4)
{
str = CommonLib.ReadXML("lblThungrac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FF3030\"></div>";
}
else if (Trangthai == 5)
{
str = CommonLib.ReadXML("lblSatusDeskHNBaigac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FFCC99\"></div>";
}
break;
case "DESKHCM":
if (Trangthai == 1)
{
str = CommonLib.ReadXML("lblSatusDeskHCMTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #00008B\"></div>";
}
else if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusDeskHCMBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #00008B\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusDeskHCMTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #00008B\"></div>";
}
else if (Trangthai == 4)
{
str = CommonLib.ReadXML("lblThungrac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FF3030\"></div>";
}
else if (Trangthai == 5)
{
str = CommonLib.ReadXML("lblSatusDeskHCMBaigac");
}
break;
case "CHIEF":
if (Trangthai == 1)
{
str = CommonLib.ReadXML("lblSatusChiefTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #8B4513\"></div>";
}
else if (Trangthai == 2)
{
str = CommonLib.ReadXML("lblSatusChiefBientap") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #8B4513\"></div>";
}
else if (Trangthai == 3)
{
str = CommonLib.ReadXML("lblSatusChiefTralai") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #8B4513\"></div>";
}
else if (Trangthai == 4)
{
str = CommonLib.ReadXML("lblThungrac") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #FF3030\"></div>";
}
break;
case "DT":
str = CommonLib.ReadXML("lblSatusDesignerTinmoi") + "</br><div style=\"float: left; width: 100%; height: 20px; background-color: #32CD32\"></div>";
break;
}
return(str);
}
private void SendBackTinbai()
{
string Thaotac = "";
ArrayList ar = new ArrayList();
if (TabContainer1.ActiveTabIndex == 0)
{
foreach (DataGridItem m_Item in DataGrid_DanTrang.Items)
{
CheckBox chk_Select = (CheckBox)m_Item.FindControl("optSelect");
if (chk_Select != null && chk_Select.Checked)
{
ar.Add(double.Parse(DataGrid_DanTrang.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()));
}
}
}
if (TabContainer1.ActiveTabIndex == 0)
{
LoadData_ChoXuly();
}
HPCBusinessLogic.DAL.TinBaiDAL News = new HPCBusinessLogic.DAL.TinBaiDAL();
if (!_isRefresh)
{
for (int i = 0; i < ar.Count; i++)
{
double News_ID = double.Parse(ar[i].ToString());
string _trace = News.GetTrace(News_ID);
if (_trace.Length > 0)
{
string[] _tmp = _trace.Split(';');
if (_tmp.Length > 0)
{
string _pos = _tmp[_tmp.Length - 2];
_trace = _trace.Substring(0, _trace.Length - _pos.Length - 1);
string _u = _pos.Substring(_pos.IndexOf("_") + 1);
_pos = _pos.Substring(0, _pos.Length - _u.Length - 1);
News.Update_Status_tintuc(News_ID, 3, int.Parse(_u), DateTime.Now, _pos, _trace);
News.Insert_Phienban_From_T_Tinbai(News_ID, _user.UserID, DateTime.Now, Request["MaDoiTuong"].ToString());
Thaotac = CommonLib.GetTenDoiTuong(Request["MaDoiTuong"]) + " Gửi trả lại tin bài cho " + CommonLib.GetTenDoiTuong(_pos) + " Tiêu đề:" + News.load_T_news(News_ID).Tieude + " ]";
UltilFunc.Log_Thaotactinbai(_user.UserID, _user.UserFullName, DateTime.Now, Thaotac, News_ID);
}
}
else
{
FuncAlert.AlertJS(this, "Không thể trả lại tin bài, vì không tìm được người gửi tin! ");
return;
}
}
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), Thaotac);
}
if (TabContainer1.ActiveTabIndex == 0)
{
LoadData_ChoXuly();
}
}
private void GuiTinBai(string MaDoiTuong)
{
string Thaotac = "";
ArrayList ar = new ArrayList();
if (TabContainer1.ActiveTabIndex == 0)
{
foreach (DataGridItem m_Item in DataGrid_Dangxuly.Items)
{
CheckBox chk_Select = (CheckBox)m_Item.FindControl("optSelect");
if (chk_Select != null && chk_Select.Checked)
{
ar.Add(double.Parse(DataGrid_Dangxuly.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()));
}
}
}
else if (TabContainer1.ActiveTabIndex == 1)
{
foreach (DataGridItem m_Item in DataGrid_TinTraLai.Items)
{
CheckBox chk_Select = (CheckBox)m_Item.FindControl("optSelect");
if (chk_Select != null && chk_Select.Checked)
{
ar.Add(double.Parse(DataGrid_TinTraLai.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString()));
}
}
}
if (!_isRefresh)
{
for (int i = 0; i < ar.Count; i++)
{
double News_ID = double.Parse(ar[i].ToString());
string _trace = _daltinbai.GetTrace(News_ID) + Request["MaDoiTuong"].ToString() + "_" + _user.UserID + ";";
_daltinbai.Update_Status_tintuc(News_ID, 1, _user.UserID, DateTime.Now, MaDoiTuong, _trace);
_daltinbai.Insert_Phienban_From_T_Tinbai(News_ID, _user.UserID, DateTime.Now, Request["MaDoiTuong"].ToString());
_daltinbai.Insert_Tulieu_From_T_Tinbai(News_ID);
Thaotac = "Thao tác gửi tin bài từ :" + CommonLib.GetTenDoiTuong(Request["MaDoiTuong"].ToString()) + "-->Gửi đến " + CommonLib.GetTenDoiTuong(MaDoiTuong) + "TinTuc:" + _daltinbai.load_T_news(int.Parse(News_ID.ToString())).Tieude;
_daltinbai.IsLock(News_ID, 0);
UltilFunc.Log_Thaotactinbai(_user.UserID, _user.UserFullName, DateTime.Now, Thaotac, News_ID);
UltilFunc.Log_Action(_user.UserID, _user.UserFullName, DateTime.Now, int.Parse(Request["Menu_ID"]), Thaotac);
int _statusvnonline = UltilFunc.GetColumnValuesOne("T_News", "News_Status", "RefID=" + News_ID);
bool _vnnewsonline = _daltinbai.load_T_news(int.Parse(News_ID.ToString())).VietNamNews;
if (_vnnewsonline && MaDoiTuong.ToUpper() == Global.MaXuatBan)
{
// Insert sang bao dien tu
if (_statusvnonline == int.Parse(CommonLib.ReadXML("Status_BDT")) || _statusvnonline == 0)
{
HPCBusinessLogic.DAL.T_NewsDAL _T_NewsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
T_News _objT_News = SetItemBaoDienTu(News_ID);
int _id_dt = _T_NewsDAL.InsertT_news(_objT_News);
_T_NewsDAL.Update_Status_tintuc(_id_dt, int.Parse(CommonLib.ReadXML("Status_BDT")), _user.UserID, DateTime.Now);
UltilFunc.Insert_News_Image(_objT_News.News_Body.Trim(), Convert.ToDouble(_id_dt.ToString()));
}
//end
}
this.TabContainer1_ActiveTabChanged(null, null);
}
}
}
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();
}
}
}
