private void LoadData_ChoXuly() { 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, BuildSQL(1, 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, BuildSQL(1, sOrder)); } DataGrid_DanTrang.DataSource = _ds; DataGrid_DanTrang.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; Session["PageIndex"] = pages.PageIndex; GetTotalRecordTinBai(); }
private void LoadData() { try { string FulltextSearch = UltilFunc.ReplaceAll(txt_tieude.Text.Trim(), "'", "’"); string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.TinBaiDAL _NewsDal = new HPCBusinessLogic.DAL.TinBaiDAL(); DataSet _ds; _ds = _NewsDal.BindGridT_NewsFullTeztSearch(pages.PageIndex, pages.PageSize, BuildSql(sOrder), UltilFunc.SplitString(FulltextSearch)); 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 = _NewsDal.BindGridT_NewsFullTeztSearch(pages.PageIndex - 1, pages.PageSize, BuildSql(sOrder), UltilFunc.SplitString(FulltextSearch)); } DataGrid_tinbai.DataSource = _ds; DataGrid_tinbai.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; } catch (Exception ex) { throw ex; } }
private void LoadData() { pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL(); DataSet _ds; int Vungmien = 0; if (cboVungmien.SelectedValue != "") { Vungmien = int.Parse(cboVungmien.SelectedValue); } _ds = _T_newsDAL.Sp_ListThongKeNhuanBut(pages.PageIndex, pages.PageSize, int.Parse(cbo_Anpham.SelectedValue), int.Parse(cboThanhtoan.SelectedValue), txt_tungay.Text.Trim(), txt_denngay.Text.Trim(), int.Parse(cbo_PVCTV.SelectedValue), Vungmien, Global.MaXuatBan); 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.Sp_ListThongKeNhuanBut(pages.PageIndex, pages.PageSize, int.Parse(cbo_Anpham.SelectedValue), int.Parse(cboThanhtoan.SelectedValue), txt_tungay.Text.Trim(), txt_denngay.Text.Trim(), int.Parse(cbo_PVCTV.SelectedValue), Vungmien, Global.MaXuatBan); } DataGrid_tinbai.DataSource = _ds; DataGrid_tinbai.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; }
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 LoadData() { HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL(); DataSet _ds; _ds = _T_newsDAL.Sp_ListTraCuuNhuanBut(GetWhere()); DataGrid_tinbai.DataSource = _ds; DataGrid_tinbai.DataBind(); }
private void BindDoiTuongGuiBai() { HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL(); if (Request["MaDoiTuong"] != null && Ma_QTBT != 0) { DataSet _ds = _T_newsDAL.Bind_DoiTuongGui(Request["MaDoiTuong"], Ma_QTBT, Session["culture"].ToString()); DataListDoiTuong.DataSource = _ds; DataListDoiTuong.DataBind(); } else { DataListDoiTuong.DataSource = null; DataListDoiTuong.DataBind(); } }
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); }
protected void DataGrid_tinbai_EditCommand(object source, DataGridCommandEventArgs e) { DataSet ds = new DataSet(); if (e.CommandArgument.ToString().ToLower() == "edit") { HPCBusinessLogic.DAL.TinBaiDAL Dal = new HPCBusinessLogic.DAL.TinBaiDAL(); string _matinbai = DataGrid_tinbai.DataKeys[e.Item.ItemIndex].ToString(); string sqlselect = "select * from T_Lichsu_Thaotac_TinBai where Ma_TinBai=" + _matinbai + " order by NgayThaotac"; ds = Ulti.ExecSqlDataSet(sqlselect); if (ds != null && ds.Tables[0].Rows.Count > 0) { DataGridLichsuthaotactinbai.DataSource = ds; DataGridLichsuthaotactinbai.DataBind(); ModalPopupThaotactinbai.Show(); } } }
private void LoadData() { 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_Tulieu(pages.PageIndex, pages.PageSize, BuildSQL(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_Tulieu(pages.PageIndex - 1, pages.PageSize, BuildSQL(sOrder)); DataGrid_tinbai.DataSource = _ds; DataGrid_tinbai.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; context.Response.Write("Hello World"); try { string[] sArrProdID = null; char[] sep = { '?' }; string[] sArrVkey = null; string strUserID = ""; char[] sep2 = { ',' }; sArrProdID = context.Request.QueryString["user"].ToString().Trim().Split(sep); sArrVkey = sArrProdID[0].ToString().Trim().Split(sep2); user = DAL.GetUserByUserName(sArrVkey[0].ToString()); strUserID = user.UserID.ToString(); int _Trang = 0; double _Sobao = 0; int _Index = 0; if (sArrVkey[1].ToString() != "") { _Trang = int.Parse(sArrVkey[1].ToString()); } if (sArrVkey[2].ToString() != "") { _Sobao = double.Parse(sArrVkey[2].ToString()); } if (sArrVkey[3].ToString() != "") { _Index = int.Parse(sArrVkey[3].ToString()); } HttpPostedFile postedFile = context.Request.Files["Filedata"]; string tempPath = System.Configuration.ConfigurationManager.AppSettings["UploadPath"].ToString() + "PDF/" + DateTime.Now.Year.ToString() + "/" + DateTime.Now.Month.ToString() + "/" + DateTime.Now.Day.ToString() + "/"; //Create forder CreateFolderByUserName(tempPath); string savepath = context.Server.MapPath("/" + tempPath); string filename = postedFile.FileName; string[] sArrTenfile = null; char[] cat = { '.' }; sArrTenfile = filename.ToString().Trim().Split(cat); string _extenfile = GetDateTimeStringUnique() + "." + sArrTenfile[1].ToString(); string _tenfilegoc = UltilFunc.RemoveSign4VietnameseString(Path.GetFileNameWithoutExtension(filename)) + _extenfile; _tenfilegoc = _tenfilegoc.Replace(" ", ""); postedFile.SaveAs(savepath + @"\" + _tenfilegoc); int startchar = tempPath.Substring(1, tempPath.Length - 1).IndexOf("/"); startchar += 1; string _PathFile = tempPath.Substring(startchar, tempPath.Length - startchar); string _savePath = _PathFile + "" + _tenfilegoc; HPCBusinessLogic.DAL.TinBaiDAL _DAL = new HPCBusinessLogic.DAL.TinBaiDAL(); T_Publish_Pdf _obj = new T_Publish_Pdf(); _obj = SetItem(_savePath, _Trang, _Sobao, _Index); _DAL.InsertT_Publish_PDF(_obj); context.Response.Write(tempPath + "/" + _tenfilegoc); context.Response.StatusCode = 200; } catch (Exception ex) { context.Response.Write("Error: " + ex.Message); } }
public static string GetActionName(Object ID) { HPCBusinessLogic.DAL.TinBaiDAL Dal = new HPCBusinessLogic.DAL.TinBaiDAL(); string str = ""; string doituongdaxuly = ""; double Trangthai = 0; if (ID != DBNull.Value) { doituongdaxuly = Dal.Sp_SelectOneFromT_PhienBan(double.Parse(ID.ToString())).Doituong_DangXuly; Trangthai = Dal.Sp_SelectOneFromT_PhienBan(double.Parse(ID.ToString())).Trangthai; } switch (doituongdaxuly.Trim()) { case "PVHCM": if (Trangthai == 3) { str = CommonLib.ReadXML("lblActionReturnReporterHCM"); } break; case "PVHN": if (Trangthai == 3) { str = CommonLib.ReadXML("lblActionReturnReporterHN"); } break; case "MOREINFO": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendMoreInfo"); } else { str = CommonLib.ReadXML("lblActionReturnMoreInfo"); } break; case "DESKHN": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendDeskHN"); } else if (Trangthai == 3) { str = CommonLib.ReadXML("lblActionReturnDeskHN"); } else if (Trangthai == 5) { str = CommonLib.ReadXML("lblActionBaigacDeskHN"); } break; case "DESKHCM": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendDeskHCM"); } else if (Trangthai == 3) { str = CommonLib.ReadXML("lblActionReturnDeskHCM"); } else if (Trangthai == 5) { str = CommonLib.ReadXML("lblActionBaigacDeskHCM"); } break; case "CHIEF": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendChief"); } else { str = CommonLib.ReadXML("lblActionReturnChief"); } break; case "EXPATHN": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendExpatHN"); } else { str = CommonLib.ReadXML("lblActionReturnExpatHN"); } break; case "EXPATHCM": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendExpatHCM"); } else { str = CommonLib.ReadXML("lblActionReturnExpatHCM"); } break; case "DT": if (Trangthai == 1) { str = CommonLib.ReadXML("lblActionSendDesigner"); } break; } return(str); }
//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); }