protected void bind_company(string mode) { //SubSonic.Query _q = new SubSonic.Query(Tables.NameAndAddressBook, "WWIProv").WHERE("CompanyID", Comparison.Equals, _pid); DAL.Logistics.NameAndAddressBookCollection _tbc = new DAL.Logistics.NameAndAddressBookCollection(); if (mode != "Insert") { int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship")); //int _pid = wwi_func.vint(get_token("pid")); DAL.Logistics.NameAndAddressBook _tbl = new DAL.Logistics.NameAndAddressBook(_pid); _tbc.Add(_tbl); } else { DAL.Logistics.NameAndAddressBook _tbl = new DAL.Logistics.NameAndAddressBook(); _tbc.Add(_tbl); } string[] _keys = { "CompanyID" }; //IDataReader _dr = _q.ExecuteReader(); this.fmvAddressBook.DataSource = _tbc; //_dr; this.fmvAddressBook.DataKeyNames = _keys; this.fmvAddressBook.DataBind(); //_dr.Close(); }
protected void bind_company(string mode) { //SubSonic.Query _q = new SubSonic.Query(Tables.NameAndAddressBook, "WWIProv").WHERE("CompanyID", Comparison.Equals, _pid); DAL.Logistics.NameAndAddressBookCollection _tbc = new DAL.Logistics.NameAndAddressBookCollection(); if (mode != "Insert") { int _pid = wwi_func.vint(wwi_security.DecryptString(get_token("pid").ToString(), "publiship")); //int _pid = wwi_func.vint(get_token("pid")); DAL.Logistics.NameAndAddressBook _tbl = new DAL.Logistics.NameAndAddressBook(_pid); _tbc.Add(_tbl); } else { DAL.Logistics.NameAndAddressBook _tbl = new DAL.Logistics.NameAndAddressBook(); _tbc.Add(_tbl); } string[] _keys = { "CompanyID" }; //IDataReader _dr = _q.ExecuteReader(); this.fmvAddressBook.DataSource = _tbc; //_dr; this.fmvAddressBook.DataKeyNames = _keys; this.fmvAddressBook.DataBind(); //_dr.Close(); }
public NameAndAddressBookCollection FetchByQuery(Query qry) { NameAndAddressBookCollection coll = new NameAndAddressBookCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public NameAndAddressBookCollection FetchAll() { NameAndAddressBookCollection coll = new NameAndAddressBookCollection(); Query qry = new Query(NameAndAddressBook.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public NameAndAddressBookCollection FetchByID(object CompanyID) { NameAndAddressBookCollection coll = new NameAndAddressBookCollection().Where("CompanyID", CompanyID).Load(); return(coll); }