/// <summary>
/// 修改楼栋信息
/// </summary>
/// <param name="buildingId"></param>
/// <param name="cityId"></param>
/// <param name="userName"></param>
/// <param name="buildingObj"></param>
/// <param name="message"></param>
/// <param name="_db"></param>
/// <returns></returns>
public static int UpdateBuildingInfo(int buildingId, int cityId, string userName, JObject buildingObj, out string message, DataBase _db = null)
{
DateTime nowTime = DateTime.Now;
DataBase db = new DataBase(_db);
message = "";
//更新Building值
DATBuilding building = DATBuildingManager.GetBuildingByBuildingId(buildingId, cityId, _db: db);
if (building == null)
{
db.Close();
message = "楼栋不存在或已被删除";
return(0);
}
try
{
foreach (var _prop in buildingObj)
{
string key = _prop.Key;
var property = building.GetType().GetProperties()
.Where(pInfo => pInfo.Name.ToLower().Equals(key.ToLower())).FirstOrDefault();
if (property == null)
{
continue;
}
object _value = CommonUtility.valueType(property.PropertyType, _prop.Value.Value <JValue>().Value, true);
property.SetValue(building, _value, null);
}
building.SaveDateTime = nowTime; //最后修改时间
building.SaveUser = userName; //修改人
db.DB.Update(building);
}
catch (Exception ex)
{
db.Close();
message = "系统异常";
log.Error("修改楼栋时失败,buildingId:" + buildingId, ex);
return(-1);
}
db.Close();
return(1);
}
/// <summary>
/// 修改房号信息
/// </summary>
/// <param name="houseId"></param>
/// <param name="cityId"></param>
/// <param name="userName"></param>
/// <param name="houseObj"></param>
/// <param name="message"></param>
/// <param name="_db"></param>
/// <returns></returns>
public static int UpdateHouseInfo(int houseId, int cityId, string userName, JObject houseObj, out string message, DataBase _db = null)
{
DateTime nowTime = DateTime.Now;
DataBase db = new DataBase(_db);
message = "";
//更新house值
DATHouse house = DATHouseManager.GetHouseByHouseId(houseId, cityId, _db: db);
if (house == null)
{
db.Close();
message = "房号不存在或已被删除";
return(0);
}
try
{
foreach (var _prop in houseObj)
{
string key = _prop.Key;
var property = house.GetType().GetProperties()
.Where(pInfo => pInfo.Name.ToLower().Equals(key.ToLower())).FirstOrDefault();
if (property == null)
{
continue;
}
object _value = CommonUtility.valueType(property.PropertyType, _prop.Value.Value <JValue>().Value, true);
property.SetValue(house, _value, null);
}
house.SaveDateTime = nowTime; //最后修改时间
house.SaveUser = userName; //修改人
DATBuilding building = DATBuildingManager.GetBuildingByBuildingId(house.BuildingId, cityId, db);
if (building.TotalFloor.HasValue && house.EndFloorNo.HasValue && house.EndFloorNo > building.TotalFloor)
{
db.Close();
message = "房号终止楼层不能大于楼栋总层数";
return(0);
}
else if (house.EndFloorNo.HasValue && house.EndFloorNo < house.FloorNo)
{
db.Close();
message = "起始楼层不能大于终止楼层";
return(0);
}
else if (house.EndFloorNo.HasValue && (house.EndFloorNo < -5 || house.FloorNo < -5))
{
db.Close();
message = "房号的起始楼层和终止楼层不能小于-5";
return(0);
}
else
{
db.DB.Update(house);
}
}
catch (Exception ex)
{
db.Close();
message = "系统异常";
log.Error("修改房号时失败,houseId:" + houseId, ex);
return(-1);
}
db.Close();
return(1);
}