|
int | ItemId [get, set] |
|
string | ItemCode [get, set] |
|
string | ItemName [get, set] |
|
string | ItemGroup [get, set] |
|
bool | MaintainStock [get, set] |
|
string | Brand [get, set] |
|
string | PreferredSupplier [get, set] |
|
int | LeadTimeInDays [get, set] |
|
double | WeightInGrams [get, set] |
|
double | WidthInCentimeters [get, set] |
|
double | HeightInCentimeters [get, set] |
|
double | LengthInCentimeters [get, set] |
|
bool | Machinable [get, set] |
|
string | PreferredShippingMailType [get, set] |
|
string | PreferredShippingPackageShape [get, set] |
|
string | Unit [get, set] |
|
bool | HotItem [get, set] |
|
decimal | CostPrice [get, set] |
|
decimal | SellingPrice [get, set] |
|
bool | SellingPriceIncludesTax [get, set] |
|
string | SalesTax [get, set] |
|
string | ReorderUnit [get, set] |
|
int | ReorderLevel [get, set] |
|
int | ReorderQuantity [get, set] |
|
static PetaPocoDB | repo [get] |
|
|
bool | IsNew () |
|
object | Insert () |
|
void | Save () |
|
int | Update () |
|
int | Update (IEnumerable< string > columns) |
|
int | Delete () |
|
static int | Update (string sql, params object[] args) |
|
static int | Update (Sql sql) |
|
static int | Delete (string sql, params object[] args) |
|
static int | Delete (Sql sql) |
|
static int | Delete (object primaryKey) |
|
static bool | Exists (object primaryKey) |
|
static T | SingleOrDefault (object primaryKey) |
|
static T | SingleOrDefault (string sql, params object[] args) |
|
static T | SingleOrDefault (Sql sql) |
|
static T | FirstOrDefault (string sql, params object[] args) |
|
static T | FirstOrDefault (Sql sql) |
|
static T | Single (object primaryKey) |
|
static T | Single (string sql, params object[] args) |
|
static T | Single (Sql sql) |
|
static T | First (string sql, params object[] args) |
|
static T | First (Sql sql) |
|
static List< T > | Fetch (string sql, params object[] args) |
|
static List< T > | Fetch (Sql sql) |
|
static List< T > | Fetch (long page, long itemsPerPage, string sql, params object[] args) |
|
static List< T > | Fetch (long page, long itemsPerPage, Sql sql) |
|
static List< T > | SkipTake (long skip, long take, string sql, params object[] args) |
|
static List< T > | SkipTake (long skip, long take, Sql sql) |
|
static Page< T > | Page (long page, long itemsPerPage, string sql, params object[] args) |
|
static Page< T > | Page (long page, long itemsPerPage, Sql sql) |
|
static IEnumerable< T > | Query (string sql, params object[] args) |
|
static IEnumerable< T > | Query (Sql sql) |
|