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 } }