protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
int id = Convert.ToInt32(((Label)e.Item.FindControl("lb_id")).Text);
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = dal.GetModel(id);
switch (e.CommandName.ToLower())
{
case "ibtnlock":
if (model.IsLock == 1)
{
dal.UpdateField(id, "IsLock=0");
}
else
{
dal.UpdateField(id, "IsLock=1");
}
break;
case "ibtntop":
if (model.IsTop == 1)
{
dal.UpdateField(id, "IsTop=0");
}
else
{
dal.UpdateField(id, "IsTop=1");
}
break;
}
RptBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = new Cms.Model.NewsInfo();
model.NewsID = Id;
model.Title = txtTitle.Text.Trim();
model.Author = txtAuthor.Text.Trim();
model.ClassId = int.Parse(ddlClassId.SelectedValue);
model.Content = Cms.Common.Utils.ToHtml(NewsContent.Text);
model.PubTime = DateTime.Parse(txtPubTime.Text);
model.Click = int.Parse(txtClick.Text.Trim());
model.IsTop = 0;
if (cblItem.Items[0].Selected == true)
{
model.IsTop = 1;
}
model.IsLock = 0;
if (cblItem.Items[1].Selected == true)
{
model.IsLock = 1;
}
dal.Update(model);
//保存日志
MessageBox.Show(this, "新闻编辑成功！");
}
protected void lbtnDel_Click(object sender, EventArgs e)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model;
bool hasDeleted = false;
//批量删除
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((Label)rptList.Items[i].FindControl("lb_id")).Text);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("cb_id");
if (cb.Checked)
{
model = dal.GetModel(id);
//删除记录
hasDeleted = true;
dal.Delete(id);
}
}
if (hasDeleted)
{
MessageBox.Show(this, "批量删除成功！");
}
else
{
MessageBox.Show(this, "没有选中记录！");
}
//Coolite.Ext.Web.Ext.MessageBox.Alert("提示", "删除成功").Show();
RptBind();
}
private void RptBind(string strWhere)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
if (String.IsNullOrEmpty(strWhere))
{
strWhere = "IsLock = 0";
}
else
{
strWhere += " AND IsLock = 0";
}
DataSet ds = dal.GetList(strWhere);
DataView dv = ds.Tables[0].DefaultView;
//利用PAGEDDAGASOURCE类来分页
PagedDataSource pds = new PagedDataSource();
AspNetPager1.RecordCount = dv.Count;
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
//获得总条数
pcount = dv.Count;
if (this.pcount == 0)
{
this.lbmsg.Visible = true;
this.lbmsg.Text = "暂时没有新闻";
}
//绑定数据
rptList.DataSource = pds;
rptList.DataBind();
}
protected void btnSave_Click(object sender, EventArgs e)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = new Cms.Model.NewsInfo();
model.NewsID = Id;
model.Title = txtTitle.Text.Trim();
model.Author = txtAuthor.Text.Trim();
model.ClassId = int.Parse(ddlClassId.SelectedValue);
model.Content = Cms.Common.Utils.ToHtml(NewsContent.Text);
model.PubTime = DateTime.Parse(txtPubTime.Text);
model.Click = int.Parse(txtClick.Text.Trim());
model.IsTop = 0;
if (cblItem.Items[0].Selected == true)
{
model.IsTop = 1;
}
model.IsLock = 0;
if (cblItem.Items[1].Selected == true)
{
model.IsLock = 1;
}
dal.Update(model);
//保存日志
MessageBox.Show(this, "新闻编辑成功！");
}
public void RptBind()
{
string strWhere = "";
if (Session["strWhereNews"] != null && Session["strWhereNews"].ToString() != "")
{
strWhere += Session["strWhereNews"].ToString();
}
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
DataSet ds = dal.GetList(strWhere);
DataView dv = ds.Tables[0].DefaultView;
//利用PAGEDDAGASOURCE类来分页
PagedDataSource pds = new PagedDataSource();
AspNetPager1.RecordCount = dv.Count;
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
//获得总条数
pcount = dv.Count;
if (this.pcount > 0)
{
this.lbtnDel.Enabled = true;
}
else
{
this.lbtnDel.Enabled = false;
}
//绑定数据
rptList.DataSource = pds;
rptList.DataBind();
}
private void RptBind(string strWhere)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
if (String.IsNullOrEmpty(strWhere))
strWhere = "IsLock = 0";
else
strWhere += " AND IsLock = 0";
DataSet ds = dal.GetList(strWhere);
DataView dv = ds.Tables[0].DefaultView;
//利用PAGEDDAGASOURCE类来分页
PagedDataSource pds = new PagedDataSource();
AspNetPager1.RecordCount = dv.Count;
pds.DataSource = dv;
pds.AllowPaging = true;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.PageSize = AspNetPager1.PageSize;
//获得总条数
pcount = dv.Count;
if (this.pcount == 0)
{
this.lbmsg.Visible = true;
this.lbmsg.Text = "暂时没有新闻";
}
//绑定数据
rptList.DataSource = pds;
rptList.DataBind();
}
public static string latestNewsList()
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
StringBuilder strTxt = new StringBuilder();
DataSet ds = dal.GetList(5, "IsTop > 0 AND IsLock = 0", " PubTime desc");
DataTable tbl = ds.Tables[0];
if (tbl.Rows.Count > 0)
{
strTxt.Append("<dl>");
for (int j = 0; j < tbl.Rows.Count; j++)
{
DataRow row = tbl.Rows[j];
strTxt.Append("<dd style=\"height: 24px;\">");
strTxt.Append("<a class=\"productClass02\" href=\"NewsView.aspx?newsID=" + row["newsID"].ToString() + "\" style=\"position: relative;top: 5px; left: 15px;\">" + row["Title"].ToString() + "</a>");
strTxt.Append("</dd>");
}
strTxt.Append("</dl>");
}
else
{
strTxt.Append("暂无活动！");
}
return(strTxt.ToString());
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtTitle.Text.Trim().Length == 0)
{
strErr += "新闻标题不能为空！\\n";
}
if (this.txtAuthor.Text.Trim().Length == 0)
{
strErr += "发布人不能为空！\\n";
}
if (this.NewsContent.Text.Trim().Length == 0)
{
strErr += "新闻内容不能为空！\\n";
}
if (!PageValidate.IsNumber(txtClick.Text))
{
strErr += "点击次数格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
Cms.Model.NewsInfo model = new Cms.Model.NewsInfo();
model.Title = this.txtTitle.Text;
model.Author = this.txtAuthor.Text;
model.ClassId = int.Parse(ddlClassId.SelectedValue);
model.Content = Cms.Common.Utils.ToHtml(this.NewsContent.Text);
model.Click = int.Parse(this.txtClick.Text);
model.IsTop = 0;
if (cblItem.Items[0].Selected == true)
{
model.IsTop = 1;
}
model.IsLock = 0;
if (cblItem.Items[1].Selected == true)
{
model.IsLock = 1;
}
model.PubTime = DateTime.Parse(DateTime.Now.ToString());
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
int ReId = dal.Add(model);
if (ReId > 0)
{
//保存日志
MessageBox.Show(this, "新闻发布成功！");
}
else
{
MessageBox.Show(this, "发布过程中发生错误！");
//Coolite.Ext.Web.Ext.MessageBox.Alert("提示", "发布过程中发生错误").Show();
}
}
protected void btnSave_Click(object sender, EventArgs e)
{
string strErr = "";
if (this.txtTitle.Text.Trim().Length == 0)
{
strErr += "新闻标题不能为空！\\n";
}
if (this.txtAuthor.Text.Trim().Length == 0)
{
strErr += "发布人不能为空！\\n";
}
if (this.NewsContent.Text.Trim().Length == 0)
{
strErr += "新闻内容不能为空！\\n";
}
if (!PageValidate.IsNumber(txtClick.Text))
{
strErr += "点击次数格式错误！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
Cms.Model.NewsInfo model = new Cms.Model.NewsInfo();
model.Title = this.txtTitle.Text;
model.Author = this.txtAuthor.Text;
model.ClassId = int.Parse(ddlClassId.SelectedValue);
model.Content = Cms.Common.Utils.ToHtml(this.NewsContent.Text);
model.Click = int.Parse(this.txtClick.Text);
model.IsTop = 0;
if (cblItem.Items[0].Selected == true)
{
model.IsTop = 1;
}
model.IsLock = 0;
if (cblItem.Items[1].Selected == true)
{
model.IsLock = 1;
}
model.PubTime = DateTime.Parse(DateTime.Now.ToString());
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
int ReId = dal.Add(model);
if (ReId > 0)
{
//保存日志
MessageBox.Show(this, "新闻发布成功！");
}
else
{
MessageBox.Show(this, "发布过程中发生错误！");
//Coolite.Ext.Web.Ext.MessageBox.Alert("提示", "发布过程中发生错误").Show();
}
}
private void ShowInfo(int _id)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = dal.GetModel(_id);
txtTitle.Text = model.Title;
txtAuthor.Text = model.Author;
ddlClassId.SelectedValue = model.ClassId.ToString();
NewsContent.Text = Cms.Common.Utils.ToTxt(model.Content);
txtPubTime.Text = model.PubTime.ToString("yyyy-MM-dd HH:mm:ss");
txtClick.Text = model.Click.ToString();
cblItem.Items[0].Selected = model.IsTop > 0;
cblItem.Items[1].Selected = model.IsLock > 0;
}
//赋值
private void ShowInfo(int Id)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = dal.GetModel(Id);
this.lblId.Text = model.NewsID.ToString();
this.lblTitle.Text = model.Title;
this.lblAuthor.Text = model.Author;
this.lblClassId.Text = model.ClassId.ToString();
this.lblContent.Text = Cms.Common.Utils.ToTxt(model.Content);
this.lblClick.Text = model.Click.ToString();
this.lblIsLock.Text = model.IsLock.ToString();
this.lblIsTop.Text = model.IsTop.ToString();
this.lblPubTime.Text = model.PubTime.ToString();
}
//赋值
private void ShowInfo(int Id)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = dal.GetModel(Id);
this.lblId.Text = model.NewsID.ToString();
this.lblTitle.Text = model.Title;
this.lblAuthor.Text = model.Author;
this.lblClassId.Text = model.ClassId.ToString();
this.lblContent.Text =Cms.Common.Utils.ToTxt(model.Content);
this.lblClick.Text = model.Click.ToString();
this.lblIsLock.Text = model.IsLock.ToString();
this.lblIsTop.Text = model.IsTop.ToString();
this.lblPubTime.Text = model.PubTime.ToString();
}
private void ShowInfo(int _id)
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
Cms.Model.NewsInfo model = dal.GetModel(_id);
txtTitle.Text = model.Title;
txtAuthor.Text = model.Author;
ddlClassId.SelectedValue = model.ClassId.ToString();
NewsContent.Text = Cms.Common.Utils.ToTxt(model.Content);
txtPubTime.Text = model.PubTime.ToString("yyyy-MM-dd HH:mm:ss");
txtClick.Text = model.Click.ToString();
cblItem.Items[0].Selected = model.IsTop > 0;
cblItem.Items[1].Selected = model.IsLock > 0;
}
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(Request.Params["newsID"] as string, out this.newsId))
{
Response.Write("<script>alert('您要查看的信息参数不正确或不存在！'),location.href='News.aspx';</script>");
return;
}
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
model = dal.GetModel(this.newsId);//获得Id
if (model == null)
{
Response.Write("<script>alert('您要查看的信息参数不正确或不存在！'),location.href='News.aspx';</script>");
return;
}
////浏览数+1
dal.UpdateField(this.newsId, "Click=Click+1");
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>menuEnable(4);</script>");
}
protected int newsId; //全局变量Id
#endregion Fields
#region Methods
protected void Page_Load(object sender, EventArgs e)
{
if (!int.TryParse(Request.Params["newsID"] as string, out this.newsId))
{
Response.Write("<script>alert('您要查看的信息参数不正确或不存在！'),location.href='News.aspx';</script>");
return;
}
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
model = dal.GetModel(this.newsId);//获得Id
if (model == null)
{
Response.Write("<script>alert('您要查看的信息参数不正确或不存在！'),location.href='News.aspx';</script>");
return;
}
////浏览数+1
dal.UpdateField(this.newsId, "Click=Click+1");
ClientScript.RegisterStartupScript(this.GetType(), "", "<script type='text/javascript'>menuEnable(4);</script>");
}
public static string latestNewsList()
{
Cms.DAL.NewsInfo dal = new Cms.DAL.NewsInfo();
StringBuilder strTxt = new StringBuilder();
DataSet ds = dal.GetList(5, "IsTop > 0 AND IsLock = 0", " PubTime desc");
DataTable tbl = ds.Tables[0];
if (tbl.Rows.Count > 0)
{
strTxt.Append("<dl>");
for (int j = 0; j < tbl.Rows.Count; j++)
{
DataRow row = tbl.Rows[j];
strTxt.Append("<dd style=\"height: 24px;\">");
strTxt.Append("<a class=\"productClass02\" href=\"NewsView.aspx?newsID=" + row["newsID"].ToString() + "\" style=\"position: relative;top: 5px; left: 15px;\">" + row["Title"].ToString() + "</a>");
strTxt.Append("</dd>");
}
strTxt.Append("</dl>");
}
else
strTxt.Append("暂无活动！");
return strTxt.ToString();
}
