//设置操作 protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e) { ChkAdminLevel("news_list", DTEnums.ActionEnum.Edit.ToString()); //检查权限 int id = Convert.ToInt32(((HiddenField)e.Item.FindControl("hidId")).Value); BLL.news bll = new BLL.news(); Model.news model = bll.GetModel(id); switch (e.CommandName) { case "lbtnIsMsg": if (model.is_msg == 1) { bll.UpdateField(id, "is_msg=0"); } else { bll.UpdateField(id, "is_msg=1"); } break; case "lbtnIsHide": if (model.is_hide == 1) { bll.UpdateField(id, "is_hide=0"); } else { bll.UpdateField(id, "is_hide=1"); } break; } this.RptBind("id>0" + CombSqlTxt(this.keywords), "sort asc,time desc,id desc"); }
/// <summary> /// 添加新闻,添加成功返回true,否则返回false /// </summary> /// <param name="M_news">参数</param> /// <returns>bool值</returns> public bool AddNews(Model.news M_news) { string times = System.DateTime.Now.ToString(); int cindex = GetMaxCindex() + 1; string strSQL = "insert news (title,info,BigClassID,username,infotime,cindex) values('" + M_news.title + "','" + M_news.info + "'," + M_news.BigClassID + ",'" + M_news.username + "','" + times + "', " + cindex + " )"; return(db.ExecuteNonQuery(false, strSQL)); }
private bool DoAdd() { bool result = false; Model.news model = new Model.news(); BLL.news bll = new BLL.news(); model.title = txtTitle.Text.Trim(); model.is_hide = Convert.ToInt32(rblIsHide.SelectedValue); model.is_msg = Convert.ToInt32(rblIsMsg.SelectedValue); model.img = txtImg.Text; model.sort = Convert.ToInt32(txtSort.Text); model.click = Convert.ToInt32(txtClick.Text); if (string.IsNullOrEmpty(txtTime.Text)) { model.time = DateTime.Now; } else { model.time = Convert.ToDateTime(txtTime.Text); } //内容摘要提取内容前255个字符 if (string.IsNullOrEmpty(txtZhaiyao.Text.Trim())) { model.zhaiyao = Utils.DropHTML(txtContent.Value, 255); } else { model.zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 255); } //是否将编辑器远程图片保存到本地 if (siteConfig.fileremote == 1) { model.cont = AutoRemoteImageSave(txtContent.Value); } else { model.cont = txtContent.Value; } model.id = bll.Add(model); if (model.id > 0) { AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加咨询内容:" + model.title); //记录日志 result = true; } return(result); }
/// <summary> /// 组合成对象实体 /// </summary> /// <param name="row">一行数据</param> /// <returns>Model.news</returns> private Model.news DataRowToModel(DataRow row) { Model.news model = new Model.news(); if (row != null) { if (null != row["id"] && "" != row["id"].ToString()) { model.id = int.Parse(row["id"].ToString()); } if (null != row["title"]) { model.title = row["title"].ToString(); } if (null != row["zhaiyao"]) { model.zhaiyao = row["zhaiyao"].ToString(); } if (null != row["cont"]) { model.cont = row["cont"].ToString(); } if (null != row["img"]) { model.img = row["img"].ToString(); } if (null != row["sort"] && "" != row["sort"].ToString()) { model.sort = int.Parse(row["sort"].ToString()); } if (null != row["click"] && "" != row["click"].ToString()) { model.click = int.Parse(row["click"].ToString()); } if (null != row["is_msg"] && "" != row["is_msg"].ToString()) { model.is_msg = int.Parse(row["is_msg"].ToString()); } if (null != row["is_hide"] && "" != row["is_hide"].ToString()) { model.is_hide = int.Parse(row["is_hide"].ToString()); } if (null != row["time"] && "" != row["time"].ToString()) { model.time = DateTime.Parse(row["time"].ToString()); } } return(model); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.news</param> /// <returns>True or False</returns> public bool Update(Model.news model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "news] set "); strSql.Append("title=@title,"); strSql.Append("zhaiyao=@zhaiyao,"); strSql.Append("cont=@cont,"); strSql.Append("img=@img,"); strSql.Append("sort=@sort,"); strSql.Append("click=@click,"); strSql.Append("is_msg=@is_msg,"); strSql.Append("is_hide=@is_hide,"); strSql.Append("time=@time"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@zhaiyao", SqlDbType.VarChar, 255), new SqlParameter("@cont", SqlDbType.NText), new SqlParameter("@img", SqlDbType.VarChar, 255), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@click", SqlDbType.Int, 4), new SqlParameter("@is_msg", SqlDbType.TinyInt, 1), new SqlParameter("@is_hide", SqlDbType.TinyInt, 1), new SqlParameter("@time", SqlDbType.DateTime), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.title; parameters[1].Value = model.zhaiyao; parameters[2].Value = model.cont; parameters[3].Value = model.img; parameters[4].Value = model.sort; parameters[5].Value = model.click; parameters[6].Value = model.is_msg; parameters[7].Value = model.is_hide; parameters[8].Value = model.time; parameters[9].Value = model.id; int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } return(false); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.news</param> /// <returns>ID</returns> public int Add(Model.news model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "news]("); strSql.Append("title,zhaiyao,cont,img,sort,click,is_msg,is_hide,time"); strSql.Append(") values("); strSql.Append("@title,@zhaiyao,@cont,@img,@sort,@click,@is_msg,@is_hide,@time)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@zhaiyao", SqlDbType.VarChar, 255), new SqlParameter("@cont", SqlDbType.NText), new SqlParameter("@img", SqlDbType.VarChar, 255), new SqlParameter("@sort", SqlDbType.Int, 4), new SqlParameter("@click", SqlDbType.Int, 4), new SqlParameter("@is_msg", SqlDbType.TinyInt, 1), new SqlParameter("@is_hide", SqlDbType.TinyInt, 1), new SqlParameter("@time", SqlDbType.DateTime) }; parameters[0].Value = model.title; parameters[1].Value = model.zhaiyao; parameters[2].Value = model.cont; parameters[3].Value = model.img; parameters[4].Value = model.sort; parameters[5].Value = model.click; parameters[6].Value = model.is_msg; parameters[7].Value = model.is_hide; parameters[8].Value = model.time; object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters); if (null != obj) { return(Convert.ToInt32(obj)); } else { return(0); } }
/// <summary> /// 根据栏目ID删除该栏目的所有新闻信息 /// </summary> /// <param name="Mn">实体层news类的对象</param> /// <returns>true,false</returns> public bool DeleteNewsByBigClassID(Model.news Mn) { return(DAL_news.DeleteNewsByBigClassID(Mn.BigClassID)); }
/// <summary> /// 修改指定的新闻,修改成功返回true,否则返回false /// </summary> /// <param name="M_news">对象参数</param> /// <returns>成功返回true,失败返回false</returns> public bool UpdateNews(Model.news M_news) { string strSQL = "update news set title='" + M_news.title + "',BigClassID=" + M_news.BigClassID + ",info='" + M_news.info + "',username='******' where id=" + M_news.id; return(db.ExecuteNonQuery(false, strSQL)); }
/// <summary> /// 修改指定的新闻,修改成功返回true,否则返回false /// </summary> /// <param name="M_news">对象参数</param> /// <returns>成功返回true,失败返回false</returns> public bool UpdateNews(Model.news M_news) { return(DAL_news.UpdateNews(M_news)); }
/// <summary> /// 按新闻内容模糊查询新闻列表 /// </summary> /// <param name="M_news">实体层news类的对象</param> /// <returns>DataSet数据集</returns> public DataSet AdminQueryByNewsInfo(Model.news M_news) { return(DAL_news.AdminQueryByNewsInfo(M_news.info)); }
/// <summary> /// 按新闻标题模糊查询新闻列表 /// </summary> /// <param name="M_news">实体层news类的对象</param> /// <returns>DataSet数据集</returns> public DataSet AdminQueryByNewsTitle(Model.news M_news) { return(DAL_news.AdminQueryByNewsTitle(M_news.title)); }
/// <summary> /// 根据新闻id删除新闻,删除成功返回true,否则返回false /// </summary> /// <param name="M">实体层news类的对象</param> /// <returns>true,false </returns> public bool DeleteNewByID(Model.news M) { return(DAL_news.DeleteNewByID(M.id)); }
/// <summary> /// 添加新闻,,添加成功返回true,否则返回false /// </summary> /// <param name="m_news">对象参数</param> /// <returns>成功返回true,失败返回false</returns> public bool AddNews(Model.news m_news) { return(DAL_news.AddNews(m_news)); }
/// <summary> /// 获取每个分栏前6条新闻 /// </summary> /// <param name="M_news">Model实体层news类的对象</param> /// <returns>DataSet数据集</returns> public DataSet GetDataByBigClassTopSix(Model.news M_news) { string strSQL = "select top 6 * from news where BigClassID='" + M_news.BigClassID.ToString() + "' and flag=1 order by cindex"; return(db.ReturnDataSet(strSQL)); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">Model.news</param> /// <returns>ID</returns> public int Add(Model.news model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">Model.news</param> /// <returns>True Or False</returns> public bool Update(Model.news model) { return(dal.Update(model)); }
/// <summary> /// 根据id进行审核新闻,审核成功返回true,否则返回false /// </summary> /// <param name="M">实体层news类的对象</param> /// <returns>审核成功返回true,否则返回false</returns> public bool CheckNewsByID(Model.news M) { return(DAL_news.CheckNewsByID(M.id)); }