public IList <AgentAccount> SelectByCasino(string casino) { MySqlParameter[] parm = new MySqlParameter[] { new MySqlParameter("?Casino", casino) }; return(MySqlModelHelper <AgentAccount> .GetObjectsBySql(SQL_SELECTBYCASINO, parm)); }
/// <summary> /// 返回角色,根据代理ID /// By xzz /// 2010-8-31 23:56 /// </summary> /// <param name="agentId">代理ID</param> /// <returns></returns> public IList <Role> GetRoleByAgentId(string agentId) { MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?agentId", agentId) }; return(MySqlModelHelper <Role> .GetObjectsBySql(SQL_SELECTBYAGENTID, param)); }
/// <summary> /// 根据Id返回所有角色,包括下级 /// By xzz /// 2010-9-4 /// </summary> /// <param name="Id">角色ID</param> /// <returns></returns> public IList <Role> GetRoleById(int Id) { MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?Id", Id) }; return(MySqlModelHelper <Role> .GetObjectsBySql(SQL_SELECTROLE, param)); }
public IList <Notice> GetNoticeBylan(string lan) { string sql = ""; string subSql = ""; switch (lan) { case "zh-cn": subSql = " msgcn, "; break; case "zh-tw": subSql = " msgtw, "; break; case "en-us": subSql = " msgen, "; break; case "th-th": subSql = " msgth, "; break; case "vi-vn": subSql = " msgvn, "; break; } sql = "select " + subSql + " displayuser,windowagent,windowuser,createdate,displayagent from notice order by ID desc"; return(MySqlModelHelper <Notice> .GetObjectsBySql(sql)); }
public IList <Config> GetPro_setup() { string sqlStr = "select ID,Otype,Oval,Remark,Status from config where ID=29 || ID=30;"; return(MySqlModelHelper <Config> .GetObjectsBySql(sqlStr)); }
/// <summary> /// 通过RootId获得当前的Name和主键Id /// Programmer:lxb /// time:08-31 17:24 /// </summary> /// <param name="RootId"></param> /// <returns></returns> public IList <Betgames> GetNameAndIdByRootId(int rootId) { MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?rootId", MySqlDbType.Int32) }; param[0].Value = rootId; return(MySqlModelHelper <Betgames> .GetObjectsBySql(SQL_NAME_IDBY_ROOTID, param)); }
/*-----------会员注单结束-----------------*/ #endregion /// <summary> /// 根据gameid返回OrderOther /// </summary> /// <param name="gameid"></param> /// <returns></returns> public IList <Orderother> GetOrderByGameId(int gameid) { string sqlStr = "select * from orderother where gameid=?gameid"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?gameid", gameid) }; return(MySqlModelHelper <Orderother> .GetObjectsBySql(sqlStr, param)); }
/// <summary> /// 根据ID获得单个实体对象 /// </summary> /// <param name="id"></param> /// <returns></returns> public IList <Betaccount> GetBetaccountByID(int id) { string str = SQL_SELECTALL + " where id=?id"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?id", id) }; return(MySqlModelHelper <Betaccount> .GetObjectsBySql(str, param)); }
/// <summary> /// 返回代理部门角色 /// By xzz 2010-11-24 /// </summary> /// <param name="rootId">当前代理角色ID</param> /// <param name="agentId">代理用户名</param> /// <returns></returns> public IList <Role> GetAgentRoleByAgentID(int rootId, string agentId) { string sqlStr = "select * from role where rootId=?rootId and agentId=?agentId order by id"; MySqlParameter[] param = new MySqlParameter[] { new MySqlParameter("?rootId", rootId), new MySqlParameter("?agentId", agentId) }; return(MySqlModelHelper <Role> .GetObjectsBySql(sqlStr, param)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-1-23 1:00:24 ///</summary> public IList <Casinologinservers> GetMutilILCasinologinservers() { return(MySqlModelHelper <Casinologinservers> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-5-5 21:16:16 ///</summary> public IList <Betaccount> GetMutilILBetaccount() { return(MySqlModelHelper <Betaccount> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-1-6 20:18:20 ///</summary> public IList <Notice> GetMutilILNotice() { return(MySqlModelHelper <Notice> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-4-14 21:35:13 ///</summary> public IList <RefusedList> GetMutilILRefusedList() { return(MySqlModelHelper <RefusedList> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-6-1 14:31:11 ///</summary> public IList <Matches_copy> GetMutilILMatches_copy() { return(MySqlModelHelper <Matches_copy> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-4-14 16:28:31 ///</summary> public IList <Banklistc> GetMutilILBanklistc() { string SQL = "select ID,Currency,namecn,nametw,nameen,nameth,cardno,bank,Province,city,Branch,status,operator,operationtime,ip,amount from yafa.banklistc "; return(MySqlModelHelper <Banklistc> .GetObjectsBySql(SQL, null)); }
/// <summary> /// 返回代理角色 /// </summary> /// <returns></returns> public IList <Role> GetAgentRole() { string sqlStr = "select * from role where rootId=0 and roleName<>'系统管理员' and roleName<>'会员'"; return(MySqlModelHelper <Role> .GetObjectsBySql(sqlStr, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-9-29 21:17:12 ///</summary> public IList <Config> GetMutilILConfig() { return(MySqlModelHelper <Config> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-8-27 22:00:49 ///</summary> public IList <System_module_operate> GetMutilILSystem_module_operate() { return(MySqlModelHelper <System_module_operate> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-6-1 20:36:02 ///</summary> public IList <Jsn> GetMutilILJsn() { return(MySqlModelHelper <Jsn> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-8-27 22:00:49 ///</summary> public IList <Sys_module_right> GetMutilILSys_module_right() { return(MySqlModelHelper <Sys_module_right> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间�?011-4-14 16:25:47 ///</summary> public IList <BillLog> GetMutilILBillLog() { return(MySqlModelHelper <BillLog> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-4-14 16:29:47 ///</summary> public IList <Bankhistory> GetMutilILBankhistory() { return(MySqlModelHelper <Bankhistory> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-9-7 18:34:31 ///</summary> public IList <Manager> GetMutilILManager() { return(MySqlModelHelper <Manager> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-1-9 20:45:38 ///</summary> public IList <Updatematches> GetMutilILUpdatematches() { return(MySqlModelHelper <Updatematches> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-11-2 10:27:01 ///</summary> public IList<Rotedshdp1> GetMutilILRotedshdp1() { return MySqlModelHelper<Rotedshdp1>.GetObjectsBySql(SQL_SELECTALL, null); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-11-2 10:27:01 ///</summary> public IList <Roteds1x2hf1> GetMutilILRoteds1x2hf1() { return(MySqlModelHelper <Roteds1x2hf1> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-9-24 21:04:12 ///</summary> public IList <Orderother> GetMutilILOrderother() { return(MySqlModelHelper <Orderother> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-8-28 22:55:41 ///</summary> public IList <Betgames> GetMutilILBetgames() { return(MySqlModelHelper <Betgames> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2011-1-21 20:24:03 ///</summary> public IList <Orderdetailouhfl> GetMutilILOrderdetailouhfl() { return(MySqlModelHelper <Orderdetailouhfl> .GetObjectsBySql(SQL_SELECTALL, null)); }
///<summary> ///获得所有数据,返回泛型集合 ///生成时间:2010-10-20 21:48:02 ///</summary> public IList <Grade> GetMutilILGrade() { return(MySqlModelHelper <Grade> .GetObjectsBySql(SQL_SELECTALL, null)); }