/// <summary> /// 修改巡查区域 /// </summary> /// <param name="patrolid"></param> /// <returns></returns> public int EditPatrolAreas(QW_PatrolAreasModel model) { using (Entities db = new Entities()) { qw_patrolareas qpmodel = db.qw_patrolareas.SingleOrDefault(t => t.patrolid == model.patrolid); if (qpmodel != null) { qpmodel.grometry = model.grometry; qpmodel.explain = model.explain; qpmodel.sszd = model.sszd; qpmodel.ssbc = model.ssbc; qpmodel.name = model.name; qpmodel.areatype = model.areatype; qpmodel.createuserid = model.createuserid; } return(db.SaveChanges()); } }
/// <summary> /// 添加巡查区域 /// </summary> /// <param name="model"></param> public void AddPatrolAreas(QW_PatrolAreasModel model) { using (Entities db = new Entities()) { qw_patrolareas qwmodel = new qw_patrolareas(); qwmodel.patrolid = model.patrolid; qwmodel.sszd = model.sszd; qwmodel.ssbc = model.ssbc; qwmodel.name = model.name; qwmodel.areatype = model.areatype; qwmodel.explain = model.explain; qwmodel.grometry = model.grometry; qwmodel.createtime = model.createtime; qwmodel.createuserid = model.createuserid; qwmodel.isnot = 0; db.qw_patrolareas.Add(qwmodel); db.SaveChanges(); } }
/// <summary> /// 删除巡查区域 /// </summary> /// <param name="patrolid"></param> /// <returns></returns> public int DeletePatrolAreas(int patrolid) { using (Entities db = new Entities()) { qw_patrolareas model = db.qw_patrolareas.SingleOrDefault(t => t.patrolid == patrolid); if (model != null) { try { model.isnot = 1; return(db.SaveChanges()); } catch (Exception e) { return(0); } } else { return(0); } } }