Example #1
0
 public void LoadData_FilePDF()
 {
     string _where = GetWhereFilePDF();
     string _sql = "select * from T_Publish_Pdf where " + _where;
     DataSet _ds = _daltinbai.Sp_SelectT_Publish_PdfDynamic(_where, " ID DESC");
     this.DataGrid_FilePDF.DataSource = _ds;
     this.DataGrid_FilePDF.DataBind();
 }
Example #2
0
        public void LoadData_FilePDF()
        {
            string _where = "Status=1";

            if (cboPage.SelectedIndex > 0)
            {
                _where += " and Page_Number=" + cboPage.SelectedValue;
            }
            if (cboSoBao.SelectedIndex > 0)
            {
                _where += " and Publish_Number_ID=" + cboSoBao.SelectedValue;
            }
            if (txt_tungay.Text.Trim() != "" && txt_denngay.Text.Trim() != "")
            {
                _where += " AND Publish_Number_ID in (select Ma_Sobao from T_Sobao where Ngay_Xuatban>='" + txt_tungay.Text.Trim() + " 00:00:00' and Ngay_Xuatban<='" + txt_denngay.Text.Trim() + " 23:59:59')";
            }
            string  _sql = "select * from T_Publish_Pdf where " + _where;
            DataSet _ds  = Daltinbai.Sp_SelectT_Publish_PdfDynamic(_where, " ID ASC");

            this.DataGrid_FilePDF.DataSource = _ds;
            this.DataGrid_FilePDF.DataBind();
        }