//增加 // POST: api/userInnfo public void Post([FromBody] UserInfos value) { using (osms1Entities1 db = new osms1Entities1()) { db.UserInfos.Add(value); db.SaveChanges(); } }
//[HttpPost] //public string GetLogin(System.Web.Mvc.FormCollection forms) //{ // var username = forms["username"]; // var password = forms["password"]; // using (osms1Entities1 db = new osms1Entities1()) // { // var user = db.UserInfos.SingleOrDefault(u => u.UserName == username); // if (user != null && user.Password == password) // { // return "0000"; // } // else // { // return "1101"; // } // } //} //查询表信息 // GET: api/userInnfo public string Get() { using (osms1Entities1 db = new osms1Entities1()) { var user = db.UserInfos.ToList(); return(JsonConvert.SerializeObject(user)); } }
// PUT: api/userInnfo/5 public void Put(int id, [FromBody] UserInfos value) { using (osms1Entities1 db = new osms1Entities1()) { var userinfo = db.UserInfos.SingleOrDefault(u => u.Id == id); if (userinfo != null) { userinfo.UserName = value.UserName; userinfo.Password = value.Password; } } }
//根据ID修改 // GET: api/userInnfo/5 public void Get(int id) { using (osms1Entities1 db = new osms1Entities1()) { var user = db.UserInfos.SingleOrDefault(u => u.Id == id); if (user != null) { user.Password = "******"; db.SaveChanges(); } } }
public void Delete(int id) { using (osms1Entities1 db = new osms1Entities1()) { var userid = db.UserInfos.SingleOrDefault(u => u.Id == id); if (userid != null) { db.UserInfos.Remove(userid); db.SaveChanges(); } //var userid=db.UserInfos.SingleOrDefault() } }
public string GetLogin([FromBody] LoginModel model) { //var username = forms["username"]; //var password = forms["password"]; using (osms1Entities1 db = new osms1Entities1()) { var user = db.UserInfos.SingleOrDefault(u => u.UserName == model.Username); if (user != null && user.Password == model.Password) { return("0000"); } else { return("1101"); } } }