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;
}
