///<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得到相应的实体类对象
///生成时间�?011-4-14 16:25:47
///</summary>
public BillLog GetBillLogByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <BillLog> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-1-21 20:24:03
///</summary>
public Orderdetailouhfl GetOrderdetailouhflByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Orderdetailouhfl> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-9-7 18:34:31
///</summary>
public Manager GetManagerByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Manager> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-11-1 11:56:51
///</summary>
public Ratehistory GetRatehistoryByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Ratehistory> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-3-19 21:56:52
///</summary>
public Orderotherhistory GetOrderotherhistoryByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Orderotherhistory> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-8-28 22:55:41
///</summary>
public Betgames GetBetgamesByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?BetGamesID", id)
};
return(MySqlModelHelper <Betgames> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-1-23 1:00:24
///</summary>
public Casinologinservers GetCasinologinserversByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Casinologinservers> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-11-2 10:27:01
///</summary>
public Rotedshdp1 GetRotedshdp1ByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[]{
new MySqlParameter("?id",id)
};
return MySqlModelHelper<Rotedshdp1>.GetSingleObjectBySql(SQL_SELECTBYPK,param);
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-1-6 20:18:20
///</summary>
public Notice GetNoticeByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Notice> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-4-14 16:28:31
///</summary>
public Banklistc GetBanklistcByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Banklistc> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-6-1 20:36:02
///</summary>
public Jsn GetJsnByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <Jsn> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-8-27 22:00:49
///</summary>
public Sys_module_operate GetSys_module_operateByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?OperateID", id)
};
return(MySqlModelHelper <Sys_module_operate> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-7-9 19:58:32
///</summary>
public Testlog GetTestlogByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Testlog> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-8-27 22:00:49
///</summary>
public Sys_module_right GetSys_module_rightByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Module_right_id", id)
};
return(MySqlModelHelper <Sys_module_right> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-1-9 20:45:38
///</summary>
public Updatematches GetUpdatematchesByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Updatematches> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-6-1 14:31:11
///</summary>
public Matches_copy GetMatches_copyByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Matches_copy> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-4-14 21:35:13
///</summary>
public RefusedList GetRefusedListByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?ID", id)
};
return(MySqlModelHelper <RefusedList> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2011-5-5 21:16:16
///</summary>
public Betaccount GetBetaccountByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?id", id)
};
return(MySqlModelHelper <Betaccount> .GetSingleObjectBySql(SQL_SELECTBYPK, param));
}
///<summary>
///根据ID得到相应的实体类对象
///生成时间：2010-8-27 22:00:48
///</summary>
public Role GetRoleByPK(object id)
{
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("?Id", id)
};
return(MySqlModelHelper <Role> .GetSingleObjectBySql(SQL_SELECTBYPK, 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));
}
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>
/// 根据用户帐号返回数据
/// </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));
}
/// <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>
/// 获取系统默认的会员等级
/// </summary>
/// <returns></returns>
public Grade GetDefaultGrade()
{
string sqlStr = "select a.* from grade a,config b where a.LevelNamecn=b.Oval and b.Otype='会员等级'";
return(MySqlModelHelper <Grade> .GetSingleObjectBySql(sqlStr));
}
/// <summary>
/// descripton:获得ID值最大的一条数据 返回一个实体对象
/// create date 2010-09-26 21：47
/// create by 肖军文
/// </summary>
/// <returns></returns>
public Reason GetReasonByMaxID()
{
return(MySqlModelHelper <Reason> .GetSingleObjectBySql(SQL_SELECTMAXINFO));
}