//获取单个栏目信息
public string SingleJson(int id)
{
Song.Entities.KnowledgeSort nc = Business.Do <IKnowledge>().SortSingle(id);
string json = nc.ToJson();
return(json);
}
protected void Page_Load(object sender, EventArgs e)
{
//this.Form.DefaultButton = this.btnSear.UniqueID;
org = Business.Do <IOrganization>().OrganCurrent();
if (!this.IsPostBack)
{
if (state == "add" || state == "edit")
{
plEditArea.Visible = true;
plListArea.Visible = false;
}
else
{
plEditArea.Visible = false;
plListArea.Visible = true;
}
//栏目名称
spanColName.Visible = knsid > 0;
if (knsid != 0)
{
Song.Entities.KnowledgeSort col = Business.Do <IKnowledge>().SortSingle(knsid);
if (col != null)
{
lbColunms.Text = col.Kns_Name;
}
}
BindData(null, null);
}
}
/// <summary>
/// 添加栏目信息
/// </summary>
/// <param name="result"></param>
private void _Add(string result)
{
if (result == "" || result == null)
{
return;
}
XmlDocument resXml = new XmlDocument();
try
{
resXml.LoadXml(result, false);
XmlNode node = resXml.SelectSingleNode("node");
int id = Convert.ToInt32(((XmlElement)node).Attributes["id"].Value);
Song.Entities.KnowledgeSort nc = new Song.Entities.KnowledgeSort();
nc.Kns_Name = ((XmlElement)node.SelectSingleNode("name")).InnerText;
nc.Kns_ByName = ((XmlElement)node.SelectSingleNode("byname")).InnerText;
nc.Kns_PID = Convert.ToInt32(((XmlElement)node.SelectSingleNode("pid")).InnerText);
nc.Kns_Intro = ((XmlElement)node.SelectSingleNode("intro")).InnerText;
nc.Kns_IsUse = Convert.ToBoolean(((XmlElement)node.SelectSingleNode("IsUse")).InnerText);
//添加
Business.Do <IKnowledge>().SortAdd(nc);
}
catch
{
}
}
/// <summary>
/// 编辑当前数据项
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnEditEnter_Click(object sender, EventArgs e)
{
System.Web.UI.WebControls.Button btn = (System.Web.UI.WebControls.Button)sender;
int index = ((GridViewRow)(btn.Parent.Parent)).RowIndex;
int id = int.Parse(this.gvColumns.DataKeys[index].Value.ToString());
//
Song.Entities.KnowledgeSort col = Business.Do <IKnowledge>().SortSingle(id);
if (col != null)
{
//名称
TextBox tb = (TextBox)gvColumns.Rows[index].FindControl("tbTitle");
col.Kns_Name = tb.Text.Trim();
//父级
DropDownTree tree = (DropDownTree)gvColumns.Rows[index].FindControl("ddlColTree");
col.Kns_PID = Convert.ToInt32(tree.SelectedValue);
//是否可用
CheckBox cb = (CheckBox)gvColumns.Rows[index].FindControl("cbIsUse");
col.Kns_IsUse = cb.Checked;
//简介
TextBox tbintro = (TextBox)gvColumns.Rows[index].FindControl("tbIntro");
col.Kns_Intro = tbintro.Text.Trim();
//
Business.Do <IKnowledge>().SortSave(col);
}
gvColumns.EditIndex = -1;
BindData(null, null);
}
protected override void InitPageTemplate(HttpContext context)
{
if (Request.ServerVariables["REQUEST_METHOD"] == "GET")
{
Song.Entities.Course course = Business.Do <ICourse>().CourseSingle(couid);
//是否学习当前课程
if (this.Account != null)
{
//是否购买当前课程
bool isBuy = Business.Do <ICourse>().StudyIsCourse(this.Account.Ac_ID, course.Cou_ID);
this.Document.Variables.SetValue("isBuy", isBuy);
//是否可以学习,如果是免费或已经选修便可以学习，否则当前课程允许试用且当前章节是免费的，也可以学习
bool canStudy = isBuy || course.Cou_IsFree || course.Cou_IsLimitFree;
this.Document.Variables.SetValue("canStudy", canStudy);
}
//知识库栏目
Song.Entities.KnowledgeSort[] kns = Business.Do <IKnowledge>().GetSortAll(-1, couid, -1, true);
DataTable dt = WeiSha.WebControl.Tree.ObjectArrayToDataTable.To(kns);
WeiSha.WebControl.Tree.DataTableTree tree = new WeiSha.WebControl.Tree.DataTableTree();
tree.IdKeyName = "Kns_ID";
tree.ParentIdKeyName = "Kns_PID";
tree.TaxKeyName = "Kns_Tax";
tree.Root = 0;
dt = tree.BuilderTree(dt);
this.Document.Variables.SetValue("kns", dt);
this.Document.Variables.SetValue("couid", couid);
//当前知识库栏目
int sorts = WeiSha.Common.Request.QueryString["sorts"].Int32 ?? 0; //栏目分类id
Song.Entities.KnowledgeSort sort = Business.Do <IKnowledge>().SortSingle(sorts);
this.Document.Variables.SetValue("sort", sort);
}
//此页面的ajax提交，全部采用了POST方式
if (Request.ServerVariables["REQUEST_METHOD"] == "POST")
{
int size = WeiSha.Common.Request.Form["size"].Int32 ?? 10; //每页多少条
int index = WeiSha.Common.Request.Form["index"].Int32 ?? 1; //第几页
string sorts = WeiSha.Common.Request.Form["sorts"].String; //栏目分类id
string search = WeiSha.Common.Request.Form["sear"].String; //要检索的字符
int sumcount = 0;
//信息列表
Song.Entities.Knowledge[] kls = null;
kls = Business.Do <IKnowledge>().KnowledgePager(couid, sorts, search, size, index, out sumcount);
string json = "{\"size\":" + size + ",\"index\":" + index + ",\"sumcount\":" + sumcount + ",";
json += "\"items\":[";
for (int n = 0; n < kls.Length; n++)
{
json += kls[n].ToJson("Kn_ID,Kn_Title", "Kn_Details") + ",";
}
if (json.EndsWith(","))
{
json = json.Substring(0, json.Length - 1);
}
json += "]}";
Response.Write(json);
Response.End();
}
}
/// 修改是否使用的状态
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void sbUse_Click(object sender, EventArgs e)
{
StateButton ub = (StateButton)sender;
int index = ((GridViewRow)(ub.Parent.Parent)).RowIndex;
int id = int.Parse(this.gvColumns.DataKeys[index].Value.ToString());
//
Song.Entities.KnowledgeSort entity = Business.Do <IKnowledge>().SortSingle(id);
entity.Kns_IsUse = !entity.Kns_IsUse;
Business.Do <IKnowledge>().SortSave(entity);
BindData(null, null);
}
/// <summary>
/// 新增按钮
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnAddEnter_Click(object sender, EventArgs e)
{
Song.Entities.KnowledgeSort col = new Song.Entities.KnowledgeSort();
col.Kns_Name = tbTitle.Text.Trim();
col.Kns_PID = Convert.ToInt32(ddlTree.SelectedValue);
col.Cou_ID = couid;
col.Kns_Intro = tbIntro.Text.Trim();
col.Kns_IsUse = cbIsUse.Checked;
Business.Do <IKnowledge>().SortAdd(col);
BindData(null, null);
gvColumns.EditIndex = -1;
btnAddBack_Click(null, null);
}
public void SortSaveOrder(string xml)
{
using (DbTrans tran = Gateway.Default.BeginTrans())
{
try
{
XmlDocument resXml = new XmlDocument();
resXml.XmlResolver = null;
resXml.LoadXml(xml, false);
XmlNodeList nodeList = resXml.SelectSingleNode("nodes").ChildNodes;
//取rootid
XmlNode nodes = resXml.SelectSingleNode("nodes");
XmlElement xenodes = (XmlElement)nodes;
//遍历所有子节点
foreach (XmlNode xn in nodeList)
{
XmlElement xe = (XmlElement)xn;
int id = Convert.ToInt32(xe.Attributes["id"].Value);
int pid = Convert.ToInt32(xe.Attributes["pid"].Value);
int tax = Convert.ToInt32(xe.Attributes["tax"].Value);
Song.Entities.KnowledgeSort nc = this.SortSingle(id);
if (nc != null)
{
nc.Kns_PID = pid;
nc.Kns_Tax = tax;
tran.Save <KnowledgeSort>(nc);
}
}
tran.Commit();
}
catch (Exception ex)
{
tran.Rollback();
throw ex;
}
finally
{
tran.Close();
}
}
}