/// <summary>
/// 增加一条数据
/// </summary>
public void Save(NoName.NetShop.Comment.AnswerModel model)
{
if (model.AnswerId == 0)
{
model.AnswerId = NoName.NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Other);
}
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_qaAnswer_Save");
db.AddInParameter(dbCommand, "QuestionId", DbType.Int32, model.QuestionId);
db.AddInParameter(dbCommand, "AnswerId", DbType.Int32, model.AnswerId);
db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
db.AddInParameter(dbCommand, "Content", DbType.String, model.Content);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Comment.AnswerModel GetModel(int AnswerId)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_qaAnswer_GetModel");
db.AddInParameter(dbCommand, "AnswerId", DbType.Int32, AnswerId);
NoName.NetShop.Comment.AnswerModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Comment.AnswerModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Comment.AnswerModel model = new NoName.NetShop.Comment.AnswerModel();
object ojb;
ojb = dataReader["QuestionId"];
if (ojb != null && ojb != DBNull.Value)
{
model.QuestionId = (int)ojb;
}
ojb = dataReader["AnswerId"];
if (ojb != null && ojb != DBNull.Value)
{
model.AnswerId = (int)ojb;
}
model.Title = dataReader["Title"].ToString();
model.Content = dataReader["Content"].ToString();
ojb = dataReader["AnswerTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.AnswerTime = (DateTime)ojb;
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Save(NoName.NetShop.Comment.AnswerModel model)
{
dal.Save(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Comment.AnswerModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Comment.AnswerModel model = new NoName.NetShop.Comment.AnswerModel();
object ojb;
ojb = dataReader["QuestionId"];
if(ojb != null && ojb != DBNull.Value)
{
model.QuestionId=(int)ojb;
}
ojb = dataReader["AnswerId"];
if(ojb != null && ojb != DBNull.Value)
{
model.AnswerId=(int)ojb;
}
model.Title=dataReader["Title"].ToString();
model.Content=dataReader["Content"].ToString();
ojb = dataReader["AnswerTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.AnswerTime=(DateTime)ojb;
}
return model;
}
