///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-11-2 10:27:02
///</summary>
public Rotedsou1 GetRotedsou1ByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Rotedsou1> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-9-18 13:49:34
///</summary>
public System_module GetSystem_moduleByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Module_code", id)
};
return(MySqlModelHelper <System_module> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-10-20 21:48:02
///</summary>
public Grade GetGradeByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Grade> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-5-12 20:18:10
///</summary>
public Agentservers GetAgentserversByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Agentservers> .GetSingleObjectBySql(SQL_SELECTBYPK, 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));
}
public static Banklistc GetBankByCardno(string bankno)
{
string sql = "select * from banklistc where nameth=@bankno";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@bankno", bankno)
};
return(MySqlModelHelper <Banklistc> .GetSingleObjectBySql(sql, 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>
/// 根据用户帐号返回数据
/// </summary>
/// <param name="managerId"></param>
/// <returns></returns>
public Manager GetManagerByManagerId(string managerId)
{
string sqlStr = "select * from manager where ManagerId=?ManagerId";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ManagerId", managerId)
};
return(MySqlModelHelper <Manager> .GetSingleObjectBySql(sqlStr, param));
}
public Grade IsExistGrade(string levelName, string lan)
{
string sqlStr = "select * from grade where levelName" + lan + "=?levelName";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?levelName", levelName)
};
return(MySqlModelHelper <Grade> .GetSingleObjectBySql(sqlStr, param));
}
public Config GetConfigByOtype(string otype)
{
string sqlStr = "select ID,Otype,Oval,Remark,Status from config where Otype=?Otype";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Otype", otype)
};
return(MySqlModelHelper <Config> .GetSingleObjectBySql(sqlStr, param));
}
/// <summary>
/// 用过登录名称获得登录对象
/// Programmer：liuxbang
/// time：2010-8-27 23：24
/// </summary>
/// <param name="managerId"></param>
/// <returns></returns>
public Manager GetManagerByManagerId(string managerId, string password)
{
MySqlParameter[] para = new MySqlParameter[] {
new MySqlParameter("?ManagerId", MySqlDbType.VarChar, 30),
new MySqlParameter("?password", MySqlDbType.VarChar, 32)
};
para[0].Value = managerId;
para[1].Value = password;
return(MySqlModelHelper <Manager> .GetSingleObjectBySql(SQL_BYLOGIN, para));
}
public static Model.PTgame GetGameinfoReport_ea(string username, DateTime enddate)
{
string sql = "select * from gameinforeport_ea where login=@login and enddate=@enddate";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("@login", username),
new MySqlParameter("@enddate", enddate)
};
return(MySqlModelHelper <Model.PTgame> .GetSingleObjectBySql(sql, param));
}
/// <summary>
/// 角色是否存在
/// </summary>
/// <param name="roleName">角色名称</param>
/// <param name="agentId">代理帐号</param>
/// <returns></returns>
public Role IsExistRole(string roleName, string agentId)
{
string sqlStr = "select * from role where roleName=?roleName and agentId=?agentId";
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?roleName", roleName),
new MySqlParameter("?agentId", agentId)
};
return(MySqlModelHelper <Role> .GetSingleObjectBySql(sqlStr, 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>
///获得所有数据，返回泛型集合
///生成时间：2010-9-24 21:04:12
///</summary>
public IList <Orderother> GetMutilILOrderother()
{
return(MySqlModelHelper <Orderother> .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>
///获得所有数据，返回泛型集合
///生成时间：2010-11-2 10:27:01
///</summary>
public IList<Rotedshdp1> GetMutilILRotedshdp1()
{
return MySqlModelHelper<Rotedshdp1>.GetObjectsBySql(SQL_SELECTALL, null);
}
///<summary>
///获得所有数据，返回泛型集合
///生成时间：2011-1-9 20:45:38
///</summary>
public IList <Updatematches> GetMutilILUpdatematches()
{
return(MySqlModelHelper <Updatematches> .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-23 1:00:24
///</summary>
public IList <Casinologinservers> GetMutilILCasinologinservers()
{
return(MySqlModelHelper <Casinologinservers> .GetObjectsBySql(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回泛型集合
///生成时间：2011-1-6 20:18:20
///</summary>
public IList <Notice> GetMutilILNotice()
{
return(MySqlModelHelper <Notice> .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-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>
///获得所有数据，返回泛型集合
///生成时间：2011-4-14 16:29:47
///</summary>
public IList <Bankhistory> GetMutilILBankhistory()
{
return(MySqlModelHelper <Bankhistory> .GetObjectsBySql(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回泛型集合
///生成时间：2010-11-2 10:27:01
///</summary>
public IList <Roteds1x2hf1> GetMutilILRoteds1x2hf1()
{
return(MySqlModelHelper <Roteds1x2hf1> .GetObjectsBySql(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回泛型集合
///生成时间�?011-4-14 16:25:47
///</summary>
public IList <BillLog> GetMutilILBillLog()
{
return(MySqlModelHelper <BillLog> .GetObjectsBySql(SQL_SELECTALL, null));
}
///<summary>
///获得所有数据，返回泛型集合
///生成时间：2010-9-29 21:17:12
///</summary>
public IList <Config> GetMutilILConfig()
{
return(MySqlModelHelper <Config> .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-8-28 22:55:41
///</summary>
public IList <Betgames> GetMutilILBetgames()
{
return(MySqlModelHelper <Betgames> .GetObjectsBySql(SQL_SELECTALL, null));
}
