/// <summary> /// Insert sang bảng news wap /// </summary> /// <param name="NewsID"></param> private void SaveWapContent(string NewsID, int NewsStatus) { if (chkCopyToWap.Checked) { NewsEditHelper.SaveWapContent(Convert.ToInt64(NewsID), NewsContent.Text, NewsStatus); } }
public void ProcessRequest(HttpContext context) { try { long NewsID = 0; Int64.TryParse(context.Request.Form["news_id"].ToString(), out NewsID); int CatID = 0; Int32.TryParse(context.Request.Form["cat_id"].ToString(), out CatID); //NewsEditHelper.AutoSave_Insert(NewsID, CatID, context.Request.Form["news_title"].ToString(), context.Request.Form["image"].ToString(), context.Request.Form["sapo"].ToString(), context.Request.Form["news_content"].ToString(), DateTime.Now); NewsRow objNewsRow = NewsEditHelper.GetNewsInfo_News(NewsID, false); if (objNewsRow == null) { NewsEditHelper.CreateNews(NewsID, CatID, string.Empty, context.Request.Form["news_title"].ToString(), context.Request.Form["image"].ToString(), context.Request.Form["news_title"].ToString(), context.Request.Form["sapo"].ToString(), context.Request.Form["news_content"].ToString(), string.Empty, false, 0 /*lưu tạm*/, 0, string.Empty, string.Empty, string.Empty, DateTime.Now, false, false, 0, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, string.Empty, 0, string.Empty, string.Empty); } else if (objNewsRow.News_Status == 0) { NewsEditHelper.UpdateNews(NewsID, CatID, string.Empty, context.Request.Form["news_title"].ToString(), context.Request.Form["image"].ToString(), string.Empty, context.Request.Form["sapo"].ToString(), context.Request.Form["news_content"].ToString(), false, 0, 0, string.Empty, string.Empty, DateTime.Now, false, false, false, 0, string.Empty, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, string.Empty, 0, string.Empty, string.Empty); } context.Response.Write("Lưu tự động lúc : " + DateTime.Now); } catch (Exception ex) { context.Response.Write(ex.Message); } }
private void BindData() { DataTable _list = NewsEditHelper.GetListCrawlerNews(); grdList.DataSource = _list; grdList.DataBind(); }
private void BindData() { int _id = 0; if (Int32.TryParse(Request.QueryString["ID"], out _id)) { DataTable _obj = NewsEditHelper.GetCrawlerNews(_id); if (_obj != null && _obj.Rows.Count > 0) { DataRow row = _obj.Rows[0]; ltrTitle.Text = row["News_Title"].ToString(); ltrSapo.Text = row["News_InitContent"].ToString(); long NewsID = Convert.ToInt64(NewsHelper.GenNewsID()); //NewsEditHelper.CreateNews(NewsID, 0, string.Empty, row["News_Title"].ToString(), string.Empty, "Theo " + row["SourceName"], row["News_InitContent"].ToString(), row["News_Content"].ToString(), string.Empty, false, 0, 0, string.Empty, string.Empty, string.Empty, DateTime.Now, false, false, 0, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, row["News_Source"].ToString(), 0, string.Empty, string.Empty); //NewsEditHelper.UpdateCrawlerStatus(_id); //Response.Redirect("/office/add,templist/" + NewsID + ".aspx"); } } }
/// <summary> /// Kiểm tra xem bài viết này có đồng thời 2 người can thiệp không [bacth, 12:29 PM 5/31/2008] /// </summary> /// <param name="message">Thông báo trong trường hợp có sự động độ</param> /// <returns></returns> private bool isConcurrency(ref string message) { if (string.IsNullOrEmpty(Request.QueryString["NewsRef"])) { return(false); // bài viết mới - không đụng độ } string cpMode = Request.QueryString["cpmode"].Replace("add,", string.Empty); long newsId = 0; long.TryParse(Request.QueryString["NewsRef"], out newsId); NewsRow news = NewsEditHelper.GetNewsInfo(newsId); if (news == null) { message = "Bài viết không tồn tại hoặc đã bị xóa"; return(true); } if (cpMode.Equals("editwaitlist")) { if (news.News_Status != 1) { message = "Bài viết đã có người khác cập nhật"; return(true); } else { // kiểm tra xem có ai nhận biên tập không? string otherUser = NewsEditHelper.getReceiver(newsId); if (!string.IsNullOrEmpty(otherUser) && otherUser != Page.User.Identity.Name) { message = otherUser + " đã nhận biên tập bài này trong khi bạn đang xem bài viết"; return(true); } } } else if (cpMode.Equals("approvalwaitlist")) { if (news.News_Status != 2) { message = "Bài viết đã có người khác cập nhật"; return(true); } else { // kiểm tra xem có ai nhận duyệt không? string otherUser = NewsEditHelper.getReceiver(newsId); if (!string.IsNullOrEmpty(otherUser) && otherUser != Page.User.Identity.Name) { message = otherUser + " đã nhận duyệt bài này trong khi bạn đang xem bài viết"; return(true); } } } return(false); }
private void BindData() { if (ID > 0) { var productObj = productController.SelectProduct(ID); if (productObj != null) { txt_Name.Value = productObj.ProductName; txt_Name_En.Value = productObj.ProductName_En; txt_Summary.Value = productObj.ProductSumary; txt_Sum_En.Value = productObj.ProductSumary_En; txtSelectedFile.Value = productObj.ProductAvatar; NewsContent.Text = productObj.ProductDescription; NewsContent_En.Text = productObj.ProductDescription_En; txt_Cost.Value = productObj.ProductCost.ToString(); ddlCategory.SelectedValue = productObj.ProductCategory.ToString(); txt_Video.Text = productObj.ProductVideo; txt_tags.Value = productObj.ProductTag; ddlLayout.SelectedValue = productObj.ProductLayout.ToString(); cb_IsActive.Checked = productObj.IsActive; ddlGift.SelectedValue = productObj.ProductColor.ToString(); productType.Items.FindByValue(productObj.ProductType.ToString()).Selected = true; try { hdMedia.Value = NewsMediaHelper.Get_ObjectId_By_FilmId(productObj.Id.ToString()); if (hdMedia.Value.TrimEnd(',').Length > 0) { BindToDropdown(cboMedia, NewsEditHelper.Get_Media_By_ListsId("Object_ID", "Object_Url", "MediaObject", hdMedia.Value)); } } catch (Exception ex) { } if (productObj.ProductOtherCat != null) { string[] strOthers = productObj.ProductOtherCat.Split(",".ToCharArray()); for (int i = 0; i < lstOtherCat.Items.Count; i++) { foreach (string strItem in strOthers) { if (strItem == lstOtherCat.Items[i].Value) { lstOtherCat.Items[i].Selected = true; break; } } } } } } }
//ThienTD EDIT: xóa dữ liệu trong bảng News_Extesion protected void btnSend_Click(object sender, EventArgs e) { if (!string.IsNullOrEmpty(Request.QueryString["NewsRef"])) { NewsEditHelper.DeleteNews_Extension(Request.QueryString["NewsRef"]); } if (!String.IsNullOrEmpty(referUrl)) { Response.Redirect(referUrl); } }
private void LoadProvinces() { DataTable provinces = NewsEditHelper.GetAllProvinces(); if (provinces != null && provinces.Rows.Count > 0) { ddlProvinces.DataSource = provinces; ddlProvinces.DataBind(); } ddlProvinces.Items.Insert(0, new ListItem("-- Chọn tỉnh thành --", "0")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var selectedItems = Request.Form["SelectedItems"]; if (selectedItems != null && selectedItems.ToString() != "") { NewsEditHelper.DeleteNewsCrawler(selectedItems.ToString()); } } }
private void GetAllTacGia() { DataTable authors = NewsEditHelper.GetAllTacGia(); if (authors != null && authors.Rows.Count > 0) { ddlAuthor.DataSource = authors; ddlAuthor.DataBind(); } ddlAuthor.Items.Insert(0, new ListItem("-- Chọn tác giả --", "0")); }
private void UpdateNewsFileType(Int64 NewsID) { string selectedItems = string.Empty; foreach (ListItem item in cblFileType.Items) { if (item.Selected) { selectedItems += item.Value + ","; } } //if (!String.IsNullOrEmpty(selectedItems)) { NewsEditHelper.UpdateNewsAttachmentFileType(NewsID, selectedItems); //} }
private void LoadAttachmentsType(long _news_id) { DataTable types = NewsEditHelper.GetAttachmentsType(_news_id); if (types != null && types.Rows.Count > 0) { DataRow row = null; foreach (ListItem item in cblFileType.Items) { for (int i = 0; i < types.Rows.Count; i++) { row = types.Rows[i]; if (item.Value == row["Type"].ToString()) { item.Selected = true; } } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { long news_ID = 0; if (!string.IsNullOrEmpty(Request.QueryString["nid"])) { news_ID = Convert.ToInt64(Request.QueryString["nid"]); } if (news_ID > 0) { NewsRow objNewsRow = NewsEditHelper.GetNewsInfo_News(news_ID, false); NewsRow objNewsRow_Ex = NewsEditHelper.GetNewsInfo_NewsExtension(news_ID, false); string title = LCSFinder.GetEditor(objNewsRow.News_Title, objNewsRow_Ex.News_Title)[0]; string Sapo = LCSFinder.GetEditor(objNewsRow.News_InitialContent, objNewsRow_Ex.News_InitialContent)[0]; string Content = LCSFinder.GetEditor(objNewsRow.News_Content, objNewsRow_Ex.News_Content)[0]; ltrTitle.Text = title; ltrInit.Text = Sapo; ltrContent.Text = Content; } } }
protected void grdList_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName.Equals("Copy")) { int _id = Convert.ToInt32(e.CommandArgument); DataTable _obj = NewsEditHelper.GetCrawlerNews(_id); if (_obj != null && _obj.Rows.Count > 0) { DataRow row = _obj.Rows[0]; long NewsID = Convert.ToInt64(NewsHelper.GenNewsID()); NewsEditHelper.CreateNews(NewsID, 0, string.Empty, row["News_Title"].ToString(), string.Empty, "Theo " + row["SourceName"], row["News_InitContent"].ToString(), row["News_Content"].ToString(), HttpContext.Current.User.Identity.Name, false, 0, 0, string.Empty, string.Empty, string.Empty, DateTime.Now, false, false, 0, string.Empty, string.Empty, string.Empty, false, string.Empty, string.Empty, row["News_Source"].ToString(), 0, string.Empty, string.Empty); NewsEditHelper.UpdateCrawlerStatus(_id); Response.Redirect("/office/add,templist/" + NewsID + ".aspx"); } else { Response.Redirect("/office/crawler.aspx"); } } }
/// <summary> /// Check whether current user can edit the news /// </summary> /// <param name="context"></param> /// <returns></returns> public static bool isHasPermission(HttpContext context) { if (context.Request.QueryString["NewsRef"] == null || context.Request.QueryString["NewsRef"] == string.Empty) { return(true); } else { string cpMode = context.Request.QueryString["cpmode"]; if (!string.IsNullOrEmpty(cpMode)) { if (cpMode.Contains(",")) { cpMode = cpMode.Substring(cpMode.IndexOf(",") + 1); } cpMode = cpMode.ToLower(); long newsId = long.Parse(context.Request.QueryString["NewsRef"]); string userName = context.User.Identity.Name; if (!string.IsNullOrEmpty(userName) && newsId != 0) { MainSecurity objsecu = new MainSecurity(); //Role objrole = objsecu.GetRole(context.User.Identity.Name); NewsRow newsRow = NewsEditHelper.GetNewsInfo_News(newsId, false); if (newsRow != null) { Permission permission = objsecu.GetPermission(userName); MainDB db = new MainDB(); bool toReturn = false; switch (cpMode) { case "templist": toReturn = newsRow.News_Status == (byte)NewsStatus.LuuTam && db.StoredProcedures.News_isLastAccessUser(newsId, userName); break; case "editwaitlist": toReturn = newsRow.News_Status == (byte)NewsStatus.ChoBienTap && permission.isBien_Tap_Bai && db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser()); break; case "editinglist": toReturn = newsRow.News_Status == (byte)NewsStatus.NhanBienTap && permission.isBien_Tap_Bai && db.StoredProcedures.News_isLastAccessUser(newsId, userName); break; case "approvalwaitlist": toReturn = newsRow.News_Status == (byte)NewsStatus.ChoDuyet && permission.isDuyet_Bai && db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser()); break; case "approvalwaitspeciallist": toReturn = newsRow.News_Status == (byte)NewsStatus.ChoDuyet && permission.isDuyet_Bai && db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser()); break; case "approvinglist": toReturn = newsRow.News_Status == (byte)NewsStatus.NhanDuyet && permission.isDuyet_Bai && db.StoredProcedures.News_isLastAccessUser(newsId, userName); break; case "publishedlist": toReturn = newsRow.News_Status == (byte)NewsStatus.XuatBan && permission.isXuat_Ban_Bai && db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser()); break; case "removedlist": toReturn = newsRow.News_Status == (byte)NewsStatus.GoBo && permission.isXuat_Ban_Bai && db.StoredProcedures.News_isHasPermissionEdit(newsId, CategoryHelper.GetCatIDByUser()); break; case "backlist": toReturn = newsRow.News_Status == (byte)NewsStatus.TraLai && db.StoredProcedures.News_isLastAccessUser(newsId, userName); break; case "dellist": toReturn = newsRow.News_Status == (byte)NewsStatus.XoaTam && db.StoredProcedures.News_isLastAccessUser(newsId, userName); break; } return(toReturn); } } } } return(false); }
protected void btnPublish_Click(object sender, EventArgs e) { if (Validate()) { // Get CatID cac chuyen muc khac string strOtherCat = ""; foreach (ListItem item in lstOtherCat.Items) { if (item.Selected) { strOtherCat += item.Value + ","; } } //string Tags = ""; foreach (ListItem item in cblTags.Items) { if (item.Selected) { hidLuongSuKien.Value += item.Value + ","; } } hidLuongSuKien.Value = hidLuongSuKien.Value.TrimEnd(','); if (strOtherCat != "") { strOtherCat = strOtherCat.Substring(0, strOtherCat.Length - 1); } string strNewsID = ""; string strcpmode = Request.QueryString["cpmode"].ToString().Replace("add,", "").Replace("#", ""); //xet 2 truong hop: 1 la tao va xuat ban, 2 sua va xuất bản if (!string.IsNullOrEmpty(Request.QueryString["NewsRef"])) { strNewsID = Request.QueryString["NewsRef"].ToString(); objsoure.UpdateParameters[9].DefaultValue = "3"; // Neu chon ngay xuat ban voi truong hop chua Published // thi check xem da chon PublishedDate chua //if (getPublishTime().Year == 2000) // objsoure.UpdateParameters[13].DefaultValue = DateTime.Now.ToString(); //else objsoure.UpdateParameters[13].DefaultValue = getPublishTime().ToString(); objsoure.UpdateParameters[12].DefaultValue = strOtherCat; objsoure.UpdateParameters["_str_Extension3"].DefaultValue = txtSourceLink.Text.Trim(); objsoure.UpdateParameters["_thread_id"].DefaultValue = hidLuongSuKien.Value.Trim(); // Get ViewNum cua Category int template = CategoryHelper.getCatInfoAsCategoryRow(Convert.ToInt32(lstCat.SelectedValue)).Cat_ViewNum; objsoure.UpdateParameters[17].DefaultValue = template.ToString(); objsoure.UpdateParameters[4].DefaultValue = txtSelectedFile.Text.Trim(); objsoure.UpdateParameters["_isSend"].DefaultValue = "true"; objsoure.Update(); NewsEditHelper.DeleteNews_Extension(Request.QueryString["NewsRef"]); if (!String.IsNullOrEmpty(referUrl)) { Response.Redirect(referUrl); } } } }
private void BindNewsEdit(long _news_id) { NewsRow objNewsRow = NewsEditHelper.GetNewsInfo_NewsExtension(_news_id, false); MainSecurity objSercu = new MainSecurity(); Permission objPer = objSercu.GetPermission(Page.User.Identity.Name); if (objPer.isXuat_Ban_Bai) { //Kiểm tra nếu có quyền xuất bản thì sẽ hiện dầy đủ thông tin btnPublish.Visible = true; // pnControl.Visible = true; } else { btnPublish.Visible = false; } if (objNewsRow != null) { if (!objPer.isXuat_Ban_Bai && Page.User.Identity.Name.Trim().ToLower() != objNewsRow.News_Author.Trim().ToLower()) { throw new SecurityException("Bạn không có quyền truy cập vào trang này"); return; } ltrXuatBan.Text = "Bài viết do \"" + objNewsRow.News_Approver.ToUpper() + "\" xuất bản lúc " + objNewsRow.News_PublishDate.ToString("dd/MM/yyyy hh:mm"); lstCat.SelectedValue = objNewsRow.Cat_ID.ToString(); txtTitle.Text = objNewsRow.News_Title != null ? objNewsRow.News_Title : ""; txtSubTitle.Text = objNewsRow.News_Subtitle != null ? objNewsRow.News_Subtitle : ""; txtSource.Text = objNewsRow.News_Source != null ? objNewsRow.News_Source : ""; txtInit.Text = objNewsRow.News_InitialContent != null?NewsEditHelper.ReplaceImageSrcToEmoticon(objNewsRow.News_InitialContent) : ""; txtInit.Text = txtInit.Text.Replace("<br/>", System.Environment.NewLine); if (Request.QueryString["redirect"] == null) { NewsContent.Text = objNewsRow.News_Content != null ? objNewsRow.News_Content : ""; Session["NewsContent"] = NewsContent.Text; } else { NewsContent.Text = Session["NewsContent"].ToString(); } chkIsFocus.Checked = objNewsRow.IsNews_isFocusNull != true ? objNewsRow.News_isFocus : false; cboIsHot.SelectedValue = objNewsRow.IsNews_ModeNull != true?objNewsRow.News_Mode.ToString() : "0"; hdRelatNews.Value = objNewsRow.News_Relation != null ? objNewsRow.News_Relation : ""; chkShowComment.Checked = objNewsRow.IsisCommentNull != true ? objNewsRow.isComment : false; //Cho phép hiện ảnh hay ko? chkShowRate.Checked = objNewsRow.IsisUserRateNull != true ? objNewsRow.isUserRate : false; txtSelectedFile.Text = objNewsRow.News_Image != null ? objNewsRow.News_Image : ""; txtImageTitle.Text = objNewsRow.News_ImageNote != null ? objNewsRow.News_ImageNote : ""; txtIcon.Text = objNewsRow.Icon != null ? objNewsRow.Icon : ""; txtMaCP.Text = objNewsRow.Extension1 != null ? objNewsRow.Extension1 : ""; txtExtension2.Text = objNewsRow.Extension2 != null ? objNewsRow.Extension2 : ""; txtSourceLink.Text = objNewsRow.Extension3 != null ? objNewsRow.Extension3 : ""; ddlAuthor.SelectedValue = objNewsRow.IsExtension4Null != true?objNewsRow.Extension4.ToString() : "0"; if (objNewsRow.Template != 0) { ddlProvinces.SelectedValue = objNewsRow.Template.ToString(); } if (objNewsRow.News_OtherCat != null) { string[] strOthers = objNewsRow.News_OtherCat.Split(",".ToCharArray()); for (int i = 0; i < lstOtherCat.Items.Count; i++) { foreach (string strItem in strOthers) { if (strItem == lstOtherCat.Items[i].Value) { lstOtherCat.Items[i].Selected = true; break; } } } } if (!objNewsRow.IsNews_PublishDateNull) { SetValueForCombo(cboMonth, objNewsRow.News_PublishDate.Month.ToString()); SetValueForCombo(cboDay, objNewsRow.News_PublishDate.Day.ToString()); SetValueForCombo(cboYear, objNewsRow.News_PublishDate.Year.ToString()); SetValueForCombo(cboSercond, objNewsRow.News_PublishDate.Second.ToString()); SetValueForCombo(cboMinute, objNewsRow.News_PublishDate.Minute.ToString()); SetValueForCombo(cboHour, objNewsRow.News_PublishDate.Hour.ToString()); } else { SetValueForCombo(cboMonth, "0"); SetValueForCombo(cboDay, "0"); SetValueForCombo(cboYear, "2000"); SetValueForCombo(cboSercond, "-1"); SetValueForCombo(cboMinute, "-1"); SetValueForCombo(cboHour, "-1"); } if (!IsPostBack) { hdMedia.Value = DFISYS.BO.Editoral.NewsMedia.NewsMediaHelper.Get_ObjectId_By_NewsId(_news_id); DataTable dtThread = ThreadHelper.SelectThreadByNewsID(_news_id); if (dtThread != null && dtThread.Rows.Count > 0) { hidLuongSuKien.Value = dtThread.Rows[0]["Thread_ID"].ToString(); } } //Load data to Combobox Tin lien quan; string str; if (hdRelatNews.Value.TrimEnd(',') != "") { str = NewsEditHelper.Get_Media_By_ListsId("News_ID", "News_Title", "News", hdRelatNews.Value); BindToDropdown(cboNews, str); } string strThread; if (hidLuongSuKien.Value.TrimEnd(',') != "") { strThread = NewsEditHelper.Get_Media_By_ListsId("Thread_ID", "Title", "NewsThread", hidLuongSuKien.Value); BindToDropdown(lstThread, strThread); string[] arrThread = hidLuongSuKien.Value.Split(','); if (arrThread != null && arrThread.Length > 0) { for (int i = 0; i < cblTags.Items.Count; i++) { foreach (string strItem in arrThread) { if (strItem == cblTags.Items[i].Value) { cblTags.Items[i].Selected = true; break; } } } } } if (hdMedia.Value.TrimEnd(',').Length > 0) { str = NewsEditHelper.Get_Media_By_ListsId("Object_ID", "Object_Url", "MediaObject", hdMedia.Value); //BindToDropdown(cboMedia, str); } LoadAttachmentsType(_news_id); } }