public async Task <SecuritySettingDto> GetSecuritySetting() { var helper = GetReadHelper(); const string sql = @"select Code,Value from SysSettingValue where Code in ('UseDevelopment','IpFilterType','Logo','UseRecordPassword','LoginPassword','ManagerPassword','UseMachineCode','FirstLoginUseMachineCode' ,'CookieTimes','UseWatermark','WatermarkText')"; var list = await helper.Select_Async <DbSysSettingValue>(sql); SecuritySettingDto dto = new SecuritySettingDto(); dto.UseDevelopment = list.Where(q => q.Code == "UseDevelopment").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.IpFilterType = list.Where(q => q.Code == "IpFilterType").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.Logo = list.Where(q => q.Code == "Logo").FirstOrDefault().SelectNull(q => q.Value); dto.UseRecordPassword = list.Where(q => q.Code == "UseRecordPassword").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.LoginPassword = list.Where(q => q.Code == "LoginPassword").FirstOrDefault().SelectNull(q => q.Value); dto.ManagerPassword = list.Where(q => q.Code == "ManagerPassword").FirstOrDefault().SelectNull(q => q.Value); dto.UseMachineCode = list.Where(q => q.Code == "UseMachineCode").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.FirstLoginUseMachineCode = list.Where(q => q.Code == "FirstLoginUseMachineCode").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.CookieTimes = list.Where(q => q.Code == "CookieTimes").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.UseWatermark = list.Where(q => q.Code == "UseWatermark").FirstOrDefault().SelectNull(q => q.Value).ToSafeInt32(0); dto.WatermarkText = list.Where(q => q.Code == "WatermarkText").FirstOrDefault().SelectNull(q => q.Value); return(dto); }
public async Task <IActionResult> OnGet() { Dto = await _adminSecurityApplication.GetSecuritySetting(); return(Page()); }