/// <summary> /// 增加一条数据 /// </summary> public void Add(ehome.Model.Unify.Tb_Unify_Building model) { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@BuildSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@CommSynchCode", SqlDbType.UniqueIdentifier, 16), new SqlParameter("@UnBuildID", SqlDbType.BigInt, 8), new SqlParameter("@BuildSNum", SqlDbType.Int, 4), new SqlParameter("@RegionSNum", SqlDbType.Int, 4), new SqlParameter("@BuildSign", SqlDbType.NVarChar, 10), new SqlParameter("@BuildName", SqlDbType.NVarChar, 20), new SqlParameter("@BuildType", SqlDbType.NVarChar, 20), new SqlParameter("@BuildUses", SqlDbType.NVarChar, 20), new SqlParameter("@PropertyRights", SqlDbType.NVarChar, 20), new SqlParameter("@PropertyUses", SqlDbType.NVarChar, 20), new SqlParameter("@BuildHeight", SqlDbType.NVarChar, 20), new SqlParameter("@FloorsNum", SqlDbType.Int, 4), new SqlParameter("@UnderFloorsNum", SqlDbType.Int, 4), new SqlParameter("@UnitNum", SqlDbType.Int, 4), new SqlParameter("@NamingPatterns", SqlDbType.NVarChar, 30), new SqlParameter("@PerFloorNum", SqlDbType.Int, 4), new SqlParameter("@HouseholdsNum", SqlDbType.Int, 4), new SqlParameter("@IsDelete", SqlDbType.SmallInt, 2), new SqlParameter("@SynchFlag", SqlDbType.SmallInt, 2), new SqlParameter("@OrdSNum", SqlDbType.BigInt, 8) }; parameters[0].Value = model.BuildSynchCode; parameters[1].Value = model.CommSynchCode; parameters[2].Value = model.UnBuildID; parameters[3].Value = model.BuildSNum; parameters[4].Value = model.RegionSNum; parameters[5].Value = model.BuildSign; parameters[6].Value = model.BuildName; parameters[7].Value = model.BuildType; parameters[8].Value = model.BuildUses; parameters[9].Value = model.PropertyRights; parameters[10].Value = model.PropertyUses; parameters[11].Value = model.BuildHeight; parameters[12].Value = model.FloorsNum; parameters[13].Value = model.UnderFloorsNum; parameters[14].Value = model.UnitNum; parameters[15].Value = model.NamingPatterns; parameters[16].Value = model.PerFloorNum; parameters[17].Value = model.HouseholdsNum; parameters[18].Value = model.IsDelete; parameters[19].Value = model.SynchFlag; parameters[20].Value = model.OrdSNum; DbHelperSQL.RunProcedure("Proc_Tb_Unify_Building_ADD", parameters, out rowsAffected); }
/// <summary> /// 得到一个对象实体 /// </summary> public ehome.Model.Unify.Tb_Unify_Building GetModel(Guid BuildSynchCode) { SqlParameter[] parameters = { new SqlParameter("@BuildSynchCode", SqlDbType.UniqueIdentifier) }; parameters[0].Value = BuildSynchCode; ehome.Model.Unify.Tb_Unify_Building model = new ehome.Model.Unify.Tb_Unify_Building(); DataSet ds = DbHelperSQL.RunProcedure("Proc_Tb_Unify_Building_GetModel", parameters, "ds"); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["BuildSynchCode"].ToString() != "") { model.BuildSynchCode = new Guid(ds.Tables[0].Rows[0]["BuildSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["CommSynchCode"].ToString() != "") { model.CommSynchCode = new Guid(ds.Tables[0].Rows[0]["CommSynchCode"].ToString()); } if (ds.Tables[0].Rows[0]["UnBuildID"].ToString() != "") { model.UnBuildID = long.Parse(ds.Tables[0].Rows[0]["UnBuildID"].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]["RegionSNum"].ToString() != "") { model.RegionSNum = int.Parse(ds.Tables[0].Rows[0]["RegionSNum"].ToString()); } model.BuildSign = ds.Tables[0].Rows[0]["BuildSign"].ToString(); model.BuildName = ds.Tables[0].Rows[0]["BuildName"].ToString(); model.BuildType = ds.Tables[0].Rows[0]["BuildType"].ToString(); model.BuildUses = ds.Tables[0].Rows[0]["BuildUses"].ToString(); model.PropertyRights = ds.Tables[0].Rows[0]["PropertyRights"].ToString(); model.PropertyUses = ds.Tables[0].Rows[0]["PropertyUses"].ToString(); model.BuildHeight = ds.Tables[0].Rows[0]["BuildHeight"].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]["UnderFloorsNum"].ToString() != "") { model.UnderFloorsNum = int.Parse(ds.Tables[0].Rows[0]["UnderFloorsNum"].ToString()); } if (ds.Tables[0].Rows[0]["UnitNum"].ToString() != "") { model.UnitNum = int.Parse(ds.Tables[0].Rows[0]["UnitNum"].ToString()); } model.NamingPatterns = ds.Tables[0].Rows[0]["NamingPatterns"].ToString(); if (ds.Tables[0].Rows[0]["PerFloorNum"].ToString() != "") { model.PerFloorNum = int.Parse(ds.Tables[0].Rows[0]["PerFloorNum"].ToString()); } if (ds.Tables[0].Rows[0]["HouseholdsNum"].ToString() != "") { model.HouseholdsNum = int.Parse(ds.Tables[0].Rows[0]["HouseholdsNum"].ToString()); } if (ds.Tables[0].Rows[0]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(ds.Tables[0].Rows[0]["IsDelete"].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]["OrdSNum"].ToString() != "") { model.OrdSNum = long.Parse(ds.Tables[0].Rows[0]["OrdSNum"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(ehome.Model.Unify.Tb_Unify_Building model) { dal.Add(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(ehome.Model.Unify.Tb_Unify_Building model) { dal.Update(model); }
/// <summary> /// 获得数据列表 /// </summary> public List <ehome.Model.Unify.Tb_Unify_Building> DataTableToList(DataTable dt) { List <ehome.Model.Unify.Tb_Unify_Building> modelList = new List <ehome.Model.Unify.Tb_Unify_Building>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ehome.Model.Unify.Tb_Unify_Building model; for (int n = 0; n < rowsCount; n++) { model = new ehome.Model.Unify.Tb_Unify_Building(); if (dt.Rows[n]["BuildSynchCode"].ToString() != "") { model.BuildSynchCode = new Guid(dt.Rows[n]["BuildSynchCode"].ToString()); } if (dt.Rows[n]["CommSynchCode"].ToString() != "") { model.CommSynchCode = new Guid(dt.Rows[n]["CommSynchCode"].ToString()); } //model.UnBuildID=dt.Rows[n]["UnBuildID"].ToString(); if (dt.Rows[n]["BuildSNum"].ToString() != "") { model.BuildSNum = int.Parse(dt.Rows[n]["BuildSNum"].ToString()); } if (dt.Rows[n]["RegionSNum"].ToString() != "") { model.RegionSNum = int.Parse(dt.Rows[n]["RegionSNum"].ToString()); } model.BuildSign = dt.Rows[n]["BuildSign"].ToString(); model.BuildName = dt.Rows[n]["BuildName"].ToString(); model.BuildType = dt.Rows[n]["BuildType"].ToString(); model.BuildUses = dt.Rows[n]["BuildUses"].ToString(); model.PropertyRights = dt.Rows[n]["PropertyRights"].ToString(); model.PropertyUses = dt.Rows[n]["PropertyUses"].ToString(); model.BuildHeight = dt.Rows[n]["BuildHeight"].ToString(); if (dt.Rows[n]["FloorsNum"].ToString() != "") { model.FloorsNum = int.Parse(dt.Rows[n]["FloorsNum"].ToString()); } if (dt.Rows[n]["UnderFloorsNum"].ToString() != "") { model.UnderFloorsNum = int.Parse(dt.Rows[n]["UnderFloorsNum"].ToString()); } if (dt.Rows[n]["UnitNum"].ToString() != "") { model.UnitNum = int.Parse(dt.Rows[n]["UnitNum"].ToString()); } model.NamingPatterns = dt.Rows[n]["NamingPatterns"].ToString(); if (dt.Rows[n]["PerFloorNum"].ToString() != "") { model.PerFloorNum = int.Parse(dt.Rows[n]["PerFloorNum"].ToString()); } if (dt.Rows[n]["HouseholdsNum"].ToString() != "") { model.HouseholdsNum = int.Parse(dt.Rows[n]["HouseholdsNum"].ToString()); } if (dt.Rows[n]["IsDelete"].ToString() != "") { model.IsDelete = int.Parse(dt.Rows[n]["IsDelete"].ToString()); } if (dt.Rows[n]["SynchFlag"].ToString() != "") { model.SynchFlag = int.Parse(dt.Rows[n]["SynchFlag"].ToString()); } //model.OrdSNum=dt.Rows[n]["OrdSNum"].ToString(); modelList.Add(model); } } return(modelList); }