/// <summary>
/// 对象实体绑定数据
/// </summary>
public BD_UserRoleTypeInfo ReaderBind(IDataReader dataReader)
{
BD_UserRoleTypeInfo model = new BD_UserRoleTypeInfo();
object ojb;
ojb = dataReader["RoleNumber"];
if (ojb != null && ojb != DBNull.Value)
{
model.RoleNumber = (int) ojb;
}
model.RoleName = dataReader["RoleName"].ToString();
model.Remarks = dataReader["Remarks"].ToString();
return model;
}
/*
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(BD_UserRoleTypeInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("insert into BD_UserRoleType(");
strSql.Append("RoleNumber,RoleName,Remarks)");
strSql.Append(" values (");
strSql.Append("@RoleNumber,@RoleName,@Remarks)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RoleNumber", DbType.Int32, model.RoleNumber);
db.AddInParameter(dbCommand, "RoleName", DbType.AnsiString, model.RoleName);
db.AddInParameter(dbCommand, "Remarks", DbType.AnsiString, model.Remarks);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(BD_UserRoleTypeInfo model)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("update BD_UserRoleType set ");
strSql.Append("RoleName=@RoleName,");
strSql.Append("Remarks=@Remarks");
strSql.Append(" where RoleNumber=@RoleNumber ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RoleNumber", DbType.Int32, model.RoleNumber);
db.AddInParameter(dbCommand, "RoleName", DbType.AnsiString, model.RoleName);
db.AddInParameter(dbCommand, "Remarks", DbType.AnsiString, model.Remarks);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 删除一条数据
/// </summary>
public void Delete(int RoleNumber)
{
StringBuilder strSql=new StringBuilder();
strSql.Append("delete from BD_UserRoleType ");
strSql.Append(" where RoleNumber=@RoleNumber ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RoleNumber", DbType.Int32,RoleNumber);
db.ExecuteNonQuery(dbCommand);
}*/
/// <summary>
/// 得到一个对象实体
/// </summary>
public BD_UserRoleTypeInfo GetModel(int RoleNumber)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select RoleNumber,RoleName,Remarks from BD_UserRoleType ");
strSql.Append(" where RoleNumber=@RoleNumber ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "RoleNumber", DbType.Int32, RoleNumber);
BD_UserRoleTypeInfo model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return model;
}
