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