是不是用的强类型dataset
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) http://feiyun0112.cnblogs.com/
*****************************************************************************
欢迎使用CSDN论坛专用阅读器 : CSDN Reader(附全部源代码) http://feiyun0112.cnblogs.com/
/// 得到一个对象实体
/// </summary>
public News GetModel(int ID)
{
string sql = "select * from News where nid = " + ID;
DataTable dt = DBHelper.SelectBySql(sql);
News model = new News();
if (dt.Rows.Count == 1)
{
model.Nid = (int)dt.Rows[0]["nid"];
model.Ntitle = (string)dt.Rows[0]["ntitle"];
model.Ncontent = (string)dt.Rows[0]["ncontent"];
model.Ndate = (DateTime)dt.Rows[0]["ndate"];
model.State = (int)dt.Rows[0]["state"];
model.Ntop = (int)dt.Rows[0]["ntop"];
// model.Re = (string)dt.Rows[0]["re"];
}
return model;
} /// <summary>
/// 查询
/// </summary>
/// <param name="Number">数量</param>
/// <param name="strWhere">条件</param>
/// <param name="order">排序</param>
/// <returns></returns>
public List<News> GetList(int Number, string strWhere, string order)
{
StringBuilder strSql = new StringBuilder();
if (Number > 0)
{
strSql.Append("select top " + Number + " * from News ");
}
else
{
strSql.Append("select * from News ");
}
if (strWhere.Trim() != "")
{
strSql.Append(" where " + DBHelper.PassSqlString(strWhere));
}
if (order.Trim() != "")
{
strSql.Append(" order by " + DBHelper.PassSqlString(order));
}
DataTable dt = DBHelper.SelectBySql(strSql.ToString());
List<News> list = new List<News>();
foreach (DataRow dr in dt.Rows)
{
News model = new News();
model.Nid = (int)dr["nid"];
model.Ntitle = dr["ntitle"] == System.DBNull.Value ? "" : (string)dr["ntitle"];
model.Ncontent = dr["ncontent"] == System.DBNull.Value ? "" : (string)dr["ncontent"];
model.Ntop = (int)dr["ntop"];
model.Ndate = (DateTime)dr["ndate"];
model.State = (int)dr["state"];
// model.Re = (string)dr["re"];
list.Add(model);
}
return list;
}
数据访问层 改这里