//public IConfiguration Configuration { get; } //public UserImpl(IConfiguration configuration) //{ // Configuration = configuration; // MysqlConn = new MySqlConnection(Configuration.GetConnectionString("MsSqlDemo")); // MysqlConn.Open(); //} public ResponseT <long> Create(RequestT <UserAdd> userAdd) { var response = new ResponseT <long>(); using (MysqlConn) { response.data = MysqlConn.Execute(@"insert into `user`(name, sex) values (@name, @sex)", userAdd.data); } return(response); }
public ResponseT <int> Delete(RequestT <UserDelete> userDelete) { var response = new ResponseT <int>(); using (MysqlConn) { response.data = MysqlConn.Execute($"delete from user where userid=@ids", userDelete.data); } return(response); }
public ResponseT <int> Edit(RequestT <UserUpdate> userUpdate) { var response = new ResponseT <int>(); using (MysqlConn) { response.data = MysqlConn.Execute(@"update user set name=@name, sex=@sex where userid=@userid", userUpdate); } return(response); }
public ResponseT <int> Delete(RequestT <UserDelete> request) { return(_user.Delete(request)); }
public ResponseT <int> Edit([FromBody] RequestT <UserUpdate> request) { return(_user.Edit(request)); }
public ResponseT <long> Create([FromBody] RequestT <UserAdd> request) { return(_user.Create(request)); }