/// <summary> /// 创建求资源 /// </summary> /// <param name="model"></param> public static void Create(ManageAskViewModel model) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { tbl_Ask ask = new tbl_Ask() { ask_Movie = model.MovieId, ask_Note = model.Note, ask_State = false, ask_With = 0 }; if (model.User != null) { ask.ask_User = model.User; } string guid; do { guid = Guid.NewGuid().ToString("N").ToUpper(); } while (_db.tbl_Ask.Where(p => p.ask_Id == guid).Count() != 0); ask.ask_Id = guid; //_db.tbl_Ask.InsertOnSubmit(ask); //_db.SubmitChanges(); //_db.SetAskTime(guid); _db.tbl_Ask.Add(ask); _db.SaveChanges(); } }
/// <summary> /// 取消求资源 /// </summary> /// <param name="id">求资源id</param> public static void Delete(string id) { using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { tbl_Ask ask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id); _db.tbl_Ask.DeleteOnSubmit(ask); _db.SubmitChanges(); } }
/// <summary> /// 求资源已求到 /// </summary> /// <param name="id">求资源id</param> public static void Over(string id) { using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) { tbl_Ask tblask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id); tblask.ask_State = true; _db.SubmitChanges(); } }
/// <summary> /// 取消求资源 /// </summary> /// <param name="id">求资源id</param> public static void Delete(string id) { //using (MR_DataClassesDataContext _db = new MR_DataClassesDataContext()) using (MRDataEntities _db = new MRDataEntities()) { tbl_Ask ask = _db.tbl_Ask.SingleOrDefault(s => s.ask_Id == id); //_db.tbl_Ask.DeleteOnSubmit(ask); _db.tbl_Ask.Remove(ask); //_db.SubmitChanges(); _db.SaveChanges(); } }
public AskViewModel(tbl_Ask ask) { Id = ask.ask_Id; MovieId = ask.ask_Movie; MR_DataClassesDataContext _db = new MR_DataClassesDataContext(); tbl_Movie tblmovie = _db.tbl_Movie.SingleOrDefault(m => m.movie_Id == ask.ask_Movie); Movie = new MovieViewModel(tblmovie); Note = ask.ask_Note; State = (bool)ask.ask_State; User = ask.ask_User; Account = AccountManager.GetAccount(ask.ask_User); Time = ((DateTime)ask.ask_Time).Date.ToShortDateString();; With = (int)ask.ask_With; hadWith = false; }