明源售楼系统技术解析 房源生成（二）
来源：互联网 发布：辐射4 补丁 优化 a卡 编辑：程序博客网 时间：2024/04/30 23:17
第2章 房源生成
上次我们说了第一种房源生成方式，主要是针对建筑性质为住宅-多层-多层的，现在我们来说一下第二种生成房间的方式
2.2.1.2 第二种生成楼栋的方法：这种生成的主要是生成车位或商铺，这是根据号码生成的。
第一步：界面效果
从界面上看我们这里用到的控件有：
控件名称
说明
单行文本框（easyui-textbox）
第一要设置每个控件的id，第二可以设置每个控件的大小，不设置也有默认值，第三（data-options）是数据的操作可以设置控件的属性和事件。
下拉框（easyui-combobox）
按钮（easyui-linkbutton）
树形控件（easyui-tree）
复选框（checkbox）
第二步：生成车位或商铺的时候需要在某个已经生成房间的楼栋下生成，数据库表与表的关系如下：
表的说明：
1、房间资料表：
用于存放房间资料信息
dbo.SYS_RoomDataTable
Primary Key(s): RoomDataID
Field Type 主键/外键 说明
RoomDataID
int - Identity
主键
房间资料ID
HouseID
int
楼栋ID
RoomCode
nchar (50)
房间代码
RoomUnit
nchar (10)
房间单元
RoomNumber
nchar (20)
房号
natureNumber
nchar (20)
自然号
Floor
nchar (20)
楼层
ColumnNumber
nchar (20)
列号
CoveredArea
decimal (18, 3)
建筑面积
BuilDingExceptArea
decimal (18, 3)
套内面积
AreaShare
decimal (18, 3)
分摊面积
BalconyArea
decimal (18, 3)
阳台面积
RoomFaceDirectionID
int
外键
房间朝向ID
LandscapeID
int
外键
景观ID
HouseTypeID
int
外键
户型ID
RoomTypeID
int
外键
房间类型ID
RoomRanking
nchar (20)
房间排号
OnbuildingExceptAreaCountNot
bit
是否按套内面积计算
LockNot
bit
是否锁定
CountWayID
int
外键
计算方法ID
RoomDescribeID
int
外键
房间描述ID
SellStatusID
int
外键
销售状态ID
AffiliatedHousePropertyNot
bit
附属房产否
BuildingPropertiesID
int
外键
建筑性质ID
BuildingNot
bit
绑定否
ZhuangTaiWeiZhenFou
bit
状态为真否
用于存放房间基本描述信息。2、房间描述表：
dbo.SYS_ RoomDescribeTable
Primary Key(s): RoomDescribeID
Field Type 主键/外键 说明
RoomDescribeID
int - Identity
主键
房间描述ID
UnitActionNumber
nchar (100)
单元开始号
UnitFinishNumber
nchar (100)
单元结束号
StoreyActionNumber
nchar (100)
楼层开始号
StoreyFinishNumber
nchar (100)
楼层结束号
NatureStoreyActionNumber
int
自然层开始号
NatureStoreyFinishNumber
int
自然层结束号
ListActionNumber
nchar (100)
列开始号
ListFinishNumber
nchar (100)
列结束号
UnitEveryStoreyTotalDoor
nchar (100)
单元每层总户数
HouseID
int
外键
楼栋ID
用于存放项目资料。3、项目表：
dbo.SYS_ProjectTable
Primary Key(s): ProjectID
Field Type 主键/外键 说明
ProjectID
int - Identity
主键
项目ID
PremisesName
nchar (100)
大楼名称
ProjectCode
nchar (100)
项目代码
ProjectName
nchar (100)
项目名称
BuildingPropertyID
int
外键
建筑性质ID
StructureID
int
外键
结构ID
PlotRatio
decimal (18, 3)
容积率
RealEstateNumber
nchar (100)
项目房地产证号
DomesticLicence
nchar (100)
内销许可证
ExportLicence
nchar (100)
外销许可证
SupervisionInstitutionID
int
外键
监理机构ID
ProjectRowNumber
int
项目排号
MassifNumber
nchar (100)
项目地块编号
LandArea
nchar (100)
项目土地面积
LandSellContractNumber
nchar (100)
项目土地出让合同号
LandUserBeginTime
nchar (100)
项目土地使用开始时间
LandUserEndTime
nchar (100)
项目土地使用结束时间
LandPurpose
nchar (100)
项目土地用途
AreaTypeID
int
外键
项目面积类型ID
用于存放项目分区信息。4、项目分区表：
dbo.SYS_ProjectSubregionTable
Primary Key(s): ProjectSubregionID
Field Type 主键/外键 说明
ProjectSubregionID
int - Identity
主键
项目分区ID
ProjectSubregionName
nchar (100)
项目分区名称
ProjectID
int
项目ID
用于存放楼栋信息。5、楼栋表：
dbo.SYS_HouseTable
Primary Key(s): HouseID
Field Type 主键/外键 说明
HouseID
int - Identity
主键
楼栋ID
HouseCode
nchar (40)
楼栋代码
HouseName
nchar (40)
楼栋名称
RoomNumberModelTypeID
int
外键
房间编号模式类型ID
ContractHouseName
nchar (40)
合同栋号名称
GiveHouseStandardID
int
外键
交屋标准ID
ShouldGiveHouseDate
date
应交房日期
BriefRemarks
nchar (80)
简要备注
NumberOfPlies
int
层数
BuildingPropertyID
int
外键
建筑性质ID
SupervisionInstitutionID
int
外键
监理机构ID
EstateNumber
nchar (80)
楼栋房地产证号
MassifNumber
nchar (80)
楼栋地块编号
LandArea
decimal (18, 3)
楼栋土地面积
LandSellAgreementNumber
nchar (80)
楼栋土地出让合同号
LandUserBeginDate
date
楼栋土地使用开始时间
LandUserEndDate
date
楼栋土地使用结束时间
HouseLandUse
nchar (80)
楼栋土地用途
HouseAreaTypeID
int
外键
楼栋面积类型ID
ProjectSubregionID
int
外键
项目分区ID
StructureID
int
外键
结构ID
用于存放各种属性明细信息。6、属性明细表：
dbo.SYS_AttributeAssembleDetailTable
Primary Key(s): AttributeAssembleDetailID
Field
Type
主键/外键
说明
AttributeAssembleDetailID
int - Identity
主键
属性明细ID
AttributeAssembleDetailName
nchar (100)
属性明细名称
AttributeAssembleID
int
外键
属性集合ID
AttributeAssembleDetailFar_ID
int
属性明细Far_ID
第三步：首先生成车位的时候主要包括有：新增房间资料表，新增房间单价表，新增实测面积表。还有一些绑定下拉框之类的就不说了，我们先来看新增的存储过程。
if @SN='InsertRoomUnivalent'--新增房间单价表 begin insert SYS_UnivalentTable(RoomDatumID) values (@RoomDatumID) end if @SN='InsertAreaMeasurement'--新增实测面积表 begin insert SYS_AreaMeasurementTable(RoomDataID) values (@RoomDataID) Endif @SN='InsertAffiliatedHouseProperty'--新增车位 begin Insert SYS_RoomDataTable(HouseID, RoomNumber, natureNumber, Floor, CoveredArea, BuilDingExceptArea, AreaShare, BalconyArea, RoomFaceDirectionID, LandscapeID, HouseTypeID, RoomTypeID, RoomRanking, AffiliatedHousePropertyNot, BuildingPropertiesID, RoomCode,BuildingNot) values (@HouseID, @RoomNumber, @natureNumber, @Floor, @CoveredArea, @BuilDingExceptArea, @AreaShare, @BalconyArea, @RoomFaceDirectionID, @LandscapeID, @HouseTypeID, @RoomTypeID, @RoomRanking, @AffiliatedHousePropertyNot, @BuildingPropertiesID, @RoomCode,'false') select @@IDENTITY end
第四步：BLL层。
public int InsertRoomUnivalent(int RoomDatumID)//新增房间单价 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@RoomDatumID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertRoomUnivalent"; SQLCMDpas[1].Value = RoomDatumID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData",SQLCMDpas); return i; } public int InsertAreaMeasurement(int RoomDataID)//新增实测面积 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@RoomDataID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertAreaMeasurement"; SQLCMDpas[1].Value = RoomDataID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData",SQLCMDpas); return i; }public DataTable InsertAffiliatedHouseProperty(int HouseID, string RoomNumber, string natureNumber, int Floor, string CoveredArea, string BuilDingExceptArea, string AreaShare, string BalconyArea, int RoomFaceDirectionID, int LandscapeID, int HouseTypeID, int RoomTypeID, string RoomRanking, Boolean AffiliatedHousePropertyNot, int BuildingPropertiesID,string RoomCode)//新增车位信息 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@HouseID",SqlDbType.Int), new SqlParameter("@RoomNumber",SqlDbType.Char), new SqlParameter("@natureNumber",SqlDbType.Char), new SqlParameter("@Floor",SqlDbType.Int), new SqlParameter("@CoveredArea",SqlDbType.Char), new SqlParameter("@BuilDingExceptArea",SqlDbType.Char), new SqlParameter("@AreaShare",SqlDbType.Char), new SqlParameter("@BalconyArea",SqlDbType.Char), new SqlParameter("@RoomFaceDirectionID",SqlDbType.Int), new SqlParameter("@LandscapeID",SqlDbType.Int), new SqlParameter("@HouseTypeID",SqlDbType.Int), new SqlParameter("@RoomTypeID",SqlDbType.Int), new SqlParameter("@RoomRanking",SqlDbType.Char), new SqlParameter("@AffiliatedHousePropertyNot",SqlDbType.Bit), new SqlParameter("@BuildingPropertiesID",SqlDbType.Int), new SqlParameter("@RoomCode",SqlDbType.Char) }; SQLCMDpas[0].Value = "InsertAffiliatedHouseProperty"; SQLCMDpas[1].Value=HouseID; SQLCMDpas[2].Value = RoomNumber; SQLCMDpas[3].Value=natureNumber; SQLCMDpas[4].Value=Floor; SQLCMDpas[5].Value=CoveredArea; SQLCMDpas[6].Value=BuilDingExceptArea; SQLCMDpas[7].Value=AreaShare; SQLCMDpas[8].Value=BalconyArea; SQLCMDpas[9].Value=RoomFaceDirectionID; SQLCMDpas[10].Value=LandscapeID; SQLCMDpas[11].Value=HouseTypeID; SQLCMDpas[12].Value=RoomTypeID; SQLCMDpas[13].Value=RoomRanking; SQLCMDpas[14].Value=AffiliatedHousePropertyNot; SQLCMDpas[15].Value=BuildingPropertiesID; SQLCMDpas[16].Value = RoomCode; DataTable dt = myDALMethod.DAL_SelectDB_Par("SYS_RoomData",SQLCMDpas); return dt; }第五步：Controller
public ActionResult InsertRoomUnivalent(int RoomDatumID)//新增房间单价 { int i = myFangJianZiLiao.InsertRoomUnivalent(RoomDatumID); return Content(i.ToString()); } public ActionResult InsertAreaMeasurement(int RoomDataID)//新增实测面积 { int i = myFangJianZiLiao.InsertAreaMeasurement(RoomDataID); return Content(i.ToString()); }public ActionResult InsertAffiliatedHouseProperty(int HouseID, string RoomNumber, string natureNumber, int Floor, string CoveredArea, string BuilDingExceptArea, string AreaShare, string BalconyArea, int RoomFaceDirectionID, int LandscapeID, int HouseTypeID, int RoomTypeID, string RoomRanking, Boolean AffiliatedHousePropertyNot, int BuildingPropertiesID, string RoomCode)//新增车位信息 { DataTable dt = myFangJianZiLiao.InsertAffiliatedHouseProperty(HouseID, RoomNumber, natureNumber, Floor, CoveredArea, BuilDingExceptArea, AreaShare, BalconyArea, RoomFaceDirectionID, LandscapeID, HouseTypeID, RoomTypeID, RoomRanking, AffiliatedHousePropertyNot, BuildingPropertiesID, RoomCode); string FangJianZiLiaoID = dt.Rows[0][0].ToString(); return Content(FangJianZiLiaoID); }第六步：界面，当然这里也跟之前第一种生成模式一样需要新增楼栋，这里既有不说新增楼栋了。
var XuanZe; var RoomCode; function HaoMaInsert() { var node = $('#treXiangMuMingCheng').tree('getSelected'); var JianzhuXingZhi = $('#tb建筑性质').datagrid('getSelected'); if (confirm("是否增加？")) { if (document.getElementById('chkFuShuFangChan').checked) { XuanZe = true; } else { XuanZe = false; } if (PanDuan == "2") { $.getJSON("/XiangMuZiLiao/XingZengLouDongZiLiao?LouDongDaiMa=" + $('#txtLouDongDaiMa1').val() + "&" + "LouDongMingCheng=" + $('#txtLouDongMingCheng1').val() + "&" + "CengShu=" + $('#txtJianZhuCengShu1').val() + "&" + "FangJianBianHaoMoShiLeiXingID=" + $("#cboFangJianBianHaoMuShi1").combobox('getValue') + "&" + "HeTongDongHaoMingCheng=" + $('#txtHeTongLouDongMingCheng1').val() + "&" + "JianLiJiGouID=" + $('#cboJianLiJiGou1').combobox('getValue') + "&" + "JianYaoBeiZhu=" + $('#txtJianYaoBeiZhu1').val() + "&" + "JianZhuXingZhiID=" + JianzhuXingZhi.BuildingPropertyID + "&" + "JiaoWuBiaoZhunID=" + $('#cboJiaoWuBiaoZhun1').combobox('getValue') + "&" + "LouDongDiKuaiBianHao=" + $('#txtDiKuaiBianHao1').val() + "&" + "LouDongFangDiChangZhengHao=" + $('#txtFangDiChanZhengHao1').val() + "&" + "LouDongTuDiChuRangHeTongHao=" + $('#txtTuDiChuRangHeTong1').val() + "&" + "LouDongTuDiMianJi=" + $('#txtTuDiMianJi1').val() + "&" + "LouDongTuDiShiYongJieShuShiJian=" + $('#datTuDiShiYongEdd1').datebox('getValue') + "&" + "LouDongTuDiShiYongKaiShiShiJian=" + $('#datTuDiShiYongCong1').datebox('getValue') + "&" + "LouDongTuDiYongTu=" + $('#txtTuDiYongTu1').val() + "&" + "YingJiaoFangRiQi=" + $('#datYingJiaoFangRiQi1').datebox('getValue') + "&" + "JieGouID=" + $('#cboJieGou1').combobox('getValue') + "&" + "XiangMuFenQuID=" + node.id + "&", function (data5) { HouseID = data5; for (var i = $('#txtRoomNumberFollow1').val(); i <= $('#txtRoomNumberTo1').val(); i++) { RoomCode = ($('#txtLouDongDaiMa1').val()).toString().trim() + "0" + i; $.getJSON("/FangJianZiLiao/InsertAffiliatedHouseProperty?HouseID=" + HouseID + "&" + "RoomNumber=" + i + "&" + "natureNumber=" + $('#txtNatureFollow1').val() + "&" + "Floor=" + $('#txtStoreyFollow1').val() + "&" + "CoveredArea=" + $('#txtFloorArea1').val() + "&" + "BuilDingExceptArea=" + $('#txtRoomArea1').val() + "&" + "AreaShare=" + $('#txtShareArea1').val() + "&" + "BalconyArea=" + $('#txtBalconyArea1').val() + "&" + "RoomFaceDirectionID=" + $('#cboOrientations1').combobox('getValue') + "&" + "LandscapeID=" + $('#cboLandscape1').combobox('getValue') + "&" + "HouseTypeID=" + $('#cboHouseType1').combobox('getValue') + "&" + "RoomTypeID=" + $('#cboRoomType1').combobox('getValue') + "&" + "RoomRanking=" + i + "&" + "AffiliatedHousePropertyNot=" + XuanZe + "&" + "BuildingPropertiesID=" + JianzhuXingZhi.BuildingPropertyID + "&" + "RoomCode=" + RoomCode, function (data) { RoomDataID = data; $.getJSON("/FangJianZiLiao/InsertRoomUnivalent?RoomDatumID=" + RoomDataID, function (data2) { if (data2 > 0) { } }); $.getJSON("/FangJianZiLiao/InsertAreaMeasurement?RoomDataID=" + RoomDataID, function (data3) { if (data3 > 0) { } }); }); } }); } else { $.getJSON("/XiangMuZiLiao/InsertProjectSubregion?ProjectSubregionName=" + $('#txtXiangMuFenQu1').val() + "&" + "ProjectID=" + XiangMu, function (data6) { XiangMuFenQuID = data6; $.getJSON("/XiangMuZiLiao/XingZengLouDongZiLiao?LouDongDaiMa=" + $('#txtLouDongDaiMa1').val() + "&" + "LouDongMingCheng=" + $('#txtLouDongMingCheng1').val() + "&" + "CengShu=" + $('#txtJianZhuCengShu1').val() + "&" + "FangJianBianHaoMoShiLeiXingID=" + $("#cboFangJianBianHaoMuShi1").combobox('getValue') + "&" + "HeTongDongHaoMingCheng=" + $('#txtHeTongLouDongMingCheng1').val() + "&" + "JianLiJiGouID=" + $('#cboJianLiJiGou1').combobox('getValue') + "&" + "JianYaoBeiZhu=" + $('#txtJianYaoBeiZhu1').val() + "&" + "JianZhuXingZhiID=" + JianzhuXingZhi.BuildingPropertyID + "&" + "JiaoWuBiaoZhunID=" + $('#cboJiaoWuBiaoZhun1').combobox('getValue') + "&" + "LouDongDiKuaiBianHao=" + $('#txtDiKuaiBianHao1').val() + "&" + "LouDongFangDiChangZhengHao=" + $('#txtFangDiChanZhengHao1').val() + "&" + "LouDongTuDiChuRangHeTongHao=" + $('#txtTuDiChuRangHeTong1').val() + "&" + "LouDongTuDiMianJi=" + $('#txtTuDiMianJi1').val() + "&" + "LouDongTuDiShiYongJieShuShiJian=" + $('#datTuDiShiYongEdd1').datebox('getValue') + "&" + "LouDongTuDiShiYongKaiShiShiJian=" + $('#datTuDiShiYongCong1').datebox('getValue') + "&" + "LouDongTuDiYongTu=" + $('#txtTuDiYongTu1').val() + "&" + "YingJiaoFangRiQi=" + $('#datYingJiaoFangRiQi1').datebox('getValue') + "&" + "JieGouID=" + $('#cboJieGou1').combobox('getValue') + "&" + "XiangMuFenQuID=" + XiangMuFenQuID + "&", function (data5) { HouseID = data5; for (var i = $('#txtRoomNumberFollow1').val(); i <= $('#txtRoomNumberTo1').val(); i++) { RoomCode = ($('#txtLouDongDaiMa1').val()).toString().trim() + "0" + i; $.getJSON("/FangJianZiLiao/InsertAffiliatedHouseProperty?HouseID=" + HouseID + "&" + "RoomNumber=" + i + "&" + "natureNumber=" + $('#txtNatureFollow1').val() + "&" + "Floor=" + $('#txtStoreyFollow1').val() + "&" + "CoveredArea=" + $('#txtFloorArea1').val() + "&" + "BuilDingExceptArea=" + $('#txtRoomArea1').val() + "&" + "AreaShare=" + $('#txtShareArea1').val() + "&" + "BalconyArea=" + $('#txtBalconyArea1').val() + "&" + "RoomFaceDirectionID=" + $('#cboOrientations1').combobox('getValue') + "&" + "LandscapeID=" + $('#cboLandscape1').combobox('getValue') + "&" + "HouseTypeID=" + $('#cboHouseType1').combobox('getValue') + "&" + "RoomTypeID=" + $('#cboRoomType1').combobox('getValue') + "&" + "RoomRanking=" + i + "&" + "AffiliatedHousePropertyNot=" + XuanZe + "&" + "BuildingPropertiesID=" + JianzhuXingZhi.BuildingPropertyID + "&" + "RoomCode=" + RoomCode, function (data) { RoomDataID = data; $.getJSON("/FangJianZiLiao/InsertRoomUnivalent?RoomDatumID=" + RoomDataID, function (data2) { if (data2 > 0) { } }); $.getJSON("/FangJianZiLiao/InsertAreaMeasurement?RoomDataID=" + RoomDataID, function (data3) { if (data3 > 0) { } }); }); } }); }); } alert("新增成功！！！"); $('#w增加楼栋').window('close'); $("#frmGeneratePreview").window('close'); $('#wHaoMaXinZengFangJianMiaoShu').window('close'); } }2.2.1.3 单元+楼层+号码的方式生成房间，它对应的是北方常见的有单元的楼房的情况。
首先界面效果如下：
从界面上看我们这里用到的控件有：
控件名称
说明
单行文本框（easyui-textbox）
第一要设置每个控件的id，第二可以设置每个控件的大小，不设置也有默认值，第三（data-options）是数据的操作可以设置控件的属性和事件。
下拉框（easyui-combobox）
按钮（easyui-linkbutton）
树形控件（easyui-tree）
复选框（checkbox）
第二步：生成车位或商铺的时候需要在某个已经生成房间的楼栋下生成，数据库表与表的关系跟上面的一样，如果不记得了请参考上面的的关系图。
然后就说下数据库，BLL，Controller和界面的代码。
第三步：数据库存储过程。
if @SN='InsertHouseData'--新增楼栋 begin INSERT SYS_HouseTable(HouseCode,HouseName,NumberOfPlies,RoomNumberModelTypeID,ContractHouseName,SupervisionInstitutionID, BriefRemarks,BuildingPropertyID,GiveHouseStandardID,MassifNumber,EstateNumber,LandSellAgreementNumber, LandArea,LandUserEndDate,LandUserBeginDate,HouseLandUse,ProjectSubregionID,ShouldGiveHouseDate,StructureID) VALUES (@HouseCode,@HouseName,@NumberOfPlies,@RoomNumberModelTypeID,@ContractHouseName,@SupervisionInstitutionID, @BriefRemarks,@BuildingPropertyID,@GiveHouseStandardID,@MassifNumber,@EstateNumber,@LandSellAgreementNumber, @LandArea,@LandUserEndDate,@LandUserBeginDate,@HouseLandUse,@ProjectSubregionID,@ShouldGiveHouseDate,@StructureID) select @@IDENTITY endif @SN='InsertRoomUnivalent'--新增房间单价表 begin insert SYS_UnivalentTable(RoomDatumID) values (@RoomDatumID) end if @SN='InsertAreaMeasurement'--新增实测面积表 begin insert SYS_AreaMeasurementTable(RoomDataID) values (@RoomDataID) end if @SN='InsertRoomDescribe'--新增房间描述 begin insert [SYS_ RoomDescribeTable](StoreyActionNumber,StoreyFinishNumber,NatureStoreyActionNumber, NatureStoreyFinishNumber,HouseID) values (@StoreyActionNumber,@StoreyFinishNumber,@NatureStoreyActionNumber,@NatureStoreyFinishNumber,@HouseID) select @@IDENTITY endif @SN='InsertUnitRoomData'--单元+楼栋+号码生成房间 begin insert SYS_RoomDataTable(HouseID,RoomCode,RoomNumber,RoomUnit,natureNumber,Floor, CoveredArea,BuilDingExceptArea,AreaShare,BalconyArea,RoomFaceDirectionID, LandscapeID,HouseTypeID,RoomTypeID,RoomRanking,RoomDescribeID,BuildingPropertiesID,BuildingNot,ZhuangTaiWeiZhenFou) values (@HouseID,@RoomCode,@RoomNumber,@RoomUnit,@natureNumber,@Floor, @CoveredArea,@BuilDingExceptArea,@AreaShare,@BalconyArea,@RoomFaceDirectionID, @LandscapeID,@HouseTypeID,@RoomTypeID,@RoomRanking,@RoomDescribeID,@BuildingPropertiesID,'false','true') select @@IDENTITY end
第四步：BLL
public DataTable InsertRoomDescribe(string StoreyActionNumber, string StoreyFinishNumber, int NatureStoreyActionNumber, int NatureStoreyFinishNumber, int HouseID)//新增房间描述 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@StoreyActionNumber",SqlDbType.Char), new SqlParameter("@StoreyFinishNumber",SqlDbType.Char), new SqlParameter("@NatureStoreyActionNumber",SqlDbType.Int), new SqlParameter("@NatureStoreyFinishNumber",SqlDbType.Int), new SqlParameter("@HouseID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertRoomDescribe"; SQLCMDpas[1].Value=StoreyActionNumber; SQLCMDpas[2].Value=StoreyFinishNumber; SQLCMDpas[3].Value=NatureStoreyActionNumber; SQLCMDpas[4].Value=NatureStoreyFinishNumber; SQLCMDpas[5].Value=HouseID; DataTable dt = myDALMethod.DAL_SelectDB_Par("SYS_RoomData", SQLCMDpas); return dt; } public int InsertRoomUnivalent(int RoomDatumID)//新增房间单价 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@RoomDatumID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertRoomUnivalent"; SQLCMDpas[1].Value = RoomDatumID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData",SQLCMDpas); return i; } public int InsertAreaMeasurement(int RoomDataID)//新增实测面积 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@RoomDataID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertAreaMeasurement"; SQLCMDpas[1].Value = RoomDataID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData",SQLCMDpas); return i; } public int InsertStatusChange(int RoomDatumID)//新增状态更改 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@RoomDatumID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertStatusChange"; SQLCMDpas[1].Value = RoomDatumID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData", SQLCMDpas); return i; } public DataTable InsertUnitRoomData(int HouseID, string RoomCode, string RoomNumber, string RoomUnit, string natureNumber, string Floor, decimal CoveredArea, decimal BuilDingExceptArea, decimal AreaShare, decimal BalconyArea, int RoomFaceDirectionID, int LandscapeID, int HouseTypeID, int RoomTypeID, string RoomRanking, int RoomDescribeID, int BuildingPropertiesID)//单元+楼层+号码生成房间 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@HouseID",SqlDbType.Int), new SqlParameter("@RoomCode",SqlDbType.Char), new SqlParameter("@RoomNumber",SqlDbType.Char), new SqlParameter("@RoomUnit",SqlDbType.Char), new SqlParameter("@natureNumber",SqlDbType.Char), new SqlParameter("@Floor",SqlDbType.Char), new SqlParameter("@CoveredArea",SqlDbType.Decimal), new SqlParameter("@BuilDingExceptArea",SqlDbType.Decimal), new SqlParameter("@AreaShare",SqlDbType.Decimal), new SqlParameter("@BalconyArea",SqlDbType.Decimal), new SqlParameter("@RoomFaceDirectionID",SqlDbType.Int), new SqlParameter("@LandscapeID",SqlDbType.Int), new SqlParameter("@HouseTypeID",SqlDbType.Int), new SqlParameter("@RoomTypeID",SqlDbType.Int), new SqlParameter("@RoomRanking",SqlDbType.Char), new SqlParameter("@RoomDescribeID",SqlDbType.Int), new SqlParameter("@BuildingPropertiesID",SqlDbType.Int) }; SQLCMDpas[0].Value = "InsertUnitRoomData"; SQLCMDpas[1].Value = HouseID; SQLCMDpas[2].Value = RoomCode; SQLCMDpas[3].Value = RoomNumber; SQLCMDpas[4].Value = RoomUnit; SQLCMDpas[5].Value = natureNumber; SQLCMDpas[6].Value = Floor; SQLCMDpas[7].Value = CoveredArea; SQLCMDpas[8].Value = BuilDingExceptArea; SQLCMDpas[9].Value = AreaShare; SQLCMDpas[10].Value = BalconyArea; SQLCMDpas[11].Value = RoomFaceDirectionID; SQLCMDpas[12].Value = LandscapeID; SQLCMDpas[13].Value = HouseTypeID; SQLCMDpas[14].Value = RoomTypeID; SQLCMDpas[15].Value = RoomRanking; SQLCMDpas[16].Value = RoomDescribeID; SQLCMDpas[17].Value = BuildingPropertiesID; DataTable dt = myDALMethod.DAL_SelectDB_Par("SYS_RoomData", SQLCMDpas); return dt; }第五步：Controller
public ActionResult InsertRoomDescribe(string StoreyActionNumber, string StoreyFinishNumber, int NatureStoreyActionNumber, int NatureStoreyFinishNumber, int HouseID)//新增房间描述 { DataTable dt = myFangJianZiLiao.InsertRoomDescribe(StoreyActionNumber, StoreyFinishNumber, NatureStoreyActionNumber, NatureStoreyFinishNumber, HouseID); string RoomDescribeID = dt.Rows[0][0].ToString(); return Content(RoomDescribeID); } public ActionResult InsertRoomUnivalent(int RoomDatumID)//新增房间单价 { int i = myFangJianZiLiao.InsertRoomUnivalent(RoomDatumID); return Content(i.ToString()); } public ActionResult InsertAreaMeasurement(int RoomDataID)//新增实测面积 { int i = myFangJianZiLiao.InsertAreaMeasurement(RoomDataID); return Content(i.ToString()); } public ActionResult InsertStatusChange(int RoomDatumID)//新增状态更改 { int i = myFangJianZiLiao.InsertStatusChange(RoomDatumID); return Content(i.ToString()); }public ActionResult InsertUnitRoomData(int HouseID, string RoomCode, string RoomNumber, string RoomUnit, string natureNumber, string Floor, decimal CoveredArea, decimal BuilDingExceptArea, decimal AreaShare, decimal BalconyArea, int RoomFaceDirectionID, int LandscapeID, int HouseTypeID, int RoomTypeID, string RoomRanking, int RoomDescribeID, int BuildingPropertiesID)//单元+楼层+号码新增房间资料 { DataTable dt = myFangJianZiLiao.InsertUnitRoomData(HouseID, RoomCode, RoomNumber,RoomUnit, natureNumber, Floor, CoveredArea, BuilDingExceptArea, AreaShare, BalconyArea, RoomFaceDirectionID, LandscapeID, HouseTypeID, RoomTypeID, RoomRanking, RoomDescribeID, BuildingPropertiesID); string RoomDataID = dt.Rows[0][0].ToString(); return Content(RoomDataID); }第六步：界面
var XiaoLouCeng; var ZiRanCeng; function ShengChengFangJianXinXiOne() {//生成预览跟绑定数据 var ZiRanLouCeng = ($('#txtNatureTo2').val()).toString().trim(); ZiRanCeng = ZiRanLouCeng; var ZuiXiaoLouCeng = ($('#txtStoreyFollow2').val()).toString().trim(); XiaoLouCeng = ZuiXiaoLouCeng; var ZuiDaLouCengShu = ($('#txtStoreyTo2').val()).toString().trim(); var ZuiXiaoFangHaoShu = ($('#txtRoomNumberFollow2').val()).toString().trim(); var ZuiDaFangHaoShu = ($('#txtRoomNumberTo2').val()).toString().trim(); var length = ((ZuiDaLouCengShu - ZuiXiaoLouCeng) + 1) * ((ZuiDaFangHaoShu - ZuiXiaoFangHaoShu) + 1); for (var i = 0; i < length; i++) { if (XiaoLouCeng > ZuiDaFangHaoShu) { ZuiXiaoLouCeng++; XiaoLouCeng = ($('#txtStoreyFollow2').val()).toString().trim(); } XiaoLouCeng++; if (ZuiXiaoFangHaoShu > ZuiDaFangHaoShu) { ZuiXiaoFangHaoShu = ($('#txtRoomNumberFollow2').val()).toString().trim(); } if (ZiRanLouCeng > ($('#txtNatureTo2').val()).toString().trim()) { ZiRanLouCeng++; ZiRanCeng = ($('#txtNatureTo2').val()).toString().trim(); } ZiRanCeng++; var FangJianDaiMa = ($('#txtBuildingCode').val()).toString().trim() + "-" + $('#txtDanYuanFollow2').val().toString().trim() + "-" + ZuiXiaoLouCeng +<span style="font-family: Arial, Helvetica, sans-serif;"> (ZuiXiaoFangHaoShu < 10 ? ('0' + ZuiXiaoFangHaoShu) : ZuiXiaoFangHaoShu);</span><span style="font-family: Arial, Helvetica, sans-serif;"> </span> var FangHao =$('#txtDanYuanFollow2').val().toString().trim()+"-"+ ZuiXiaoLouCeng + (ZuiXiaoFangHaoShu < 10 ? ('0' + ZuiXiaoFangHaoShu) : ZuiXiaoFangHaoShu); $('#dgRoomListing').datagrid("appendRow", { HouseName: $('#txtBuildingName').val(), ProjectSubregionName: $('#txtProjectSubregion').val(), RoomCode: FangJianDaiMa, Floor: ZuiXiaoLouCeng, NatureFloor: (ZiRanLouCeng < 10 ? ('0' + ZiRanLouCeng) : ZiRanLouCeng), Number: (ZuiXiaoFangHaoShu < 10 ? ('0' + ZuiXiaoFangHaoShu) : ZuiXiaoFangHaoShu), RoomNumber: FangHao, BuildingProperties: $('#txtBuildingProperty').val(), RoomType: $('#cboRoomType2').combobox('getText'), HouseType: $('#cboHouseType2').combobox('getText'), RoomRanking: (B < 10 ? ('0' + B) : B), Landscape: $('#cboLandscape2').combobox('getText'), Orientations: $('#cboOrientations2').combobox('getText'), Structure: $('#cboStructure2').combobox('getText'), Unit: $('#txtDanYuanFollow2').val() }); ZuiXiaoFangHaoShu++; } var row2 = $('#dgRoomListing').datagrid('getData'); $('#txtXiangMuMingCheng').attr('value', $('#txtProjectName').val()); $('#txtXiangMuFenQu').attr('value', $('#txtProjectSubregion').val()); $('#txtLouDongMingCheng').attr('value', $('#txtBuildingName').val()); $('#txtFangJianDaiMa').attr('value', row2.rows[0].RoomCode); $('#txtLouCeng').attr('value', row2.rows[0].Floor); $('#txtZiRanLouCeng').attr('value', row2.rows[0].NatureFloor); $('#txtFangHao').attr('value', row2.rows[0].RoomNumber); $('#txtChaoXiang').attr('value', row2.rows[0].Orientations); $('#txtHuXing').attr('value', row2.rows[0].HouseType); $('#txtFangJianLeiXing').attr('value', row2.rows[0].RoomType); $('#txtJieGou').attr('value', row2.rows[0].Structure); $('#txtJianZhuMianJi').attr('value', $('#txtFloorArea2').val()); $('#txtTaoNeiMianJi').attr('value', $('#txtRoomArea2').val()); $('#txtFenTanMianJi').attr('value', $('#txtShareArea2').val()); $('#txtDanYuan').attr('value', $('#txtDanYuanFollow2').val());//绑定每一个数据 } function onChangeHouse1() {//生成动态外观图 var y; var options = {}; var String1 = "[[{ field:'LouChen', title: '楼层', width: 40},"; for (var i = 0; i < ($('#txtRoomNumberTo2').val()).toString().trim(); i++) { y = i + 1; if (i < ($('#txtRoomNumberTo2').val()).toString().trim() - 1) { var s = "{ field:'F" + i + "', title: '0" + y + "', width: 80,formatter:myformatterOne},"; String1 = String1 + s; } else { var s = "{ field:'F" + i + "', title: '0" + y + "', width: 80,formatter:myformatterOne}"; String1 = String1 + s + "]]"; } } options.columns = eval(String1); $('#dgRoomAppearancePicture').datagrid(options); for (var j = ($('#txtStoreyTo2').val()).toString().trim(); j >= ($('#txtStoreyFollow2').val()).toString().trim(); j--) { $('#dgRoomAppearancePicture').datagrid("appendRow", { LouChen: (j < 10 ? ('0' + j) : j) }); } } var ssss = 0; var tt = 0; function myformatterOne(value, rowData, rowIndex) {//绑定外观图数据 ssss++; tt = $('#txtStoreyTo2').val() - rowIndex; if (ssss > ($('#txtRoomNumberTo2').val()).toString().trim()) { ssss = 1; } if (ssss < 10) { ssss = '0' + ssss; } if (tt >= ($('#txtStoreyFollow2').val()).toString().trim()) { return $('#txtDanYuanFollow2').val().toString().trim()+"-"+tt.toString() + ssss.toString(); } } function InsertUnitRoomData() {//生成房间方法 if (confirm('是否生成房间？')) { var node = $('#treXiangMuMingCheng').tree('getSelected'); var JianzhuXingZhi = $('#tb建筑性质').datagrid('getSelected'); var row = $('#dgRoomListing').datagrid('getChanges', 'inserted'); if (PanDuan == "2") { $.getJSON("/XiangMuZiLiao/XingZengLouDongZiLiao?LouDongDaiMa=" + $('#txtLouDongDaiMa1').val() + "&" + "LouDongMingCheng=" + $('#txtLouDongMingCheng1').val() + "&" + "CengShu=" + $('#txtJianZhuCengShu1').val() + "&" + "FangJianBianHaoMoShiLeiXingID=" + $("#cboFangJianBianHaoMuShi1").combobox('getValue') + "&" + "HeTongDongHaoMingCheng=" + $('#txtHeTongLouDongMingCheng1').val() + "&" + "JianLiJiGouID=" + $('#cboJianLiJiGou1').combobox('getValue') + "&" + "JianYaoBeiZhu=" + $('#txtJianYaoBeiZhu1').val() + "&" + "JianZhuXingZhiID=" + JianzhuXingZhi.BuildingPropertyID + "&" + "JiaoWuBiaoZhunID=" + $('#cboJiaoWuBiaoZhun1').combobox('getValue') + "&" + "LouDongDiKuaiBianHao=" + $('#txtDiKuaiBianHao1').val() + "&" + "LouDongFangDiChangZhengHao=" + $('#txtFangDiChanZhengHao1').val() + "&" + "LouDongTuDiChuRangHeTongHao=" + $('#txtTuDiChuRangHeTong1').val() + "&" + "LouDongTuDiMianJi=" + $('#txtTuDiMianJi1').val() + "&" + "LouDongTuDiShiYongJieShuShiJian=" + $('#datTuDiShiYongEdd1').datebox('getValue') + "&" + "LouDongTuDiShiYongKaiShiShiJian=" + $('#datTuDiShiYongCong1').datebox('getValue') + "&" + "LouDongTuDiYongTu=" + $('#txtTuDiYongTu1').val() + "&" + "YingJiaoFangRiQi=" + $('#datYingJiaoFangRiQi1').datebox('getValue') + "&" + "JieGouID=" + $('#cboJieGou1').combobox('getValue') + "&" + "XiangMuFenQuID=" + node.id + "&", function (data5) { if (data5 != null) { HouseID = data5; $.getJSON("/FangJianZiLiao/InsertRoomDescribe?StoreyActionNumber=" + $('#txtStoreyFollow2').val() + "&" + "StoreyFinishNumber=" + $('#txtStoreyTo2').val() + "&" + "NatureStoreyActionNumber=" + $('#txtNatureFollow2').val() + "&" + "NatureStoreyFinishNumber=" + $('#txtNatureTo2').val() + "&" + "HouseID=" + HouseID, function (data) { if (data > 0) { RoomDescribeID = data; for (var i = 0; i < row.length; i++) { $.getJSON("/FangJianZiLiao/InsertUnitRoomData?HouseID=" + HouseID + "&" + "RoomCode=" + row[i].RoomCode + "&" + "RoomNumber=" + row[i].RoomNumber + "&" + "RoomUnit=" + row[i].Unit + "&" + "natureNumber=" + row[i].NatureFloor + "&" + "Floor=" + row[i].Floor + "&" + "CoveredArea=" + $('#txtFloorArea2').val() + "&" + "BuilDingExceptArea=" + $('#txtRoomArea2').val() + "&" + "AreaShare=" + $('#txtShareArea2').val() + "&" + "BalconyArea=" + $('#txtBalconyArea2').val() + "&" + "RoomFaceDirectionID=" + $('#cboOrientations2').combobox('getValue') + "&" + "LandscapeID=" + $('#cboLandscape2').combobox('getValue') + "&" + "HouseTypeID=" + $('#cboHouseType2').combobox('getValue') + "&" + "RoomTypeID=" + $('#cboRoomType2').combobox('getValue') + "&" + "RoomRanking=" + row[i].RoomRanking + "&" + "RoomDescribeID=" + RoomDescribeID + "&" + "BuildingPropertiesID=" + JianzhuXingZhi.BuildingPropertyID, function (data1) { if (data1 > 0) { RoomDataID = data1; $.getJSON("/FangJianZiLiao/InsertRoomUnivalent?RoomDatumID=" + RoomDataID, function (data2) { if (data2 > 0) { } }); $.getJSON("/FangJianZiLiao/InsertAreaMeasurement?RoomDataID=" + RoomDataID, function (data3) { if (data3 > 0) { } }); $.getJSON("/FangJianZiLiao/InsertStatusChange?RoomDatumID=" + RoomDataID, function (data4) { if (data4 > 0) { } }); } }); } } alert("生成成功！！！"); $('#w增加楼栋').window('close'); $("#frmGeneratePreview").window('close'); $('#w新增房间描述').window('close'); }); } else { } }); } else { $.getJSON("/XiangMuZiLiao/InsertProjectSubregion?ProjectSubregionName=" + $('#txtXiangMuFenQu1').val() + "&" + "ProjectID=" + XiangMu, function (data6) { XiangMuFenQuID = data6; $.getJSON("/XiangMuZiLiao/XingZengLouDongZiLiao?LouDongDaiMa=" + $('#txtLouDongDaiMa1').val() + "&" + "LouDongMingCheng=" + $('#txtLouDongMingCheng1').val() + "&" + "CengShu=" + $('#txtJianZhuCengShu1').val() + "&" + "FangJianBianHaoMoShiLeiXingID=" + $("#cboFangJianBianHaoMuShi1").combobox('getValue') + "&" + "HeTongDongHaoMingCheng=" + $('#txtHeTongLouDongMingCheng1').val() + "&" + "JianLiJiGouID=" + $('#cboJianLiJiGou1').combobox('getValue') + "&" + "JianYaoBeiZhu=" + $('#txtJianYaoBeiZhu1').val() + "&" + "JianZhuXingZhiID=" + JianzhuXingZhi.BuildingPropertyID + "&" + "JiaoWuBiaoZhunID=" + $('#cboJiaoWuBiaoZhun1').combobox('getValue') + "&" + "LouDongDiKuaiBianHao=" + $('#txtDiKuaiBianHao1').val() + "&" + "LouDongFangDiChangZhengHao=" + $('#txtFangDiChanZhengHao1').val() + "&" + "LouDongTuDiChuRangHeTongHao=" + $('#txtTuDiChuRangHeTong1').val() + "&" + "LouDongTuDiMianJi=" + $('#txtTuDiMianJi1').val() + "&" + "LouDongTuDiShiYongJieShuShiJian=" + $('#datTuDiShiYongEdd1').datebox('getValue') + "&" + "LouDongTuDiShiYongKaiShiShiJian=" + $('#datTuDiShiYongCong1').datebox('getValue') + "&" + "LouDongTuDiYongTu=" + $('#txtTuDiYongTu1').val() + "&" + "YingJiaoFangRiQi=" + $('#datYingJiaoFangRiQi1').datebox('getValue') + "&" + "JieGouID=" + $('#cboJieGou1').combobox('getValue') + "&" + "XiangMuFenQuID=" + XiangMuFenQuID + "&", function (data5) { if (data5 != null) { HouseID = data5; $.getJSON("/FangJianZiLiao/InsertRoomDescribe?StoreyActionNumber=" + $('#txtStoreyFollow2').val() + "&" + "StoreyFinishNumber=" + $('#txtStoreyTo2').val() + "&" + "NatureStoreyActionNumber=" + $('#txtNatureFollow2').val() + "&" + "NatureStoreyFinishNumber=" + $('#txtNatureTo2').val() + "&" + "HouseID=" + HouseID, function (data) { if (data > 0) { RoomDescribeID = data; for (var i = 0; i < row.length; i++) { $.getJSON("/FangJianZiLiao/InsertUnitRoomData?HouseID=" + HouseID + "&" + "RoomCode=" + row[i].RoomCode + "&" + "RoomNumber=" + row[i].RoomNumber + "&" + "RoomUnit=" + row[i].Unit + "&" + "natureNumber=" + row[i].NatureFloor + "&" + "Floor=" + row[i].Floor + "&" + "CoveredArea=" + $('#txtFloorArea2').val() + "&" + "BuilDingExceptArea=" + $('#txtRoomArea2').val() + "&" + "AreaShare=" + $('#txtShareArea2').val() + "&" + "BalconyArea=" + $('#txtBalconyArea2').val() + "&" + "RoomFaceDirectionID=" + $('#cboOrientations2').combobox('getValue') + "&" + "LandscapeID=" + $('#cboLandscape2').combobox('getValue') + "&" + "HouseTypeID=" + $('#cboHouseType2').combobox('getValue') + "&" + "RoomTypeID=" + $('#cboRoomType2').combobox('getValue') + "&" + "RoomRanking=" + row[i].RoomRanking + "&" + "RoomDescribeID=" + RoomDescribeID + "&" + "BuildingPropertiesID=" + JianzhuXingZhi.BuildingPropertyID, function (data1) { if (data1 > 0) { RoomDataID = data1; $.getJSON("/FangJianZiLiao/InsertRoomUnivalent?RoomDatumID=" + RoomDataID, function (data2) { if (data2 > 0) { } }); $.getJSON("/FangJianZiLiao/InsertAreaMeasurement?RoomDataID=" + RoomDataID, function (data3) { if (data3 > 0) { } }); $.getJSON("/FangJianZiLiao/InsertStatusChange?RoomDatumID=" + RoomDataID, function (data4) { if (data4 > 0) { } }); } }); } } alert("生成成功！！！"); $('#w增加楼栋').window('close'); $("#frmGeneratePreview").window('close'); $('#w新增房间描述').window('close'); }); } else { } }); }); } } }生成房间之后，如果发现有一些错误或者客户的特殊要求，那么我们可以在房间资料里面进行维护。楼栋出现错误可以在项目资料模块进行维护。
楼栋资料界面效果图如下：
房间资料维护界面效果图：
在这里我们可以通过查询出默一栋楼的房间资料进行维护。在这里可以进行新增、修改、删除的维护。
首先说一下修改：
修改界面如下：
从界面上看我们这里用到的控件有：
控件名称
说明
单行文本框（easyui-textbox）
第一要设置每个控件的id，第二可以设置每个控件的大小，不设置也有默认值，第三（data-options）是数据的操作可以设置控件的属性和事件。
下拉框（easyui-combobox）
按钮（easyui-linkbutton）
复选框（checkbox）
这里涉及到的是房间资料表上面有，请参考上面的房源的生成。
第一步：数据库的存储过程
if @SN='UpdateRoomData'--修改房间资料 begin update SYS_RoomDataTable set Floor=@Floor,natureNumber=@natureNumber,RoomNumber=@RoomNumber, CoveredArea=@CoveredArea,BuilDingExceptArea=@BuilDingExceptArea, AreaShare=@AreaShare,BalconyArea=@BalconyArea,RoomFaceDirectionID=@RoomFaceDirectionID, LandscapeID=@LandscapeID,HouseTypeID=@HouseTypeID,RoomTypeID=@RoomTypeID,BuildingPropertiesID=@BuildingPropertiesID where RoomDataID=@RoomDataID end
第二步：BLL
public int UpdateFangJianZiLiao(int Floor, string natureNumber, string RoomNumber, decimal CoveredArea, decimal BuilDingExceptArea, decimal AreaShare, decimal BalconyArea, int RoomFaceDirectionID, int LandscapeID, int HouseTypeID, int RoomTypeID, int BuildingPropertiesID,int RoomDataID) { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@Floor",SqlDbType.Int), new SqlParameter("@natureNumber",SqlDbType.Char), new SqlParameter("@RoomNumber",SqlDbType.Char), new SqlParameter("@CoveredArea",SqlDbType.Decimal), new SqlParameter("@BuilDingExceptArea",SqlDbType.Decimal), new SqlParameter("@AreaShare",SqlDbType.Decimal), new SqlParameter("@BalconyArea",SqlDbType.Decimal), new SqlParameter("@RoomFaceDirectionID",SqlDbType.Int), new SqlParameter("@LandscapeID",SqlDbType.Int), new SqlParameter("@HouseTypeID",SqlDbType.Int), new SqlParameter("@RoomTypeID",SqlDbType.Int), new SqlParameter("@BuildingPropertiesID",SqlDbType.Int), new SqlParameter("@RoomDataID",SqlDbType.Int) }; SQLCMDpas[0].Value = "UpdateRoomData"; SQLCMDpas[1].Value=Floor; SQLCMDpas[2].Value=natureNumber; SQLCMDpas[3].Value=RoomNumber; SQLCMDpas[4].Value=CoveredArea; SQLCMDpas[5].Value=BuilDingExceptArea; SQLCMDpas[6].Value=AreaShare; SQLCMDpas[7].Value=BalconyArea; SQLCMDpas[8].Value=RoomFaceDirectionID; SQLCMDpas[9].Value=LandscapeID; SQLCMDpas[10].Value=HouseTypeID; SQLCMDpas[11].Value=RoomTypeID; SQLCMDpas[12].Value=BuildingPropertiesID; SQLCMDpas[13].Value = RoomDataID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData",SQLCMDpas); return i; }第三步：Controller
public ActionResult UpdateRoomData(int Floor, string natureNumber, string RoomNumber, decimal CoveredArea, decimal BuilDingExceptArea, decimal AreaShare, decimal BalconyArea, int RoomFaceDirectionID, int LandscapeID, int HouseTypeID, int RoomTypeID, int BuildingPropertiesID,int RoomDataID) { int i = myFangJianZiLiao.UpdateFangJianZiLiao(Floor, natureNumber, RoomNumber, CoveredArea, BuilDingExceptArea, AreaShare, BalconyArea, RoomFaceDirectionID, LandscapeID, HouseTypeID, RoomTypeID, BuildingPropertiesID, RoomDataID); return Content(i.ToString()); }第四步：界面
function UpdateFangJianZiLiao(){ var row = $('#tb建筑性质').datagrid('getSelected'); var row1 = $('#tb房间资料').datagrid('getSelected'); if(row==null){ JianZhuXingZhiID; }else{ JianZhuXingZhiID=row.BuildingPropertyID; } if (confirm("是否修改？")) { $.getJSON("/FangJianZiLiao/UpdateRoomData?Floor=" + $('#txtXStoreyFollow').val() + "&" + "natureNumber=" + $('#txtXNatureFollow').val() + "&" + "RoomNumber=" + $('#txtXRoomNumberFollow').val() + "&" + "CoveredArea=" + $('#txtXFloorArea').val() + "&" + "BuilDingExceptArea=" + $('#txtXRoomArea').val() + "&" + "AreaShare=" + $('#txtXShareArea').val() + "&" + "BalconyArea=" + $('#txtXBalconyArea').val() + "&" + "RoomFaceDirectionID=" + $('#cboXOrientations').combobox('getValue') + "&" + "LandscapeID=" + $('#cboXLandscape').combobox('getValue') + "&" + "HouseTypeID=" + $('#cboXHouseType').combobox('getValue') + "&" + "RoomTypeID=" + $('#cboXRoomType').combobox('getValue') + "&" + "BuildingPropertiesID=" + JianZhuXingZhiID + "&" + "RoomDataID=" + row1.RoomDataID, function (data) { if (data > 0) { alert("修改成功！"); $('#w修改房间描述').window('close'); $.getJSON("/FangJianZiLiao/SelectAllRoomData", function (data) { $('#tb房间资料').datagrid('loadData', data); }); } else { alert("修改失败！"); } } ); } } function closeXiuGaiChuangTi() { $('#w修改房间描述').window('close'); } function DeleteRoomData() { var row=$('#tb房间资料').datagrid('getSelected'); if (row != null) { if (confirm("是否删除？")) { $.getJSON("/FangJianZiLiao/DeleteRoomData?RoomDataID=" + row.RoomDataID, function (data) { if (data > 0) { alert("删除成功！"); $.getJSON("/FangJianZiLiao/SelectAllRoomData", function (data) { $('#tb房间资料').datagrid('loadData', data); }); } else { alert("删除失败！"); } }); } }else{ alert("请先选中一行数据！！！"); } }这样就可以修改成功了！
还有就是删除。
删除就直接说下代码把。
第一步：数据库存储过程。
if @SN='DeleteRoomData'--删除房间资料 begin delete SYS_RoomDataTable where RoomDataID=@RoomDataID end
第二步：BLL
public int DeleteRoomData(int RoomDataID)//删除房间资料 { SqlParameter[] SQLCMDpas = { new SqlParameter("@SN",SqlDbType.Char), new SqlParameter("@RoomDataID",SqlDbType.Int) }; SQLCMDpas[0].Value = "DeleteRoomData"; SQLCMDpas[1].Value = RoomDataID; int i = myDALMethod.DAL_OPTableDB_Par("SYS_RoomData",SQLCMDpas); return i; }第三步：Controller
public ActionResult DeleteRoomData(int RoomDataID) { int i = myFangJianZiLiao.DeleteRoomData(RoomDataID); return Content(i.ToString()); }第四步：界面
function DeleteRoomData() { var row=$('#tb房间资料').datagrid('getSelected'); if (row != null) { if (confirm("是否删除？")) { $.getJSON("/FangJianZiLiao/DeleteRoomData?RoomDataID=" + row.RoomDataID, function (data) { if (data > 0) { alert("删除成功！"); $.getJSON("/FangJianZiLiao/SelectAllRoomData", function (data) { $('#tb房间资料').datagrid('loadData', data); }); } else { alert("删除失败！"); } }); } }else{ alert("请先选中一行数据！！！"); } }这样就可以删除成功了！
楼栋资料的维护也跟这里房间资料的维护一样，做楼栋资料维护可以参考这里房间资料的维护。
仅供学习参考，禁止商业用途！
0 0
- 明源售楼系统技术解析 房源生成（二）
- 明源售楼系统技术解析 MVC架构与房源生成（一）
- 明源售楼系统技术解析 折扣管理（二）
- 明源售楼系统技术解析 签约管理（二）
- 明源售楼系统技术解析（二）付款方式定义——查询
- 明源售楼系统技术解析 架构搭建（一）
- 明源售楼系统技术解析 销售控制（三）
- 明源售楼系统技术解析（四）右键菜单
- 明源售楼系统技术解析 签约管理（一）
- 明源售楼系统技术解析—MVC架构
- 明源售楼系统技术解析（一）搭建MVC3框架
- 明源售楼系统技术解析—诚意认购（一）
- 明源售楼系统技术解析（三）付款定义新增、修改、删除
- 明源售楼系统技术解析 销售控制（更名查询与变更查询）
- 明源售楼系统技术解析（五）开发商销控、客户自助查询
- WCF＋SQL Server 2008 明源售楼系统项目解析（一）
- 新锐房地产销售管理系统（部分流程）技术解释（三）销售管理_房源查询
- 会员卡管理系统技术解析（四）生成持久类
- 计算机硬件系统组成
- linux常用命令-简单文件处理命令
- appium初学环境搭建
- C++ 学习笔记（三） 编写makefile
- gabor小波代码
- 明源售楼系统技术解析 房源生成（二）
- 凯云水利水电造价工程系统 （三） 材料单价 （3）
- linux常用命令-文件处理命令
- 核函数（Kernels）
- 赫夫曼编码\译码
- 输入两个整数n 和m，从数列1，2，3.......n 中随意取几个数, 使其和等于m ,要求将其中所有的可能组合列出来
- javascript常见的设计模式
- 密封类
- 五子棋设计
