public async Task <IHttpActionResult> GetDeviceType(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } DeviceType item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { UUID = item.UUID, Name = item.Name, Description = item.Description, Unit = item.Unit, Price1 = TextHelper.ConvertMoney(item.Price1), Price2 = TextHelper.ConvertMoney(item.Price2), Price3 = TextHelper.ConvertMoney(item.Price3), Price4 = TextHelper.ConvertMoney(item.Price4), Price5 = TextHelper.ConvertMoney(item.Price5), CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PutAdmin(string uuid, [FromUri] Admin admin) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } if (uuid != admin.UUID) { return(BadRequest()); } try { admin.Password = TextHelper.MD5Encrypt(admin.Password); admin.CreateTime = DateTime.Now; await this.adminRepository.PutAsync(admin); } catch (DbUpdateConcurrencyException) { if (!this.adminRepository.IsExist(uuid)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> GetRecharge(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Recharge item = await this.rechargeRespository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { UUID = item.UUID, RoomNo = item.RoomNo, RealName = item.Room.RealName, Money = TextHelper.ConvertMoney(item.Money), DateTime = item.DateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PostDevice([FromUri] Device device) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } try { device.Status = 0; device.DateTime = DateTime.Now; device.ArchiveTime = DateTime.Now; await this.repository.AddAsync(device); } catch (DbUpdateException) { if (this.repository.IsExist(device.DeviceNo)) { return(Conflict()); } else { throw; } } return(Ok()); }
public async Task <IHttpActionResult> PostRoom([FromUri] Room room) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } try { room.CreateTime = DateTime.Now; await this.roomRepository.AddAsync(room); TextHelper.SetCacheBuilding(this.buildingRepository, this.roomRepository); } catch (DbUpdateException) { if (this.roomRepository.IsExist(room.RoomNo)) { return(Conflict()); } else { throw; } } return(Ok()); }
public async Task <IHttpActionResult> GetAdmin(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Admin item = await this.adminRepository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { UUID = item.UUID, RoleID = item.RoleID, RoleName = item.Role.Name, UserName = item.UserName, Password = item.Password, RealName = item.RealName, Phone = item.Phone, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PostCommunity([FromUri] Community Community) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } try { Community.UUID = TextHelper.GenerateUUID(); Community.CreateTime = DateTime.Now; await this.repository.AddAsync(Community); } catch (DbUpdateException) { if (this.repository.IsExist(Community.UUID)) { return(Conflict()); } else { throw; } } return(Ok()); }
public async Task <IHttpActionResult> PutRoom(string uuid, [FromUri] Room room) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } if (uuid != room.RoomNo) { return(BadRequest()); } try { room.CreateTime = DateTime.Now; await this.roomRepository.PutAsync(room); TextHelper.SetCacheBuilding(this.buildingRepository, this.roomRepository); } catch (DbUpdateConcurrencyException) { if (!this.roomRepository.IsExist(uuid)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> PutLog(int uuid, [FromUri] Log log) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } if (uuid != log.ID) { return(BadRequest()); } try { log.DateTime = DateTime.Now; await this.repository.PutAsync(log); } catch (DbUpdateConcurrencyException) { if (!this.repository.IsExist(uuid)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> GetLog(int uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Log item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { ID = item.ID, UserName = item.Admin.UserName, RealName = item.Admin.RealName, Phone = item.Admin.Phone, Type = item.Type, ClientAddr = item.ClientAddr, Content = item.Content, DateTime = item.DateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> GetBill(int uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Bill item = await this.billRepository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { ID = item.ID, DeviceNo = item.DeviceNo, DeviceName = item.Device.DeviceName, RoomNo = item.Device.RoomNo, PreValue = item.PreValue, CurValue = item.CurValue, Money = TextHelper.ConvertMoney(item.Money), DateTime = item.DateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PostBill([FromUri] Bill bill) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } try { bill.LotNo = TextHelper.GenerateUUID(); bill.DateTime = DateTime.Now; //bill.Remark = string.Format("yyyy-MM", bill.DateTime); await this.billRepository.AddAsync(bill); } catch (DbUpdateException) { if (this.billRepository.IsExist(bill.ID)) { return(Conflict()); } else { throw; } } return(Ok()); }
public IHttpActionResult ExportRoomBills() { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } string fileName = string.Format("业主能耗缴费历史账单{0}.xls", DateTime.Now.ToString("yyyy-MM-dd[hh-mm-ss]")); string[] titles = { "房间编号", "结算批号", "业主姓名", "结算时间", "设备编号", "设备名称", "上次刻度", "结算刻度", "单价", "价格", "总费用", "账户余额" }; string RoomNo = HttpContext.Current.Request.Params["RoomNo"]; string BuildingNo = HttpContext.Current.Request.Params["BuildingNo"]; string Floor = HttpContext.Current.Request.Params["Floor"]; string RealName = HttpContext.Current.Request.Params["RealName"]; string StartTime = HttpContext.Current.Request.Params["StartTime"]; string EndTime = HttpContext.Current.Request.Params["EndTime"]; IEnumerable <RoomBill> bills = this.billRepository.GetRoomBills(RoomNo, BuildingNo, Floor, RealName, StartTime, EndTime); ReportHelper.ExportRoomBills(bills, titles, fileName); HttpContext.Current.Response.ContentType = "text/plain"; HttpContext.Current.Response.Write(fileName); return(Ok()); }
public IHttpActionResult GetArrearsRooms() { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Pager pager = null; IEnumerable <PrepaidBill> bills; string strPageIndex = HttpContext.Current.Request.Params["PageIndex"]; string strPageSize = HttpContext.Current.Request.Params["PageSize"]; string buildingNo = HttpContext.Current.Request.Params["BuildingNo"]; if (strPageIndex == null || strPageSize == null) { pager = new Pager(); bills = this.billRepository.GetArrearsPrepaidBills(buildingNo); } else { // 获取分页数据 int pageIndex = Convert.ToInt32(strPageIndex); int pageSize = Convert.ToInt32(strPageSize); pager = new Pager(pageIndex, pageSize, this.billRepository.GetArrearsPrepaidBillsCount(buildingNo)); bills = this.billRepository.GetArrearsPrepaidPagerBills(buildingNo, pageIndex, pageSize); } pager.Items = bills; return(Ok(pager)); }
public async Task <IHttpActionResult> GetBuilding(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Building item = await this.buildingRepository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { BuildingNo = item.BuildingNo, Name = item.Name, CommunityID = item.CommunityID, CommunityName = item.Community.Name, Description = item.Description, Floors = item.Floors, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
// GET: api/roles/1 public async Task <IHttpActionResult> GetRole(int uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Role item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { ID = item.ID, Name = item.Name, Description = item.Description, Status = item.Status, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> GetMsg(int uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Msg item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { ID = item.ID, RoomNo = item.RoomNo, Content = item.Content, PostType = item.PostType, Status = item.Status, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> GetAlarm(int uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Alarm item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { ID = item.ID, DeviceNo = item.DeviceNo, DeviceName = item.Device.DeviceName, Content = item.Content, Type = item.Type, Level = item.Level, MsgID = item.MsgID, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> GetCutout(int uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Cutout item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { ID = item.ID, DeviceNo = item.DeviceNo, DeviceName = item.Device.DeviceName, Reason = item.Reason, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public IHttpActionResult GetRealtimeFundStatis() { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } IEnumerable <string> BuildingNos = from item in this.buildingRepository.GetAll() select item.BuildingNo; var statises = this.deviceRepository.GetRealtimeFunds(); var Balance = statises.Sum(p => p.totalBalance); double Expend = 0.00; foreach (var item in statises) { Expend += Math.Round(item.totalExpend ?? 0.00, 2); } var items = new { BuildingNos = BuildingNos, TotalBalances = from item in statises select TextHelper.ConvertMoney(item.totalBalance), TotalExpends = from item in statises select TextHelper.ConvertMoney((int)(item.totalExpend ?? 0)), Balance = TextHelper.ConvertMoney(Balance), Expend = TextHelper.ConvertMoney((int)Expend), Percent = string.Format("{0:P}", Expend / Balance) }; return(Ok(items)); }
public async Task <IHttpActionResult> GetLadder(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Ladder item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { UUID = item.UUID, TypeID = item.TypeID, TypeName = item.DeviceType.Name, Name = item.Name, Description = item.Description, MinEnergy = item.MinEnergy, MaxEnergy = item.MaxEnergy, Price = TextHelper.ConvertMoney(item.Price), CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PostLog([FromUri] Log log) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } try { log.DateTime = DateTime.Now; await this.repository.AddAsync(log); } catch (DbUpdateException) { if (this.repository.IsExist(log.ID)) { return(Conflict()); } else { throw; } } return(Ok()); }
public async Task <IHttpActionResult> GetCredit(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Credit item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { UUID = item.UUID, Name = item.Name, Description = item.Description, MinScore = item.MinScore, MaxScore = item.MaxScore, Arrears = TextHelper.ConvertMoney(item.Arrears), CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PutCommunity(string uuid, [FromUri] Community Community) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } if (uuid != Community.UUID) { return(BadRequest()); } try { Community.CreateTime = DateTime.Now; await this.repository.PutAsync(Community); } catch (DbUpdateConcurrencyException) { if (!this.repository.IsExist(uuid)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> PutRecharge(string uuid, [FromUri] Recharge recharge) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } if (uuid != recharge.UUID) { return(BadRequest()); } try { await this.rechargeRespository.PutAsync(recharge); } catch (DbUpdateConcurrencyException) { if (!this.rechargeRespository.IsExist(uuid)) { return(NotFound()); } else { throw; } } return(StatusCode(HttpStatusCode.NoContent)); }
public async Task <IHttpActionResult> GetCommunity(string uuid) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Community item = await this.repository.GetByIdAsync(uuid); if (item == null) { return(NotFound()); } var result = new { UUID = item.UUID, Name = item.Name, Description = item.Description, Address = item.Address, Area = item.Area, Capacity = item.Capacity, CheckInTime = item.CheckInTime, CreateTime = item.CreateTime, Remark = item.Remark }; return(Ok(result)); }
public async Task <IHttpActionResult> PostAdmin([FromUri] Admin admin) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } try { admin.UUID = Prepaid.Utils.TextHelper.GenerateUUID(); admin.Password = TextHelper.MD5Encrypt(admin.Password); admin.CreateTime = DateTime.Now; await this.adminRepository.AddAsync(admin); } catch (DbUpdateException) { if (this.adminRepository.IsExist(admin.UUID)) { return(Conflict()); } else { throw; } } return(Ok()); }
// GET: api/rooms public IHttpActionResult GetRooms() { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Pager pager = null; IEnumerable <Room> rooms; string RealName = HttpContext.Current.Request.Params["RealName"]; string BuildingNo = HttpContext.Current.Request.Params["BuildingNo"]; string RoomNo = HttpContext.Current.Request.Params["RoomNo"]; string Floor = HttpContext.Current.Request.Params["Floor"]; string strPageIndex = HttpContext.Current.Request.Params["PageIndex"]; string strPageSize = HttpContext.Current.Request.Params["PageSize"]; if (strPageIndex == null || strPageSize == null) { pager = new Pager(); rooms = this.roomRepository.GetAll(RealName, BuildingNo, RoomNo, Floor); } else { // 获取分页数据 int pageIndex = Convert.ToInt32(strPageIndex); int pageSize = Convert.ToInt32(strPageSize); pager = new Pager(pageIndex, pageSize, this.roomRepository.GetCount(RealName, BuildingNo, RoomNo, Floor)); rooms = this.roomRepository.GetPagerItems(RealName, BuildingNo, RoomNo, Floor, pageIndex, pageSize, u => u.BuildingNo); } var items = from item in rooms select new { RoomNo = item.RoomNo, BuildingNo = item.BuildingNo, BuildingName = item.Building.Name, Floors = item.Building.Floors, Floor = item.Floor, Area = item.Area, Price = item.Price, RealName = item.RealName, Phone = item.Phone, Email = item.Email, AccountBalance = TextHelper.ConvertMoney(item.AccountBalance), AccountWarnLimit = TextHelper.ConvertMoney(item.AccountWarnLimit), CreditScore = item.CreditScore, AlipayAccount = item.AlipayAccount, WechatAccount = item.WechatAccount, BankAccount = item.BankAccount, CreateTime = item.CreateTime, Remark = item.Remark }; pager.Items = items; return(Ok(pager)); }
public IHttpActionResult GetSystemSetting() { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } Setting setting = TextHelper.GetSystemConfig(); return(Ok(setting)); }
public IHttpActionResult PostSystemSetting([FromUri] Setting setting) { var errResult = TextHelper.CheckAuthorized(Request); if (errResult != null) { return(errResult); } TextHelper.SetSystemConfig(setting); return(Ok()); }