/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Comment.QuestionModel GetModel(int QuestionId)
{
Database db = CommDataAccess.DbReader;
DbCommand dbCommand = db.GetStoredProcCommand("UP_qaQuestion_GetModel");
db.AddInParameter(dbCommand, "QuestionId", DbType.Int32, QuestionId);
NoName.NetShop.Comment.QuestionModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Comment.QuestionModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Comment.QuestionModel model = new NoName.NetShop.Comment.QuestionModel();
object ojb;
ojb = dataReader["QuestionId"];
if (ojb != null && ojb != DBNull.Value)
{
model.QuestionId = (int)ojb;
}
model.UserId = dataReader["UserId"].ToString();
ojb = dataReader["ContentId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ContentId = (int)ojb;
}
model.Title = dataReader["Title"].ToString();
model.Content = dataReader["Content"].ToString();
ojb = dataReader["InsertTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.InsertTime = (DateTime)ojb;
}
ojb = dataReader["LastAnswerTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.LastAnswerTime = (DateTime)ojb;
}
ojb = dataReader["LastAnswerId"];
if (ojb != null && ojb != DBNull.Value)
{
model.LastAnswerId = (int)ojb;
}
ojb = dataReader["AnswerNum"];
if (ojb != null && ojb != DBNull.Value)
{
model.AnswerNum = (int)ojb;
}
ojb = dataReader["ContentType"];
if (ojb != null && ojb != DBNull.Value)
{
model.ContentType = (ContentType)(Convert.ToInt32(ojb));
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(NoName.NetShop.Comment.QuestionModel model)
{
Database db = CommDataAccess.DbReader;
if (model.QuestionId == 0)
{
model.QuestionId = CommDataHelper.GetNewSerialNum(AppType.Other);
}
DbCommand dbCommand = db.GetStoredProcCommand("UP_qaQuestion_ADD");
db.AddInParameter(dbCommand, "QuestionId", DbType.Int32, model.QuestionId);
db.AddInParameter(dbCommand, "UserId", DbType.AnsiString, model.UserId);
db.AddInParameter(dbCommand, "ContentId", DbType.Int32, model.ContentId);
db.AddInParameter(dbCommand, "Title", DbType.AnsiString, model.Title);
db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content);
db.AddInParameter(dbCommand, "@contentType", DbType.Int16, (int)model.ContentType);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(NoName.NetShop.Comment.QuestionModel model)
{
dal.Add(model);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Comment.QuestionModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Comment.QuestionModel model = new NoName.NetShop.Comment.QuestionModel();
object ojb;
ojb = dataReader["QuestionId"];
if(ojb != null && ojb != DBNull.Value)
{
model.QuestionId=(int)ojb;
}
model.UserId=dataReader["UserId"].ToString();
ojb = dataReader["ContentId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ContentId=(int)ojb;
}
model.Title=dataReader["Title"].ToString();
model.Content=dataReader["Content"].ToString();
ojb = dataReader["InsertTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.InsertTime=(DateTime)ojb;
}
ojb = dataReader["LastAnswerTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.LastAnswerTime=(DateTime)ojb;
}
ojb = dataReader["LastAnswerId"];
if (ojb != null && ojb != DBNull.Value)
{
model.LastAnswerId = (int)ojb;
}
ojb = dataReader["AnswerNum"];
if(ojb != null && ojb != DBNull.Value)
{
model.AnswerNum=(int)ojb;
}
ojb = dataReader["ContentType"];
if (ojb != null && ojb != DBNull.Value)
{
model.ContentType = (ContentType)(Convert.ToInt32(ojb));
}
return model;
}
