/// <summary>
/// 获得数据列表（比DataSet效率高，推荐使用）
/// </summary>
public List <VAN_OA.Model.JXC.TB_HouseGoods> GetModelInfo(string strWhere)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select TB_HouseGoods.id,HouseId,TB_HouseGoods.GoodId,GoodAvgPrice,GoodNum");
strSql.Append(" FROM TB_HouseGoods ");
if (strWhere.Trim() != "")
{
strSql.Append(" where " + strWhere);
}
List <VAN_OA.Model.JXC.TB_HouseGoods> list = new List <VAN_OA.Model.JXC.TB_HouseGoods>();
using (SqlConnection conn = DBHelp.getConn())
{
conn.Open();
SqlCommand objCommand = new SqlCommand(strSql.ToString(), conn);
using (SqlDataReader dataReader = objCommand.ExecuteReader())
{
while (dataReader.Read())
{
VAN_OA.Model.JXC.TB_HouseGoods model = new VAN_OA.Model.JXC.TB_HouseGoods();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.id = (int)ojb;
}
ojb = dataReader["HouseId"];
if (ojb != null && ojb != DBNull.Value)
{
model.HouseId = (int)ojb;
}
ojb = dataReader["GoodId"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodId = (int)ojb;
}
ojb = dataReader["GoodAvgPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodAvgPrice = (decimal)ojb;
}
ojb = dataReader["GoodNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodNum = (decimal)ojb;
}
model.Total = model.GoodNum * model.GoodAvgPrice;
list.Add(model);
}
}
}
return(list);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public VAN_OA.Model.JXC.TB_HouseGoods ReaderBind(IDataReader dataReader)
{
VAN_OA.Model.JXC.TB_HouseGoods model = new VAN_OA.Model.JXC.TB_HouseGoods();
object ojb;
ojb = dataReader["id"];
if (ojb != null && ojb != DBNull.Value)
{
model.id = (int)ojb;
}
ojb = dataReader["HouseId"];
if (ojb != null && ojb != DBNull.Value)
{
model.HouseId = (int)ojb;
}
ojb = dataReader["GoodId"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodId = (int)ojb;
}
ojb = dataReader["GoodAvgPrice"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodAvgPrice = (decimal)ojb;
}
ojb = dataReader["GoodNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodNum = (decimal)ojb;
}
ojb = dataReader["GoodNo"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodNo = ojb.ToString();
}
ojb = dataReader["GoodName"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodName = ojb.ToString();
}
ojb = dataReader["GoodSpec"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodSpec = ojb.ToString();
}
ojb = dataReader["GoodModel"];
if (ojb != null && ojb != DBNull.Value)
{
model.Good_Model = ojb.ToString();
}
ojb = dataReader["GoodUnit"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodUnit = ojb.ToString();
}
ojb = dataReader["GoodTypeSmName"];
if (ojb != null && ojb != DBNull.Value)
{
model.GoodTypeSmName = ojb.ToString();
}
ojb = dataReader["houseName"];
if (ojb != null && ojb != DBNull.Value)
{
model.HouseName = ojb.ToString();
}
model.Total = model.GoodNum * model.GoodAvgPrice;
return(model);
}
