摘要:
page 当前页,pageSize 每页大小 1、 order by [字段] offset [preIndex] rows fetch next [rowNum] rows only select * from ( select row_number() over(order by createT 阅读全文
摘要:
#List拼接SQL中in条件 ⼀、拼接字符串类型的字段string sql = @"select distinct ziduan from tablename where ziduan in ('{0}')";sql=string.Format(sql, string.Join("','", li 阅读全文