public async Task <string> QueryPagedAsync([FromQuery] RightSearchParam param) { var filter = param.SearchLambda <TRight, RightSearchParam>(); var result = await _iTRightRepository.QueryPagedAsync(param.Page, param.Limit, null, filter); var pageData = new LayuiTableDto <TRight> { Code = "0", Msg = "获取数据成功", Count = result.TotalResults, Data = result.Items.ToList() }; var json = JsonConvert.SerializeObject(pageData); return(json); }
public static List <Module> ModuleGet() { var dbUtil = new DatabaseManager(); var Modules = new List <Module>(); using (var conn = new SqlConnection(dbUtil.getSQLConnectionString("MainDB"))) { conn.Open(); using (SqlCommand cmd = conn.CreateCommand()) { cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "spMasModuleGet"; cmd.CommandTimeout = 180; using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { var RightSearchParam = new RightSearchParam { strCriteria = ReferenceEquals(reader["ID"], DBNull.Value) ? Convert.ToString(0) : Convert.ToString(reader["ID"]) }; string strXML = WebCommon.ToXML(RightSearchParam); var Module = new Module { ID = ReferenceEquals(reader["ID"], DBNull.Value) ? Convert.ToUInt16(0) : Convert.ToUInt16(reader["ID"]), strName = ReferenceEquals(reader["strName"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strName"]), strCode = ReferenceEquals(reader["strCode"], DBNull.Value) ? string.Empty : Convert.ToString(reader["strCode"]), objRight = RightGet(strXML), }; Modules.Add(Module); } return(Modules); } } } }