/// <summary>
/// 获得数据列表
/// </summary>
public List <OS.Model.contents.category_field> GetList(int category_id)
{
List <OS.Model.contents.category_field> modelList = new List <OS.Model.contents.category_field>();
StringBuilder strSql = new StringBuilder();
strSql.Append("select id,category_id,field_id from " + databaseprefix + "category_field ");
strSql.Append(" where category_id=" + category_id);
DataTable dt = DbHelperSQL.Query(strSql.ToString()).Tables[0];
int rowsCount = dt.Rows.Count;
if (rowsCount > 0)
{
OS.Model.contents.category_field model;
for (int n = 0; n < rowsCount; n++)
{
model = new Model.contents.category_field();
if (dt.Rows[n]["id"] != null && dt.Rows[n]["id"].ToString() != "")
{
model.id = int.Parse(dt.Rows[n]["id"].ToString());
}
if (dt.Rows[n]["category_id"] != null && dt.Rows[n]["category_id"].ToString() != "")
{
model.category_id = int.Parse(dt.Rows[n]["category_id"].ToString());
}
if (dt.Rows[n]["field_id"] != null && dt.Rows[n]["field_id"].ToString() != "")
{
model.field_id = int.Parse(dt.Rows[n]["field_id"].ToString());
}
modelList.Add(model);
}
}
return(modelList);
}
private void ShowInfo(int _id)
{
BLL.contents.article_category bll = new BLL.contents.article_category();
Model.contents.article_category model = bll.GetModel(_id);
ddlParentId.SelectedValue = model.parent_id.ToString();
txtCallIndex.Text = model.call_index;
txtCallIndex.Attributes.Add("ajaxurl", "../../ashx/admin_ajax.ashx?action=navigation_validate&old_name=" + Utils.UrlEncode(model.call_index));
txtCallIndex.Focus(); //设置焦点，防止JS无法提交
txtTitle.Text = model.title;
txtSortId.Text = model.sort_id.ToString();
txtSeoTitle.Text = model.seo_title;
txtSeoKeywords.Text = model.seo_keywords;
txtSeoDescription.Text = model.seo_description;
txtLinkUrl.Text = model.link_url;
txtImgUrl.Text = model.img_url;
txtContent.Value = model.content;
rblStatus.SelectedValue = model.model_id.ToString();
if (model.is_add_category == 1)
{
cblItem.Items[0].Selected = true;
}
if (model.is_add_content == 1)
{
cblItem.Items[1].Selected = true;
}
if (model.is_show_top == 1)
{
cblItem.Items[2].Selected = true;
}
if (model.is_show_foot == 1)
{
cblItem.Items[3].Selected = true;
}
if (model.is_albums == 1)
{
cbIsAlbums.Checked = true;
}
if (model.is_attach == 1)
{
cbIsAttach.Checked = true;
}
txtPageSize.Text = model.page_size.ToString();
//赋值扩展字段
if (model.category_fields != null)
{
for (int i = 0; i < cblAttributeField.Items.Count; i++)
{
Model.contents.category_field modelt = model.category_fields.Find(p => p.field_id == int.Parse(cblAttributeField.Items[i].Value)); //查找对应的字段ID
if (modelt != null)
{
cblAttributeField.Items[i].Selected = true;
}
}
}
}