public static User ToUser(DataRow row)
{
User user = new User();
user.id = (int)row["id"];
user.UserID = (string)row["UserID"];
user.UserName = (string)row["name"];
user.UserPosition = (string)row["UserPosition"];
user.UserPwd = (string)row["UserPwd"];
user.UserSex = (string)row["UserSex"];
return user;
}
public void AddAUser(User user)
{
try
{
string sql = "INSERT INTO `yooga`.`auser`(`name`,`UserID`,`UserPwd`,`UserSex`,`UserPosition`)VALUES(@name,@UserID,@UserPwd,@UserSex,@UserPosition);";
DbUtil.ExecuteNonQuery(sql,
new MySqlParameter("@name", user.UserName),
new MySqlParameter("@UserID", user.UserID),
new MySqlParameter("@UserPwd", user.UserPwd),
new MySqlParameter("@UserSex", user.UserSex),
new MySqlParameter("@UserPosition", user.UserPosition));
}
catch (Exception ex)
{
throw new Exception("新增失败" + ex.Message);
}
}
public void UpdateUser(User user)
{
try
{
string sql = "UPDATE `yooga`.`auser` SET `name` = @name,`UserID` = @UserID,`UserPwd` = @UserPwd,`UserSex` = @UserSex,`UserPosition` = @UserPosition where `id` = @id";
DbUtil.ExecuteNonQuery(sql,
new MySqlParameter("@name", user.UserName),
new MySqlParameter("@UserID", user.UserID),
new MySqlParameter("@UserPwd", user.UserPwd),
new MySqlParameter("@UserSex", user.UserSex),
new MySqlParameter("@UserPosition", user.UserPosition),
new MySqlParameter("@id", user.id));
}
catch (Exception ex)
{
throw new Exception("更新失败" + ex.Message);
}
}
