/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.HSPR.Tb_HSPR_Room model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(MobileSoft.Model.HSPR.Tb_HSPR_Room model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <MobileSoft.Model.HSPR.Tb_HSPR_Room> DataTableToList(DataTable dt) { List <MobileSoft.Model.HSPR.Tb_HSPR_Room> modelList = new List <MobileSoft.Model.HSPR.Tb_HSPR_Room>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { MobileSoft.Model.HSPR.Tb_HSPR_Room model; for (int n = 0; n < rowsCount; n++) { model = new MobileSoft.Model.HSPR.Tb_HSPR_Room(); //model.RoomID=dt.Rows[n]["RoomID"].ToString(); if (dt.Rows[n]["CommID"].ToString() != "") { model.CommID = int.Parse(dt.Rows[n]["CommID"].ToString()); } model.RoomSign = dt.Rows[n]["RoomSign"].ToString(); model.RoomName = dt.Rows[n]["RoomName"].ToString(); if (dt.Rows[n]["RegionSNum"].ToString() != "") { model.RegionSNum = int.Parse(dt.Rows[n]["RegionSNum"].ToString()); } if (dt.Rows[n]["BuildSNum"].ToString() != "") { model.BuildSNum = int.Parse(dt.Rows[n]["BuildSNum"].ToString()); } if (dt.Rows[n]["UnitSNum"].ToString() != "") { model.UnitSNum = int.Parse(dt.Rows[n]["UnitSNum"].ToString()); } if (dt.Rows[n]["FloorSNum"].ToString() != "") { model.FloorSNum = int.Parse(dt.Rows[n]["FloorSNum"].ToString()); } if (dt.Rows[n]["RoomSNum"].ToString() != "") { model.RoomSNum = int.Parse(dt.Rows[n]["RoomSNum"].ToString()); } model.RoomModel = dt.Rows[n]["RoomModel"].ToString(); model.RoomType = dt.Rows[n]["RoomType"].ToString(); model.PropertyRights = dt.Rows[n]["PropertyRights"].ToString(); model.RoomTowards = dt.Rows[n]["RoomTowards"].ToString(); if (dt.Rows[n]["BuildArea"].ToString() != "") { model.BuildArea = decimal.Parse(dt.Rows[n]["BuildArea"].ToString()); } if (dt.Rows[n]["InteriorArea"].ToString() != "") { model.InteriorArea = decimal.Parse(dt.Rows[n]["InteriorArea"].ToString()); } if (dt.Rows[n]["CommonArea"].ToString() != "") { model.CommonArea = decimal.Parse(dt.Rows[n]["CommonArea"].ToString()); } model.RightsSign = dt.Rows[n]["RightsSign"].ToString(); model.PropertyUses = dt.Rows[n]["PropertyUses"].ToString(); if (dt.Rows[n]["RoomState"].ToString() != "") { model.RoomState = int.Parse(dt.Rows[n]["RoomState"].ToString()); } //model.ChargeTypeID=dt.Rows[n]["ChargeTypeID"].ToString(); if (dt.Rows[n]["UsesState"].ToString() != "") { model.UsesState = int.Parse(dt.Rows[n]["UsesState"].ToString()); } if (dt.Rows[n]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString()); } model.FloorHeight = dt.Rows[n]["FloorHeight"].ToString(); model.BuildStructure = dt.Rows[n]["BuildStructure"].ToString(); if (dt.Rows[n]["PoolRatio"].ToString() != "") { model.PoolRatio = decimal.Parse(dt.Rows[n]["PoolRatio"].ToString()); } model.BearParameters = dt.Rows[n]["BearParameters"].ToString(); model.Renovation = dt.Rows[n]["Renovation"].ToString(); model.Configuration = dt.Rows[n]["Configuration"].ToString(); model.Advertising = dt.Rows[n]["Advertising"].ToString(); if (dt.Rows[n]["IsSplitUnite"].ToString() != "") { model.IsSplitUnite = int.Parse(dt.Rows[n]["IsSplitUnite"].ToString()); } if (dt.Rows[n]["GardenArea"].ToString() != "") { model.GardenArea = decimal.Parse(dt.Rows[n]["GardenArea"].ToString()); } if (dt.Rows[n]["PropertyArea"].ToString() != "") { model.PropertyArea = decimal.Parse(dt.Rows[n]["PropertyArea"].ToString()); } if (dt.Rows[n]["AreaType"].ToString() != "") { model.AreaType = int.Parse(dt.Rows[n]["AreaType"].ToString()); } if (dt.Rows[n]["YardArea"].ToString() != "") { model.YardArea = decimal.Parse(dt.Rows[n]["YardArea"].ToString()); } model.DelUser = dt.Rows[n]["DelUser"].ToString(); if (dt.Rows[n]["DelDate"].ToString() != "") { model.DelDate = DateTime.Parse(dt.Rows[n]["DelDate"].ToString()); } if (dt.Rows[n]["ResideType"].ToString() != "") { model.ResideType = int.Parse(dt.Rows[n]["ResideType"].ToString()); } if (dt.Rows[n]["RoomSynchCode"].ToString() != "") { model.RoomSynchCode = new Guid(dt.Rows[n]["RoomSynchCode"].ToString()); } if (dt.Rows[n]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(dt.Rows[n]["SynchFlag"].ToString()); } //model.BedTypeID=dt.Rows[n]["BedTypeID"].ToString(); if (dt.Rows[n]["UseType"].ToString() != "") { model.UseType = int.Parse(dt.Rows[n]["UseType"].ToString()); } if (dt.Rows[n]["IsFrozen"].ToString() != "") { model.IsFrozen = int.Parse(dt.Rows[n]["IsFrozen"].ToString()); } modelList.Add(model); } } return(modelList); }