public static Question GetQues(int QuesID)
{
kemuyiEntities dbcontext = new kemuyiEntities();
var Ques = dbcontext.Question.Find(QuesID);
return(Ques);
}
public static bool Selects(int ID)
{
kemuyiEntities db = new kemuyiEntities();
var users = db.Users.Where(u => u.Name == "要查询的用户名").Select(u => new { Id = u.ID, Name = u.Name, Psw = u.Password }).FirstOrDefault();
return(true);
}
public static bool Selects(int QuestionID)
{
kemuyiEntities db = new kemuyiEntities();
var Question = db.Question.Where(u => u.Content == "要查询的用户名").Select(u => new { Id = u.QuestionID, Name = u.Content, Psw = u.Answer }).FirstOrDefault();
return(true);
}
public static bool TransactionScope(int ID)
{
kemuyiEntities db = new kemuyiEntities();
var user = new Users {
ID = ID
};
db.Users.Attach(user);
return(false);
}
public static void Add(int ID, string Name, string Psw)
{
kemuyiEntities db = new kemuyiEntities();
db.Users.Add(new Users()
{
ID = ID, Name = Name, Password = Psw
});
db.SaveChanges();
}
public static bool TransactionScope(int QuestionID)
{
kemuyiEntities db = new kemuyiEntities();
var Question = new Question {
QuestionID = QuestionID
};
db.Question.Attach(Question);
return(false);
}
public static void Add(int QuestionID, string Content, string Answer)
{
kemuyiEntities db = new kemuyiEntities();
db.Question.Add(new Question()
{
QuestionID = QuestionID, Content = Content, Answer = Answer
});
db.SaveChanges();
}
public static bool Updata(int ID, string Name, string Psw)
{
kemuyiEntities db = new kemuyiEntities();
var user = db.Users.Find(ID);
user.Name = Name;
user.Password = Psw;
db.SaveChanges();
return(false);
}
public static bool Updata(int QuestionID, string Content, string Answer)
{
kemuyiEntities db = new kemuyiEntities();
var Question = db.Question.Find(QuestionID);
Question.Content = Content;
Question.Answer = Answer;
db.SaveChanges();
return(false);
}
public static bool Delete(int ID)
{
kemuyiEntities db = new kemuyiEntities();
var user = new Users {
ID = ID
};
db.Users.Attach(user);
db.Users.Remove(user);
db.SaveChanges();
return(false);
}
public static bool Delete(int QuestionID)
{
kemuyiEntities db = new kemuyiEntities();
var Question = new Question {
QuestionID = QuestionID
};
db.Question.Attach(Question);
db.Question.Remove(Question);
db.SaveChanges();
return(false);
}
