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);
}
}
}
}
