private void ShowInfo(int _id)
{
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(_id);
ddlCategoryId.SelectedValue = model.category_id.ToString();
txtTitle.Text = model.title;
txtAuthor.Text = model.author;
txtFrom.Text = model.from;
txtZhaiyao.Text = model.zhaiyao;
txtLinkUrl.Text = model.link_url;
if (model.is_msg == 1)
{
cblItem.Items[0].Selected = true;
}
if (model.is_top == 1)
{
cblItem.Items[1].Selected = true;
}
if (model.is_red == 1)
{
cblItem.Items[2].Selected = true;
}
if (model.is_hot == 1)
{
cblItem.Items[3].Selected = true;
}
if (model.is_slide == 1)
{
cblItem.Items[4].Selected = true;
}
if (model.is_lock == 1)
{
cblItem.Items[5].Selected = true;
}
txtSortId.Text = model.sort_id.ToString();
txtClick.Text = model.click.ToString();
//自訂圖片才綁定
string filename = model.img_url.Substring(model.img_url.LastIndexOf("/") + 1);
if (!filename.StartsWith("small_"))
{
txtImgUrl.Text = model.img_url;
}
txtDiggGood.Text = model.digg_good.ToString();
txtDiggBad.Text = model.digg_bad.ToString();
txtContent.Value = model.content;
txtSeoTitle.Text = model.seo_title;
txtTime.Text = model.add_time.ToString();
txtSeoKeywords.Text = model.seo_keywords;
txtSeoDescription.Text = model.seo_description;
//賦值上傳的相冊
focus_photo.Value = model.img_url; //封面圖片
LitAlbumList.Text = GetAlbumHtml(model.albums, model.img_url);
//賦值屬性清單
LitAttributeList.Text = GetAttributeHtml(model.attribute_values, this.channel_id, _id);
}
private void ShowInfo(int _id)
{
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(_id);
ddlCategoryId.SelectedValue = model.category_id.ToString();
txtTitle.Text = model.title;
txtAuthor.Text = model.author;
txtFrom.Text = model.from;
txtZhaiyao.Text = model.zhaiyao;
txtLinkUrl.Text = model.link_url;
if (model.is_msg == 1)
{
cblItem.Items[0].Selected = true;
}
if (model.is_top == 1)
{
cblItem.Items[1].Selected = true;
}
if (model.is_red == 1)
{
cblItem.Items[2].Selected = true;
}
if (model.is_hot == 1)
{
cblItem.Items[3].Selected = true;
}
if (model.is_slide == 1)
{
cblItem.Items[4].Selected = true;
}
if (model.is_lock == 1)
{
cblItem.Items[5].Selected = true;
}
txtSortId.Text = model.sort_id.ToString();
txtClick.Text = model.click.ToString();
//自定义图片才绑定
string filename = model.img_url.Substring(model.img_url.LastIndexOf("/") + 1);
if (!filename.StartsWith("small_"))
{
txtImgUrl.Text = model.img_url;
}
txtDiggGood.Text = model.digg_good.ToString();
txtDiggBad.Text = model.digg_bad.ToString();
txtContent.Value = model.content;
txtSeoTitle.Text = model.seo_title;
txtSeoKeywords.Text = model.seo_keywords;
txtSeoDescription.Text = model.seo_description;
//赋值上传的相册
focus_photo.Value = model.img_url; //封面图片
LitAlbumList.Text = GetAlbumHtml(model.albums, model.img_url);
//赋值属性列表
LitAttributeList.Text = GetAttributeHtml(model.attribute_values, this.channel_id, _id);
}
/// <summary>
/// 重写虚方法,此方法将在Init事件前执行
/// </summary>
protected override void ShowPage()
{
id = DTRequest.GetQueryInt("id");
BLL.article bll = new BLL.article();
if (!bll.Exists(id))
{
HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出错啦，您要浏览的页面不存在或已删除啦！"));
return;
}
model = bll.GetNewsModel(id);
//浏览数+1
bll.UpdateField(id, "click=click+1");
//跳转URL
if (model.link_url != null)
model.link_url = model.link_url.Trim();
if (!string.IsNullOrEmpty(model.link_url))
{
HttpContext.Current.Response.Redirect(model.link_url);
}
}
private void Bind()
{
BLL.article bll = new BLL.article();
Model.article_news model;
if (Request.QueryString["type"] != null)
{
model = new DAL.article().GetModel(id);
lblDatetime.Visible = false;
}
else
{
model = bll.GetNewsModel(id);
}
if (model != null)
{
lblTitle.Text = model.title;
lblDatetime.Text = "發佈日期: " + model.add_time.ToString("yyyy-MM-dd");
lblFrom.Text = "來源：" + model.from;
lblContent.Text = model.content;
}
}
/// <summary>
/// 重写虚方法,此方法将在Init事件前执行
/// </summary>
protected override void ShowPage()
{
id = DTRequest.GetQueryInt("id");
BLL.article bll = new BLL.article();
if (!bll.Exists(id))
{
HttpContext.Current.Response.Redirect(config.webpath + "error.aspx?msg=" + Utils.UrlEncode("出錯啦，您要瀏覽的頁面不存在或已刪除啦！"));
return;
}
model = bll.GetNewsModel(id);
//浏览数+1
bll.UpdateField(id, "click=click+1");
//跳转URL
if (model.link_url != null)
{
model.link_url = model.link_url.Trim();
}
if (!string.IsNullOrEmpty(model.link_url))
{
HttpContext.Current.Response.Redirect(model.link_url);
}
}
private bool DoEdit(int _id)
{
bool result = true;
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(_id);
model.channel_id = this.channel_id;
model.title = txtTitle.Text.Trim();
model.category_id = int.Parse(ddlCategoryId.SelectedValue);
model.author = txtAuthor.Text.Trim();
model.from = txtFrom.Text.Trim();
model.zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 250);
model.link_url = txtLinkUrl.Text.Trim();
model.add_time = DateTime.Parse(txtTime.Text.ToString());
//檢查是否有自訂圖片
if (txtImgUrl.Text.Trim() != "")
{
model.img_url = txtImgUrl.Text;
}
else
{
model.img_url = focus_photo.Value;
}
model.content = txtContent.Value;
model.seo_title = txtSeoTitle.Text.Trim();
model.seo_keywords = txtSeoKeywords.Text.Trim();
model.seo_description = txtSeoDescription.Text.Trim();
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.click = int.Parse(txtClick.Text.Trim());
model.digg_good = int.Parse(txtDiggGood.Text.Trim());
model.digg_bad = int.Parse(txtDiggBad.Text.Trim());
model.is_msg = 0;
model.is_top = 0;
model.is_red = 0;
model.is_hot = 0;
model.is_slide = 0;
model.is_lock = 0;
if (cblItem.Items[0].Selected == true)
{
model.is_msg = 1;
}
if (cblItem.Items[1].Selected == true)
{
model.is_top = 1;
}
if (cblItem.Items[2].Selected == true)
{
model.is_red = 1;
}
if (cblItem.Items[3].Selected == true)
{
model.is_hot = 1;
}
if (cblItem.Items[4].Selected == true)
{
model.is_slide = 1;
}
if (cblItem.Items[5].Selected == true)
{
model.is_lock = 1;
}
//儲存相冊
if (model.albums != null)
{
model.albums.Clear();
}
string[] albumArr = Request.Form.GetValues("hide_photo_name");
string[] remarkArr = Request.Form.GetValues("hide_photo_remark");
if (albumArr != null)
{
List <Model.article_albums> ls = new List <Model.article_albums>();
for (int i = 0; i < albumArr.Length; i++)
{
string[] imgArr = albumArr[i].Split('|');
int img_id = int.Parse(imgArr[0]);
if (imgArr.Length == 3)
{
if (!string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.article_albums {
id = img_id, article_id = _id, big_img = imgArr[1], small_img = imgArr[2], remark = remarkArr[i]
});
}
else
{
ls.Add(new Model.article_albums {
id = img_id, article_id = _id, big_img = imgArr[1], small_img = imgArr[2]
});
}
}
}
model.albums = ls;
}
//擴展屬性
BLL.attributes bll2 = new BLL.attributes();
DataSet ds2 = bll2.GetList("channel_id=" + this.channel_id);
List <Model.attribute_value> attrls = new List <Model.attribute_value>();
foreach (DataRow dr in ds2.Tables[0].Rows)
{
int attr_id = int.Parse(dr["id"].ToString());
string attr_title = dr["title"].ToString();
string attr_value_id = Request.Form["value_" + attr_id];
string attr_value_content = Request.Form["content_" + attr_id];
if (!string.IsNullOrEmpty(attr_value_id) && !string.IsNullOrEmpty(attr_value_content))
{
attrls.Add(new Model.attribute_value {
id = Convert.ToInt32(attr_value_id), article_id = _id, attribute_id = attr_id, title = attr_title, content = attr_value_content
});
}
}
model.attribute_values = attrls;
if (!bll.Update(model))
{
result = false;
}
return(result);
}
//設置操作
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ChkAdminLevel(channel_id, DTEnums.ActionEnum.Edit.ToString()); //檢查許可權
int id = Convert.ToInt32(((HiddenField)e.Item.FindControl("hidId")).Value);
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(id);
switch (e.CommandName.ToLower())
{
case "ibtnmsg":
if (model.is_msg == 1)
{
bll.UpdateNewsField(id, "is_msg=0");
}
else
{
bll.UpdateNewsField(id, "is_msg=1");
}
break;
case "ibtntop":
if (model.is_top == 1)
{
bll.UpdateNewsField(id, "is_top=0");
}
else
{
bll.UpdateNewsField(id, "is_top=1");
}
break;
case "ibtnred":
if (model.is_red == 1)
{
bll.UpdateNewsField(id, "is_red=0");
}
else
{
bll.UpdateNewsField(id, "is_red=1");
}
break;
case "ibtnhot":
if (model.is_hot == 1)
{
bll.UpdateNewsField(id, "is_hot=0");
}
else
{
bll.UpdateNewsField(id, "is_hot=1");
}
break;
case "ibtnslide":
if (model.is_slide == 1)
{
bll.UpdateNewsField(id, "is_slide=0");
}
else
{
bll.UpdateNewsField(id, "is_slide=1");
}
break;
}
this.RptBind("id>0" + CombSqlTxt(this.channel_id, this.category_id, this.keywords, this.property), "sort_id asc,add_time desc");
}
//设置操作
protected void rptList_ItemCommand(object source, RepeaterCommandEventArgs e)
{
ChkAdminLevel(channel_id, DTEnums.ActionEnum.Edit.ToString()); //检查权限
int id = Convert.ToInt32(((HiddenField)e.Item.FindControl("hidId")).Value);
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(id);
switch (e.CommandName.ToLower())
{
case "ibtntop":
if (model.is_top == 1)
bll.UpdateNewsField(id, "is_top=0");
else
bll.UpdateNewsField(id, "is_top=1");
break;
case "ibtnred":
if (model.is_red == 1)
bll.UpdateNewsField(id, "is_red=0");
else
bll.UpdateNewsField(id, "is_red=1");
break;
case "ibtnslide":
if (model.is_slide == 1)
bll.UpdateNewsField(id, "is_slide=0");
else
bll.UpdateNewsField(id, "is_slide=1");
break;
}
this.RptBind("id>0" + CombSqlTxt(this.channel_id, this.category_id, this.keywords, this.property), "sort_id asc,add_time desc");
}
//批量发布
protected void lbtnPublish_Click(object sender, EventArgs e)
{
try
{
ChkAdminLevel(channel_id, DTEnums.ActionEnum.Publish.ToString()); //检查权限
BLL.article bll = new BLL.article();
Repeater rptList = new Repeater();
rptList = this.rptList1;
Model.article_news model_new = null;
for (int i = 0; i < rptList.Items.Count; i++)
{
int _id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
CheckBox cb = (CheckBox)rptList.Items[i].FindControl("chkId");
if (cb.Checked)
{
model_new = bll.GetNewsModel(_id);
Publish publish_new = new Publish();
//开始发布
string serverFileName = publish_new.Publish_News(model_new.title, model_new.content, model_new.from, model_new.add_time.ToShortDateString());
//修改URL字段
if (!string.IsNullOrEmpty(serverFileName))
{
model_new.link_url = serverFileName;
model_new.is_publish = 1;
bll.Update(model_new);
}
//bll.UpdateField(_id, "link_url='" + serverFileName + "'");
//bll.UpdateNewsField(_id, "is_publish=1");
}
}
JscriptMsg("批量发布成功啦！", Utils.CombUrlTxt("list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}",
this.channel_id.ToString(), this.category_id.ToString(), this.keywords, this.property), "Success");
}
catch
{
JscriptMsg("发布过程中遇到错误，请联系管理员！", Utils.CombUrlTxt("list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}",
this.channel_id.ToString(), this.category_id.ToString(), this.keywords, this.property), "Error");
}
}
/// <summary>
/// 取消发布
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void lbtnEditPublish_Click(object sender, EventArgs e)
{
BLL.article bll = new BLL.article();
//Repeater rptList = new Repeater();
//rptList = this.rptList1;
Model.article_news model_new = null;
LinkButton lnkbtn = (LinkButton)sender;
int _id = Convert.ToInt32(((HiddenField)lnkbtn.FindControl("hidId")).Value);
model_new = bll.GetNewsModel(_id);
if (model_new != null)
{
string temp_url = model_new.link_url;
model_new.link_url = "";
model_new.is_publish = 0;
if (bll.Update(model_new))
{
Utils.DeleteFile(temp_url); //删除文件
}
JscriptMsg("取消发布成功啦！", Utils.CombUrlTxt("list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}",
this.channel_id.ToString(), this.category_id.ToString(), this.keywords, this.property), "Success");
}
else
{
JscriptMsg("实体获取失败，请联系管理员！", Utils.CombUrlTxt("list.aspx", "channel_id={0}&category_id={1}&keywords={2}&property={3}",
this.channel_id.ToString(), this.category_id.ToString(), this.keywords, this.property), "Error");
}
}
private bool DoEdit(int _id)
{
bool result = true;
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(_id);
model.channel_id = this.channel_id;
model.title = txtTitle.Text.Trim();
model.category_id = int.Parse(ddlCategoryId.SelectedValue);
model.author = txtAuthor.Text.Trim();
model.from = txtFrom.Text.Trim();
model.zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 250);
model.link_url = txtLinkUrl.Text.Trim();
//检查是否有自定义图片
if (txtImgUrl.Text.Trim() != "")
{
model.img_url = txtImgUrl.Text;
}
else
{
model.img_url = focus_photo.Value;
}
model.content = txtContent.Value;
model.seo_title = txtSeoTitle.Text.Trim();
model.seo_keywords = txtSeoKeywords.Text.Trim();
model.seo_description = txtSeoDescription.Text.Trim();
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.click = int.Parse(txtClick.Text.Trim());
model.digg_good = int.Parse(txtDiggGood.Text.Trim());
model.digg_bad = int.Parse(txtDiggBad.Text.Trim());
model.is_msg = 0;
model.is_top = 0;
model.is_red = 0;
model.is_hot = 0;
model.is_slide = 0;
model.is_lock = 0;
if (cblItem.Items[0].Selected == true)
{
model.is_msg = 1;
}
if (cblItem.Items[1].Selected == true)
{
model.is_top = 1;
}
if (cblItem.Items[2].Selected == true)
{
model.is_red = 1;
}
if (cblItem.Items[3].Selected == true)
{
model.is_hot = 1;
}
if (cblItem.Items[4].Selected == true)
{
model.is_slide = 1;
}
if (cblItem.Items[5].Selected == true)
{
model.is_lock = 1;
}
//保存相册
if (model.albums != null)
model.albums.Clear();
string[] albumArr = Request.Form.GetValues("hide_photo_name");
string[] remarkArr = Request.Form.GetValues("hide_photo_remark");
if (albumArr != null)
{
List<Model.article_albums> ls = new List<Model.article_albums>();
for (int i = 0; i < albumArr.Length; i++)
{
string[] imgArr = albumArr[i].Split('|');
int img_id = int.Parse(imgArr[0]);
if (imgArr.Length == 3)
{
if (!string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.article_albums { id = img_id, article_id = _id, big_img = imgArr[1], small_img = imgArr[2], remark = remarkArr[i] });
}
else
{
ls.Add(new Model.article_albums { id = img_id, article_id = _id, big_img = imgArr[1], small_img = imgArr[2] });
}
}
}
model.albums = ls;
}
//扩展属性
BLL.attributes bll2 = new BLL.attributes();
DataSet ds2 = bll2.GetList("channel_id=" + this.channel_id);
List<Model.attribute_value> attrls = new List<Model.attribute_value>();
foreach (DataRow dr in ds2.Tables[0].Rows)
{
int attr_id = int.Parse(dr["id"].ToString());
string attr_title = dr["title"].ToString();
string attr_value_id = Request.Form["value_" + attr_id];
string attr_value_content = Request.Form["content_" + attr_id];
if (!string.IsNullOrEmpty(attr_value_id) && !string.IsNullOrEmpty(attr_value_content))
{
attrls.Add(new Model.attribute_value { id = Convert.ToInt32(attr_value_id), article_id = _id, attribute_id = attr_id, title = attr_title, content = attr_value_content });
}
}
model.attribute_values = attrls;
if (!bll.Update(model))
{
result = false;
}
return result;
}
private bool DoEdit(int _id)
{
bool result = true;
BLL.article bll = new BLL.article();
Model.article_news model = bll.GetNewsModel(_id);
model.channel_id = this.channel_id;
model.title = txtTitle.Text.Trim();
model.category_id = int.Parse(ddlCategoryId.SelectedValue);
model.author = txtAuthor.Text.Trim();
model.from = txtFrom.Text.Trim();
model.zhaiyao = Utils.DropHTML(txtZhaiyao.Text, 250);
model.link_url = txtLinkUrl.Text.Trim();
//检查是否有自定义图片
if (txtImgUrl.Text.Trim() != "")
{
model.img_url = txtImgUrl.Text;
}
else
{
model.img_url = focus_photo.Value;
}
model.content = txtContent.Value;
model.seo_title = txtSeoTitle.Text.Trim();
model.seo_keywords = txtSeoKeywords.Text.Trim();
model.seo_description = txtSeoDescription.Text.Trim();
model.sort_id = int.Parse(txtSortId.Text.Trim());
model.click = int.Parse(txtClick.Text.Trim());
model.digg_good = int.Parse(txtDiggGood.Text.Trim());
model.digg_bad = int.Parse(txtDiggBad.Text.Trim());
model.is_msg = 0;
model.is_top = 0;
model.is_red = 0;
model.is_hot = 0;
model.is_slide = 0;
model.is_lock = 0;
if (cblItem.Items[0].Selected == true)
{
model.is_top = 1;
}
//if (cblItem.Items[1].Selected == true)
//{
// model.is_top = 1;
//}
//if (cblItem.Items[2].Selected == true)
//{
// model.is_red = 1;
//}
//if (cblItem.Items[3].Selected == true)
//{
// model.is_hot = 1;
//}
//if (cblItem.Items[4].Selected == true)
//{
// model.is_slide = 1;
//}
//if (cblItem.Items[5].Selected == true)
//{
// model.is_lock = 1;
//}
//保存相册
if (model.albums != null)
model.albums.Clear();
string[] albumArr = Request.Form.GetValues("hide_photo_name");
string[] remarkArr = Request.Form.GetValues("hide_photo_remark");
if (albumArr != null)
{
List<Model.article_albums> ls = new List<Model.article_albums>();
for (int i = 0; i < albumArr.Length; i++)
{
string[] imgArr = albumArr[i].Split('|');
int img_id = int.Parse(imgArr[0]);
if (imgArr.Length == 3)
{
if (!string.IsNullOrEmpty(remarkArr[i]))
{
ls.Add(new Model.article_albums { id = img_id, article_id = _id, big_img = imgArr[1], small_img = imgArr[2], remark = remarkArr[i] });
}
else
{
ls.Add(new Model.article_albums { id = img_id, article_id = _id, big_img = imgArr[1], small_img = imgArr[2] });
}
}
}
model.albums = ls;
}
//如果为外链模型，则不需要发布过程
if (model.category_id == (int)DTEnums.CatergoryID.ad_url)
{
model.is_publish = 1;
}
if (!bll.Update(model))
{
result = false;
}
return result;
}
