// 分页条件查询 public PageData <Student> GetData(string Name, string Tel, int PageIndex = 1, int PageSize = 3) { PageData <Student> pd = new PageData <Student>(); pd.PageSize = PageSize; int start = (PageIndex - 1) * PageSize + 1; int end = PageIndex * PageSize; string sql = "from Student where 1=1 "; if (!string.IsNullOrWhiteSpace(Name)) { sql += $" and Name like '%{Name}%'"; } if (!string.IsNullOrWhiteSpace(Tel)) { sql += $" and Tel like '%{Tel}%'"; } // SQL 设置好查询条件 获取总记录数 ,, pd.TotalRecord = DBhelper <Student> .GetData("select * " + sql).Count(); // Sql 设置好分页,获取当前页记录 var pageSql = "select * from ( select Row_number() over(order by Id) as No, * " + sql + $") T where T.No between {start} and {end}"; pd.Data = DBhelper <Student> .GetData(pageSql); return(pd); }
public string GetUrl(string Name) { string sql = $"select * from UserInfo where Name='{Name}'"; return(DBhelper <UserInfo> .GetData(sql).FirstOrDefault()?.Url); }
public UserInfo Login(string Name, string Pass) { string sql = $"select * from UserInfo where Name='{Name}' and Pass = '******'"; return(DBhelper <UserInfo> .GetData(sql).FirstOrDefault()); }