//获取证书列表
public static List<MyCertificate> Certificate_List(MyCertificate model)
{
try
{
using (var conn = DbHelper.CCService())
{
var p = new DynamicParameters();
p.Add("@userid", model.UserID);
return conn.Query<MyCertificate>("MyCertificate_List", p, commandType: CommandType.StoredProcedure).ToList();
}
}
catch (Exception)
{
return new List<MyCertificate>();
}
}
//获取证书详细信息
public static MyCertificate MyCertificate_Get(MyCertificate model)
{
try
{
using (var conn = DbHelper.CCService())
{
var p = new DynamicParameters();
p.Add("@CertificateID", model.CertificateID);
return conn.Query<MyCertificate>("MyCertificate_Get", p, commandType: CommandType.StoredProcedure).Single();
}
}
catch (Exception)
{
throw;
}
}
//获取证书的详细信息
public MyCertificate MyCertificate_Get(MyCertificate model)
{
return CertificateDAL.MyCertificate_Get(model);
}
public List<MyCertificate> Certificate_List(MyCertificate model)
{
return CertificateDAL.Certificate_List(model);
}
