/// <summary> /// 增加一条数据 /// </summary> public void Add(MobileSoft.Model.HSPR.Tb_HSPR_Room model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@RoomID", SqlDbType.BigInt, 8), new SqlParameter("@CommID", SqlDbType.Int, 4), new SqlParameter("@RoomSign", SqlDbType.NVarChar, 20), new SqlParameter("@RoomName", SqlDbType.NVarChar, 200), new SqlParameter("@RegionSNum", SqlDbType.Int, 4), new SqlParameter("@BuildSNum", SqlDbType.Int, 4), new SqlParameter("@UnitSNum", SqlDbType.Int, 4), new SqlParameter("@FloorSNum", SqlDbType.Int, 4), new SqlParameter("@RoomSNum", SqlDbType.Int, 4), new SqlParameter("@RoomModel", SqlDbType.NVarChar, 20), new SqlParameter("@RoomType", SqlDbType.NVarChar, 20), new SqlParameter("@PropertyRights", SqlDbType.NVarChar, 20), new SqlParameter("@RoomTowards", SqlDbType.NVarChar, 10), new SqlParameter("@BuildArea", SqlDbType.Decimal, 9), new SqlParameter("@InteriorArea", SqlDbType.Decimal, 9), new SqlParameter("@CommonArea", SqlDbType.Decimal, 9), new SqlParameter("@RightsSign", SqlDbType.NVarChar, 50), new SqlParameter("@PropertyUses", SqlDbType.NVarChar, 20), new SqlParameter("@RoomState", SqlDbType.Int, 4), new SqlParameter("@ChargeTypeID", SqlDbType.BigInt, 8), new SqlParameter("@UsesState", SqlDbType.SmallInt, 2), new SqlParameter("@IsDelete", SqlDbType.SmallInt, 2), new SqlParameter("@FloorHeight", SqlDbType.NVarChar, 30), new SqlParameter("@BuildStructure", SqlDbType.NVarChar, 30), new SqlParameter("@PoolRatio", SqlDbType.Decimal, 9), new SqlParameter("@BearParameters", SqlDbType.NVarChar, 30), new SqlParameter("@Renovation", SqlDbType.NVarChar, 30), new SqlParameter("@Configuration", SqlDbType.NVarChar, 80), new SqlParameter("@Advertising", SqlDbType.NVarChar, 30), new SqlParameter("@IsSplitUnite", SqlDbType.SmallInt, 2), new SqlParameter("@GardenArea", SqlDbType.Decimal, 9), new SqlParameter("@PropertyArea", SqlDbType.Decimal, 9), new SqlParameter("@AreaType", SqlDbType.SmallInt, 2), new SqlParameter("@YardArea", SqlDbType.Decimal, 9), new SqlParameter("@DelUser", SqlDbType.NVarChar, 50), new SqlParameter("@DelDate", SqlDbType.DateTime), new SqlParameter("@ResideType", SqlDbType.SmallInt, 2), new SqlParameter("@RoomSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@SynchFlag", SqlDbType.SmallInt, 2), new SqlParameter("@BedTypeID", SqlDbType.BigInt, 8), new SqlParameter("@UseType", SqlDbType.SmallInt, 2), new SqlParameter("@IsFrozen", SqlDbType.SmallInt, 2) }; parameters[0].Value = model.RoomID; parameters[1].Value = model.CommID; parameters[2].Value = model.RoomSign; parameters[3].Value = model.RoomName; parameters[4].Value = model.RegionSNum; parameters[5].Value = model.BuildSNum; parameters[6].Value = model.UnitSNum; parameters[7].Value = model.FloorSNum; parameters[8].Value = model.RoomSNum; parameters[9].Value = model.RoomModel; parameters[10].Value = model.RoomType; parameters[11].Value = model.PropertyRights; parameters[12].Value = model.RoomTowards; parameters[13].Value = model.BuildArea; parameters[14].Value = model.InteriorArea; parameters[15].Value = model.CommonArea; parameters[16].Value = model.RightsSign; parameters[17].Value = model.PropertyUses; parameters[18].Value = model.RoomState; parameters[19].Value = model.ChargeTypeID; parameters[20].Value = model.UsesState; parameters[21].Value = model.IsDelete; parameters[22].Value = model.FloorHeight; parameters[23].Value = model.BuildStructure; parameters[24].Value = model.PoolRatio; parameters[25].Value = model.BearParameters; parameters[26].Value = model.Renovation; parameters[27].Value = model.Configuration; parameters[28].Value = model.Advertising; parameters[29].Value = model.IsSplitUnite; parameters[30].Value = model.GardenArea; parameters[31].Value = model.PropertyArea; parameters[32].Value = model.AreaType; parameters[33].Value = model.YardArea; parameters[34].Value = model.DelUser; parameters[35].Value = model.DelDate; parameters[36].Value = model.ResideType; parameters[37].Value = model.RoomSynchCode; parameters[38].Value = model.SynchFlag; parameters[39].Value = model.BedTypeID; parameters[40].Value = model.UseType; parameters[41].Value = model.IsFrozen; DbHelperSQL.RunProcedure("Proc_Tb_HSPR_Room_ADD", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public MobileSoft.Model.HSPR.Tb_HSPR_Room GetModel(long RoomID) { SqlParameter[] parameters = { new SqlParameter("@RoomID", SqlDbType.BigInt) }; parameters[0].Value = RoomID; MobileSoft.Model.HSPR.Tb_HSPR_Room model = new MobileSoft.Model.HSPR.Tb_HSPR_Room(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_HSPR_Room_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["RoomID"].ToString() != "") { model.RoomID = long.Parse(ds.Tables[0].Rows[0]["RoomID"].ToString()); } if (ds.Tables[0].Rows[0]["CommID"].ToString() != "") { model.CommID = int.Parse(ds.Tables[0].Rows[0]["CommID"].ToString()); } model.RoomSign = ds.Tables[0].Rows[0]["RoomSign"].ToString(); model.RoomName = ds.Tables[0].Rows[0]["RoomName"].ToString(); if (ds.Tables[0].Rows[0]["RegionSNum"].ToString() != "") { model.RegionSNum = int.Parse(ds.Tables[0].Rows[0]["RegionSNum"].ToString()); } if (ds.Tables[0].Rows[0]["BuildSNum"].ToString() != "") { model.BuildSNum = int.Parse(ds.Tables[0].Rows[0]["BuildSNum"].ToString()); } if (ds.Tables[0].Rows[0]["UnitSNum"].ToString() != "") { model.UnitSNum = int.Parse(ds.Tables[0].Rows[0]["UnitSNum"].ToString()); } if (ds.Tables[0].Rows[0]["FloorSNum"].ToString() != "") { model.FloorSNum = int.Parse(ds.Tables[0].Rows[0]["FloorSNum"].ToString()); } if (ds.Tables[0].Rows[0]["RoomSNum"].ToString() != "") { model.RoomSNum = int.Parse(ds.Tables[0].Rows[0]["RoomSNum"].ToString()); } model.RoomModel = ds.Tables[0].Rows[0]["RoomModel"].ToString(); model.RoomType = ds.Tables[0].Rows[0]["RoomType"].ToString(); model.PropertyRights = ds.Tables[0].Rows[0]["PropertyRights"].ToString(); model.RoomTowards = ds.Tables[0].Rows[0]["RoomTowards"].ToString(); if (ds.Tables[0].Rows[0]["BuildArea"].ToString() != "") { model.BuildArea = decimal.Parse(ds.Tables[0].Rows[0]["BuildArea"].ToString()); } if (ds.Tables[0].Rows[0]["InteriorArea"].ToString() != "") { model.InteriorArea = decimal.Parse(ds.Tables[0].Rows[0]["InteriorArea"].ToString()); } if (ds.Tables[0].Rows[0]["CommonArea"].ToString() != "") { model.CommonArea = decimal.Parse(ds.Tables[0].Rows[0]["CommonArea"].ToString()); } model.RightsSign = ds.Tables[0].Rows[0]["RightsSign"].ToString(); model.PropertyUses = ds.Tables[0].Rows[0]["PropertyUses"].ToString(); if (ds.Tables[0].Rows[0]["RoomState"].ToString() != "") { model.RoomState = int.Parse(ds.Tables[0].Rows[0]["RoomState"].ToString()); } if (ds.Tables[0].Rows[0]["ChargeTypeID"].ToString() != "") { model.ChargeTypeID = long.Parse(ds.Tables[0].Rows[0]["ChargeTypeID"].ToString()); } if (ds.Tables[0].Rows[0]["UsesState"].ToString() != "") { model.UsesState = int.Parse(ds.Tables[0].Rows[0]["UsesState"].ToString()); } if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].ToString()); } model.FloorHeight = ds.Tables[0].Rows[0]["FloorHeight"].ToString(); model.BuildStructure = ds.Tables[0].Rows[0]["BuildStructure"].ToString(); if (ds.Tables[0].Rows[0]["PoolRatio"].ToString() != "") { model.PoolRatio = decimal.Parse(ds.Tables[0].Rows[0]["PoolRatio"].ToString()); } model.BearParameters = ds.Tables[0].Rows[0]["BearParameters"].ToString(); model.Renovation = ds.Tables[0].Rows[0]["Renovation"].ToString(); model.Configuration = ds.Tables[0].Rows[0]["Configuration"].ToString(); model.Advertising = ds.Tables[0].Rows[0]["Advertising"].ToString(); if (ds.Tables[0].Rows[0]["IsSplitUnite"].ToString() != "") { model.IsSplitUnite = int.Parse(ds.Tables[0].Rows[0]["IsSplitUnite"].ToString()); } if (ds.Tables[0].Rows[0]["GardenArea"].ToString() != "") { model.GardenArea = decimal.Parse(ds.Tables[0].Rows[0]["GardenArea"].ToString()); } if (ds.Tables[0].Rows[0]["PropertyArea"].ToString() != "") { model.PropertyArea = decimal.Parse(ds.Tables[0].Rows[0]["PropertyArea"].ToString()); } if (ds.Tables[0].Rows[0]["AreaType"].ToString() != "") { model.AreaType = int.Parse(ds.Tables[0].Rows[0]["AreaType"].ToString()); } if (ds.Tables[0].Rows[0]["YardArea"].ToString() != "") { model.YardArea = decimal.Parse(ds.Tables[0].Rows[0]["YardArea"].ToString()); } model.DelUser = ds.Tables[0].Rows[0]["DelUser"].ToString(); if (ds.Tables[0].Rows[0]["DelDate"].ToString() != "") { model.DelDate = DateTime.Parse(ds.Tables[0].Rows[0]["DelDate"].ToString()); } if (ds.Tables[0].Rows[0]["ResideType"].ToString() != "") { model.ResideType = int.Parse(ds.Tables[0].Rows[0]["ResideType"].ToString()); } if (ds.Tables[0].Rows[0]["RoomSynchCode"].ToString() != "") { model.RoomSynchCode = new Guid(ds.Tables[0].Rows[0]["RoomSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(ds.Tables[0].Rows[0]["SynchFlag"].ToString()); } if (ds.Tables[0].Rows[0]["BedTypeID"].ToString() != "") { model.BedTypeID = long.Parse(ds.Tables[0].Rows[0]["BedTypeID"].ToString()); } if (ds.Tables[0].Rows[0]["UseType"].ToString() != "") { model.UseType = int.Parse(ds.Tables[0].Rows[0]["UseType"].ToString()); } if (ds.Tables[0].Rows[0]["IsFrozen"].ToString() != "") { model.IsFrozen = int.Parse(ds.Tables[0].Rows[0]["IsFrozen"].ToString()); } return(model); } else { return(null); } }