/// <summary>
/// 往实体集合中添加记录
/// </summary>
/// <param name="list">实体列表</param>
/// <param name="dt">表</param>
private void LoadListData(ref IList<Model.Number_Card > list, DataTable dt)
{
if (dt.Rows.Count > 0)
{
Model.Number_Card model;
foreach (DataRow dr in dt.Rows)
{
model = new Model.Number_Card ();
LoadEntityData(ref model, dr);
list.Add(model);
}
}
}
/// <summary>
/// 获得单个实体对象
/// </summary>
/// <param name="id">关键字</param>
/// <returns>实体对象</returns>
public Model.Number_Card SelectModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select [Id],[JK_Number_Card],[JK_Number_Card_Id],[JK_NumberCard_DateTime],[JK_Number_Count],[JK_Member_id] from [Number_Card] ");
strSql.Append(@" where [Id]=@id ");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
Model.Number_Card model = new Model.Number_Card();
DataTable dt = DAL.SqlDataHelper.GetDataTable(strSql.ToString(), parameters);
if (dt.Rows.Count > 0)
{
LoadEntityData(ref model, dt.Rows[0]);
return model;
}
else
{
return null;
}
}
/// <summary>
/// 获得单个实体对象
/// </summary>
/// <param name="whereStr">关键字</param>
/// <returns>实体对象</returns>
public Model.Number_Card SelectModel(string whereStr)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select [Id],[JK_Number_Card],[JK_Number_Card_Id],[JK_NumberCard_DateTime],[JK_Number_Count],[JK_Member_id] from [Number_Card] ");
if (whereStr.Trim() != "")
{
strSql.Append(@" where " + whereStr);
}
Model.Number_Card model = new Model.Number_Card();
DataTable dt = DAL.SqlDataHelper.GetDataTable(strSql.ToString());
if (dt.Rows.Count > 0)
{
LoadEntityData(ref model, dt.Rows[0]);
return model;
}
else
{
return null;
}
}
/// <summary>
/// 根据条件查询实体记录
/// </summary>
/// <param name="whereStr">查询条件</param>
/// <returns>实体记录</returns>
public IList<Model.Number_Card> SelectList(int top,string whereStr)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(@"select ");
if(top>0)
{
strSql.Append(" top "+top);
}
strSql.Append(" [Id],[JK_Number_Card],[JK_Number_Card_Id],[JK_NumberCard_DateTime],[JK_Number_Count],[JK_Member_id] from [Number_Card] ");
if (whereStr.Trim() != "")
{
strSql.Append(@" where " + whereStr);
}
DataTable dt = DAL.SqlDataHelper.GetDataTable(strSql.ToString());
List<Model.Number_Card > list = null;
if (dt.Rows.Count > 0)
{
list = new List<Model.Number_Card >();
Model.Number_Card model = null;
foreach (DataRow dr in dt.Rows)
{
model = new Model.Number_Card ();
LoadEntityData(ref model, dr);
list.Add(model);
}
}
return list;
}
