public static void TestINDEX()
{
//MySqlTemplate.DROP("Test1");
//CreateTableElement ct = new CreateTableElement("Test1");
//ct.Add("ID", DataType.INT, true);
//ct.Add("Name", DataType.CHAR10, true);
//ct.Add("Age", DataType.INT);
//ct.Create();
//for (int i = 0; i < 800; i++)
//{
// MySqlTemplate.INSERT("Test1", new string[] { "ID", "Name", "Age" }, new object[] { 1000 + i, "张三", 16 });
//}
//MySqlTemplate.INDEX("Test1", "ByID", "ID");
//MySqlTemplate.INDEX("Test1", "ByID", "", false);
List <Test2> list = MySqlTemplate.SELECT <Test2>(new string[] { "Test1" }, new string[] { "ID" }, "ID>1556");
foreach (var item in list)
{
Console.WriteLine("ID:{0} Name:{1} Age:{2}", item.ID, item.Name, item.Age);
}
Console.WriteLine();
}
public User ReadUser(int userId)
{
string where = string.Format("userId = '{0}'", userId);
var users = MySqlTemplate.SELECT <User>(new string[] { "user" }, new string[] { "*" }, where);
foreach (var item in users)
{
return(item);
}
return(null);
}
// 读取用户
public User ReadUser(string accountNumber)
{
string where = string.Format("accountNumber = '{0}'", accountNumber);
var users = MySqlTemplate.SELECT <User>(new string[] { "user" }, new string[] { "*" }, where);
foreach (var item in users)
{
return(item);
}
return(null);
}
// 检测账号是否已占用
public int CheckUser(string accountNumber)
{
string where = string.Format("accountNumber = '{0}'", accountNumber);
var users = MySqlTemplate.SELECT <User>(new string[] { "user" }, new string[] { "*" }, where);
if (users != null)
{
return(0);
}
return(1001);
}
public bool RoleIsExisting(string roleName)
{
string where = string.Format("roleName = '{0}'", roleName);
var roles = MySqlTemplate.SELECT <Entity>(new string[] { "role" }, new string[] { "*" }, where);
if (roles.Count < 1)
{
return(false);
}
return(roles[0] != null);
}
// 检测密码正确与否
public int CheckUserPassword(string accountNumber, string password)
{
string where = string.Format("accountNumber = '{0}'", accountNumber);
var users = MySqlTemplate.SELECT <User>(new string[] { "user" }, new string[] { "*" }, where);
foreach (var item in users)
{
if (item.password == password)
{
return(0);
}
}
return(1002);
}
// 读取角色
public Role ReadRole(int roleId)
{
Role role;
if (!roleDic.TryGetValue(roleId, out role))
{
string where = string.Format("roleId = {0}", roleId);
var roles = MySqlTemplate.SELECT <Role>(new string[] { "role" }, new string[] { "*" }, where);
if (roles.Count > 0)
{
role = roles[0];
}
if (role != null)
{
roleDic[role.roleId] = role;
}
}
return(role);
}
// 读取设定信息
private void ReadSettings()
{
List <Settings> list = MySqlTemplate.SELECT <Settings>(new string[] { "setting" }, new string[] { "*" });
settings = list[0];
}
