public static IList <ContactInfoEntity> GetByVesteeId(string vesteeId)
{
var sql = string.Format("SELECT {0} FROM contact_info WHERE vestee_id=@p_vestee_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_vestee_id", DbType.String, vesteeId);
var list = new List <ContactInfoEntity>();
using (IDataReader reader = db.ExecuteReader(dc))
{
while (reader.Read())
{
var entity = new ContactInfoEntity();
entity.Init(reader);
list.Add(entity);
}
}
return(list);
}
public static ContactInfoEntity Get(string id)
{
var sql = string.Format("SELECT {0} FROM contact_info WHERE id=@p_id", COLUMN_SQL);
var db = DatabaseFactory.CreateDatabase();
var dc = db.GetSqlStringCommand(sql);
db.AddInParameter(dc, "p_id", DbType.String, id);
using (IDataReader reader = db.ExecuteReader(dc))
{
if (reader.Read())
{
var entity = new ContactInfoEntity();
entity.Init(reader);
return(entity);
}
else
{
return(null);
}
}
}
