string sql = @"select [Name],[Value],[TypeCode]
from [dbo].[SYS_Parameter]
WHERE TypeCode = 'UserSystem' AND Status = 1 ORDER BY TypeCode,OrderNum ";
//string sql = @"SELECT Code,Name,Value,TypeCode,TypeName
// FROM dbo.SYS_Parameter
// WHERE TypeCode IN ('UserType','Nature','PaperType','GenderType','Nationality','Nation','Education','MaritalType','RegistAddress')
// AND Status = 1 ORDER BY TypeCode,OrderNum";
List<MDM_SYS_Parameter> allSelectList = MDMDapperHelper.GetListBySqlstr<MDM_SYS_Parameter>(sql)?.ToList();
var maxpage=(int)Math.Ceiling((float)allSelectList.Count /pageSize);
pageNumber = pageNumber < 1 ? 1 : pageNumber;
pageNumber = pageNumber> maxpage?maxpage: maxpage;
var resultList = allSelectList.Skip((pageNumber - 1) * pageSize).Take(pageSize)?.ToList();
//var list = BPMModelManager.Main_NewsRecordDAO.RetrieveByPage(pageNumber - 1, pageSize, "CreateTime", true,
// sb.ToString(), ref rowCount);
//var userList = BaseModelManager.UserDAO.RetrieveListByUserIds(string.Join(",", list.Select(o => o.CreateUserId)));
return JsonConvert.SerializeObject(new
{
total = allSelectList.Count,
items = resultList
});
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步