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));
}
