public T FindEntity <T>(string propertyName, object propertyValue) where T : new() { string str = propertyName; StringBuilder builder = DatabaseCommon.SelectSql <T>(1); builder.Append(" AND ").Append(str).Append("=").Append(DbHelper.DbParmChar + str); IList <DbParameter> source = new List <DbParameter> { DbFactory.CreateDbParameter(DbHelper.DbParmChar + str, propertyValue) }; return(DatabaseReader.ReaderToModel <T>(DbHelper.ExecuteReader(CommandType.Text, builder.ToString(), source.ToArray <DbParameter>()))); }
public DataTable FindTableTop <T>(int Top) where T : new() { StringBuilder builder = DatabaseCommon.SelectSql <T>(Top); return(DatabaseReader.ReaderToDataTable(DbHelper.ExecuteReader(CommandType.Text, builder.ToString()))); }
public object FindMax <T>(string propertyName) where T : new() { StringBuilder builder = DatabaseCommon.SelectMaxSql <T>(propertyName); return(DbHelper.ExecuteScalar(CommandType.Text, builder.ToString())); }
public List <T> FindListPage <T>(string orderField, string orderType, int pageIndex, int pageSize, ref int recordCount) where T : new() { return(SqlServerHelper.GetPageList <T>(DatabaseCommon.SelectSql <T>().ToString(), orderField, orderType, pageIndex, pageSize, ref recordCount)); }
public List <T> FindList <T>() where T : new() { StringBuilder builder = DatabaseCommon.SelectSql <T>(); return(DatabaseReader.ReaderToList <T>(DbHelper.ExecuteReader(CommandType.Text, builder.ToString()))); }
public int FindCount <T>() where T : new() { StringBuilder builder = DatabaseCommon.SelectCountSql <T>(); return(Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, builder.ToString()))); }