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));
}
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));
}
public int UpdatePartBuildInfo(BuildInfoSet buildInfoSet)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@BuildID", buildInfoSet.BuildID),
new SqlParameter("@BuildName", buildInfoSet.BuildName),
new SqlParameter("@BuildAddr", buildInfoSet.BuildAddr),
new SqlParameter("@BuildLong", buildInfoSet.BuildLong),
new SqlParameter("@BuildLat", buildInfoSet.BuildLat),
new SqlParameter("@TotalArea", buildInfoSet.TotalArea),
new SqlParameter("@NumberOfPeople", buildInfoSet.NumberOfPeople),
new SqlParameter("@TransCount", buildInfoSet.TransCount),
new SqlParameter("@InstallCapacity", buildInfoSet.InstallCapacity),
new SqlParameter("@OperateCapacity", buildInfoSet.OperateCapacity),
new SqlParameter("@DesignMeters", buildInfoSet.DesignMeters)
};
return(_db.Database.ExecuteSqlCommand(BuildSetResources.UpdatePartBuildInfo, sqlParameters));
}
public int UpdateBuildInfo(BuildInfoSet buildInfoSet)
{
SqlParameter[] sqlParameters =
{
new SqlParameter("@BuildID", buildInfoSet.BuildID),
new SqlParameter("@DataCenterID", buildInfoSet.DataCenterID),
new SqlParameter("@BuildName", buildInfoSet.BuildName),
new SqlParameter("@AliasName", buildInfoSet.AliasName),
new SqlParameter("@BuildOwner", buildInfoSet.BuildOwner),
new SqlParameter("@DistrictCode", buildInfoSet.DistrictCode),
new SqlParameter("@BuildAddr", buildInfoSet.BuildAddr),
new SqlParameter("@BuildLong", buildInfoSet.BuildLong),
new SqlParameter("@BuildLat", buildInfoSet.BuildLat),
new SqlParameter("@BuildYear", buildInfoSet.BuildYear),
new SqlParameter("@UpFloor", buildInfoSet.UpFloor),
new SqlParameter("@DownFloor", buildInfoSet.DownFloor),
new SqlParameter("@BuildFunc", buildInfoSet.BuildFunc),
new SqlParameter("@TotalArea", buildInfoSet.TotalArea),
new SqlParameter("@AirArea", buildInfoSet.AirArea),
new SqlParameter("@DesignDept", buildInfoSet.DesignDept),
new SqlParameter("@WorkDept", buildInfoSet.WorkDept),
new SqlParameter("@CreateTime", buildInfoSet.CreateTime),
new SqlParameter("@CreateUser", buildInfoSet.CreateUser),
new SqlParameter("@MonitorDate", buildInfoSet.MonitorDate),
new SqlParameter("@AcceptDate", buildInfoSet.AcceptDate),
new SqlParameter("@NumberOfPeople", buildInfoSet.NumberOfPeople),
new SqlParameter("@SPArea", buildInfoSet.SPArea),
new SqlParameter("@TransCount", buildInfoSet.TransCount),
new SqlParameter("@InstallCapacity", buildInfoSet.InstallCapacity),
new SqlParameter("@OperateCapacity", buildInfoSet.OperateCapacity),
new SqlParameter("@DesignMeters", buildInfoSet.DesignMeters),
new SqlParameter("@Mobiles", buildInfoSet.Mobiles)
};
return(_db.Database.ExecuteSqlCommand(BuildSetResources.UpdateBuildInfo, sqlParameters));
}
public object Updata([FromBody] JObject obj)
{
try
{
BuildInfoSet inputBuildInfoSet = new BuildInfoSet();
inputBuildInfoSet.BuildID = obj["BuildID"].ToString();
inputBuildInfoSet.BuildName = obj["BuildName"].ToString();
inputBuildInfoSet.AliasName = obj["AliasName"].ToString();
inputBuildInfoSet.BuildOwner = obj["BuildOwner"].ToString();
inputBuildInfoSet.BuildAddr = obj["BuildAddr"].ToString();
inputBuildInfoSet.BuildLong = Convert.ToDecimal(obj["BuildLong"].ToString());
inputBuildInfoSet.BuildLat = Convert.ToDecimal(obj["BuildLat"].ToString());
inputBuildInfoSet.UpFloor = Convert.ToInt32(obj["UpFloor"].ToString());
inputBuildInfoSet.DownFloor = Convert.ToInt32(obj["DownFloor"].ToString());
inputBuildInfoSet.TotalArea = Convert.ToDecimal(obj["TotalArea"].ToString());
inputBuildInfoSet.AirArea = Convert.ToDecimal(obj["AirArea"].ToString());
inputBuildInfoSet.DesignDept = obj["DesignDept"].ToString();
inputBuildInfoSet.WorkDept = obj["WorkDept"].ToString();
inputBuildInfoSet.CreateUser = User.Identity.Name;
inputBuildInfoSet.NumberOfPeople = Convert.ToInt32(obj["NumberOfPeople"].ToString());
inputBuildInfoSet.TransCount = Convert.ToInt32(obj["TransCount"].ToString());
//安装变压器容量，运行容量，监控仪表数量，联系电话
inputBuildInfoSet.InstallCapacity = Convert.ToInt32(obj["InstallCapacity"].ToString());
inputBuildInfoSet.OperateCapacity = Convert.ToInt32(obj["OperateCapacity"].ToString());
inputBuildInfoSet.DesignMeters = Convert.ToInt32(obj["DesignMeters"].ToString());
inputBuildInfoSet.Mobiles = obj["Mobiles"].ToString();
return(service.UpdateBuild(inputBuildInfoSet));
}
catch (Exception e)
{
return(9999);
}
}
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);
}
