/// <summary>
/// 增加一条数据
/// </summary>
public int Add(ManagementCenter.Model.UM_FreezeReason model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into UM_FreezeReason(");
strSql.Append("FreezeReason,FreezeReasonTime,ThawReasonTime,DealerAccoutID,IsAuto)");
strSql.Append(" values (");
strSql.Append("@FreezeReason,@FreezeReasonTime,@ThawReasonTime,@DealerAccoutID,@IsAuto)");
strSql.Append(";select @@IDENTITY");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "FreezeReason", DbType.String, model.FreezeReason);
db.AddInParameter(dbCommand, "FreezeReasonTime", DbType.DateTime, model.FreezeReasonTime);
db.AddInParameter(dbCommand, "ThawReasonTime", DbType.DateTime, model.ThawReasonTime);
db.AddInParameter(dbCommand, "DealerAccoutID", DbType.String, model.DealerAccoutID);
db.AddInParameter(dbCommand, "IsAuto", DbType.Byte, model.IsAuto);
int result;
object obj = db.ExecuteScalar(dbCommand);
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public ManagementCenter.Model.UM_FreezeReason ReaderBind(IDataReader dataReader)
{
ManagementCenter.Model.UM_FreezeReason model = new ManagementCenter.Model.UM_FreezeReason();
object ojb;
ojb = dataReader["FreezeReasonID"];
if (ojb != null && ojb != DBNull.Value)
{
model.FreezeReasonID = (int)ojb;
}
model.FreezeReason = dataReader["FreezeReason"].ToString();
ojb = dataReader["FreezeReasonTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.FreezeReasonTime = (DateTime)ojb;
}
ojb = dataReader["ThawReasonTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.ThawReasonTime = (DateTime)ojb;
}
model.DealerAccoutID = dataReader["DealerAccoutID"].ToString();
ojb = dataReader["IsAuto"];
if (ojb != null && ojb != DBNull.Value)
{
model.IsAuto = (int)ojb;
}
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public ManagementCenter.Model.UM_FreezeReason GetModel(int FreezeReasonID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select FreezeReasonID,FreezeReason,FreezeReasonTime,ThawReasonTime,DealerAccoutID,IsAuto from UM_FreezeReason ");
strSql.Append(" where FreezeReasonID=@FreezeReasonID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "FreezeReasonID", DbType.Int32, FreezeReasonID);
ManagementCenter.Model.UM_FreezeReason model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(ManagementCenter.Model.UM_FreezeReason model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update UM_FreezeReason set ");
strSql.Append("FreezeReason=@FreezeReason,");
strSql.Append("FreezeReasonTime=@FreezeReasonTime,");
strSql.Append("ThawReasonTime=@ThawReasonTime,");
strSql.Append("DealerAccoutID=@DealerAccoutID,");
strSql.Append("IsAuto=@IsAuto");
strSql.Append(" where FreezeReasonID=@FreezeReasonID ");
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetSqlStringCommand(strSql.ToString());
db.AddInParameter(dbCommand, "FreezeReasonID", DbType.Int32, model.FreezeReasonID);
db.AddInParameter(dbCommand, "FreezeReason", DbType.String, model.FreezeReason);
db.AddInParameter(dbCommand, "FreezeReasonTime", DbType.DateTime, model.FreezeReasonTime);
db.AddInParameter(dbCommand, "ThawReasonTime", DbType.DateTime, model.ThawReasonTime);
db.AddInParameter(dbCommand, "DealerAccoutID", DbType.String, model.DealerAccoutID);
db.AddInParameter(dbCommand, "IsAuto", DbType.Byte, model.IsAuto);
db.ExecuteNonQuery(dbCommand);
}
