public virtual bool Insert(T businessObject) { string sql = mStoreProcedurePrefix + "AddUpdate"; businessObject.ID = Extensions.AsLong(DbAdapter1.ExcecuteScalar(sql, true, Take(businessObject))); if (businessObject.ID > 0) { return(true); } return(false); }
public virtual IList <T> GetFilter(List <string> parms, string storeName = "") { switch (ConnectionName) { case "Default": return(DbAdapter1.ReadList(storeName, Make, true, parms.ToArray())); case "Inside": return(DbAdapter2.ReadList(storeName, Make, true, parms.ToArray())); default: return(DbAdapter1.ReadList(storeName, Make, true, parms.ToArray())); } }
public virtual int UpdateCustomField(object[] parms, string sql) { switch (ConnectionName) { case "Default": return(Convert.ToInt32(DbAdapter1.ExcecuteScalar(sql, false, parms))); case "Inside": return(Convert.ToInt32(DbAdapter2.ExcecuteScalar(sql, false, parms))); default: return(Convert.ToInt32(DbAdapter1.ExcecuteScalar(sql, false, parms))); } }
public virtual DataTable GetDataTable(object[] parms, string sql) { switch (ConnectionName) { case "Default": return(DbAdapter1.ReadDataTable(sql, true, parms)); case "Inside": return(DbAdapter2.ReadDataTable(sql, true, parms)); default: return(DbAdapter1.ReadDataTable(sql, true, parms)); } }
public virtual T GetSingleObject(List <string> parms, string storeProcedure) { switch (ConnectionName) { case "Default": return(DbAdapter1.Read(storeProcedure, Make, true, parms.ToArray())); case "Inside": return(DbAdapter2.Read(storeProcedure, Make, true, parms.ToArray())); default: return(DbAdapter1.Read(storeProcedure, Make, true, parms.ToArray())); } }
public virtual object GetSingleData(List <string> parms, string storeProcedure) { switch (ConnectionName) { case "Default": return(DbAdapter1.ExcecuteScalar(storeProcedure, true, parms.ToArray())); case "Inside": return(DbAdapter2.ExcecuteScalar(storeProcedure, true, parms.ToArray())); default: return(DbAdapter1.ExcecuteScalar(storeProcedure, true, parms.ToArray())); } }
public virtual IList <T> GetList(object[] parms) { string sql = StoreProcedurePrefix + "GetList"; switch (ConnectionName) { case "Default": return(DbAdapter1.ReadList <T>(sql, Make, true, parms)); case "Inside": return(DbAdapter2.ReadList <T>(sql, Make, true, parms)); default: return(DbAdapter1.ReadList <T>(sql, Make, true, parms)); } }
public virtual T GetSingle(long entityID) { string sql = string.Format(@"SELECT * FROM {0} WHERE {1} = @EntityID", mTableName, mEntityIDName); object[] parms = { "@EntityID", entityID }; switch (ConnectionName) { case "Default": return(DbAdapter1.Read(sql, Make, false, parms)); case "Inside": return(DbAdapter2.Read(sql, Make, false, parms)); default: return(DbAdapter1.Read(sql, Make, false, parms)); } }
public int Clear(string tableName = "") { object[] parms = new object[] { "@tableName", tableName }; return(Convert.ToInt32(DbAdapter1.ExcecuteScalar("spFieldListAuto_Clear", true, parms))); }
public virtual IList <T> GetListByCustomDataSource(object[] parms, string dataSource) { return(DbAdapter1.ReadList(dataSource, Make, true, parms)); }
public virtual int Count() { string sql = string.Format(@"SELECT count({0}) FROM {1}", mEntityIDName, TableName); return(DbAdapter1.ExcecuteScalar(sql, false, null).AsInt()); }
public virtual IList <T> GetAll() { string sql = Extensions.OrderBy(string.Format(@"SELECT * FROM {0}", TableName), mEntityIDName + " desc"); return(DbAdapter1.ReadList(sql, Make, false)); }
public virtual DataTable GetDataTable(object[] parms, string sql) { return(DbAdapter1.ReadDataTable(sql, true, parms)); }
public virtual int UpdateByCustomDataSource(object[] parms, string dataSource) { return(Convert.ToInt32(DbAdapter1.ExcecuteScalar(dataSource, true, parms))); }
public virtual T GetSingleByCustomDataSource(object[] parms, string dataSource) { return(DbAdapter1.Read(dataSource, Make, true, parms)); }