/// <summary> /// 增加一条数据 /// </summary> public int Add(Maticsoft.Model.NewsTypeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into NewsTypeInfo("); strSql.Append("NewsTypeTitle)"); strSql.Append(" values ("); strSql.Append("@NewsTypeTitle)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@NewsTypeTitle", SqlDbType.VarChar, 200) }; parameters[0].Value = model.NewsTypeTitle; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
protected void datanewsquan_ItemDataBound(object sender, DataListItemEventArgs e) { Maticsoft.BLL.NewsInfo newbll = new Maticsoft.BLL.NewsInfo(); int index = int.Parse(datanewsquan.DataKeys[e.Item.ItemIndex].ToString()); //DataSet bllds = newbll.GetList("NewsTypeID="+index+""); int pageSize = 5; //每页大小 int page = 1; //当前第几页 int recordCount; //总共有多少条数据 if (Request.QueryString["page"] != null) { if (Request.QueryString["page"].ToString() != "") { page = int.Parse(Request.QueryString["page"].ToString()); } } recordCount = newbll.GetNewCount("NewsTypeID=" + index + ""); int pageCount = recordCount / pageSize + 1;//共有多少页 if (recordCount % pageSize == 0) { pageCount--; } DataSet bllds = newbll.GeNewsList(pageSize * (page - 1), pageSize, "NewsTypeID=" + index + ""); DataList dlNews = e.Item.FindControl("datanewsfen") as DataList; dlNews.DataSource = bllds; dlNews.DataBind(); Maticsoft.BLL.NewsTypeInfo typebll = new Maticsoft.BLL.NewsTypeInfo(); Maticsoft.Model.NewsTypeInfo typemodel = typebll.GetModel(int.Parse(this.datanewsquan.DataKeys[e.Item.ItemIndex].ToString())); Label lbltype = e.Item.FindControl("lbltype") as Label; lbltype.Text = typemodel.NewsTypeTitle; Label lblpage = e.Item.FindControl("lblpage") as Label; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Maticsoft.Model.NewsTypeInfo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update NewsTypeInfo set "); strSql.Append("NewsTypeTitle=@NewsTypeTitle"); strSql.Append(" where NewsTypeID=@NewsTypeID"); SqlParameter[] parameters = { new SqlParameter("@NewsTypeID", SqlDbType.Int, 4), new SqlParameter("@NewsTypeTitle", SqlDbType.VarChar, 200) }; parameters[0].Value = model.NewsTypeID; parameters[1].Value = model.NewsTypeTitle; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
public void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtNewsTypeTitle.Text.Trim().Length == 0) { strErr += "NewsTypeTitle不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } int NewsTypeID = int.Parse(this.lblNewsTypeID.Text); string NewsTypeTitle = this.txtNewsTypeTitle.Text; Maticsoft.Model.NewsTypeInfo model = new Maticsoft.Model.NewsTypeInfo(); model.NewsTypeID = NewsTypeID; model.NewsTypeTitle = NewsTypeTitle; Maticsoft.BLL.NewsTypeInfo bll = new Maticsoft.BLL.NewsTypeInfo(); bll.Update(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "list.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public Maticsoft.Model.NewsTypeInfo GetModel(int NewsTypeID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select top 1 NewsTypeID,NewsTypeTitle from NewsTypeInfo "); strSql.Append(" where NewsTypeID=@NewsTypeID"); SqlParameter[] parameters = { new SqlParameter("@NewsTypeID", SqlDbType.Int, 4) }; parameters[0].Value = NewsTypeID; Maticsoft.Model.NewsTypeInfo model = new Maticsoft.Model.NewsTypeInfo(); DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["NewsTypeID"].ToString() != "") { model.NewsTypeID = int.Parse(ds.Tables[0].Rows[0]["NewsTypeID"].ToString()); } model.NewsTypeTitle = ds.Tables[0].Rows[0]["NewsTypeTitle"].ToString(); return(model); } else { return(null); } }
private void ShowInfo(int NewsTypeID) { Maticsoft.BLL.NewsTypeInfo bll = new Maticsoft.BLL.NewsTypeInfo(); Maticsoft.Model.NewsTypeInfo model = bll.GetModel(NewsTypeID); this.lblNewsTypeID.Text = model.NewsTypeID.ToString(); this.txtNewsTypeTitle.Text = model.NewsTypeTitle; }
protected void datamess_ItemDataBound(object sender, DataListItemEventArgs e) { int index = int.Parse(datamess.DataKeys[e.Item.ItemIndex].ToString()); Maticsoft.BLL.NewsInfo newbll = new Maticsoft.BLL.NewsInfo(); Maticsoft.Model.NewsInfo newmodel = newbll.GetModel(index); int typeid = int.Parse(newmodel.NewsTypeID.ToString()); Maticsoft.BLL.NewsTypeInfo typebll = new Maticsoft.BLL.NewsTypeInfo(); Maticsoft.Model.NewsTypeInfo typemodel = typebll.GetModel(typeid); ((Label)e.Item.FindControl("lbltype")).Text = typemodel.NewsTypeTitle; }
protected void btntype_Click(object sender, EventArgs e) { if (txtaddtype.Text.Trim() == "") { lbladdtype.Text = "请填写新闻类型"; return; } Maticsoft.BLL.NewsTypeInfo typebll = new Maticsoft.BLL.NewsTypeInfo(); Maticsoft.Model.NewsTypeInfo typemodel = new Maticsoft.Model.NewsTypeInfo(); typemodel.NewsTypeTitle = txtaddtype.Text.Trim(); typebll.Add(typemodel); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<SCRIPT>alert('信息提交成功)</SCRIPT>"); }
protected void btnNews_Click(object sender, EventArgs e) { Maticsoft.BLL.NewsTypeInfo newsbll = new Maticsoft.BLL.NewsTypeInfo(); Maticsoft.Model.NewsTypeInfo newmodel = new Maticsoft.Model.NewsTypeInfo(); if (txtNewsInfo.Text.Trim() == "") { Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('请将填写完整!')</script>"); return; } newmodel.NewsTypeTitle = txtNewsInfo.Text.Trim(); newsbll.Add(newmodel); Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('信息添加成功!')</script>"); txtNewsInfo.Text = ""; }
private void bind(int newsid) { Maticsoft.BLL.NewsInfo newbll = new Maticsoft.BLL.NewsInfo(); Maticsoft.Model.NewsInfo newmodel = newbll.GetModel(newsid); int typeid = int.Parse(newmodel.NewsTypeID.ToString()); Maticsoft.BLL.NewsTypeInfo typebll = new Maticsoft.BLL.NewsTypeInfo(); Maticsoft.Model.NewsTypeInfo typemodel = typebll.GetModel(typeid); lblFatime.Text = Convert.ToDateTime(newmodel.Fatime.ToString()).ToString("yyyy-MM-dd"); lblNewsContent.Text = newmodel.NewsContent; lblNewsTitle.Text = newmodel.NewsTitle; lblNewsTypeTitle.Text = typemodel.NewsTypeTitle; lblNewsTypeTitle1.Text = typemodel.NewsTypeTitle; lblWrite.Text = newmodel.Write; imgnews.ImageUrl = newmodel.ImageURL; }
private void bind() { Maticsoft.BLL.NewsInfo newsbll = new Maticsoft.BLL.NewsInfo(); int index = int.Parse(Request.QueryString["NewsID"].ToString()); Maticsoft.Model.NewsInfo newmodel = newsbll.GetModel(index); Maticsoft.BLL.NewsTypeInfo typebll = new Maticsoft.BLL.NewsTypeInfo(); int typeid = int.Parse(newmodel.NewsTypeID.ToString()); Maticsoft.Model.NewsTypeInfo typemodel = typebll.GetModel(typeid); lblkey.Text = newmodel.NewsKey; lblstarttime.Text = Convert.ToDateTime(newmodel.Fatime.ToString()).ToString("yyyy-MM-dd"); lbltitle.Text = newmodel.NewsTitle; lbltype.Text = typemodel.NewsTypeTitle; lblwrite.Text = newmodel.Write; Image1.ImageUrl = newmodel.ImageURL; txtcontent.Text = newmodel.NewsContent; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr = ""; if (this.txtNewsTypeTitle.Text.Trim().Length == 0) { strErr += "NewsTypeTitle不能为空!\\n"; } if (strErr != "") { MessageBox.Show(this, strErr); return; } string NewsTypeTitle = this.txtNewsTypeTitle.Text; Maticsoft.Model.NewsTypeInfo model = new Maticsoft.Model.NewsTypeInfo(); model.NewsTypeTitle = NewsTypeTitle; Maticsoft.BLL.NewsTypeInfo bll = new Maticsoft.BLL.NewsTypeInfo(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this, "保存成功!", "add.aspx"); }