public void DeleteUsedInfo(int id) { var msg = new Msg(); try { var Used = new Useds_total(); var used = Used.FindById(id); if (used == null) { throw new Exception("该宿舍读表信息不存在!"); } else if (!Used.Delete(id)) { throw new Exception("删除宿舍读表信息时发生错误!"); } else { msg.Message = "删除成功!"; } } catch (Exception ex) { msg.Code = -1; msg.Message = ex.Message; } Response.Write(msg.ToJson()); Response.End(); }
public ActionResult UsedInfo() { var keyword = ""; int page = 1; int limit = 10; int stat = 0; int count = 0; try { keyword = Request["keyword"]; // 搜索关键词 page = Convert.ToInt32(Request["page"]); if (page < 1) { page = 1; } limit = Convert.ToInt32(Request["limit"]); if (limit > 99 || limit < 1) { limit = 10; } stat = Convert.ToInt32(Request["stat"]); var Useds_total = new Useds_total(); ViewBag.useds = Useds_total.GetByPages(page, limit, ref count, keyword, (int)Session["pid"]);// 获取列表 ViewBag.keyword = keyword; ViewBag.count = count; // 获取当前页数量 ViewBag.page = page; // 获取当前页 return(View()); } catch (Exception) { throw; } }
public void Last(FormCollection collection) { /// 获取宿舍的读表数值 var msg = new Msg(); try { var Used = new Useds_total(); msg.Content = Used.Last(Convert.ToInt32(collection["pid"])); Response.Write(msg.ToJson()); Response.End(); } catch (Exception) { throw; } }
public void CreateUsedInfo(FormCollection collection) { var msg = new Msg(); var Db = new Useds_total().Db; try { var pid = Convert.ToInt32(collection["pid"]); var cold_water_value = Convert.ToSingle(collection["cold_water_value"]); var hot_water_value = Convert.ToSingle(collection["hot_water_value"]); var electric_value = Convert.ToSingle(collection["electric_value"]); var Note = collection["note"]; ///1.1判断输入数值 if (cold_water_value < 0 || hot_water_value < 0 || electric_value < 0) { throw new Exception("数值输入有误,读表数值不能小于0"); } else { var usedinfo = Db.Queryable <T_Used_total>().Single(u => u.Ut_model_state && pid == u.Ut_room_id); if (usedinfo == null)//如果读表数值为null,新建一个读表数值对象 { usedinfo = new T_Used_total(); var room = Db.Queryable <Entity.T_Room>().Single(x => x.Room_id == pid && x.Room_model_state); if (room == null) { throw new Exception("该宿舍不存在,id:" + pid); } usedinfo.Ut_dorm_id = room.Room_dorm_id; usedinfo.Ut_building_id = room.Room_building_id; usedinfo.Ut_room_id = pid; } usedinfo.Ut_note = Note; usedinfo.Ut_hot_water_value = hot_water_value; usedinfo.Ut_cold_water_value = cold_water_value; usedinfo.Ut_electric_value = electric_value; usedinfo.Ut_post_date = DateTime.Now; ///1.2保存读表信息 Db.Ado.BeginTran(); //开始事务 if (usedinfo.Ut_id < 1) // 如果是新增的读表记录,就执行插入操作 { Db.Insertable(usedinfo).ExecuteCommand(); //throw new Exception("插入读表记录时发生错误"); } else if (Db.Updateable(usedinfo).ExecuteCommand() < 1) { throw new Exception("更新读表记录时发生错误"); // 否则执行更新操作 } Db.Ado.CommitTran(); // 提交事务 msg.Message = "保存成功"; } } catch (Exception ex) { Db.Ado.RollbackTran();//发生错误,回滚操作 msg.Code = -1; msg.Message = "添加读表信息时发生错误:" + ex.Message; } Response.Write(msg.ToJson()); Response.End(); }