/// <summary>
/// Delete base <see cref="EntityType"/> specified by entity id
/// </summary>
/// <param name="id">Entity id</param>
/// <returns></returns>
public virtual int Delete(int id)
{
EntityType entity = EntityReflector <EntityType> .CreateInstance();
StringBuilder sb = new StringBuilder();
sb.Append("DELETE FROM ").Append(entity.TableName).Append(" WHERE id=@id");
Db db = new Db();
int ret = db.Delete(sb.ToString(), new DbParameter("@id", id), CommandType.Text);
return(ret);
}
/// <summary>
/// Find list EntityType
/// </summary>
/// <param name="sql">string query</param>
/// <param name="commandType">command type</param>
/// <returns></returns>
public virtual IList <EntityType> FindList(string sql, CommandType commandType)
{
Db db = new Db();
DataTable dt = db.GetDataTable(sql, commandType);
List <EntityType> list = new List <EntityType>();
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
EntityType entity = EntityReflector <EntityType> .CreateInstance();
entity = mapper.MapItem(row);
list.Add(entity);
}
}
return(list);
}
/// <summary>
/// Find EntityType
/// </summary>
/// <param name="sql">string query</param>
/// <param name="p">parameter</param>
/// <param name="commandType">command type</param>
/// <returns></returns>
public virtual EntityType FindEntity(string sql, DbParameter[] p, CommandType commandType)
{
Db db = new Db();
EntityType entity = EntityReflector <EntityType> .CreateInstance();
try
{
DataRow row = db.GetDataRow(sql, p, commandType);
if (row != null)
{
entity = mapper.MapItem(row);
}
}
catch (Exception ex)
{
log.Fatal("Find entity has an exception: ", ex);
return(null);
}
return(entity);
}
/// <summary>
/// Find object <see cref="EntityType"/> specified by id
/// </summary>
/// <param name="id">Entity Id</param>
/// <returns>A object of <see cref="EntityType"/> when success, <b>null</b> when error or not found </returns>
public virtual EntityType FindByKey(int id)
{
EntityType entity = EntityReflector <EntityType> .CreateInstance();
try
{
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM ").Append(entity.TableName).Append(" WHERE id=@id");
Db db = new Db();
DataRow row = db.GetDataRow(sb.ToString(), new DbParameter("@id", id), CommandType.Text);
if (row != null)
{
entity = mapper.MapItem(row);
}
}
catch (Exception ex)
{
log.Fatal("Find entity has an exception: ", ex);
return(null);
}
return(entity);
}
public virtual IList <EntityType> FindAll()
{
EntityType entity1 = EntityReflector <EntityType> .CreateInstance();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM ").Append(entity1.TableName);
Db db = new Db();
DataTable dt = db.GetDataTable(sb.ToString(), CommandType.Text);
List <EntityType> list = new List <EntityType>();
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
EntityType entity = EntityReflector <EntityType> .CreateInstance();
entity = mapper.MapItem(row);
list.Add(entity);
}
}
return(list);
}
/// <summary>
/// Lazy load method
/// </summary>
public void LazyLoad()
{
if (!initialized)
{
EntityType entity1 = EntityReflector <EntityType> .CreateInstance();
StringBuilder sb = new StringBuilder();
sb.Append("SELECT * FROM ").Append(entity1.TableName).Append(" WHERE ").Append(ForeignKey).Append("=@").Append(ForeignKey);
DbParameter param = new DbParameter("@" + this.ForeignKey, Parrent.Id);
Db db = new Db();
DataTable dt = db.GetDataTable(sb.ToString(), param, CommandType.Text);
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
EntityType entity = EntityReflector <EntityType> .CreateInstance();
entity = mapper.MapItem(row);
list.Add(entity);
}
}
}
initialized = true;
}
