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