public List <AP_Master_Supplier_Address> SelectAll(int start, int length, List <WhereClause> Where, List <OrderByClause> OrderBy) { SelectQueryBuilder Sqb = new SelectQueryBuilder(); Sqb.SelectAllColumns(); if (start > 0 || length > 0) { if (start == 0) { Sqb.TopRecords = length; } else { Sqb.LimitRecords(start, length); } } Sqb.SelectFromTable("AP_Master_Supplier_Address"); if (Where != null) { foreach (WhereClause Item in Where) { Sqb.AddWhere(Item); } } if (OrderBy != null) { foreach (OrderByClause Item in OrderBy) { Sqb.AddOrderBy(Item); } } DataTable dt = LoadByQueryBuilder(Sqb); List <AP_Master_Supplier_Address> Res = new List <AP_Master_Supplier_Address>(); foreach (DataRow Dr in dt.Rows) { AP_Master_Supplier_Address Item = new AP_Master_Supplier_Address(); Item.ExecCommand.Load(Dr); Res.Add(Item); } return(Res); }
internal AP_Master_Supplier_Address_Command(string ConnectionStr, AP_Master_Supplier_Address obj_AP_Master_Supplier_Address) { this._AP_Master_Supplier_Address = obj_AP_Master_Supplier_Address; this._DBHelper = new DBHelper(ConnectionStr, null); }
internal AP_Master_Supplier_Address_Command(AP_Master_Supplier_Address obj_AP_Master_Supplier_Address) { this._AP_Master_Supplier_Address = obj_AP_Master_Supplier_Address; this._DBHelper = new DBHelper(); }