public void DeleteKnowledgeCategoryAndChildren(string RequestKCID, out string msg)
{
msg = string.Empty;
int kcid;
Entities.KnowledgeCategory model = new Entities.KnowledgeCategory();
if (int.TryParse(RequestKCID, out kcid))
{
model.KCID = kcid;
string kcids = GetChildrenKnowledgeCategoryKCIDS(RequestKCID);
int count = Dal.KnowledgeCategory.Instance.GetNotDelStatusNum(kcids);
if (count > 0)
{
msg = "{msg:'该分类或该分类的子分类在知识库中有使用，无法删除，请尝试分步删除！'}";
}
else
{
Dal.KnowledgeCategory.Instance.DeleteKnowledgeCategoryAndChildren(kcids, out msg);
}
}
else
{
msg = "{msg:'参数类型错误！'}";
}
}
private Entities.KnowledgeCategory LoadSingleKnowledgeCategory(DataRow row)
{
Entities.KnowledgeCategory model = new Entities.KnowledgeCategory();
if (row["KCID"].ToString() != "")
{
model.KCID = int.Parse(row["KCID"].ToString());
}
model.Name = row["Name"].ToString();
if (row["Level"].ToString() != "")
{
model.Level = int.Parse(row["Level"].ToString());
}
if (row["Pid"].ToString() != "")
{
model.Pid = int.Parse(row["Pid"].ToString());
}
if (row["Status"].ToString() != "")
{
model.Status = int.Parse(row["Status"].ToString());
}
if (row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["CreateUserID"].ToString() != "")
{
model.CreateUserID = int.Parse(row["CreateUserID"].ToString());
}
return(model);
}
private void BindKnowledgeInfo()
{
Entities.KnowledgeLib model = BLL.KnowledgeLib.Instance.GetKnowledgeLib(long.Parse(KID));
if (model != null)
{
this.txtTitle.Value = model.Title;
// this.txtContext.Value = BLL.Util.HtmlDiscode(model.Content);
this.FCKeditor1.Value = BLL.KnowledgeLib.Instance.GetKnowledgeHtml(long.Parse(KID));
this.txtAbstract.Value = model.Abstract;
status = model.Status.ToString();;
#region 知识点级别
Entities.KnowledgeCategory category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(model.KCID.ToString()));
if (category != null)
{
Level = category.Level.ToString();
if (Level == "3")
{
Level3ID = category.KCID.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level2ID = category.KCID.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1ID = category.KCID.ToString();
}
}
}
else if (Level == "2")
{
Level2ID = category.KCID.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1ID = category.KCID.ToString();
}
}
else if (Level == "1")
{
Level1ID = category.KCID.ToString();
}
KCID = model.KCID.ToString();
}
#endregion
}
}
public int UpdateKnowledgeCategoryStatus(Entities.KnowledgeCategory model)
{
int count = 0;
string strSelect = "update KnowledgeCategory set Status='" + model.Status + "' WHERE kcid='" + model.KCID + "' ";
using (SqlConnection conn = new SqlConnection(CONNECTIONSTRINGS))
{
conn.Open();
SqlCommand comm = new SqlCommand(strSelect, conn);
count = comm.ExecuteNonQuery();
}
return(count);
}
//分类
public string getCategory(string kcid)
{
string categoryStr = string.Empty;
int _kcid;
if (int.TryParse(kcid, out _kcid))
{
Entities.KnowledgeCategory model = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(_kcid);
if (model != null)
{
categoryStr = model.Name;
}
}
return(categoryStr);
}
/// <summary>
/// 根据分类Id更新指定的分类信息
/// </summary>
/// <param name="RequestName">分类名称</param>
/// <param name="RequestKCID">分类Id</param>
/// <param name="msg"></param>
public void UpdateKnowledgeCategory(string RequestName, string RequestKCID, out string msg)
{
msg = string.Empty;
int kcid;
Entities.KnowledgeCategory model = new Entities.KnowledgeCategory();
model.Name = RequestName;
if (int.TryParse(RequestKCID, out kcid))
{
model.KCID = kcid;
Dal.KnowledgeCategory.Instance.UpdateKnowledgeCategory(model, out msg);
}
else
{
msg = "{msg:'参数类型错误！'}";
}
}
public void UpdateKnowledgeCategory(Entities.KnowledgeCategory model, out string msg)
{
int count = 0;
string strSelect = "update KnowledgeCategory set name = '" + StringHelper.SqlFilter(model.Name) + "' WHERE kcid='" + model.KCID + "' ";
using (SqlConnection conn = new SqlConnection(CONNECTIONSTRINGS))
{
conn.Open();
SqlCommand comm = new SqlCommand(strSelect, conn);
count = comm.ExecuteNonQuery();
}
if (count > 0)
{
msg = "{msg:'操作成功！'}";
}
else
{
msg = "{msg:'操作失败！'}";
}
}
public void InsertKnowledgeCategory(Entities.KnowledgeCategory model, out string msg)
{
int count = 0;
string strSelect = "INSERT INTO KnowledgeCategory (Name,Level,Pid,RegionID) VALUES ('" + StringHelper.SqlFilter(model.Name) + "','" + model.Level + "','" + model.Pid + "','" + model.Regionid + "')";
using (SqlConnection conn = new SqlConnection(CONNECTIONSTRINGS))
{
conn.Open();
SqlCommand comm = new SqlCommand(strSelect, conn);
count = comm.ExecuteNonQuery();
}
if (count > 0)
{
msg = "{msg:'操作成功！'}";
}
else
{
msg = "{msg:'操作失败！'}";
}
}
public int GetCountTheKnowledgeCategoryUsed(Entities.KnowledgeCategory model)
{
object count = 0;
string strSelect = "SELECT COUNT(1) FROM KnowledgeLib WHERE kcid='" + model.KCID + "' ";
using (SqlConnection conn = new SqlConnection(CONNECTIONSTRINGS))
{
conn.Open();
SqlCommand comm = new SqlCommand(strSelect, conn);
count = comm.ExecuteScalar();
}
if (count != null)
{
return(Convert.ToInt32(count));
}
else
{
return(0);
}
}
/// <summary>
/// 添加新的分类信息
/// </summary>
/// <param name="RequestName">分类名称</param>
/// <param name="RequestKCID">父类Id</param>
/// <param name="RequestLevel">分类级别</param>
/// <param name="msg">输出信息</param>
public void InsertKnowledgeCategory(string RequestName, string RequestKCID, string RequestLevel, int Regionid, out string msg)
{
msg = string.Empty;
int kcid;
int level;
Entities.KnowledgeCategory model = new Entities.KnowledgeCategory();
model.Name = RequestName;
if (int.TryParse(RequestKCID, out kcid) && int.TryParse(RequestLevel, out level))
{
model.Pid = kcid;
model.Level = level;
model.Regionid = Regionid;
Dal.KnowledgeCategory.Instance.InsertKnowledgeCategory(model, out msg);
}
else
{
msg = "{msg:'参数类型错误！'}";
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KnowledgeCategory model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KCID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@Level", SqlDbType.Int, 4),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Value = model.KCID;
parameters[1].Value = model.Name;
parameters[2].Value = model.Level;
parameters[3].Value = model.Pid;
parameters[4].Value = model.Status;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
return(SqlHelper.ExecuteNonQuery(sqltran, CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KNOWLEDGECATEGORY_UPDATE, parameters));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.KnowledgeCategory model)
{
SqlParameter[] parameters =
{
new SqlParameter("@KCID", SqlDbType.Int, 4),
new SqlParameter("@Name", SqlDbType.NVarChar, 100),
new SqlParameter("@Level", SqlDbType.Int, 4),
new SqlParameter("@Pid", SqlDbType.Int, 4),
new SqlParameter("@Status", SqlDbType.Int, 4),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@CreateUserID", SqlDbType.Int, 4)
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.Name;
parameters[2].Value = model.Level;
parameters[3].Value = model.Pid;
parameters[4].Value = model.Status;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.CreateUserID;
SqlHelper.ExecuteNonQuery(CONNECTIONSTRINGS, CommandType.StoredProcedure, P_KNOWLEDGECATEGORY_INSERT, parameters);
return((int)parameters[0].Value);
}
/// <summary>
/// 根据分类id逻辑删除分类（如果该分类已经被使用，则不能删除）
/// </summary>
/// <param name="RequestKCID">分类id</param>
/// <param name="msg">输出信息</param>
public void DeleteKnowledgeCategory(string RequestKCID, out string msg)
{
msg = string.Empty;
int kcid;
Entities.KnowledgeCategory model = new Entities.KnowledgeCategory();
if (int.TryParse(RequestKCID, out kcid))
{
model.KCID = kcid;
int count = Dal.KnowledgeCategory.Instance.GetCountTheKnowledgeCategoryUsed(model);
if (count > 0)
{
msg = "{msg:'该类别在知识库中有使用，无法删除！'}";
}
else
{
Dal.KnowledgeCategory.Instance.DeleteKnowledgeCategory(model, out msg);
}
}
else
{
msg = "{msg:'参数类型错误！'}";
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(Entities.KnowledgeCategory model)
{
return(Dal.KnowledgeCategory.Instance.Update(model));
}
/// <summary>
/// 更新知识库类别状态
/// </summary>
/// <param name="RequestKCID">类别id</param>
/// <param name="msg">输出信息</param>
public void ChangeKnowledgeCategoryStatus(string RequestKCID, out string msg)
{
msg = string.Empty;
int kcid = 0;
if (int.TryParse(RequestKCID, out kcid))
{
#region 通过实体进行操作
//Entities.KnowledgeCategory model = GetKnowledgeCategory(kcid);
//if (model != null)
//{
// if (model.Status == 0)//正在使用
// {
// model.Status = 1;
// }
// else if (model.Status == 1) //已经停用
// {
// model.Status = 0;
// }
// int result = 0;
// try
// {
// result = Dal.KnowledgeCategory.Instance.UpdateKnowledgeCategoryStatus(model);
// if (result > 0)
// {
// msg = "{msg:'success'}";
// }
// else
// {
// msg = "{msg:'操作失败！'}";
// }
// }
// catch (Exception ex)
// {
// msg = "{msg:'" + ex.Message + "'}";
// }
//}
#endregion
int status = Dal.KnowledgeCategory.Instance.GetKnowledgeCategoryStatusByKCID(kcid);
if (status != -5)
{
Entities.KnowledgeCategory model = new Entities.KnowledgeCategory();
model.KCID = kcid;
if (status == 0)//正在使用
{
model.Status = 1;
}
else if (status == 1) //已经停用
{
model.Status = 0;
}
int result = 0;
try
{
result = Dal.KnowledgeCategory.Instance.UpdateKnowledgeCategoryStatus(model);
if (result > 0)
{
msg = "{msg:'success'}";
}
else
{
msg = "{msg:'操作失败！'}";
}
}
catch (Exception ex)
{
msg = "{msg:'" + ex.Message + "'}";
}
}
else
{
msg = "{msg:'未找到指定类别！'}";
}
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public int Update(SqlTransaction sqltran, Entities.KnowledgeCategory model)
{
return(Dal.KnowledgeCategory.Instance.Update(sqltran, model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Insert(Entities.KnowledgeCategory model)
{
return(Dal.KnowledgeCategory.Instance.Insert(model));
}
private void BindKnowledgeInfo()
{
Entities.KnowledgeLib model = BLL.KnowledgeLib.Instance.GetKnowledgeLib(long.Parse(KID));
if (model != null)
{
FileUrl = model.FileUrl == null ? "" : "/upload/" + (BLL.Util.GetUploadProject(BLL.Util.ProjectTypePath.KnowledgeLib) + model.FileUrl).Replace("\\", "/");
lbCreateTime.Text = model.CreateTime.Value.ToString("yyyy-M-d");
lbClickCount.Text = model.ClickCount < 0 ? "0" : model.ClickCount.ToString();
lbDownCount.Text = model.DownLoadCount < 0 ? "0" : model.DownLoadCount.ToString();
hdAbs.Value = string.IsNullOrEmpty(model.Abstract) ? "" : model.Abstract;
this.txtTitle.InnerText = model.Title;
try
{
this.txtContext.InnerHtml = BLL.KnowledgeLib.Instance.GetKnowledgeHtml(long.Parse(KID));
blIsContentEmpty = string.IsNullOrEmpty(this.txtContext.InnerHtml);
}
catch
{
}
//给摘要赋值
Entities.KnowledgeCategory categortyModel = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(model.KCID.ToString()));
if (model.UploadFileCount > 0)
{
IsHaveFiles = "1";
}
#region 知识点级别
Entities.KnowledgeCategory category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(model.KCID.ToString()));
if (category != null)
{
//lbC.Text = category.Name;
Level = category.Level.ToString();
if (Level == "3")
{
Level3Name = category.Name.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level2Name = category.Name.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1Name = category.Name.ToString();
}
}
}
else if (Level == "2")
{
Level2Name = category.Name.ToString();
category = BLL.KnowledgeCategory.Instance.GetKnowledgeCategory(int.Parse(category.Pid.ToString()));
if (category != null)
{
Level1Name = category.Name.ToString();
}
}
else if (Level == "1")
{
Level1Name = category.Name.ToString();
}
}
lbC.Text = Level1Name + "--" + Level2Name;
/*
* string catageName = "";
*
*
* if (Level3Name != "")
* {
* catageName = Level3Name;
* }
* else if (Level2Name != "")
* {
* catageName = Level2Name;
* }
* else if (Level1Name != "")
* {
* catageName = Level1Name;
* }
*/
//this.txtCategory.InnerHtml = DateTime.Parse(model.CreateTime.ToString()).ToString("yyyy-MM-dd") + " " + catageName;
#endregion
}
}
