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