Example #1
0
 public void getDataPhai(string nguonPhai)
 {
     DataTable dt, dtTemp;
     string catName, catLink;
     zClass ob = new zClass();
     dt = ob.nsHOME(nguonPhai, out dtTemp, out catName, out catLink);
     rbPhai.Text = catName;
     if (Settings["TieuDePhai"] != null) rbPhai.Text = Settings["TieuDePhai"].ToString();
     if (rbPhai.Text == "") rbPhai.Text = catName;
     rbPhai.NavigateUrl = catLink;
     GridView3.DataSource = dtTemp;
     GridView3.DataBind();
     try
     {
         lkTieuDePhai.Text = dt.Rows[0][1].ToString();
         lkTieuDePhai.NavigateUrl = dt.Rows[0][4].ToString();
         ImagePhai.ImageUrl = dt.Rows[0][2].ToString();
         lbContentPhai.Text = dt.Rows[0][3].ToString();
     }
     catch 
     {
         lkTieuDePhai.Text = "";
         ImagePhai.Width = 0;
     }
 }
Example #2
0
 protected void Page_Load(object sender, EventArgs e)
 {
     string newsID = Request.QueryString["id"];
     try
     {
         zClass ob = new zClass();
         //DataTable dt = ob.zGetNews(newsID, out dtTinKhac);
         DataTable dtTemp;
         DataTable dt = ob.ASP_nsVIEW(newsID, out dtTemp);
         if ((dt.Rows[0][8].ToString() == "False") && (UserInfo.IsInRole("DuyetTin") == false) && (UserInfo.IsInRole("DangTin") == false))
         {
             lbHeadline.Text = "Không tìm thấy bài viết!";
             return;
         }
         hlCatName.Text = dt.Rows[0][1].ToString();
         hlCatName.NavigateUrl = ob.GET_CAT_LINK(dt.Rows[0][0].ToString());
         lbHeadline.Text = dt.Rows[0][2].ToString();
         lbDate.Text = dt.Rows[0][5].ToString();
         lbContent.Text = dt.Rows[0][7].ToString();
         if (dt.Rows[0][4].ToString() != "") lbSource.Text = "Theo " + dt.Rows[0][4].ToString();
         lbTotalView.Text = dt.Rows[0][6].ToString() + " lượt xem.";
         GridView1.DataSource = dtTemp;
         GridView1.DataBind();
     }
     catch
     {
         lbHeadline.Text = "Không tìm thấy bài viết.";
     }
 }
 public override void LoadSettings()
 {
     zClass ob = new zClass();
     DataTable dt = ob.GET_CAT_LIST("");
     DataRow dr = dt.NewRow();
     dr[0] = "HOT";
     dr[1] = "Tin nổi bật";
     dt.Rows.InsertAt(dr, 0);
     dr = dt.NewRow();
     dr[0] = "VIEW";
     dr[1] = "Tin đọc nhiều";
     dt.Rows.InsertAt(dr, 0);
     dr = dt.NewRow();
     dr[0] = "NEW";
     dr[1] = "Tin mới nhất";
     dt.Rows.InsertAt(dr, 0);
     DropDownList1.DataSource = dt;
     DropDownList1.DataTextField = "CatName";
     DropDownList1.DataValueField = "CatID";
     DropDownList1.DataBind();
     DropDownList2.DataSource = dt;
     DropDownList2.DataTextField = "CatName";
     DropDownList2.DataValueField = "CatID";
     DropDownList2.DataBind();
     try
     {
         if (ModuleSettings["Nguon"] != null) DropDownList1.SelectedValue = ModuleSettings["Nguon"].ToString();
         if (ModuleSettings["TieuDe"] != null) TextBox1.Text = ModuleSettings["TieuDe"].ToString();
         if (ModuleSettings["NguonPhai"] != null) DropDownList2.SelectedValue = ModuleSettings["NguonPhai"].ToString();
         if (ModuleSettings["TieuDePhai"] != null) TextBox2.Text = ModuleSettings["TieuDePhai"].ToString();
     }
     catch { }
 }
        public override void LoadSettings()
        {
            try
            {
                if (ModuleSettings["SQL"] != null) tbSQL.Text = ModuleSettings["SQL"].ToString();

                if (ModuleSettings["Nguon"] != null) DropDownList1.SelectedValue = ModuleSettings["Nguon"].ToString();
                if (ModuleSettings["Trang"] != null) TextBox1.Text = ModuleSettings["Trang"].ToString();
                zClass ob = new zClass();
                const string st = "SELECT CatID, CatName FROM News_Category";                
                SqlParameter[] para = new SqlParameter[0];
                DataTable dt = ob.CMD_SELECT(st, para).Tables[0];
                DataRow dr = dt.NewRow();
                dr[0] = "URL";
                dr[1] = "[Default] Lấy từ URL";
                dt.Rows.InsertAt(dr, 0);
                dr = dt.NewRow();                
                dr[0] = "SQL";
                dr[1] = "* T-SQL";
                dt.Rows.Add(dr);
                DropDownList1.DataSource = dt;
                DropDownList1.DataTextField = "CatName";
                DropDownList1.DataValueField = "CatID";
                DropDownList1.DataBind();
            }
            catch { }
        }
Example #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         catID = "URL";
         if (Settings["Nguon"] != null) catID = Settings["Nguon"].ToString();
         if (catID == "URL") catID = Request.QueryString["categoryid"].ToString();
         zClass ob = new zClass();
         string catName = "-";
         //DataTable dt = ob.zGetNewsCat(catID, out catName);
         DataTable dt = ob.ASP_nsLIST(catID, out catName);
         lbCatName.Text = catName;
         page = 10;
         if (Settings["Trang"] != null) page = Convert.ToInt32(Settings["Trang"].ToString());
         GridView1.PageSize = page;
         GridView1.DataSource = dt;
         GridView1.DataBind();
         if (UserInfo.IsInRole("DangTin") || UserInfo.IsInRole("DuyetTin"))
         {
             hlAddNews.Visible = true;
             hlAddNews.NavigateUrl = DotNetNuke.Common.Globals.NavigateURL(PortalSettings.ActiveTab.TabID, "nsQLTT", "mid/" + this.ModuleId.ToString());
             hlYahoo.Visible = true;
         }
         else
         {
             hlAddNews.Visible = false;
             hlYahoo.Visible = false;
         }
     }
     catch { }
 }
Example #6
0
 protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
 {
     GridView1.PageIndex = e.NewPageIndex;
     zClass ob = new zClass();
     string catName = "";
     //DataTable dt = ob.zGetNewsCat(catID, out catName);
     DataTable dt = ob.ASP_nsLIST(catID, out catName);
     GridView1.PageSize = page;
     GridView1.DataSource = dt;
     GridView1.DataBind();
 }
Example #7
0
 protected void Page_Load(object sender, EventArgs e)
 {
     string catID = "";
     if (Settings["Nguon"] != null)
         try
         {
             Int32.Parse(Settings["Nguon"].ToString());
             catID = Settings["Nguon"].ToString();
         }
         catch { }
     if (catID != "") catID = "and N.catid=" + catID;
     int maxNews = 5;
     if (Settings["Trang"] != null)
         try
         {
             maxNews = Int32.Parse(Settings["Trang"].ToString());
         }
         catch { }
     string cmdTxt = string.Format(@"select top {0}
         ID, Headline, N.Description, ImageUrl, CONVERT(CHAR(11), CreatedDate, 103)+CONVERT(CHAR(5), CreatedDate, 108) AS Date, DesktopViewID, CatName 
         from news_news N
         join news_category C
         on N.catid=C.catid
         where N.published=1 {1}
         order by createddate desc", maxNews, catID);
     // Thực thi T-SQL đã nhập
     if (Settings["Nguon"].ToString() == "SQL" && Settings["SQL"] != null) cmdTxt = Settings["SQL"].ToString();
     DataSet ds;
     zClass ob = new zClass();
     catID = ob.zSelectNone(cmdTxt, out ds);
     try
     {
         DataColumn dc = new DataColumn("Link");
         ds.Tables[0].Columns.Add(dc);
         ds.Tables[0].AcceptChanges();
         foreach (DataRow dr in ds.Tables[0].Rows)
         {
             dr.BeginEdit();
             dr["Link"] = DotNetNuke.Common.Globals.NavigateURL(Convert.ToInt32(dr[5].ToString()), "", "id/" + dr[0].ToString());
             dr.EndEdit();
         }
         lbCatName.Text = ds.Tables[0].Rows[0][6].ToString();
         gvCatList.DataSource = ds;
         gvCatList.DataBind();
     }
     catch { }
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     // Get Data
     DataTable dt, dtTemp;
     string nguon = "NEW", catName, catLink;
     if (Settings["Nguon"] != null) nguon = Settings["Nguon"].ToString();
     zClass ob = new zClass();
     //dt = ob.nsHOME(nguon, out dtTemp, out catName, out catLink);
     dt = ob.news_getNewsByCatID(nguon, out dtTemp, out catName, out catLink);
     // Bind Data
     try
     {
         txtCAT.Text = catName;
         txtCAT.NavigateUrl = catLink;
         txtIMG.ImageUrl = dt.Rows[0][2].ToString();
         txtTITLE.Text = dt.Rows[0][1].ToString();
         txtTITLE.NavigateUrl = dt.Rows[0][4].ToString();
         txtDESCRIP.Text = dt.Rows[0][3].ToString();
         imgNew.Visible = Int32.Parse(dt.Rows[0]["DD"].ToString()) <= 3;
         if (dtTemp.Rows.Count > 0)
         {
             hl1st.Text = dtTemp.Rows[0][1].ToString();
             hl1st.NavigateUrl = dtTemp.Rows[0][2].ToString();
             imgNew1.Visible = Int32.Parse(dtTemp.Rows[0]["DD"].ToString()) <= 3;
         }
         if (dtTemp.Rows.Count > 1)
         {
             hl2nd.Text = dtTemp.Rows[1][1].ToString();
             hl2nd.NavigateUrl = dtTemp.Rows[1][2].ToString();
             imgNew2.Visible = Int32.Parse(dtTemp.Rows[1]["DD"].ToString()) <= 3;
         }
         if (dtTemp.Rows.Count > 2)
         {
             hl3rd.Text = dtTemp.Rows[2][1].ToString();
             hl3rd.NavigateUrl = dtTemp.Rows[2][2].ToString();
             imgNew3.Visible = Int32.Parse(dtTemp.Rows[2]["DD"].ToString()) <= 3;
         }
         if (dtTemp.Rows.Count > 3)
         {
             hl4th.Text = dtTemp.Rows[3][1].ToString();
             hl4th.NavigateUrl = dtTemp.Rows[3][2].ToString();
             imgNew4.Visible = Int32.Parse(dtTemp.Rows[3]["DD"].ToString()) <= 3;
         }
     }
     catch { }
 }
 public override void LoadSettings()
 {
     zClass ob = new zClass();
     DataTable dt = ob.GET_CAT_LIST("");
     DataRow dr = dt.NewRow();
     dr[0] = "ALL";
     dr[1] = "All News - Tất cả tin bài";
     dt.Rows.InsertAt(dr, 0);
     DropDownList1.DataSource = dt;
     DropDownList1.DataTextField = "CatName";
     DropDownList1.DataValueField = "CatID";
     DropDownList1.DataBind();
     try
     {
         if (ModuleSettings["Nguon"] != null) DropDownList1.SelectedValue = ModuleSettings["Nguon"].ToString();
         if (ModuleSettings["TuyChon"] != null) RadioButtonList1.SelectedValue = ModuleSettings["TuyChon"].ToString();
     }
     catch { }
 }
Example #10
0
 public string bind_jFlow()
 {
     string jFlow = @"<div id='slides'>";
     string rowText = "";
     string catID = "ALL";
     if (Settings["Nguon"] != null) catID = Settings["Nguon"].ToString();
     string option = "0";
     if (Settings["TuyChon"] != null) option = Settings["TuyChon"].ToString();
     zClass ob = new zClass();
     DataSet ds = ob.nsGetNews(catID, option);
     foreach (DataRow dr in ds.Tables[0].Rows)
     {
         rowText = "<div class='slide-wrapper'><div class='slide-thumbnail'><img src='" + dr[2].ToString()
             + "' /></div><div class='slide-details'><h2><a href='" + dr[1].ToString() + "' class='notLink'>"
             + dr[0].ToString() + "</a></h2><div class='description'>" + dr[3].ToString() + "</div></div><div class='clear'></div></div>";
         jFlow += rowText;
     }
     jFlow += "</div>";
     return jFlow;
 }
 protected void Page_Load(object sender, EventArgs e)
 {
     try
     {
         string catID = "ALL", option = "0"; ;
         if (Settings["Nguon"] != null) catID = Settings["Nguon"].ToString();
         if (Settings["TuyChon"] != null) option = Settings["TuyChon"].ToString();
         zClass ob = new zClass();
         DataTable dt = ob.nsHOT(catID, option);
         // Row 0 
         hl1.Text = dt.Rows[0][1].ToString();
         hl1.NavigateUrl = dt.Rows[0][4].ToString();
         img1.ImageUrl = dt.Rows[0][2].ToString();
         hl11.Text = dt.Rows[0][1].ToString();
         hl11.NavigateUrl = dt.Rows[0][4].ToString();
         img11.ImageUrl = dt.Rows[0][2].ToString();
         // Row 1
         hl2.Text = dt.Rows[1][1].ToString();
         hl2.NavigateUrl = dt.Rows[1][4].ToString();
         img2.ImageUrl = dt.Rows[1][2].ToString();
         hl22.Text = dt.Rows[1][1].ToString();
         hl22.NavigateUrl = dt.Rows[1][4].ToString();
         img22.ImageUrl = dt.Rows[1][2].ToString();
         // Row 2
         hl3.Text = dt.Rows[2][1].ToString();
         hl3.NavigateUrl = dt.Rows[2][4].ToString();
         img3.ImageUrl = dt.Rows[2][2].ToString();
         hl33.Text = dt.Rows[2][1].ToString();
         hl33.NavigateUrl = dt.Rows[2][4].ToString();
         img33.ImageUrl = dt.Rows[2][2].ToString();
         // Row 3
         hl4.Text = dt.Rows[3][1].ToString();
         hl4.NavigateUrl = dt.Rows[3][4].ToString();
         img4.ImageUrl = dt.Rows[3][2].ToString();
         hl44.Text = dt.Rows[3][1].ToString();
         hl44.NavigateUrl = dt.Rows[3][4].ToString();
         img44.ImageUrl = dt.Rows[3][2].ToString();
     }
     catch { }
 }