public ActionResult LineCreate(FormCollection fc) { var model = new tblline(); var bll = new MatchBll(); model.Lineid = Guid.NewGuid().ToString(); model.Name = fc["Name"].ToString().Trim(); model.Content = fc["Content"].ToString().Trim(); model.Players = Int32.Parse(fc["Players"].ToString().Trim()); model.Count = Int32.Parse(fc["Count"].ToString().Trim()); model.Conditions = "{players:\"" + model.Players.ToString() + "\",count:\"" + model.Count.ToString() + "\"}"; model.Createtime = DateTime.Now; model.Status = Int32.Parse(fc["optStatus"].ToString()); try { bll.AddLine(model); } catch (ValidException ex) { this.ModelState.AddModelError(ex.Name, ex.Message); return(View(model)); } return(this.RefreshParent()); }
/// <summary> /// 删除线路 /// </summary> /// <param name="ids"></param> /// <returns></returns> public int DeleteLine(List <string> ids) { using (var db = new BFdbContext()) { int res = 0; using (var tx = db.BeginTransaction()) { try { foreach (string id in ids) { tblline ent = db.tblline.FirstOrDefault(p => p.Lineid == id); ent.Status = 2; db.TUpdate <tblline>(ent); } db.SaveChanges(); tx.Commit(); } catch (Exception ex) { tx.Rollback(); throw ex; } } return(res); } }
/// <summary> /// 新增线路 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int AddLine(tblline ent) { using (var db = new BFdbContext()) { return(db.Insert <tblline>(ent)); } }
/// <summary> /// 更新线路 /// </summary> /// <param name="ent"></param> /// <returns></returns> public int EditLine(tblline ent) { using (var db = new BFdbContext()) { tblline line = db.tblline.FirstOrDefault(p => p.Lineid == ent.Lineid); line.Name = ent.Name; line.Content = ent.Content; line.Players = ent.Players; line.Count = ent.Count; line.Conditions = ent.Conditions; line.Status = ent.Status; return(db.Update <tblline>(line)); } }