private bool DoAdd()
{
bool result = false;
Model.article_tags model = new Model.article_tags();
BLL.article_tags bll = new BLL.article_tags();
model.title = txtTitle.Text.Trim();
if (cbIsRed.Checked == true)
{
model.is_red = 1;
}
else
{
model.is_red = 0;
}
model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99);
model.content = txtContent.Value;
//SEO优化
model.call_index = txtCallIndex.Text.Trim();
model.seo_title = txtSeoTitle.Text.Trim();
model.seo_keywords = txtSeoKeywords.Text.Trim().Replace("，", ",");
model.seo_description = txtSeoDescription.Text.Trim();
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加Tags标签:" + model.title); //记录日志
result = true;
}
return(result);
}
private bool DoAdd()
{
bool result = false;
Model.article_tags model = new Model.article_tags();
BLL.article_tags bll = new BLL.article_tags();
model.title = txtTitle.Text.Trim();
if (cbIsRed.Checked == true)
{
model.is_red = 1;
}
else
{
model.is_red = 0;
}
model.sort_id = ConvertTool.ToInt(txtSortId.Text.Trim(), 99);
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加Tags标签:" + model.title); //记录日志
result = true;
}
return(result);
}
/// <summary>
/// 获取文章Tags标签列表
/// </summary>
/// <param name="tags">标签列表</param>
/// <returns></returns>
protected DataTable get_article_tags(string tags)
{
//创建一个DataTable
DataTable dt = new DataTable();
dt.Columns.Add("id", Type.GetType("System.Int32"));
dt.Columns.Add("title", Type.GetType("System.String"));
dt.Columns.Add("call_index", Type.GetType("System.String"));
if (string.IsNullOrEmpty(tags) || "" == tags)
{
return(dt);
}
tags = tags.Replace("，", ",");
string[] arr = tags.Split(',');
//遍历
BLL.article_tags bll = new BLL.article_tags();
foreach (string t in arr)
{
Model.article_tags model = bll.GetTitleModel(t);
if (null != model)
{
DataRow dr = dt.NewRow();
dr["id"] = model.id;
dr["title"] = model.title;
dr["call_index"] = model.call_index;
dt.Rows.Add(dr);
}
}
return(dt);
}
private void ShowInfo(int _id)
{
BLL.article_tags bll = new BLL.article_tags();
Model.article_tags model = bll.GetModel(_id);
txtTitle.Text = model.title;
if (model.is_red == 1)
{
cbIsRed.Checked = true;
}
else
{
cbIsRed.Checked = false;
}
txtSortId.Text = model.sort_id.ToString();
txtContent.Value = model.content;
//SEO优化
txtCallIndex.Text = model.call_index;
txtCallIndex.Attributes.Add("ajaxurl", "../../tools/admin_ajax.ashx?action=tags_validate&old_name=" + Utils.UrlEncode(model.call_index));
txtCallIndex.Focus(); //设置焦点，防止JS无法提交
txtSeoTitle.Text = model.seo_title;
txtSeoKeywords.Text = model.seo_keywords;
txtSeoDescription.Text = model.seo_description;
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.article_tags bll = new BLL.article_tags();
Model.article_tags model = bll.GetModel(_id);
model.title = txtTitle.Text.Trim();
if (cbIsRed.Checked == true)
{
model.is_red = 1;
}
else
{
model.is_red = 0;
}
model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99);
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改Tags标签:" + model.title); //记录日志
result = true;
}
return(result);
}
//设置推荐
protected void btnRed_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_article_tags", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.article_tags bll = new BLL.article_tags();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
bll.UpdateField(id, "is_red=1");
}
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存Tags标签排序"); //记录日志
JscriptMsg("设置推荐成功！", Utils.CombUrlTxt("tags_list.aspx", "keywords={0}", this.keywords));
}
//设置推荐
protected void btnRed_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_article_tags", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.article_tags bll = new BLL.article_tags();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
bll.UpdateField(id, "is_red=1");
}
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存Tags标签排序"); //记录日志
JscriptMsg("设置推荐成功！", Utils.CombUrlTxt("tags_list.aspx", "keywords={0}", this.keywords));
}
/// <summary>
/// 获取tag名
/// </summary>
/// <returns>DataTable</returns>
public string get_article_tags_title(int id)
{
Model.article_tags model = new BLL.article_tags().Get(id);
if (model == null)
{
return("无标签");
}
else
{
return(model.title);
}
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.article_tags bll = new BLL.article_tags();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("tags_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void RptBind(string _strWhere, string _orderby)
{
this.page = DTRequest.GetQueryInt("page", 1);
txtKeywords.Text = this.keywords;
BLL.article_tags bll = new BLL.article_tags();
this.rptList.DataSource = bll.GetList(this.pageSize, this.page, _strWhere, _orderby, out this.totalCount);
this.rptList.DataBind();
//绑定页码
txtPageNum.Text = this.pageSize.ToString();
string pageUrl = Utils.CombUrlTxt("tags_list.aspx", "keywords={0}&page={1}", this.keywords, "__id__");
PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8);
}
private void BrandBind(int _channel_id)
{
BLL.article_tags bll = new BLL.article_tags();
DataTable dt = bll.GetList("1=1").Tables[0];
this.ddlBrandId.Items.Clear();
this.ddlBrandId.Items.Add(new ListItem("所有標籤", ""));
foreach (DataRow dr in dt.Rows)
{
string Id = dr["id"].ToString();
string Title = dr["title"].ToString().Trim();
this.ddlBrandId.Items.Add(new ListItem(Title, Id));
}
}
private void ShowInfo(int _id)
{
BLL.article_tags bll = new BLL.article_tags();
Model.article_tags model = bll.GetModel(_id);
txtTitle.Text = model.title;
if (model.is_red == 1)
{
cbIsRed.Checked = true;
}
else
{
cbIsRed.Checked = false;
}
txtSortId.Text = model.sort_id.ToString();
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_article_tags", DTEnums.ActionEnum.Delete.ToString()); //检查权限
BLL.article_tags bll = new BLL.article_tags();
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)
{
bll.Delete(id);
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除Tags标签"); //记录日志
JscriptMsg("删除Tags标签成功！", Utils.CombUrlTxt("tags_list.aspx", "keywords={0}", this.keywords));
}
//批量删除
protected void btnDelete_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_article_tags", DTEnums.ActionEnum.Delete.ToString()); //检查权限
BLL.article_tags bll = new BLL.article_tags();
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)
{
bll.Delete(id);
}
}
AddAdminLog(DTEnums.ActionEnum.Delete.ToString(), "删除Tags标签"); //记录日志
JscriptMsg("删除Tags标签成功！", Utils.CombUrlTxt("tags_list.aspx", "keywords={0}", this.keywords));
}
private void ShowInfo(int _id)
{
BLL.article_tags bll = new BLL.article_tags();
Model.article_tags model = bll.GetModel(_id);
txtTitle.Text = model.title;
if (model.is_red == 1)
{
cbIsRed.Checked = true;
}
else
{
cbIsRed.Checked = false;
}
txtSortId.Text = model.sort_id.ToString();
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_article_tags", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.article_tags bll = new BLL.article_tags();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存Tags标签排序"); //记录日志
JscriptMsg("保存排序成功！", Utils.CombUrlTxt("tags_list.aspx", "keywords={0}", this.keywords));
}
//保存排序
protected void btnSave_Click(object sender, EventArgs e)
{
ChkAdminLevel("sys_article_tags", DTEnums.ActionEnum.Edit.ToString()); //检查权限
BLL.article_tags bll = new BLL.article_tags();
for (int i = 0; i < rptList.Items.Count; i++)
{
int id = Convert.ToInt32(((HiddenField)rptList.Items[i].FindControl("hidId")).Value);
int sortId;
if (!int.TryParse(((TextBox)rptList.Items[i].FindControl("txtSortId")).Text.Trim(), out sortId))
{
sortId = 99;
}
bll.UpdateField(id, "sort_id=" + sortId.ToString());
}
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "保存Tags标签排序"); //记录日志
JscriptMsg("保存排序成功！", Utils.CombUrlTxt("tags_list.aspx", "keywords={0}", this.keywords));
}
/// <summary>
/// 重写虚方法,此方法将在Init事件前执行
/// </summary>
protected override void ShowPage()
{
id = DTRequest.GetQueryInt("id");
call_index = Utils.SafeXXS(DTRequest.GetQueryString("call_index"));
channel = Utils.SafeXXS(DTRequest.GetQueryString("channel"));
//验证tags标签是否存在
BLL.article_tags bll = new BLL.article_tags();
if (id > 0) //如果ID获取到，将使用ID
{
if (!bll.Exists(id))
{
HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦，您要浏览的页面不存在或已删除！")));
return;
}
model = bll.GetModel(id);
}
else if (!string.IsNullOrEmpty(call_index)) //否则检查设置的别名
{
if (!bll.Exists(call_index))
{
HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦，您要浏览的页面不存在或已删除！")));
return;
}
model = bll.GetModel(call_index);
id = model.id;
}
else
{
HttpContext.Current.Response.Redirect(linkurl("error", "?msg=" + Utils.UrlEncode("出错啦，您要浏览的页面不存在或已删除！")));
return;
}
//判断SEO标题
if (string.IsNullOrEmpty(model.seo_title) || "" == model.seo_title)
{
model.seo_title = model.title;
}
}
private bool DoAdd()
{
bool result = false;
Model.article_tags model = new Model.article_tags();
BLL.article_tags bll = new BLL.article_tags();
model.title = txtTitle.Text.Trim();
if (cbIsRed.Checked == true)
{
model.is_red = 1;
}
else
{
model.is_red = 0;
}
model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99);
if (bll.Add(model) > 0)
{
AddAdminLog(DTEnums.ActionEnum.Add.ToString(), "添加Tags标签:" + model.title); //记录日志
result = true;
}
return result;
}
private bool DoEdit(int _id)
{
bool result = false;
BLL.article_tags bll = new BLL.article_tags();
Model.article_tags model = bll.GetModel(_id);
model.title = txtTitle.Text.Trim();
if (cbIsRed.Checked == true)
{
model.is_red = 1;
}
else
{
model.is_red = 0;
}
model.sort_id = Utils.StrToInt(txtSortId.Text.Trim(), 99);
if (bll.Update(model))
{
AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改Tags标签:" + model.title); //记录日志
result = true;
}
return result;
}
