private void ShowInfo(int CmsTagId) { NoName.NetShop.BLL.TagsModelBll bll = new NoName.NetShop.BLL.TagsModelBll(); NoName.NetShop.Model.TagsModel model = bll.GetModel(CmsTagId); this.lblCmsTagName.Text = model.CmsTagName; this.lblTagBrief.Text = model.TagBrief; this.lblDefaultContent.Text = model.DefaultContent; this.lblTagType.Text = model.TagType; this.lblTagParas.Text = model.TagParas; }
/// <summary> /// 更新一条数据 /// </summary> public void Update(NoName.NetShop.Model.TagsModel model) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsTags_Update"); db.AddInParameter(dbCommand, "CmsTagId", DbType.Int32, model.CmsTagId); db.AddInParameter(dbCommand, "CmsTagName", DbType.AnsiString, model.CmsTagName); db.AddInParameter(dbCommand, "TagBrief", DbType.AnsiString, model.TagBrief); db.AddInParameter(dbCommand, "DefaultContent", DbType.AnsiString, model.DefaultContent); db.AddInParameter(dbCommand, "TagType", DbType.AnsiString, model.TagType); db.AddInParameter(dbCommand, "TagParas", DbType.AnsiString, model.TagParas); db.ExecuteNonQuery(dbCommand); }
protected void btnAdd_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtCmsTagName.Text == "") { strErr += "CmsTagName不能为空!\\n"; } if (this.txtTagBrief.Text == "") { strErr += "TagBrief不能为空!\\n"; } if (this.txtDefaultContent.Text == "") { strErr += "DefaultContent不能为空!\\n"; } if (this.txtTagType.Text == "") { strErr += "TagType不能为空!\\n"; } if (this.txtTagParas.Text == "") { strErr += "TagParas不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string CmsTagName = this.txtCmsTagName.Text; string TagBrief = this.txtTagBrief.Text; string DefaultContent = this.txtDefaultContent.Text; string TagType = this.txtTagType.Text; string TagParas = this.txtTagParas.Text; NoName.NetShop.Model.TagsModel model = new NoName.NetShop.Model.TagsModel(); model.CmsTagName = CmsTagName; model.TagBrief = TagBrief; model.DefaultContent = DefaultContent; model.TagType = TagType; model.TagParas = TagParas; NoName.NetShop.BLL.TagsModelBll bll = new NoName.NetShop.BLL.TagsModelBll(); bll.Update(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Model.TagsModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.TagsModel model = new NoName.NetShop.Model.TagsModel(); object ojb; ojb = dataReader["CmsTagId"]; if (ojb != null && ojb != DBNull.Value) { model.CmsTagId = (int)ojb; } model.CmsTagName = dataReader["CmsTagName"].ToString(); model.TagBrief = dataReader["TagBrief"].ToString(); model.DefaultContent = dataReader["DefaultContent"].ToString(); model.TagType = dataReader["TagType"].ToString(); model.TagParas = dataReader["TagParas"].ToString(); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Model.TagsModel GetModel(int CmsTagId) { Database db = DatabaseFactory.CreateDatabase(); DbCommand dbCommand = db.GetStoredProcCommand("UP_cmsTags_GetModel"); db.AddInParameter(dbCommand, "CmsTagId", DbType.Int32, CmsTagId); NoName.NetShop.Model.TagsModel 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(this.txtCmsTagName.Text =="") { strErr+="CmsTagName����Ϊ�գ�\\n"; } if(this.txtTagBrief.Text =="") { strErr+="TagBrief����Ϊ�գ�\\n"; } if(this.txtDefaultContent.Text =="") { strErr+="DefaultContent����Ϊ�գ�\\n"; } if(this.txtTagType.Text =="") { strErr+="TagType����Ϊ�գ�\\n"; } if(this.txtTagParas.Text =="") { strErr+="TagParas����Ϊ�գ�\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } string CmsTagName=this.txtCmsTagName.Text; string TagBrief=this.txtTagBrief.Text; string DefaultContent=this.txtDefaultContent.Text; string TagType=this.txtTagType.Text; string TagParas=this.txtTagParas.Text; NoName.NetShop.Model.TagsModel model=new NoName.NetShop.Model.TagsModel(); model.CmsTagName=CmsTagName; model.TagBrief=TagBrief; model.DefaultContent=DefaultContent; model.TagType=TagType; model.TagParas=TagParas; NoName.NetShop.BLL.TagsModelBll bll=new NoName.NetShop.BLL.TagsModelBll(); bll.Add(model); }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Model.TagsModel ReaderBind(IDataReader dataReader) { NoName.NetShop.Model.TagsModel model=new NoName.NetShop.Model.TagsModel(); object ojb; ojb = dataReader["CmsTagId"]; if(ojb != null && ojb != DBNull.Value) { model.CmsTagId=(int)ojb; } model.CmsTagName=dataReader["CmsTagName"].ToString(); model.TagBrief=dataReader["TagBrief"].ToString(); model.DefaultContent=dataReader["DefaultContent"].ToString(); model.TagType=dataReader["TagType"].ToString(); model.TagParas=dataReader["TagParas"].ToString(); return model; }