/// <summary>
/// 由一行数据得到一个实体
/// </summary>
/// <param name="dr">SqlDataReader对象</param>
/// <returns>实体对象</returns>
private Arc_Soft GetModel(SqlDataReader dr)
{
Arc_Soft model = new Arc_Soft();
model.AID = dbHelper.GetInt(dr["AID"]);
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Arc_Soft model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE " + tablePrefix + "Arc_Soft SET ");
strSql.Append("AID=@AID");
strSql.Append(" WHERE AID=@AID");
SqlParameter[] cmdParms =
{
AddInParameter("@AID", SqlDbType.Int, 4, model.AID),
AddInParameter("@AID", SqlDbType.Int, 4, model.AID)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="AID">编号ID</param>
/// <returns>返回影响行数</returns>
public int Add(Arc_Soft model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("INSERT INTO " + tablePrefix + "Arc_Soft(");
strSql.Append("AID)");
strSql.Append(" VALUES (");
strSql.Append("@AID)");
SqlParameter[] cmdParms =
{
AddInParameter("@AID", SqlDbType.Int, 4, model.AID)
};
return(dbHelper.ExecuteNonQuery(CommandType.Text, strSql.ToString(), cmdParms));
}
/// <summary>
/// 更新一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Update(Arc_Soft model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="model">实体对象</param>
/// <returns>返回影响行数</returns>
public int Add(Arc_Soft model)
{
return(dal.Add(model));
}
