Beispiel #1
0
        public JsonPager <CompoundInfo> PageComoundList(CompoundQInfo qInfo)
        {
            Sql sql = new Sql("select  * from  [dbo].[CompoundLibrary] where 1 = 1  ");
            Page <CompoundInfo>      pagedata = _db.Page <CompoundInfo>(qInfo.Page, qInfo.ItemsPerPage, sql);
            JsonPager <CompoundInfo> ret      = new JsonPager <CompoundInfo>();

            ret.result = pagedata.Items;
            ret.total  = pagedata.TotalItems;
            return(ret);
        }
Beispiel #2
0
        public JsonPager <Employee> PageUser(EmployeeQryInfo qInfo)
        {
            Sql sql = new Sql("select badge,name UserName,[compid] Company,[depcname] Department from [users] where status<>'Loff'");

            if (!string.IsNullOrEmpty(qInfo.UserName))
            {
                sql.Append(" and name like @0", "%" + qInfo.UserName + "%");
            }

            if (qInfo.OrderBy != null && qInfo.OrderBy.Length > 0)
            {
                sql.AddOrderBy(qInfo.OrderBy);
            }
            ;

            var pageData = _db.Page <Employee>(qInfo.Page, qInfo.ItemsPerPage, sql);

            JsonPager <Employee> ret = new JsonPager <Employee>();

            ret.result = pageData.Items;
            ret.total  = pageData.TotalItems;
            return(ret);
        }