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);
}
