/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.xf_Building GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 ID,CreateTime,BuildingUuid,buildingName,buildingType,buildingUseNature,fireDanger,fireResistantLevel,structureType,buildingHeight,buildingAddr,regionCode,buildingState,buildingTime,buildingFinishTime,propertyRight,buildingArea,occupyArea,standardFloorArea,overFloorNum,overFloorArea,underFloorNum,underFloorArea,tunnelHeight,tunnelLength,controlRoomCondition,controlRoomPosition,workerDailyNum,buildingGalleryful,fireElevatorNum,fireElevatorPosition,fireElevatorCarrery,shelterFloorNum,shelterFloorArea,shelterFloorPosition,exitNum,exitPosition,exitForm,storageName,storageNum,storageNature,storageShape,storageSize,mainMaterial,mainProduct,enterOrgNum,orgAbutSituation,belongOrgId,managerOrgId,unitNum,floorNum,mapType,gpsX3d,gpsY3d,gpsZ3d,isMezzanine,memo,platformCode,recordCode from xf_Building ");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@ID", SqlDbType.Int, 4)
};
parameters[0].Value = ID;
ClassLibrary1.Model.xf_Building model = new ClassLibrary1.Model.xf_Building();
DataSet ds = DbHelperSql.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ClassLibrary1.Model.xf_Building DataRowToModel(DataRow row)
{
ClassLibrary1.Model.xf_Building model = new ClassLibrary1.Model.xf_Building();
if (row != null)
{
if (row["ID"] != null && row["ID"].ToString() != "")
{
model.ID = int.Parse(row["ID"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["BuildingUuid"] != null && row["BuildingUuid"].ToString() != "")
{
model.BuildingUuid = new Guid(row["BuildingUuid"].ToString());
}
if (row["buildingName"] != null)
{
model.buildingName = row["buildingName"].ToString();
}
if (row["buildingType"] != null)
{
model.buildingType = row["buildingType"].ToString();
}
if (row["buildingUseNature"] != null)
{
model.buildingUseNature = row["buildingUseNature"].ToString();
}
if (row["fireDanger"] != null)
{
model.fireDanger = row["fireDanger"].ToString();
}
if (row["fireResistantLevel"] != null)
{
model.fireResistantLevel = row["fireResistantLevel"].ToString();
}
if (row["structureType"] != null)
{
model.structureType = row["structureType"].ToString();
}
if (row["buildingHeight"] != null && row["buildingHeight"].ToString() != "")
{
model.buildingHeight = decimal.Parse(row["buildingHeight"].ToString());
}
if (row["buildingAddr"] != null)
{
model.buildingAddr = row["buildingAddr"].ToString();
}
if (row["regionCode"] != null)
{
model.regionCode = row["regionCode"].ToString();
}
if (row["buildingState"] != null)
{
model.buildingState = row["buildingState"].ToString();
}
if (row["buildingTime"] != null)
{
model.buildingTime = row["buildingTime"].ToString();
}
if (row["buildingFinishTime"] != null)
{
model.buildingFinishTime = row["buildingFinishTime"].ToString();
}
if (row["propertyRight"] != null)
{
model.propertyRight = row["propertyRight"].ToString();
}
if (row["buildingArea"] != null && row["buildingArea"].ToString() != "")
{
model.buildingArea = decimal.Parse(row["buildingArea"].ToString());
}
if (row["occupyArea"] != null && row["occupyArea"].ToString() != "")
{
model.occupyArea = decimal.Parse(row["occupyArea"].ToString());
}
if (row["standardFloorArea"] != null && row["standardFloorArea"].ToString() != "")
{
model.standardFloorArea = decimal.Parse(row["standardFloorArea"].ToString());
}
if (row["overFloorNum"] != null && row["overFloorNum"].ToString() != "")
{
model.overFloorNum = int.Parse(row["overFloorNum"].ToString());
}
if (row["overFloorArea"] != null && row["overFloorArea"].ToString() != "")
{
model.overFloorArea = decimal.Parse(row["overFloorArea"].ToString());
}
if (row["underFloorNum"] != null && row["underFloorNum"].ToString() != "")
{
model.underFloorNum = int.Parse(row["underFloorNum"].ToString());
}
if (row["underFloorArea"] != null && row["underFloorArea"].ToString() != "")
{
model.underFloorArea = decimal.Parse(row["underFloorArea"].ToString());
}
if (row["tunnelHeight"] != null && row["tunnelHeight"].ToString() != "")
{
model.tunnelHeight = decimal.Parse(row["tunnelHeight"].ToString());
}
if (row["tunnelLength"] != null && row["tunnelLength"].ToString() != "")
{
model.tunnelLength = decimal.Parse(row["tunnelLength"].ToString());
}
if (row["controlRoomCondition"] != null && row["controlRoomCondition"].ToString() != "")
{
model.controlRoomCondition = int.Parse(row["controlRoomCondition"].ToString());
}
if (row["controlRoomPosition"] != null)
{
model.controlRoomPosition = row["controlRoomPosition"].ToString();
}
if (row["workerDailyNum"] != null && row["workerDailyNum"].ToString() != "")
{
model.workerDailyNum = int.Parse(row["workerDailyNum"].ToString());
}
if (row["buildingGalleryful"] != null && row["buildingGalleryful"].ToString() != "")
{
model.buildingGalleryful = int.Parse(row["buildingGalleryful"].ToString());
}
if (row["fireElevatorNum"] != null && row["fireElevatorNum"].ToString() != "")
{
model.fireElevatorNum = int.Parse(row["fireElevatorNum"].ToString());
}
if (row["fireElevatorPosition"] != null)
{
model.fireElevatorPosition = row["fireElevatorPosition"].ToString();
}
if (row["fireElevatorCarrery"] != null && row["fireElevatorCarrery"].ToString() != "")
{
model.fireElevatorCarrery = decimal.Parse(row["fireElevatorCarrery"].ToString());
}
if (row["shelterFloorNum"] != null && row["shelterFloorNum"].ToString() != "")
{
model.shelterFloorNum = decimal.Parse(row["shelterFloorNum"].ToString());
}
if (row["shelterFloorArea"] != null && row["shelterFloorArea"].ToString() != "")
{
model.shelterFloorArea = decimal.Parse(row["shelterFloorArea"].ToString());
}
if (row["shelterFloorPosition"] != null)
{
model.shelterFloorPosition = row["shelterFloorPosition"].ToString();
}
if (row["exitNum"] != null && row["exitNum"].ToString() != "")
{
model.exitNum = int.Parse(row["exitNum"].ToString());
}
if (row["exitPosition"] != null)
{
model.exitPosition = row["exitPosition"].ToString();
}
if (row["exitForm"] != null)
{
model.exitForm = row["exitForm"].ToString();
}
if (row["storageName"] != null)
{
model.storageName = row["storageName"].ToString();
}
if (row["storageNum"] != null && row["storageNum"].ToString() != "")
{
model.storageNum = int.Parse(row["storageNum"].ToString());
}
if (row["storageNature"] != null)
{
model.storageNature = row["storageNature"].ToString();
}
if (row["storageShape"] != null)
{
model.storageShape = row["storageShape"].ToString();
}
if (row["storageSize"] != null && row["storageSize"].ToString() != "")
{
model.storageSize = decimal.Parse(row["storageSize"].ToString());
}
if (row["mainMaterial"] != null)
{
model.mainMaterial = row["mainMaterial"].ToString();
}
if (row["mainProduct"] != null)
{
model.mainProduct = row["mainProduct"].ToString();
}
if (row["enterOrgNum"] != null && row["enterOrgNum"].ToString() != "")
{
model.enterOrgNum = int.Parse(row["enterOrgNum"].ToString());
}
if (row["orgAbutSituation"] != null)
{
model.orgAbutSituation = row["orgAbutSituation"].ToString();
}
if (row["belongOrgId"] != null)
{
model.belongOrgId = row["belongOrgId"].ToString();
}
if (row["managerOrgId"] != null)
{
model.managerOrgId = row["managerOrgId"].ToString();
}
if (row["unitNum"] != null && row["unitNum"].ToString() != "")
{
model.unitNum = int.Parse(row["unitNum"].ToString());
}
if (row["floorNum"] != null && row["floorNum"].ToString() != "")
{
model.floorNum = int.Parse(row["floorNum"].ToString());
}
if (row["mapType"] != null && row["mapType"].ToString() != "")
{
model.mapType = int.Parse(row["mapType"].ToString());
}
if (row["gpsX3d"] != null && row["gpsX3d"].ToString() != "")
{
model.gpsX3d = decimal.Parse(row["gpsX3d"].ToString());
}
if (row["gpsY3d"] != null && row["gpsY3d"].ToString() != "")
{
model.gpsY3d = decimal.Parse(row["gpsY3d"].ToString());
}
if (row["gpsZ3d"] != null && row["gpsZ3d"].ToString() != "")
{
model.gpsZ3d = decimal.Parse(row["gpsZ3d"].ToString());
}
if (row["isMezzanine"] != null && row["isMezzanine"].ToString() != "")
{
model.isMezzanine = int.Parse(row["isMezzanine"].ToString());
}
if (row["memo"] != null)
{
model.memo = row["memo"].ToString();
}
if (row["platformCode"] != null)
{
model.platformCode = row["platformCode"].ToString();
}
if (row["recordCode"] != null)
{
model.recordCode = row["recordCode"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ClassLibrary1.Model.xf_Building model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into xf_Building(");
strSql.Append("CreateTime,BuildingUuid,buildingName,buildingType,buildingUseNature,fireDanger,fireResistantLevel,structureType,buildingHeight,buildingAddr,regionCode,buildingState,buildingTime,buildingFinishTime,propertyRight,buildingArea,occupyArea,standardFloorArea,overFloorNum,overFloorArea,underFloorNum,underFloorArea,tunnelHeight,tunnelLength,controlRoomCondition,controlRoomPosition,workerDailyNum,buildingGalleryful,fireElevatorNum,fireElevatorPosition,fireElevatorCarrery,shelterFloorNum,shelterFloorArea,shelterFloorPosition,exitNum,exitPosition,exitForm,storageName,storageNum,storageNature,storageShape,storageSize,mainMaterial,mainProduct,enterOrgNum,orgAbutSituation,belongOrgId,managerOrgId,unitNum,floorNum,mapType,gpsX3d,gpsY3d,gpsZ3d,isMezzanine,memo,platformCode,recordCode)");
strSql.Append(" values (");
strSql.Append("@CreateTime,@BuildingUuid,@buildingName,@buildingType,@buildingUseNature,@fireDanger,@fireResistantLevel,@structureType,@buildingHeight,@buildingAddr,@regionCode,@buildingState,@buildingTime,@buildingFinishTime,@propertyRight,@buildingArea,@occupyArea,@standardFloorArea,@overFloorNum,@overFloorArea,@underFloorNum,@underFloorArea,@tunnelHeight,@tunnelLength,@controlRoomCondition,@controlRoomPosition,@workerDailyNum,@buildingGalleryful,@fireElevatorNum,@fireElevatorPosition,@fireElevatorCarrery,@shelterFloorNum,@shelterFloorArea,@shelterFloorPosition,@exitNum,@exitPosition,@exitForm,@storageName,@storageNum,@storageNature,@storageShape,@storageSize,@mainMaterial,@mainProduct,@enterOrgNum,@orgAbutSituation,@belongOrgId,@managerOrgId,@unitNum,@floorNum,@mapType,@gpsX3d,@gpsY3d,@gpsZ3d,@isMezzanine,@memo,@platformCode,@recordCode)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime2, 8),
new SqlParameter("@BuildingUuid", SqlDbType.UniqueIdentifier, 16),
new SqlParameter("@buildingName", SqlDbType.VarChar, 255),
new SqlParameter("@buildingType", SqlDbType.VarChar, 255),
new SqlParameter("@buildingUseNature", SqlDbType.VarChar, 255),
new SqlParameter("@fireDanger", SqlDbType.VarChar, 255),
new SqlParameter("@fireResistantLevel", SqlDbType.VarChar, 255),
new SqlParameter("@structureType", SqlDbType.VarChar, 255),
new SqlParameter("@buildingHeight", SqlDbType.Float, 8),
new SqlParameter("@buildingAddr", SqlDbType.VarChar, 255),
new SqlParameter("@regionCode", SqlDbType.VarChar, 255),
new SqlParameter("@buildingState", SqlDbType.VarChar, 255),
new SqlParameter("@buildingTime", SqlDbType.VarChar, 255),
new SqlParameter("@buildingFinishTime", SqlDbType.VarChar, 255),
new SqlParameter("@propertyRight", SqlDbType.VarChar, 255),
new SqlParameter("@buildingArea", SqlDbType.Float, 8),
new SqlParameter("@occupyArea", SqlDbType.Float, 8),
new SqlParameter("@standardFloorArea", SqlDbType.Float, 8),
new SqlParameter("@overFloorNum", SqlDbType.Int, 4),
new SqlParameter("@overFloorArea", SqlDbType.Float, 8),
new SqlParameter("@underFloorNum", SqlDbType.Int, 4),
new SqlParameter("@underFloorArea", SqlDbType.Float, 8),
new SqlParameter("@tunnelHeight", SqlDbType.Float, 8),
new SqlParameter("@tunnelLength", SqlDbType.Float, 8),
new SqlParameter("@controlRoomCondition", SqlDbType.Int, 4),
new SqlParameter("@controlRoomPosition", SqlDbType.VarChar, 255),
new SqlParameter("@workerDailyNum", SqlDbType.Int, 4),
new SqlParameter("@buildingGalleryful", SqlDbType.Int, 4),
new SqlParameter("@fireElevatorNum", SqlDbType.Int, 4),
new SqlParameter("@fireElevatorPosition", SqlDbType.VarChar, 255),
new SqlParameter("@fireElevatorCarrery", SqlDbType.Float, 8),
new SqlParameter("@shelterFloorNum", SqlDbType.Float, 8),
new SqlParameter("@shelterFloorArea", SqlDbType.Float, 8),
new SqlParameter("@shelterFloorPosition", SqlDbType.VarChar, 255),
new SqlParameter("@exitNum", SqlDbType.Int, 4),
new SqlParameter("@exitPosition", SqlDbType.VarChar, 255),
new SqlParameter("@exitForm", SqlDbType.VarChar, 255),
new SqlParameter("@storageName", SqlDbType.VarChar, 255),
new SqlParameter("@storageNum", SqlDbType.Int, 4),
new SqlParameter("@storageNature", SqlDbType.VarChar, 255),
new SqlParameter("@storageShape", SqlDbType.VarChar, 255),
new SqlParameter("@storageSize", SqlDbType.Float, 8),
new SqlParameter("@mainMaterial", SqlDbType.VarChar, 255),
new SqlParameter("@mainProduct", SqlDbType.VarChar, 255),
new SqlParameter("@enterOrgNum", SqlDbType.Int, 4),
new SqlParameter("@orgAbutSituation", SqlDbType.VarChar, 255),
new SqlParameter("@belongOrgId", SqlDbType.VarChar, 255),
new SqlParameter("@managerOrgId", SqlDbType.VarChar, 255),
new SqlParameter("@unitNum", SqlDbType.Int, 4),
new SqlParameter("@floorNum", SqlDbType.Int, 4),
new SqlParameter("@mapType", SqlDbType.Int, 4),
new SqlParameter("@gpsX3d", SqlDbType.Float, 8),
new SqlParameter("@gpsY3d", SqlDbType.Float, 8),
new SqlParameter("@gpsZ3d", SqlDbType.Float, 8),
new SqlParameter("@isMezzanine", SqlDbType.Int, 4),
new SqlParameter("@memo", SqlDbType.VarChar, 255),
new SqlParameter("@platformCode", SqlDbType.VarChar, 255),
new SqlParameter("@recordCode", SqlDbType.VarChar, 255)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = Guid.NewGuid();
parameters[2].Value = model.buildingName;
parameters[3].Value = model.buildingType;
parameters[4].Value = model.buildingUseNature;
parameters[5].Value = model.fireDanger;
parameters[6].Value = model.fireResistantLevel;
parameters[7].Value = model.structureType;
parameters[8].Value = model.buildingHeight;
parameters[9].Value = model.buildingAddr;
parameters[10].Value = model.regionCode;
parameters[11].Value = model.buildingState;
parameters[12].Value = model.buildingTime;
parameters[13].Value = model.buildingFinishTime;
parameters[14].Value = model.propertyRight;
parameters[15].Value = model.buildingArea;
parameters[16].Value = model.occupyArea;
parameters[17].Value = model.standardFloorArea;
parameters[18].Value = model.overFloorNum;
parameters[19].Value = model.overFloorArea;
parameters[20].Value = model.underFloorNum;
parameters[21].Value = model.underFloorArea;
parameters[22].Value = model.tunnelHeight;
parameters[23].Value = model.tunnelLength;
parameters[24].Value = model.controlRoomCondition;
parameters[25].Value = model.controlRoomPosition;
parameters[26].Value = model.workerDailyNum;
parameters[27].Value = model.buildingGalleryful;
parameters[28].Value = model.fireElevatorNum;
parameters[29].Value = model.fireElevatorPosition;
parameters[30].Value = model.fireElevatorCarrery;
parameters[31].Value = model.shelterFloorNum;
parameters[32].Value = model.shelterFloorArea;
parameters[33].Value = model.shelterFloorPosition;
parameters[34].Value = model.exitNum;
parameters[35].Value = model.exitPosition;
parameters[36].Value = model.exitForm;
parameters[37].Value = model.storageName;
parameters[38].Value = model.storageNum;
parameters[39].Value = model.storageNature;
parameters[40].Value = model.storageShape;
parameters[41].Value = model.storageSize;
parameters[42].Value = model.mainMaterial;
parameters[43].Value = model.mainProduct;
parameters[44].Value = model.enterOrgNum;
parameters[45].Value = model.orgAbutSituation;
parameters[46].Value = model.belongOrgId;
parameters[47].Value = model.managerOrgId;
parameters[48].Value = model.unitNum;
parameters[49].Value = model.floorNum;
parameters[50].Value = model.mapType;
parameters[51].Value = model.gpsX3d;
parameters[52].Value = model.gpsY3d;
parameters[53].Value = model.gpsZ3d;
parameters[54].Value = model.isMezzanine;
parameters[55].Value = model.memo;
parameters[56].Value = model.platformCode;
parameters[57].Value = model.recordCode;
object obj = DbHelperSql.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(ClassLibrary1.Model.xf_Building model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update xf_Building set ");
strSql.Append("CreateTime=@CreateTime,");
strSql.Append("buildingName=@buildingName,");
strSql.Append("buildingType=@buildingType,");
strSql.Append("buildingUseNature=@buildingUseNature,");
strSql.Append("fireDanger=@fireDanger,");
strSql.Append("fireResistantLevel=@fireResistantLevel,");
strSql.Append("structureType=@structureType,");
strSql.Append("buildingHeight=@buildingHeight,");
strSql.Append("buildingAddr=@buildingAddr,");
strSql.Append("regionCode=@regionCode,");
strSql.Append("buildingState=@buildingState,");
strSql.Append("buildingTime=@buildingTime,");
strSql.Append("buildingFinishTime=@buildingFinishTime,");
strSql.Append("propertyRight=@propertyRight,");
strSql.Append("buildingArea=@buildingArea,");
strSql.Append("occupyArea=@occupyArea,");
strSql.Append("standardFloorArea=@standardFloorArea,");
strSql.Append("overFloorNum=@overFloorNum,");
strSql.Append("overFloorArea=@overFloorArea,");
strSql.Append("underFloorNum=@underFloorNum,");
strSql.Append("underFloorArea=@underFloorArea,");
strSql.Append("tunnelHeight=@tunnelHeight,");
strSql.Append("tunnelLength=@tunnelLength,");
strSql.Append("controlRoomCondition=@controlRoomCondition,");
strSql.Append("controlRoomPosition=@controlRoomPosition,");
strSql.Append("workerDailyNum=@workerDailyNum,");
strSql.Append("buildingGalleryful=@buildingGalleryful,");
strSql.Append("fireElevatorNum=@fireElevatorNum,");
strSql.Append("fireElevatorPosition=@fireElevatorPosition,");
strSql.Append("fireElevatorCarrery=@fireElevatorCarrery,");
strSql.Append("shelterFloorNum=@shelterFloorNum,");
strSql.Append("shelterFloorArea=@shelterFloorArea,");
strSql.Append("shelterFloorPosition=@shelterFloorPosition,");
strSql.Append("exitNum=@exitNum,");
strSql.Append("exitPosition=@exitPosition,");
strSql.Append("exitForm=@exitForm,");
strSql.Append("storageName=@storageName,");
strSql.Append("storageNum=@storageNum,");
strSql.Append("storageNature=@storageNature,");
strSql.Append("storageShape=@storageShape,");
strSql.Append("storageSize=@storageSize,");
strSql.Append("mainMaterial=@mainMaterial,");
strSql.Append("mainProduct=@mainProduct,");
strSql.Append("enterOrgNum=@enterOrgNum,");
strSql.Append("orgAbutSituation=@orgAbutSituation,");
strSql.Append("belongOrgId=@belongOrgId,");
strSql.Append("managerOrgId=@managerOrgId,");
strSql.Append("unitNum=@unitNum,");
strSql.Append("floorNum=@floorNum,");
strSql.Append("mapType=@mapType,");
strSql.Append("gpsX3d=@gpsX3d,");
strSql.Append("gpsY3d=@gpsY3d,");
strSql.Append("gpsZ3d=@gpsZ3d,");
strSql.Append("isMezzanine=@isMezzanine,");
strSql.Append("memo=@memo,");
strSql.Append("platformCode=@platformCode,");
strSql.Append("recordCode=@recordCode");
strSql.Append(" where ID=@ID");
SqlParameter[] parameters =
{
new SqlParameter("@CreateTime", SqlDbType.DateTime2, 8),
new SqlParameter("@buildingName", SqlDbType.VarChar, 255),
new SqlParameter("@buildingType", SqlDbType.VarChar, 255),
new SqlParameter("@buildingUseNature", SqlDbType.VarChar, 255),
new SqlParameter("@fireDanger", SqlDbType.VarChar, 255),
new SqlParameter("@fireResistantLevel", SqlDbType.VarChar, 255),
new SqlParameter("@structureType", SqlDbType.VarChar, 255),
new SqlParameter("@buildingHeight", SqlDbType.Float, 8),
new SqlParameter("@buildingAddr", SqlDbType.VarChar, 255),
new SqlParameter("@regionCode", SqlDbType.VarChar, 255),
new SqlParameter("@buildingState", SqlDbType.VarChar, 255),
new SqlParameter("@buildingTime", SqlDbType.VarChar, 255),
new SqlParameter("@buildingFinishTime", SqlDbType.VarChar, 255),
new SqlParameter("@propertyRight", SqlDbType.VarChar, 255),
new SqlParameter("@buildingArea", SqlDbType.Float, 8),
new SqlParameter("@occupyArea", SqlDbType.Float, 8),
new SqlParameter("@standardFloorArea", SqlDbType.Float, 8),
new SqlParameter("@overFloorNum", SqlDbType.Int, 4),
new SqlParameter("@overFloorArea", SqlDbType.Float, 8),
new SqlParameter("@underFloorNum", SqlDbType.Int, 4),
new SqlParameter("@underFloorArea", SqlDbType.Float, 8),
new SqlParameter("@tunnelHeight", SqlDbType.Float, 8),
new SqlParameter("@tunnelLength", SqlDbType.Float, 8),
new SqlParameter("@controlRoomCondition", SqlDbType.Int, 4),
new SqlParameter("@controlRoomPosition", SqlDbType.VarChar, 255),
new SqlParameter("@workerDailyNum", SqlDbType.Int, 4),
new SqlParameter("@buildingGalleryful", SqlDbType.Int, 4),
new SqlParameter("@fireElevatorNum", SqlDbType.Int, 4),
new SqlParameter("@fireElevatorPosition", SqlDbType.VarChar, 255),
new SqlParameter("@fireElevatorCarrery", SqlDbType.Float, 8),
new SqlParameter("@shelterFloorNum", SqlDbType.Float, 8),
new SqlParameter("@shelterFloorArea", SqlDbType.Float, 8),
new SqlParameter("@shelterFloorPosition", SqlDbType.VarChar, 255),
new SqlParameter("@exitNum", SqlDbType.Int, 4),
new SqlParameter("@exitPosition", SqlDbType.VarChar, 255),
new SqlParameter("@exitForm", SqlDbType.VarChar, 255),
new SqlParameter("@storageName", SqlDbType.VarChar, 255),
new SqlParameter("@storageNum", SqlDbType.Int, 4),
new SqlParameter("@storageNature", SqlDbType.VarChar, 255),
new SqlParameter("@storageShape", SqlDbType.VarChar, 255),
new SqlParameter("@storageSize", SqlDbType.Float, 8),
new SqlParameter("@mainMaterial", SqlDbType.VarChar, 255),
new SqlParameter("@mainProduct", SqlDbType.VarChar, 255),
new SqlParameter("@enterOrgNum", SqlDbType.Int, 4),
new SqlParameter("@orgAbutSituation", SqlDbType.VarChar, 255),
new SqlParameter("@belongOrgId", SqlDbType.VarChar, 255),
new SqlParameter("@managerOrgId", SqlDbType.VarChar, 255),
new SqlParameter("@unitNum", SqlDbType.Int, 4),
new SqlParameter("@floorNum", SqlDbType.Int, 4),
new SqlParameter("@mapType", SqlDbType.Int, 4),
new SqlParameter("@gpsX3d", SqlDbType.Float, 8),
new SqlParameter("@gpsY3d", SqlDbType.Float, 8),
new SqlParameter("@gpsZ3d", SqlDbType.Float, 8),
new SqlParameter("@isMezzanine", SqlDbType.Int, 4),
new SqlParameter("@memo", SqlDbType.VarChar, 255),
new SqlParameter("@platformCode", SqlDbType.VarChar, 255),
new SqlParameter("@recordCode", SqlDbType.VarChar, 255),
new SqlParameter("@ID", SqlDbType.Int, 4),
new SqlParameter("@BuildingUuid", SqlDbType.UniqueIdentifier, 16)
};
parameters[0].Value = model.CreateTime;
parameters[1].Value = model.buildingName;
parameters[2].Value = model.buildingType;
parameters[3].Value = model.buildingUseNature;
parameters[4].Value = model.fireDanger;
parameters[5].Value = model.fireResistantLevel;
parameters[6].Value = model.structureType;
parameters[7].Value = model.buildingHeight;
parameters[8].Value = model.buildingAddr;
parameters[9].Value = model.regionCode;
parameters[10].Value = model.buildingState;
parameters[11].Value = model.buildingTime;
parameters[12].Value = model.buildingFinishTime;
parameters[13].Value = model.propertyRight;
parameters[14].Value = model.buildingArea;
parameters[15].Value = model.occupyArea;
parameters[16].Value = model.standardFloorArea;
parameters[17].Value = model.overFloorNum;
parameters[18].Value = model.overFloorArea;
parameters[19].Value = model.underFloorNum;
parameters[20].Value = model.underFloorArea;
parameters[21].Value = model.tunnelHeight;
parameters[22].Value = model.tunnelLength;
parameters[23].Value = model.controlRoomCondition;
parameters[24].Value = model.controlRoomPosition;
parameters[25].Value = model.workerDailyNum;
parameters[26].Value = model.buildingGalleryful;
parameters[27].Value = model.fireElevatorNum;
parameters[28].Value = model.fireElevatorPosition;
parameters[29].Value = model.fireElevatorCarrery;
parameters[30].Value = model.shelterFloorNum;
parameters[31].Value = model.shelterFloorArea;
parameters[32].Value = model.shelterFloorPosition;
parameters[33].Value = model.exitNum;
parameters[34].Value = model.exitPosition;
parameters[35].Value = model.exitForm;
parameters[36].Value = model.storageName;
parameters[37].Value = model.storageNum;
parameters[38].Value = model.storageNature;
parameters[39].Value = model.storageShape;
parameters[40].Value = model.storageSize;
parameters[41].Value = model.mainMaterial;
parameters[42].Value = model.mainProduct;
parameters[43].Value = model.enterOrgNum;
parameters[44].Value = model.orgAbutSituation;
parameters[45].Value = model.belongOrgId;
parameters[46].Value = model.managerOrgId;
parameters[47].Value = model.unitNum;
parameters[48].Value = model.floorNum;
parameters[49].Value = model.mapType;
parameters[50].Value = model.gpsX3d;
parameters[51].Value = model.gpsY3d;
parameters[52].Value = model.gpsZ3d;
parameters[53].Value = model.isMezzanine;
parameters[54].Value = model.memo;
parameters[55].Value = model.platformCode;
parameters[56].Value = model.recordCode;
parameters[57].Value = model.ID;
parameters[58].Value = model.BuildingUuid;
int rows = DbHelperSql.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
