public async Task <ResponseModel> GetCompanyInfo([FromQuery] EntityCompanySearch entityCompany)
{
if (entityCompany == null)
{
entityCompany = new EntityCompanySearch();
}
var result = await ICompanyService.GetCompanyInfo(entityCompany);
return(Success(result));
}
/// <summary>
/// 暂时不支持分页
/// </summary>
/// <param name="entityCompany"></param>
/// <returns></returns>
public async Task <List <TableCompany> > GetCompanyInfo(EntityCompanySearch entityCompany)
{
var companyRep = GetRepositoryInstance <TableCompany>();
var strSql = new StringBuilder();
strSql.Append(@"SELECT Id ,
CompanyName ,
Provice ,
City ,
County ,
AddressDetail ,
Longitude ,
Latitude ,
Industry ,
Economy ,
CompanyDetail ,
ZipCode ,
FoundedTime ,
IssureTime ,
IndustryCode ,
Owner ,
CompanyScale ,
CompanyIncome ,
ChiefSafeyName ,
ChiefSafeyPhone ,
ViceSafeyName ,
ViceSafeyPhone ,
OnDutyPhone ,
EmergencyPhone ,
CompanyProductDetail ,
CreateTime ,
Memo ,
Status ,
RiskLevel ,
ProvCode ,
CityCode ,
CountyCode FROM T_Company WITH 1= 1 ");
if (!string.IsNullOrEmpty(entityCompany.CountryCode) && entityCompany.CountryCode != "0")
{
strSql.Append(" and CountyCode = @countryCode ");
}
if (!string.IsNullOrEmpty(entityCompany.CompanyName))
{
strSql.Append(" and CompanyName like '%' +@companyName + '%'");
}
if (entityCompany.RiskLevel != 0)
{
strSql.Append(" and RiskLevel = @riskLevel ");
}
var paras = new DynamicParameters(new
{
countryCode = entityCompany.CountryCode,
companyName = entityCompany.CompanyName,
riskLevel = entityCompany.RiskLevel,
});
var restult = companyRep.FindAll(new SqlQuery(strSql.ToString(), paras)).ToList();
return(restult);
}
