using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.OleDb;
using DTcms.DBUtility;
namespace example
{
public class AdminAccess
{
#region 是否存在该记录
/// <summary>
/// 是否存在该记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool Exists(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select count(1) from Admin");
strSql.Append(" where admin_id=@admin_id ");
OleDbParameter[] parameters = {
new OleDbParameter("@admin_id", OleDbType.Integer,4)};
parameters[0].Value = id;
return DbHelperOleDb.Exists(strSql.ToString(), parameters);
}
#endregion
#region 增加
/// <summary>
/// 增加一条数据
/// </summary>
/// <param name="client"></param>
/// <returns></returns>
public bool Insert(AdminInfo admin)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into Admin(");
strSql.Append("admin_name,admin_password,admin_type)");
strSql.Append(" values (");
strSql.Append("@admin_name,@admin_password,@adm