/// <summary> /// 根据用户AccessToken查询(RawSqlQuery)该用户所对应角色的所有权限 /// </summary> /// <param name="token"></param> /// <returns></returns> public DataTable GetUserFunctionsByToken(string token) { string sql = @" select token.accesstoken,`user`.id as userId,`user`.userno,`user`.name as userName,role.id as roleId,role.name as role, `function`.id as funcId,`function`.funcNo,`function`.funcName,`function`.funcGroup, rolefunctions.add,rolefunctions.mod,rolefunctions.del,rolefunctions.qry from token,user,role,function,rolefunctions,userroles where token.userId = `user`.id and `user`.id = userroles.user_id and role.id = userroles.role_id and role.id = rolefunctions.role_id AND `function`.id = rolefunctions.function_id and accesstoken = ?"; try { return(MySqlTool.ExecuteDataTable(sql, token)); } catch (Exception e) { throw e; } }
static void testMysql() { string sql; int rtn = 0; sql = "insert into person(name,age)values(?,?)"; MySqlTransTool t = new MySqlTransTool(); rtn = t.ExecuteSqlUsingTrans(sql, new object[] { "Sb", 17 }); Console.WriteLine(rtn); sql = "delete from person where id = ?"; rtn = t.ExecuteSqlUsingTrans(sql, 12); Console.WriteLine(rtn); t.Commit(); sql = "select * from person"; DataSet ds = MySqlTool.ExecuteDataSet(sql); foreach (DataRow item in ds.Tables[0].Rows) { for (int i = 0; i < ds.Tables[0].Columns.Count; i++) { Console.Write(item[i].ToString().PadLeft(10, ' ')); } Console.WriteLine(Environment.NewLine); } Console.WriteLine("Now Save File..."); sql = "update person set photo = ? where ID = ?"; object photo = FromPhoto(@"d:\test.png"); rtn = MySqlTool.ExecuteSql(sql, new object[] { photo, 1 }); Console.WriteLine("Set photo return {0}", rtn); Console.WriteLine(@"Now Create File..."); sql = "select photo from person where ID = ?"; photo = MySqlTool.ExecuteScalar(sql, new object[] { 1 }); CreatePhoto(@"d:\test_copy.png", (byte[])photo); }