コード例 #1
0
        public static List <TinTuc_Info> DanhSachBaiViet(int trang = 1, string tukhoa = "", string chuyenmucid = "", int sotintuc = 3)
        {
            List <TinTuc_Info> items    = new List <TinTuc_Info>();
            DBHelp             db       = new DBHelp();
            string             dieukien = " WHERE 1=1";

            if (tukhoa != "")
            {
                dieukien += " and TenTinTuc like @tukhoa";
            }
            if (chuyenmucid != "")
            {
                dieukien += " and ChuyenMucID = @chuyenmucid";
            }
            db.SetCommandText("SELECT * FROM (SELECT *, ROW_NUMBER() OVER(ORDER BY NgayDang DESC) AS RowNum  FROM dbo.TinTuc " + dieukien + ") AS t WHERE t.RowNum BETWEEN (@trang-1)*@sotintuc+1 AND @trang*@sotintuc", System.Data.CommandType.Text);
            db.AddParameter("@trang", trang);
            db.AddParameter("@sotintuc", sotintuc);
            if (tukhoa != "")
            {
                db.AddParameter("@tukhoa", "%" + tukhoa + "%");
            }
            if (chuyenmucid != "")
            {
                db.AddParameter("@chuyenmucid", chuyenmucid);
            }
            System.Data.DataTable t = new System.Data.DataTable();
            db.FillDataTable(t);
            for (int i = 0; i < t.Rows.Count; i++)
            {
                TinTuc_Info item = new TinTuc_Info();
                item.Id          = Guid.Parse(t.Rows[i]["id"].ToString());
                item.Tentintuc   = t.Rows[i]["tentintuc"].ToString();
                item.Mota        = t.Rows[i]["mota"].ToString();
                item.Chitiet     = t.Rows[i]["chitiet"].ToString();
                item.Hinhanh     = t.Rows[i]["hinhanh"].ToString();
                item.Ngaydang    = DateTime.Parse(t.Rows[i]["ngaydang"].ToString());
                item.Chuyenmucid = Guid.Parse(t.Rows[i]["chuyenmucid"].ToString());
                item.Nguoidang   = t.Rows[i]["nguoidang"].ToString();

                items.Add(item);
            }
            return(items);
        }
コード例 #2
0
        public static TinTuc_Info LayTinTuc(string TinTucID)
        {
            TinTuc_Info item = new TinTuc_Info();
            DBHelp      db   = new DBHelp();

            db.SetCommandText("SELECT * FROM TinTuc WHERE id=@id", System.Data.CommandType.Text);
            db.AddParameter("@id", TinTucID);
            System.Data.DataTable t = new System.Data.DataTable();
            db.FillDataTable(t);
            if (t.Rows.Count > 0)
            {
                item.Id          = Guid.Parse(t.Rows[0]["id"].ToString());
                item.Tentintuc   = t.Rows[0]["tentintuc"].ToString();
                item.Mota        = t.Rows[0]["mota"].ToString();
                item.Chitiet     = t.Rows[0]["chitiet"].ToString();
                item.Hinhanh     = t.Rows[0]["hinhanh"].ToString();
                item.Ngaydang    = DateTime.Parse(t.Rows[0]["ngaydang"].ToString());
                item.Chuyenmucid = Guid.Parse(t.Rows[0]["chuyenmucid"].ToString());
                item.Nguoidang   = t.Rows[0]["nguoidang"].ToString();
            }
            return(item);
        }