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]; }