/// <summary>
/// 测试用户的合法性
/// </summary>
/// <param name="vAIS_Users"></param>
/// <returns></returns>
public Model.v_UserInfos TestUser(Model.v_UserInfos vUser)
{
Model.v_UserInfos users = null;
StringBuilder sql = new StringBuilder();
sql.Append("select UserID,UserAccount,UserName From UserInfos ");
sql.Append(" where UserAccount=@UserAccount and UserPassword=@UserPassword ");
MySqlParameter[] paras = new MySqlParameter[]{
new MySqlParameter("@UserAccount",vUser.UserAccount),
new MySqlParameter("@UserPassword",vUser.UserPassword)
};
using (MySqlDataReader reader = db.getSelectData(sql.ToString(), paras))
{
if (reader.Read())
{
users = new Model.v_UserInfos();
users.UserID = reader.GetDecimal(0);
users.UserAccount = reader.GetString(1);
users.UserName = reader.GetString(2);
}
reader.Close();
return users;
}
}
// 删除
public bool del(Model.v_UserInfos vUser)
{
StringBuilder sql = new StringBuilder();
sql.Append("Delete From UserInfos where UserID=@UserID");
MySqlParameter[] paras = new MySqlParameter[]{
new MySqlParameter("@UserID",vUser.UserID)
};
return db.insert_or_update_or_delete(sql.ToString(), paras) > 0 ? true : false;
}
/// <summary>
/// 修改用户
/// </summary>
/// <param name="vUser"></param>
/// <returns></returns>
public bool edit(Model.v_UserInfos vUser)
{
StringBuilder sql = new StringBuilder();
sql.Append("Update UserInfos Set UserPassword=@UserPassword,UserName=@UserName ,UserType=@UserType ");
sql.Append(" where UserID=@UserID");
MySqlParameter[] paras = new MySqlParameter[]{
new MySqlParameter("@UserID",vUser.UserID),
new MySqlParameter("@UserPassword",vUser.UserPassword),
new MySqlParameter("@UserName",vUser.UserName),
new MySqlParameter("@UserType",vUser.UserType)
};
return db.insert_or_update_or_delete(sql.ToString(), paras) > 0 ? true : false;
}
/// <summary>
/// 测试账号是否已经存在
/// </summary>
/// <param name="useraccount"></param>
/// <returns></returns>
public Model.v_UserInfos TestAccountIsExist(string useraccount)
{
Model.v_UserInfos users = null;
string sql = string.Format("select UserAccount from UserInfos where UserAccount like '{0}%' order by UserAccount Desc", useraccount);
using (MySqlDataReader reader = db.getSelectData(sql))
{
if (reader.Read())
{
users = new Model.v_UserInfos();
users.UserAccount = reader.GetString(0);
}
reader.Close();
return users;
}
}
public bool add(Model.v_UserInfos vUser)
{
StringBuilder sql = new StringBuilder();
sql.Append("Insert into UserInfos (UserID,UserAccount,UserPassword,UserName,UserType) ");
sql.Append(" Values (@UserID,@UserAccount,@UserPassword,@UserName,@UserType)");
MySqlParameter[] paras = new MySqlParameter[]{
new MySqlParameter("@UserID",vUser.UserID),
new MySqlParameter("@UserAccount",vUser.UserAccount),
new MySqlParameter("@UserPassword",vUser.UserPassword),
new MySqlParameter("@UserName",vUser.UserName),
new MySqlParameter("@UserType",vUser.UserType)
};
return db.insert_or_update_or_delete(sql.ToString(), paras) > 0 ? true : false;
}
