//Load dữ liệu vào ListView private void LoadListViewData() { DAArticle da = new DAArticle(); DataTable dt = new DataTable(); try { dt.Load(da.USP_Article_Client_GetPageArticle(23, 0)); if (dt.Rows.Count > 0) { lvData.DataSource = dt; lvData.DataBind(); //Reset lai pager //dpData.SetPageProperties(0, dpData.PageSize, true); //lblPage.Text = "Trong tổng cộng " + ((dpData.TotalRowCount / dpData.PageSize) + 1).ToString() + " trang"; if (dt.Rows.Count <= 5) { dvPaging.Visible = false; } else { dvPaging.Visible = true; } } } catch { } finally { da.Close(); } }
private void LoadHotArticle() { try { DataTable mTable = new DataTable(); DAArticle oData = new DAArticle(); mTable.Load(oData.USP_Article_Client_GetHot()); //if (mTable.Rows.Count > 0) //{ // imgLink.ImageUrl = mTable.Rows[0]["ImgLink"].ToString(); // imgLink.AlternateText = mTable.Rows[0]["Title"].ToString(); // lblTitle.Text = mTable.Rows[0]["Title"].ToString(); // lblDescription.Text = mTable.Rows[0]["Description"].ToString(); // mTable.Rows.RemoveAt(0); //} // Load tin khác rptHotNews.DataSource = mTable; rptHotNews.DataBind(); } catch { } }
// Hiển thị chi tiết private void LoadArticle() { try { DataTable mTable = new DataTable(); DAArticle oData = new DAArticle(); mTable.Load(oData.USP_Article_Client_GetTop()); if (mTable.Rows.Count > 0) { imgLink.ImageUrl = mTable.Rows[0]["ImgLink"].ToString(); imgLink.AlternateText = mTable.Rows[0]["Title"].ToString(); //lblTitle.Text = mTable.Rows[0]["Title"].ToString(); lblDate.Text = Convert.ToDateTime(mTable.Rows[0]["PublishDate"]).ToString("dd"); lblMonth.Text = Convert.ToDateTime(mTable.Rows[0]["PublishDate"]).ToString("MM"); lblDescription.Text = mTable.Rows[0]["Description"].ToString(); hplTitle.Text = mTable.Rows[0]["Title"].ToString(); hplTitle.NavigateUrl = mTable.Rows[0]["UrlRewrite"].ToString(); hplLink.NavigateUrl = mTable.Rows[0]["UrlRewrite"].ToString(); hplDetail.NavigateUrl = mTable.Rows[0]["UrlRewrite"].ToString(); mTable.Rows.RemoveAt(0); } // Load tin khác rptArticle.DataSource = mTable; rptArticle.DataBind(); } catch { } }
override protected int DeleteByID(int pID) { try { DAArticle DAArticle = new DAArticle(); DAArticle.USP_Article_Delete(pID); return(1); } catch { return(0); } }
override protected int ExecUpdate() { // Update with ID = this.ID try { DAArticle DAArticle = CreateObjectFromPage(); DAArticle.fID = this.KeyID; DAArticle.USP_Article_Update(); return(1); } catch { return(0); } }
private void LoadNotification() { try { DataTable dt = new DataTable(); DAArticle oData = new DAArticle(); dt.Load(oData.USP_Article_Client_GetNotification()); rptNotification.DataSource = dt; rptNotification.DataBind(); } catch { } }
private void LoadAbout() { try { DataTable dt = new DataTable(); DAArticle oData = new DAArticle(); dt.Load(oData.USP_Article_Client_GetAbout()); rptAbout.DataSource = dt; rptAbout.DataBind(); } catch { } }
private void LoadFooter() { try { DataTable dt = new DataTable(); DAArticle oData = new DAArticle(); dt.Load(oData.USP_Article_Client_GetFooter()); if (dt.Rows.Count > 0) { divFooter.InnerHtml = dt.Rows[0]["Content"].ToString(); } } catch { } }
private void LoadHotArticle() { try { DataTable mTable = new DataTable(); DAArticle oData = new DAArticle(); mTable.Load(oData.USP_Article_Client_GetHot()); // Load tin khác rptHotNews.DataSource = mTable; rptHotNews.DataBind(); } catch { } }
override protected Boolean LoadData() { try { // Load Data For Page. DAArticle daArticle = new DAArticle(); daArticle.USP_Article_GetFullID(this.KeyID); // fCategoryID.Value = daArticle.fCategoryID.ToString(); fTitle.Value = daArticle.fTitle.ToString(); fDescription.Value = daArticle.fDescription.ToString(); fContent.Content = daArticle.fContent.ToString(); fUrlRewrite.Value = daArticle.fUrlRewrite.ToString(); fImgLink.ImageUrl = "~" + daArticle.fImgLink.ToString(); fIsComment.Checked = daArticle.fIsComment; fNew.Value = daArticle.fNew.ToString(); fHot.Value = daArticle.fHot.ToString(); fViewNumber.Value = daArticle.fViewNumber.ToString(); fRecordStatusID.Value = daArticle.fRecordStatusID.ToString(); fPublishDate.SelectedDate = daArticle.fPublishDate; fMetaTitle.Value = daArticle.fMetaTitle.ToString(); fMetaDescription.Value = daArticle.fMetaDescription.ToString(); fMetaKeywords.Value = daArticle.fMetaKeywords.ToString(); fTags.Value = daArticle.fTags.ToString(); // // Khi cần enabled cột nào //if (this.KeyID > 0) //{ // if (mode != Act.Clone) // fUserName.Enabled = false; // else // fUserName.Text = ""; //} } catch (Exception e) { ShowErrorMes("Lỗi hệ thống: " + e.ToString()); return(false); } return(true); }
private DAArticle CreateObjectFromPage() { // check DAArticle daArticle = new DAArticle(); // daArticle.fCategoryID = Convert.ToInt32(fCategoryID.Value.Trim()); daArticle.fTitle = fTitle.Value.Trim(); daArticle.fTitleNosign = Utils.convertToUnSign2(fTitle.Value); daArticle.fDescription = fDescription.Value.Trim(); daArticle.fContent = fContent.Content; daArticle.fUrlRewrite = fUrlRewrite.Value.Trim(); HttpPostedFile file = inputFile.PostedFile; if (file != null && file.ContentLength > 0) { //Delete old file Utils.DeleteFile(fImgLink.ImageUrl, Server); daArticle.fImgLink = Utils.UploadImage(file, Server, "~/Media/Article"); } else { daArticle.fImgLink = fImgLink.ImageUrl.Replace("~", ""); } fImgLink.ImageUrl = "~" + daArticle.fImgLink; daArticle.fIsComment = fIsComment.Checked; daArticle.fNew = Convert.ToByte(fNew.Value.Trim()); daArticle.fHot = Convert.ToByte(fHot.Value.Trim()); daArticle.fViewNumber = Convert.ToInt32(fViewNumber.Value.Trim()); daArticle.fRecordStatusID = Convert.ToInt32(fRecordStatusID.Value.Trim()); daArticle.fPublishDate = Convert.ToDateTime(fPublishDate.SelectedDate); daArticle.fMetaTitle = fMetaTitle.Value.Trim(); daArticle.fMetaDescription = fMetaDescription.Value.Trim(); daArticle.fMetaKeywords = fMetaKeywords.Value.Trim(); daArticle.fTags = fTags.Value.Trim(); daArticle.fOperator = MySession.UserName; // return(daArticle); }
override protected int ExecInsert() { try { DAArticle DAArticle = CreateObjectFromPage(); if (this.mode == ActParam.New) { DAArticle.fID = DAArticle.USP_GetKey(); this.KeyID = DAArticle.fID; // --> Update new SessionID for continue edit. } else { DAArticle.fID = 0; } DAArticle.USP_Article_Insert(); return(1); } catch { return(0); } }
// Hiển thị chi tiết private void LoadDataDetail(Int32 AID) { try { DataTable mTable = new DataTable(); DAArticle oData = new DAArticle(); mTable.Load(oData.USP_Article_Client_GetDetail(AID)); String sDes, sKey; if (mTable.Rows.Count > 0) { lblTitle.Text = mTable.Rows[0]["Title"].ToString(); lblOperator.Text = mTable.Rows[0]["Operator"].ToString(); lblDate.Text = Convert.ToDateTime(mTable.Rows[0]["PublishDate"]).ToString("MMMM dd, yyyy"); lblView.Text = mTable.Rows[0]["ViewNumber"].ToString(); lblContent.Text = mTable.Rows[0]["Content"].ToString(); sDes = mTable.Rows[0]["MetaDescription"].ToString(); sKey = mTable.Rows[0]["MetaKeywords"].ToString(); // Add Tieu de Page.Header.Title = mTable.Rows[0]["MetaTitle"].ToString(); // Create two instances of an HtmlMeta control. HtmlMeta hm1 = new HtmlMeta(); HtmlMeta hm2 = new HtmlMeta(); // Define an HTML <meta> element - description - that is useful for search engines. hm1.Name = "description"; hm1.Content = sDes; // Define an HTML <meta> element - keywords - that is useful for search engines. hm2.Name = "keywords"; hm2.Content = sKey; // clsCommon.ConvertToUnSign(sDes); // Get a reference to the page header element. HtmlHead head = (HtmlHead)Page.Header; head.Controls.Add(hm1); head.Controls.Add(hm2); // Load tin khác mTable.Rows.RemoveAt(0); //if (dr.HasRows) // dvOther.Visible = true; //else // dvOther.Visible = false; rptOther.DataSource = mTable; rptOther.DataBind(); } } catch { } }