/// <summary> /// 添加用户 /// </summary> /// <param name="Info"></param> public void Insert(mUsers Info) { OleDbParameter[] par = new OleDbParameter[] { new OleDbParameter("@UserName", Info.UserName), new OleDbParameter("@UserPwd", Info.UserPwd), new OleDbParameter("@GroupId", Info.GroupId), new OleDbParameter("@IsLock", Info.IsLock) }; OLEHelper.ExecuteNonQuery(sql_Insert, par); }
//check for admin account create admin account if one does not exist public void adminAccount() { var ucol = globals.getDB().GetCollection <mUsers>("mUsers"); var admin = ucol.Find(i => i._id != null).FirstOrDefault(); if (admin == null) { var na = new mUsers(); na.username = "******"; na.password = globals.getmd5("admin"); ucol.InsertOne(na); } }
/// <summary> /// 获取用户列表 /// </summary> /// <param name="Info"></param> /// <returns></returns> public IList <DataSet> GetUserList(mUsers Info) { OleDbParameter[] par = new OleDbParameter[] { new OleDbParameter("@UserName", Info.UserName) }; if (!String.IsNullOrEmpty(Info.UserName)) { sql_GetUserList = sql_GetUserList.Replace("@WHERE", "WHERE UserName LIKE '%@UserName%'"); } else { sql_GetUserList = sql_GetUserList.Replace("@WHERE", ""); } IList <DataSet> list = new List <DataSet>(); DataSet ds = OLEHelper.ExecuteDataset(sql_GetUserList, par); list.Add(ds); return(list); }
/// <summary> /// 根据ID获取单条用户信息 /// </summary> /// <param name="Info"></param> /// <returns></returns> public IList <mUsers> GetUser(mUsers Info) { OleDbParameter[] par = new OleDbParameter[] { new OleDbParameter("@Id", Info.Id) }; IList <mUsers> list = new List <mUsers>(); using (OleDbDataReader dr = OLEHelper.ExecuteReader(sql_GetUser, par)) { while (dr.Read()) { mUsers m = new mUsers(); m.UserName = dr[0].ToString(); m.UserPwd = dr[1].ToString(); m.GroupId = (int)dr[2]; m.IsLock = (bool)dr[3]; m.CreatTime = (DateTime)dr[4]; list.Add(m); } } return(list); }
public usuariosplataformaDto LoginPlataforma(string user, string password) { mUsers oUser = new mUsers(); return(oUser.Login(user, password)); }
public usuariosplataformaDto Get() { mUsers o = new mUsers(); return(o.Login("carlos", "justime")); }