/// <summary>
/// 增加一条数据
/// </summary>
public void Add(ManagementCenter.Model.UM_AccountType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UM_AccountType(");
strSql.Append("AccountTypeID,AccountName,AccountAttributionType,ReMark,ConnectHoldID)");
strSql.Append(" values (");
strSql.Append("@AccountTypeID,@AccountName,@AccountAttributionType,@ReMark,@ConnectHoldID)");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AccountTypeID", DbType.Int32, model.AccountTypeID);
db.AddInParameter(dbCommand, "AccountName", DbType.String, model.AccountName);
db.AddInParameter(dbCommand, "AccountAttributionType", DbType.Int32, model.AccountAttributionType);
db.AddInParameter(dbCommand, "ReMark", DbType.String, model.ReMark);
db.AddInParameter(dbCommand, "ConnectHoldID", DbType.Int32, model.ConnectHoldID);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ManagementCenter.Model.UM_AccountType model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UM_AccountType set ");
strSql.Append("AccountName=@AccountName,");
strSql.Append("AccountAttributionType=@AccountAttributionType,");
strSql.Append("ReMark=@ReMark,");
strSql.Append("ConnectHoldID=@ConnectHoldID ");
strSql.Append(" where AccountTypeID=@AccountTypeID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AccountTypeID", DbType.Int32, model.AccountTypeID);
db.AddInParameter(dbCommand, "AccountName", DbType.String, model.AccountName);
db.AddInParameter(dbCommand, "AccountAttributionType", DbType.Int32, model.AccountAttributionType);
db.AddInParameter(dbCommand, "ReMark", DbType.String, model.ReMark);
db.AddInParameter(dbCommand, "ConnectHoldID", DbType.Int32, model.ConnectHoldID);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagementCenter.Model.UM_AccountType GetModel(int AccountTypeID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select AccountTypeID,AccountName,AccountAttributionType,ReMark,ConnectHoldID from UM_AccountType ");
strSql.Append(" where AccountTypeID=@AccountTypeID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "AccountTypeID", DbType.Int32, AccountTypeID);
ManagementCenter.Model.UM_AccountType model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ManagementCenter.Model.UM_AccountType ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.UM_AccountType model = new ManagementCenter.Model.UM_AccountType();
object ojb;
ojb = dataReader["AccountTypeID"];
if (ojb != null && ojb != DBNull.Value)
{
model.AccountTypeID = (int)ojb;
}
model.AccountName = dataReader["AccountName"].ToString();
ojb = dataReader["AccountAttributionType"];
if (ojb != null && ojb != DBNull.Value)
{
model.AccountAttributionType = (int)ojb;
}
model.ReMark = dataReader["ReMark"].ToString();
ojb = dataReader["ConnectHoldID"];
if (ojb != null && ojb != DBNull.Value)
{
model.ConnectHoldID = (int)ojb;
}
return(model);
}
