/// <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);
}
