/// <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; }