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