public DataEvent SelectByBossID(long id) { string cmdText = string.Format("select * from {0} where bossid = {1}", Name, id); DataEvent ev = CreateDataEvent(); using (DataCommandBase dtc = new LongDataCommand(string.Format("select id from {0} where bossid = {1}", Name, id))) { _file.AddCommand(dtc); dtc.Wait(); ev.ID = (long)dtc.Result; } using (DataCommandBase dtc = new EventDataCommand(ev, cmdText)) { _file.AddCommand(dtc); dtc.Wait(); } foreach (DataTableBase linkedTable in LinkedTables) { long[] linkids = linkedTable.SelectIDsByIndexColumn(id); if (linkids != null) { foreach (long linkid in linkids) { ev.LinkedDataEvents(linkedTable).Add(linkedTable.SelectByID(linkid)); } } } return(ev); }
public bool DoesBossIDExist(long id) { bool ret; long count = 0; string cmdText = string.Format("select COUNT(*) from {0} where bossid = {1}", Name, id); using (DataCommandBase dtc = new LongDataCommand(cmdText)) { _file.AddCommand(dtc); dtc.Wait(); count = (long)dtc.Result; } return(count > 0); }
protected long GetCountCustom(string query) { try { string cmdText = "select count(*) from " + Name; if (!string.IsNullOrEmpty(query)) { cmdText += query; } using (DataCommandBase dtc = new LongDataCommand(cmdText)) { _file.AddCommand(dtc); dtc.Wait(); return((long)dtc.Result); } } catch { return(0); } }