コード例 #1
0
        private void Load_Detail(double _id)
        {
            type = int.Parse(cbo_types.SelectedValue);
            T_BaoCao _DAL = new T_BaoCao();
            DataSet  _ds;

            _ds = _DAL.BindGridT_ActionHistory_Detail(_id, type);
            grdDetail.DataSource = _ds;
            grdDetail.DataBind();
            _ds.Clear();
        }
コード例 #2
0
 public void LoadData()
 {
     if ((!string.IsNullOrEmpty(txt_FromDate.Text.Trim())) && (!string.IsNullOrEmpty(txt_ToDate.Text.Trim())))
     {
         T_BaoCao _DAL = new T_BaoCao();
         DataSet  _ds;
         _ds = GetDataByCallSP("CMS_List_HitCounter", txt_FromDate.Text.Trim(), txt_ToDate.Text.Trim(), Int32.Parse(ddlCate.SelectedValue));
         grdListHistory.DataSource = _ds;
         grdListHistory.DataBind();
     }
     else
     {
         grdListHistory.DataSource = null;
         grdListHistory.DataBind();
         System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('Hãy nhập khoảng thời gian tìm kiếm!');", true);
     }
 }
コード例 #3
0
        private void LoadMutimedia()
        {
            string where = " 1=1 ";
            if (!String.IsNullOrEmpty(this.txtTieude.Text.Trim()))
            {
                where += " AND T_Multimedia.Tittle like N'%" + UltilFunc.SqlFormatText(this.txtTieude.Text.Trim()) + "%'";
            }
            if (cboNgonNgu.SelectedIndex > 0)
            {
                where += " AND Languages_ID=" + cboNgonNgu.SelectedValue.ToString();
            }
            if (cbo_chuyenmuc.SelectedIndex > 0)
            {
                where += " AND " + string.Format(" T_Multimedia.Category IN (SELECT * FROM [dbo].[fn_Return_Category_Tree] ({0}))", cbo_chuyenmuc.SelectedValue);
            }
            if (!String.IsNullOrEmpty(this.txt_FromDate.Text.Trim()))
            {
                where += " AND T_Multimedia.DatePublish  >='" + txt_FromDate.Text + " 00:00:01'";
            }
            if (!String.IsNullOrEmpty(this.txt_ToDate.Text.Trim()))
            {
                where += " AND T_Multimedia.DatePublish  <='" + txt_ToDate.Text + " 23:59:59'";
            }
            pages.PageSize = 20;
            T_BaoCao _DAL = new T_BaoCao();
            DataSet  _ds;

            _ds = _DAL.BindGridT_ActionHistory_AmThanhHinhAnh(pages.PageIndex, pages.PageSize, where);

            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 = _DAL.BindGridT_ActionHistory_AmThanhHinhAnh(pages.PageIndex - 1, pages.PageSize, where);
            }
            grdList.DataSource = _ds;
            grdList.DataBind(); _ds.Clear();
            pages.TotalRecords     = currentPage.TotalRecords = TotalRecords;
            currentPage.TotalPages = pages.CalculateTotalPages();
            currentPage.PageIndex  = pages.PageIndex;
        }
コード例 #4
0
        private void LoadThoiSuAnh()
        {
            string where = " 1=1 ";
            if (!String.IsNullOrEmpty(this.txtTieude.Text.Trim()))
            {
                where += " AND T_Photo_Event.Photo_Name like N'%" + UltilFunc.SqlFormatText(this.txtTieude.Text.Trim()) + "%'";
            }
            if (cboNgonNgu.SelectedIndex > 0)
            {
                where += " AND Lang_ID=" + cboNgonNgu.SelectedValue.ToString();
            }
            if (!String.IsNullOrEmpty(this.txt_FromDate.Text.Trim()))
            {
                where += " AND T_Photo_Event.Date_Update  >='" + txt_FromDate.Text + " 00:00:01'";
            }
            if (!String.IsNullOrEmpty(this.txt_ToDate.Text.Trim()))
            {
                where += " AND T_Photo_Event.Date_Update  <='" + txt_ToDate.Text + " 23:59:59'";
            }
            pages.PageSize = 20;
            T_BaoCao _DAL = new T_BaoCao();
            DataSet  _ds;

            _ds = _DAL.BindGridT_ActionHistory_TsAnh(pages.PageIndex, pages.PageSize, where);

            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 = _DAL.BindGridT_ActionHistory_TsAnh(pages.PageIndex - 1, pages.PageSize, where);
            }
            grdList.DataSource = _ds;
            grdList.DataBind(); _ds.Clear();
            pages.TotalRecords     = currentPage.TotalRecords = TotalRecords;
            currentPage.TotalPages = pages.CalculateTotalPages();
            currentPage.PageIndex  = pages.PageIndex;
        }