//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
{
}
}
