Exemplo n.º 1
0
        public List <Like> GetPageList(int start, int end)
        {
            string sql = "select * from(select *,row_number()over(order by id) as num from Likes) as t where t.num between @start and @end";

            SqlParameter[] ps = new SqlParameter[]
            {
                new SqlParameter("@start", start),
                new SqlParameter("@end", end),
            };
            DataTable dt = DbHelper.GetDataTable(sql, ps);

            if (dt != null && dt.Rows.Count < 1)
            {
                return(null);
            }
            List <Model.Like> models = new List <Model.Like>();

            for (int i = 0; i < dt.Rows.Count; ++i)
            {
                Model.Like model = new Model.Like();
                model.UserId    = Convert.ToInt32(dt.Rows[0]["Id"]);
                model.ProjectId = Convert.ToInt32(dt.Rows[0]["ClassifyName"]);
                models.Add(model);
            }
            return(models);
        }
Exemplo n.º 2
0
        public List <Like> GetPageListWhereTo(int start, int end, Dictionary <string, object> where)
        {
            StringBuilder       sql   = new StringBuilder("select * from(select *,row_number()over(order by id) as num from Likes) as t where t.num between @start and @end");
            List <SqlParameter> pList = new List <SqlParameter>()
            {
                new SqlParameter("@start", start),
                new SqlParameter("@end", end),
            };

            if (where != null && where.Count() > 0)
            {
                foreach (var item in where)
                {
                    sql.Append($" and {item.Key}=@{item.Value}");
                    pList.Add(new SqlParameter("@" + item.Key, item.Value));
                }
            }
            DataTable dt = DbHelper.GetDataTable(sql.ToString(), pList.ToArray());

            if (dt != null && dt.Rows.Count < 1)
            {
                return(null);
            }
            List <Model.Like> models = new List <Model.Like>();

            for (int i = 0; i < dt.Rows.Count; ++i)
            {
                Model.Like model = new Model.Like();
                model.UserId    = Convert.ToInt32(dt.Rows[0]["Id"]);
                model.ProjectId = Convert.ToInt32(dt.Rows[0]["ClassifyName"]);
                models.Add(model);
            }
            return(models);
        }
Exemplo n.º 3
0
        public Like GetModel(int id)
        {
            string       sql = "select * from Likes where Id=@id";
            SqlParameter p   = new SqlParameter("@id", id);
            DataTable    dt  = DbHelper.GetDataTable(sql, p);

            if (dt != null && dt.Rows.Count < 1)
            {
                return(null);
            }
            Model.Like model = new Model.Like();
            model.UserId    = Convert.ToInt32(dt.Rows[0]["Id"]);
            model.ProjectId = Convert.ToInt32(dt.Rows[0]["ClassifyName"]);
            return(model);
        }