public UseAction(Unity.DbConn dbc, string servername, string playername, int maxprematch, int searchdeep) { dbconn = dbc; _servername = servername; _playername = playername; _maxprematch = maxprematch; _searchdeep = searchdeep; }
public static bool ExistUser(Unity.DbConn dbconn, string server, string playername) { int i = dbconn.ExecScaner <int>("select count(1) from lolplayer where servername=@servername and playername=@playername", new { playername = playername, servername = server }); return(i > 0); }
public static List <Models.Player> GetListByPage(Unity.DbConn dbconn, string server, int searchdeep, int pno, int pagesize, out int total) { total = dbconn.ExecScaner <int>("select count(1) from lolplayer where servername=@servername and [searchdeep]=@searchdeep", new { servername = server, searchdeep = searchdeep }); string pagesql = string.Format("select * from (select ROW_NUMBER() over (order by playername asc) as rownum,* from lolplayer where servername=@servername and [searchdeep]=@searchdeep) A where A.rownum between {0} and {1}", (pno - 1) * pagesize + 1, pno * pagesize); var model = dbconn.ExecModel <Models.Player>(pagesql, new { servername = server, searchdeep = searchdeep }); return(model); }
public static Models.Player Get(Unity.DbConn dbconn, string server, string playername) { var model = dbconn.ExecModel <Models.Player>("select * from lolplayer where servername=@servername and playername=@playername", new { playername = playername, servername = server }); if (model.Count == 0) { return(null); } return(model[0]); }
public static void AddUser(Unity.DbConn dbconn, Models.Player usermodel) { int i = dbconn.ExecSql("insert into lolplayer(servername,playername,parentplayer,[level],fighting,searchdeep,lastplaytime) values(@servername,@playername,@parentplayer,@level,@fighting,@searchdeep,@lastplaytime)", usermodel); }