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