public List <HttpConfig> GetAll()
{
using (var con = DrapperHelper.GetSmartHttpOpenConnection())
{
try
{
var sql = "select * FROM [HttpConfig]";
var ret = con.Query <HttpConfig>(sql).ToList();
return(ret);
}
catch (Exception)
{
return(new List <HttpConfig>());
}
}
}
public static HttpMessage GetByAppIDAndMethod(int AppID, string method, string version)
{
using (var con = DrapperHelper.GetSmartHttpOpenConnection())
{
try
{
var sql = "select Method,Url,AppID,HttpType,Moudle,LoopTime,LoopWaitTime,IsLog,WebServiceTemplate,ContentType,Headers,HttpEncoding,UserAgent,InterfaceArgsCount,InterfaceArgsJsonString,WsExcepitonsJsonString,WSExceptionType,IsValid,IsCache,CacheSeconds,[Version],[Status],[TimeOut],IsNeedLogin,IsNotify FROM [HttpMessage] where AppID=@AppID and Method=@Method and [Version]=@Version";
if (string.IsNullOrWhiteSpace(version))
{
version = "1.0";
}
var ret = con.QuerySingle <HttpMessage>(sql, new { AppID = AppID, method = method, version = version });
return(ret);
}
catch
{
return(null);
}
}
}