public void TestDeleteBuild() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.DeleteBuild("000001G005"); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
public void TestGetBuildInfo() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.GetViewModel("000001G001"); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
public void TestGetBuildListByuser() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.GetViewModelByUserName("admin"); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
public void TestUpdataBuild_OK2() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.GetAllBuilds(); BuildViewModel lasstbuild = ViewModel.Builds.Last(); string buildID = "000001G008"; string buildName = "test8"; string buildAddr = "test addr 8"; decimal buildLong = 123; decimal buildLat = 45; decimal totalArea = 789; int numberOfPeople = 1234; int transCount = 45; int installCapacity = 78; int operateCapacity = 90; int designMeters = 100; ViewModel = service.UpdatePartBuildInfo(buildID, buildName, buildAddr, buildLong, buildLat, totalArea, numberOfPeople, transCount, installCapacity, operateCapacity, designMeters ); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
public void TestAddBuild_OK2() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.GetAllBuilds(); BuildViewModel lasstbuild = ViewModel.Builds.Last(); BuildInfoSet buildInfoSet = new BuildInfoSet(); buildInfoSet.BuildName = "TestName" + (DateTime.Now).ToString(); buildInfoSet.AliasName = "TestName" + (DateTime.Now).ToString(); buildInfoSet.BuildOwner = "TestOwner" + (DateTime.Now).ToString(); //BuildID,DataCenterID,BuildName,AliasName,BuildOwner //,DistrictCode,BuildAddr,BuildLong,BuildLat,BuildYear //,UpFloor,DownFloor,BuildFunc,TotalArea,AirArea //,DesignDept,WorkDept,CreateTime,CreateUser,MonitorDate //,AcceptDate,NumberOfPeople,SPArea,Image,TransCount //,InstallCapacity,OperateCapacity,DesignMeters,Mobiles ViewModel = service.AddBuild(buildInfoSet); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
/// <summary> /// 删除建筑,删除建筑前,须先删除与建筑关联的仪表和支路; /// </summary> /// <param name="buildId"></param> /// <returns></returns> public BuildSetViewModel DeleteBuild(string buildId) { BuildSetViewModel viewModel = new BuildSetViewModel(); ResultState resultState = new ResultState(); if (string.IsNullOrEmpty(buildId)) { resultState.State = 1; resultState.Details = "建筑ID不能为空,请输入正确的建筑ID。"; viewModel.ResultState = resultState; return(viewModel); } int result = context.DeleteBuild(buildId); if (result == 1) { resultState.State = 0; viewModel.ResultState = resultState; } else { resultState.State = 1; viewModel.ResultState = resultState; } return(viewModel); }
public void TestUpdataBuild_OK() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.GetAllBuilds(); BuildViewModel lasstbuild = ViewModel.Builds.Last(); string newBuildID = "000001G005"; BuildInfoSet buildInfoSet = new BuildInfoSet(); buildInfoSet.BuildID = newBuildID; buildInfoSet.DataCenterID = "000001"; buildInfoSet.BuildName = "TestName" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); buildInfoSet.AliasName = "TestName" + DateTime.Now.ToString("HH:mm:ss"); buildInfoSet.BuildOwner = "TestOwner"; buildInfoSet.DistrictCode = "310000"; buildInfoSet.BuildAddr = "Addr Test"; buildInfoSet.BuildLong = 123; buildInfoSet.BuildLat = 45; buildInfoSet.BuildYear = 2018; buildInfoSet.UpFloor = (DateTime.Now.Hour + 1); buildInfoSet.DownFloor = DateTime.Now.Hour; buildInfoSet.BuildFunc = "G"; buildInfoSet.TotalArea = 5000; buildInfoSet.AirArea = 3000; buildInfoSet.DesignDept = "设计单位"; buildInfoSet.WorkDept = "使用单位"; buildInfoSet.CreateTime = DateTime.Now; buildInfoSet.CreateUser = "******"; buildInfoSet.MonitorDate = DateTime.Now; buildInfoSet.AcceptDate = DateTime.Now; buildInfoSet.NumberOfPeople = 500; buildInfoSet.SPArea = 500; buildInfoSet.Image = null; buildInfoSet.TransCount = 5; buildInfoSet.InstallCapacity = 500; buildInfoSet.OperateCapacity = 400; buildInfoSet.DesignMeters = 20; buildInfoSet.Mobiles = "12345678901"; //BuildID,DataCenterID,BuildName,AliasName,BuildOwner //,DistrictCode,BuildAddr,BuildLong,BuildLat,BuildYear //,UpFloor,DownFloor,BuildFunc,TotalArea,AirArea //,DesignDept,WorkDept,CreateTime,CreateUser,MonitorDate //,AcceptDate,NumberOfPeople,SPArea,Image,TransCount //,InstallCapacity,OperateCapacity,DesignMeters,Mobiles ViewModel = service.UpdateBuild(buildInfoSet); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
/// <summary> /// 获取建筑信息 /// </summary> /// <param name="buildId"></param> /// <returns></returns> public BuildSetViewModel GetViewModel(string buildId) { List <BuildInfoSet> buildInfo = context.GetBuildInfoList(buildId); BuildSetViewModel viewModel = new BuildSetViewModel(); viewModel.BuildInfo = buildInfo; return(viewModel); }
/// <summary> /// 获取用户关联的建筑 /// </summary> /// <param name="userName"></param> /// <returns></returns> public BuildSetViewModel GetViewModelByUserName(string userName) { List <BuildInfoSet> buildInfoList = context.GetBuildInfoAll(userName); BuildSetViewModel viewModel = new BuildSetViewModel(); viewModel.BuildInfo = buildInfoList; return(viewModel); }
/// <summary> /// 获取系统中全部的建筑 /// </summary> /// <returns></returns> public BuildSetViewModel GetAllBuilds() { BuildSetViewModel viewModel = new BuildSetViewModel(); List <BuildViewModel> builds = context.GetBuildList(); viewModel.Builds = builds; return(viewModel); }
public void TestAddBuild_OK() { BuildSetService service = new BuildSetService(); BuildSetViewModel ViewModel = service.GetAllBuilds(); BuildViewModel lasstbuild = ViewModel.Builds.Last(); string lastBID = lasstbuild.BuildID; string newBuildID; int bID = Convert.ToInt16(lastBID.Substring(lastBID.Length - 3)); if (bID + 1 < 10) { newBuildID = "000001G00" + (bID + 1).ToString(); } else if (bID + 1 >= 10 && bID + 1 < 100) { newBuildID = "000001G0" + (bID + 1).ToString(); } else { newBuildID = "000001G" + (bID + 1).ToString(); } BuildInfoSet buildInfoSet = new BuildInfoSet(); buildInfoSet.BuildID = newBuildID; buildInfoSet.DataCenterID = "000001"; buildInfoSet.BuildName = "TestName" + (bID + 1).ToString(); buildInfoSet.AliasName = "TestName" + (bID + 1).ToString(); buildInfoSet.BuildOwner = "TestOwner" + (bID + 1).ToString(); buildInfoSet.DistrictCode = "310000"; buildInfoSet.BuildAddr = "Addr Test"; buildInfoSet.BuildLong = 123; buildInfoSet.BuildLat = 45; buildInfoSet.BuildYear = 2018; buildInfoSet.UpFloor = (bID + 1); buildInfoSet.DownFloor = bID; buildInfoSet.BuildFunc = "G"; buildInfoSet.TotalArea = 5000; buildInfoSet.AirArea = 3000; buildInfoSet.DesignDept = "设计单位" + (bID + 1).ToString(); buildInfoSet.WorkDept = "使用单位" + (bID + 1).ToString(); buildInfoSet.CreateTime = DateTime.Now; buildInfoSet.CreateUser = "******"; buildInfoSet.MonitorDate = DateTime.Now; buildInfoSet.AcceptDate = DateTime.Now; buildInfoSet.NumberOfPeople = 500; buildInfoSet.SPArea = 500; buildInfoSet.Image = null; buildInfoSet.TransCount = 5; buildInfoSet.InstallCapacity = 500; buildInfoSet.OperateCapacity = 400; buildInfoSet.DesignMeters = 20 + bID + 1; buildInfoSet.Mobiles = "12345678901"; //BuildID,DataCenterID,BuildName,AliasName,BuildOwner //,DistrictCode,BuildAddr,BuildLong,BuildLat,BuildYear //,UpFloor,DownFloor,BuildFunc,TotalArea,AirArea //,DesignDept,WorkDept,CreateTime,CreateUser,MonitorDate //,AcceptDate,NumberOfPeople,SPArea,Image,TransCount //,InstallCapacity,OperateCapacity,DesignMeters,Mobiles ViewModel = service.AddBuild(buildInfoSet); Console.WriteLine(UtilTest.GetJson(ViewModel)); }
/// <summary> /// 新增建筑 /// </summary> /// <param name="buildInfoSet"></param> /// <returns></returns> public BuildSetViewModel AddBuild(BuildInfoSet inputBuildInfoSet) { try { BuildSetViewModel viewModel = new BuildSetViewModel(); ResultState resultState = new ResultState(); List <BuildViewModel> builds = context.GetBuildList(); //最后一个建筑ID BuildViewModel lastBuilD = builds.Last(); string lastBID = lastBuilD.BuildID; //新插入的建筑ID string newBuildID; int rightID = Convert.ToInt16(lastBID.Substring(lastBID.Length - 3)); if (rightID + 1 < 10) { newBuildID = lastBID.Substring(0, lastBID.Length - 1) + (rightID + 1).ToString(); } else if (rightID + 1 >= 10 && rightID + 1 < 100) { newBuildID = lastBID.Substring(0, lastBID.Length - 2) + (rightID + 1).ToString(); } else { newBuildID = lastBID.Substring(0, lastBID.Length - 3) + (rightID + 1).ToString(); } BuildInfoSet buildInfoSet = new BuildInfoSet(); buildInfoSet.BuildID = newBuildID; buildInfoSet.DataCenterID = "000001"; buildInfoSet.BuildName = inputBuildInfoSet.BuildName; buildInfoSet.AliasName = string.IsNullOrEmpty(inputBuildInfoSet.AliasName) ? "A" : inputBuildInfoSet.AliasName.Length > 16 ? inputBuildInfoSet.AliasName.Substring(0, 16) : inputBuildInfoSet.AliasName; buildInfoSet.BuildOwner = string.IsNullOrEmpty(inputBuildInfoSet.BuildOwner) ? "无" : inputBuildInfoSet.BuildOwner; buildInfoSet.DistrictCode = "310000"; buildInfoSet.BuildAddr = string.IsNullOrEmpty(inputBuildInfoSet.BuildAddr) ? "无" : inputBuildInfoSet.BuildAddr; buildInfoSet.BuildLong = inputBuildInfoSet.BuildLong > 0 ? inputBuildInfoSet.BuildLong : 121; //默认上海市坐标121.506267,31.243709 buildInfoSet.BuildLat = inputBuildInfoSet.BuildLat > 0 ? inputBuildInfoSet.BuildLat : 31; buildInfoSet.BuildYear = DateTime.Now.Year; buildInfoSet.UpFloor = inputBuildInfoSet.UpFloor > 0 ? inputBuildInfoSet.UpFloor : 0; buildInfoSet.DownFloor = inputBuildInfoSet.DownFloor > 0 ? inputBuildInfoSet.DownFloor : 0; buildInfoSet.BuildFunc = "G"; buildInfoSet.TotalArea = inputBuildInfoSet.TotalArea > 0 ? inputBuildInfoSet.TotalArea : 0; buildInfoSet.AirArea = inputBuildInfoSet.AirArea > 0 ? inputBuildInfoSet.AirArea : 0; buildInfoSet.DesignDept = string.IsNullOrEmpty(inputBuildInfoSet.DesignDept) ? "无" : inputBuildInfoSet.DesignDept; buildInfoSet.WorkDept = string.IsNullOrEmpty(inputBuildInfoSet.WorkDept) ? "无" : inputBuildInfoSet.WorkDept; buildInfoSet.CreateTime = DateTime.Now; buildInfoSet.CreateUser = string.IsNullOrEmpty(inputBuildInfoSet.CreateUser) ? "无" : inputBuildInfoSet.CreateUser; buildInfoSet.MonitorDate = DateTime.Now; buildInfoSet.AcceptDate = DateTime.Now; buildInfoSet.NumberOfPeople = inputBuildInfoSet.NumberOfPeople > 0 ? inputBuildInfoSet.NumberOfPeople : 0; buildInfoSet.SPArea = 0; buildInfoSet.TransCount = inputBuildInfoSet.TransCount > 0 ? inputBuildInfoSet.TransCount : 0; //安装变压器容量,运行容量,监控仪表数量,联系电话 buildInfoSet.InstallCapacity = inputBuildInfoSet.InstallCapacity > 0 ? inputBuildInfoSet.InstallCapacity : 0; buildInfoSet.OperateCapacity = inputBuildInfoSet.OperateCapacity > 0 ? inputBuildInfoSet.OperateCapacity : 0; buildInfoSet.DesignMeters = inputBuildInfoSet.DesignMeters > 0 ? inputBuildInfoSet.DesignMeters : 0; buildInfoSet.Mobiles = string.IsNullOrEmpty(inputBuildInfoSet.Mobiles) ? "无" : inputBuildInfoSet.Mobiles; int result = context.AddBuildInfo(buildInfoSet); if (result == 1) { resultState.State = 0; viewModel.ResultState = resultState; } else { resultState.State = 1; viewModel.ResultState = resultState; } return(viewModel); } catch (Exception ex) { BuildSetViewModel viewModel = new BuildSetViewModel(); ResultState resultState = new ResultState(); resultState.State = 1; resultState.Details = ex.Message; viewModel.ResultState = resultState; return(viewModel); } }
/// <summary> /// 更新建筑信息 /// </summary> /// <param name="buildID"></param> /// <param name="buildName"></param> /// <param name="buildAddr"></param> /// <param name="buildLong"></param> /// <param name="buildLat"></param> /// <param name="totalArea"></param> /// <param name="numberOfPeople"></param> /// <param name="transCount"></param> /// <param name="installCapacity"></param> /// <param name="operateCapacity"></param> /// <param name="designMeters"></param> /// <returns></returns> public BuildSetViewModel UpdatePartBuildInfo(string buildID, string buildName, string buildAddr, decimal buildLong, decimal buildLat, decimal totalArea, int numberOfPeople, int transCount, int installCapacity, int operateCapacity, int designMeters) { BuildSetViewModel viewModel = new BuildSetViewModel(); ResultState resultState = new ResultState(); BuildInfoSet buildInfoSet = new BuildInfoSet(); if (string.IsNullOrEmpty(buildID)) { resultState.State = 1; resultState.Details = "建筑ID不能为空,请输入正确的建筑ID。"; viewModel.ResultState = resultState; return(viewModel); } List <BuildInfoSet> buildInfo = context.GetBuildByNmaeList(buildID, buildName); if (buildInfo.Count > 0) { resultState.State = 1; resultState.Details = "建筑名称重复,请输入其他名称。"; viewModel.ResultState = resultState; return(viewModel); } buildInfoSet.BuildID = buildID; buildInfoSet.BuildName = buildName; buildInfoSet.BuildAddr = string.IsNullOrEmpty(buildAddr) ? "无" : buildAddr; buildInfoSet.BuildLong = buildLong > 0 ? buildLong : 121.5062m; //默认上海市坐标121.506267,31.243709 buildInfoSet.BuildLat = buildLat > 0 ? buildLat : 31.2437m; buildInfoSet.TotalArea = totalArea > 0 ? totalArea : 0; buildInfoSet.NumberOfPeople = numberOfPeople > 0 ? numberOfPeople : 0; //变压器数量,安装变压器容量,运行容量,监控仪表数量 buildInfoSet.TransCount = transCount > 0 ? transCount : 0; buildInfoSet.InstallCapacity = installCapacity > 0 ? installCapacity : 0; buildInfoSet.OperateCapacity = operateCapacity > 0 ? operateCapacity : 0; buildInfoSet.DesignMeters = designMeters > 0 ? designMeters : 0; int result = context.UpdatePartBuildInfo(buildInfoSet); if (result == 1) { resultState.State = 0; resultState.Details = "OK"; viewModel.ResultState = resultState; } else { resultState.State = 1; resultState.Details = "NG"; viewModel.ResultState = resultState; } return(viewModel); }
/// <summary> /// 修改建筑信息 /// </summary> /// <param name="buildInfoSet"></param> /// <returns></returns> public BuildSetViewModel UpdateBuild(BuildInfoSet inputBuildInfoSet) { BuildSetViewModel viewModel = new BuildSetViewModel(); ResultState resultState = new ResultState(); BuildInfoSet buildInfoSet = new BuildInfoSet(); if (string.IsNullOrEmpty(inputBuildInfoSet.BuildID)) { resultState.State = 1; resultState.Details = "建筑ID不能为空,请输入正确的建筑ID。"; viewModel.ResultState = resultState; return(viewModel); } buildInfoSet.BuildID = inputBuildInfoSet.BuildID; buildInfoSet.DataCenterID = "000001"; buildInfoSet.BuildName = inputBuildInfoSet.BuildName; buildInfoSet.AliasName = string.IsNullOrEmpty(inputBuildInfoSet.AliasName) ? "A" : inputBuildInfoSet.AliasName.Length > 16 ? inputBuildInfoSet.AliasName.Substring(0, 16) : inputBuildInfoSet.AliasName; buildInfoSet.BuildOwner = string.IsNullOrEmpty(inputBuildInfoSet.BuildOwner) ? "无" : inputBuildInfoSet.BuildOwner; buildInfoSet.DistrictCode = "310000"; buildInfoSet.BuildAddr = string.IsNullOrEmpty(inputBuildInfoSet.BuildAddr) ? "无" : inputBuildInfoSet.BuildAddr; buildInfoSet.BuildLong = inputBuildInfoSet.BuildLong > 0 ? inputBuildInfoSet.BuildLong : 121; //默认上海市坐标121.506267,31.243709 buildInfoSet.BuildLat = inputBuildInfoSet.BuildLat > 0 ? inputBuildInfoSet.BuildLat : 31; buildInfoSet.BuildYear = DateTime.Now.Year; buildInfoSet.UpFloor = inputBuildInfoSet.UpFloor > 0 ? inputBuildInfoSet.UpFloor : 0; buildInfoSet.DownFloor = inputBuildInfoSet.DownFloor > 0 ? inputBuildInfoSet.DownFloor : 0; buildInfoSet.BuildFunc = "G"; buildInfoSet.TotalArea = inputBuildInfoSet.TotalArea > 0 ? inputBuildInfoSet.TotalArea : 0; buildInfoSet.AirArea = inputBuildInfoSet.AirArea > 0 ? inputBuildInfoSet.AirArea : 0; buildInfoSet.DesignDept = string.IsNullOrEmpty(inputBuildInfoSet.DesignDept) ? "无" : inputBuildInfoSet.DesignDept; buildInfoSet.WorkDept = string.IsNullOrEmpty(inputBuildInfoSet.WorkDept) ? "无" : inputBuildInfoSet.WorkDept; buildInfoSet.CreateTime = DateTime.Now; buildInfoSet.CreateUser = string.IsNullOrEmpty(inputBuildInfoSet.CreateUser) ? "无" : inputBuildInfoSet.CreateUser; buildInfoSet.MonitorDate = DateTime.Now; buildInfoSet.AcceptDate = DateTime.Now; buildInfoSet.NumberOfPeople = inputBuildInfoSet.NumberOfPeople > 0 ? inputBuildInfoSet.NumberOfPeople : 0; buildInfoSet.SPArea = 0; buildInfoSet.TransCount = inputBuildInfoSet.TransCount > 0 ? inputBuildInfoSet.TransCount : 0; //安装变压器容量,运行容量,监控仪表数量,联系电话 buildInfoSet.InstallCapacity = inputBuildInfoSet.InstallCapacity > 0 ? inputBuildInfoSet.InstallCapacity : 0; buildInfoSet.OperateCapacity = inputBuildInfoSet.OperateCapacity > 0 ? inputBuildInfoSet.OperateCapacity : 0; buildInfoSet.DesignMeters = inputBuildInfoSet.DesignMeters > 0 ? inputBuildInfoSet.DesignMeters : 0; buildInfoSet.Mobiles = string.IsNullOrEmpty(inputBuildInfoSet.Mobiles) ? "无" : inputBuildInfoSet.Mobiles; int result = context.UpdateBuildInfo(buildInfoSet); if (result == 1) { resultState.State = 0; viewModel.ResultState = resultState; } else { resultState.State = 1; viewModel.ResultState = resultState; } return(viewModel); }