/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Model.AnswerModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.AnswerModel model = new NoName.NetShop.Model.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.Brief = dataReader["Brief"].ToString();
model.Content = dataReader["Content"].ToString();
ojb = dataReader["AnswerTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.AnswerTime = (DateTime)ojb;
}
return(model);
}
private void ShowInfo(int AnswerId)
{
NoName.NetShop.BLL.AnswerModelBll bll = new NoName.NetShop.BLL.AnswerModelBll();
NoName.NetShop.Model.AnswerModel model = bll.GetModel(AnswerId);
this.lblQuestionId.Text = model.QuestionId.ToString();
this.lblTitle.Text = model.Title;
this.lblBrief.Text = model.Brief;
this.lblContent.Text = model.Content;
this.lblAnswerTime.Text = model.AnswerTime.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.Model.AnswerModel model)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_qaAnswer_Update");
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, "Brief", DbType.AnsiString, model.Brief);
db.AddInParameter(dbCommand, "Content", DbType.String, model.Content);
db.AddInParameter(dbCommand, "AnswerTime", DbType.DateTime, model.AnswerTime);
db.ExecuteNonQuery(dbCommand);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtQuestionId.Text))
{
strErr += "QuestionId不是数字！\\n";
}
if (this.txtTitle.Text == "")
{
strErr += "Title不能为空！\\n";
}
if (this.txtBrief.Text == "")
{
strErr += "Brief不能为空！\\n";
}
if (this.txtContent.Text == "")
{
strErr += "Content不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtAnswerTime.Text))
{
strErr += "AnswerTime不是时间格式！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int QuestionId = int.Parse(this.txtQuestionId.Text);
string Title = this.txtTitle.Text;
string Brief = this.txtBrief.Text;
string Content = this.txtContent.Text;
DateTime AnswerTime = DateTime.Parse(this.txtAnswerTime.Text);
NoName.NetShop.Model.AnswerModel model = new NoName.NetShop.Model.AnswerModel();
model.QuestionId = QuestionId;
model.Title = Title;
model.Brief = Brief;
model.Content = Content;
model.AnswerTime = AnswerTime;
NoName.NetShop.BLL.AnswerModelBll bll = new NoName.NetShop.BLL.AnswerModelBll();
bll.Update(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Model.AnswerModel GetModel(int AnswerId)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_qaAnswer_GetModel");
db.AddInParameter(dbCommand, "AnswerId", DbType.Int32, AnswerId);
NoName.NetShop.Model.AnswerModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txtQuestionId.Text))
{
strErr+="QuestionId�������֣�\\n";
}
if(this.txtTitle.Text =="")
{
strErr+="Title����Ϊ�գ�\\n";
}
if(this.txtBrief.Text =="")
{
strErr+="Brief����Ϊ�գ�\\n";
}
if(this.txtContent.Text =="")
{
strErr+="Content����Ϊ�գ�\\n";
}
if(!PageValidate.IsDateTime(txtAnswerTime.Text))
{
strErr+="AnswerTime����ʱ���ʽ��\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int QuestionId=int.Parse(this.txtQuestionId.Text);
string Title=this.txtTitle.Text;
string Brief=this.txtBrief.Text;
string Content=this.txtContent.Text;
DateTime AnswerTime=DateTime.Parse(this.txtAnswerTime.Text);
NoName.NetShop.Model.AnswerModel model=new NoName.NetShop.Model.AnswerModel();
model.QuestionId=QuestionId;
model.Title=Title;
model.Brief=Brief;
model.Content=Content;
model.AnswerTime=AnswerTime;
NoName.NetShop.BLL.AnswerModelBll bll=new NoName.NetShop.BLL.AnswerModelBll();
bll.Add(model);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public NoName.NetShop.Model.AnswerModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.AnswerModel model=new NoName.NetShop.Model.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.Brief=dataReader["Brief"].ToString();
model.Content=dataReader["Content"].ToString();
ojb = dataReader["AnswerTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.AnswerTime=(DateTime)ojb;
}
return model;
}
