private void ShowInfo(int CmsTagId) { NoName.NetShop.BLL.ContentModelBll bll = new NoName.NetShop.BLL.ContentModelBll(); NoName.NetShop.Model.ContentModel model = bll.GetModel(CmsTagId); this.lblContent.Text = model.Content; this.lblLastModifyTime.Text = model.LastModifyTime.ToString(); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtContent.Text == "") { strErr += "Content不能为空!\\n"; } if (!PageValidate.IsDateTime(txtLastModifyTime.Text)) { strErr += "LastModifyTime不是时间格式!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string Content = this.txtContent.Text; DateTime LastModifyTime = DateTime.Parse(this.txtLastModifyTime.Text); NoName.NetShop.Model.ContentModel model = new NoName.NetShop.Model.ContentModel(); model.Content = Content; model.LastModifyTime = LastModifyTime; NoName.NetShop.BLL.ContentModelBll bll = new NoName.NetShop.BLL.ContentModelBll(); bll.Update(model); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr=""; if(this.txtContent.Text =="") { strErr+="Content����Ϊ�գ�\\n"; } if(!PageValidate.IsDateTime(txtLastModifyTime.Text)) { strErr+="LastModifyTime����ʱ���ʽ��\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string Content=this.txtContent.Text; DateTime LastModifyTime=DateTime.Parse(this.txtLastModifyTime.Text); NoName.NetShop.Model.ContentModel model=new NoName.NetShop.Model.ContentModel(); model.Content=Content; model.LastModifyTime=LastModifyTime; NoName.NetShop.BLL.ContentModelBll bll=new NoName.NetShop.BLL.ContentModelBll(); bll.Update(model); }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.ContentModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsContent_Update"); db.AddInParameter(dbCommand, "CmsTagId", DbType.Int32, model.CmsTagId); db.AddInParameter(dbCommand, "Content", DbType.String, model.Content); db.AddInParameter(dbCommand, "LastModifyTime", DbType.DateTime, model.LastModifyTime); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.ContentModel GetModel(int CmsTagId) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsContent_GetModel"); db.AddInParameter(dbCommand, "CmsTagId", DbType.Int32, CmsTagId); NoName.NetShop.Model.ContentModel model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.ContentModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.ContentModel model = new NoName.NetShop.Model.ContentModel(); object ojb; ojb = dataReader["CmsTagId"]; if (ojb != null && ojb != DBNull.Value) { model.CmsTagId = (int)ojb; } model.Content = dataReader["Content"].ToString(); ojb = dataReader["LastModifyTime"]; if (ojb != null && ojb != DBNull.Value) { model.LastModifyTime = (DateTime)ojb; } return(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.ContentModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.ContentModel model=new NoName.NetShop.Model.ContentModel(); object ojb; ojb = dataReader["CmsTagId"]; if(ojb != null && ojb != DBNull.Value) { model.CmsTagId=(int)ojb; } model.Content=dataReader["Content"].ToString(); ojb = dataReader["LastModifyTime"]; if(ojb != null && ojb != DBNull.Value) { model.LastModifyTime=(DateTime)ojb; } return model; }