//设置操作
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));
}
