/// <summary>
/// 根据房号ID获取房号详细信息,(根据查勘权限和字表)
/// </summary>
/// <param name="houseId"></param>
/// <param name="cityId"></param>
/// <param name="companyId"></param>
/// <param name="_fxtApi"></param>
/// <returns></returns>
public static DATHouse GetHouseDetailByHouseIdAndCityIdAndCompanyId(int houseId, int cityId, int companyId, FxtAPIClientExtend _fxtApi = null)
{
DATHouse obj = null;
FxtAPIClientExtend fxtApi = new FxtAPIClientExtend(_fxtApi);
try
{
string name = "GetHouseDetailByHouseIdAndCityIdAndCompanyId";
var para = new { houseId = houseId, cityId = cityId, companyId = companyId };
string jsonStr = Convert.ToString(EntranceApi.Entrance(name, para.ToJSONjss(), _fxtApi: fxtApi));
FxtApi_PublicResult result = jsonStr.ParseJSONjss <FxtApi_PublicResult>();
if (result == null || string.IsNullOrEmpty(Convert.ToString(result.data)))
{
fxtApi.Abort();
return(obj);
}
obj = Convert.ToString(result.data).ParseJSONjss <DATHouse>();
fxtApi.Abort();
}
catch (Exception ex)
{
fxtApi.Abort();
log.Error("GetHouseDetailByHouseIdAndCityIdAndCompanyId()", ex);
}
return(obj);
}
/// <summary>
/// 根据房号ID获取房号信息
/// </summary>
/// <param name="houseId"></param>
/// <param name="cityId"></param>
/// <param name="_db"></param>
/// <returns></returns>
public static DATHouse GetHouseByHouseId(int houseId, int cityId, DataBase _db = null)
{
DataBase db = new DataBase(_db);
try
{
string sql = "{0} HouseId=:houseId and CityID=:cityId and Valid=1";
sql = string.Format(sql, NHibernateUtility.GetMSSQL_SQL_NOLOCK(NHibernateUtility.TableName_DATHouse));
List <NHParameter> parameters = new List <NHParameter>();
parameters.Add(new NHParameter("houseId", houseId, NHibernateUtil.Int32));
parameters.Add(new NHParameter("cityId", cityId, NHibernateUtil.Int32));
DATHouse house = db.DB.GetCustomSQLQueryEntity <DATHouse>(sql, parameters);
//DATHouse house = db.DB.GetCustom<DATHouse>(
// (Expression<Func<DATHouse, bool>>)
// (tbl =>
// tbl.HouseId == houseId && tbl.CityID == cityId&&tbl.Valid==1
// ));
db.Close();
return(house);
}
catch (Exception ex)
{
db.Close();
throw ex;
}
}
/// <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);
}
