//获取证书列表 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); }