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