public static string GetDataList(string Name, string GradeTerm, string Subject, string Resource_Version, string Book_Type, int PageIndex, int PageSize) { try { BLL_S_KnowledgePoint bll = new BLL_S_KnowledgePoint(); DataTable dt = new DataTable(); List <object> listReturn = new List <object>(); string strWhere = " Parent_Id='0' "; if (!string.IsNullOrEmpty(Name)) { strWhere += " and (KPName like '%" + Name.Filter() + "%' or KPCode like '%" + Name.Filter() + "%') "; } if (!string.IsNullOrEmpty(GradeTerm)) { strWhere += " and GradeTerm='" + GradeTerm.Filter() + "' "; } if (!string.IsNullOrEmpty(Subject)) { strWhere += " and Subject='" + Subject.Filter() + "' "; } if (!string.IsNullOrEmpty(Resource_Version)) { strWhere += " and Resource_Version='" + Resource_Version.Filter() + "' "; } if (!string.IsNullOrEmpty(Book_Type)) { strWhere += " and Book_Type='" + Book_Type.Filter() + "' "; } dt = bll.GetListByPageJoinDict(strWhere, "KPCode", ((PageIndex - 1) * PageSize + 1), (PageIndex * PageSize)).Tables[0]; int rCount = bll.GetRecordCount(strWhere); DataTable dtAll = bll.GetList(" ").Tables[0]; for (int i = 0; i < dt.Rows.Count; i++) { DataRow[] drSub = dtAll.Select("Parent_Id='" + dt.Rows[i]["S_KnowledgePoint_Id"].ToString() + "'"); listReturn.Add(new { S_KnowledgePoint_Id = dt.Rows[i]["S_KnowledgePoint_Id"].ToString(), Parent_Id = dt.Rows[i]["Parent_Id"].ToString().Trim(), KPName = string.IsNullOrEmpty(dt.Rows[i]["KPNameBasic"].ToString()) ? dt.Rows[i]["KPName"].ToString() : dt.Rows[i]["KPNameBasic"].ToString(), KPCode = dt.Rows[i]["KPCode"].ToString(), KPLevel = dt.Rows[i]["KPLevel"].ToString(), KPLevelName = dt.Rows[i]["KPLevelName"].ToString(), IsLast = dt.Rows[i]["IsLast"].ToString(), parentIdStr = "", paddingLeft = "", hasChildren = drSub.Length }); } if (dt.Rows.Count > 0) { return(JsonConvert.SerializeObject(new { err = "null", PageIndex = PageIndex, PageSize = PageSize, TotalCount = rCount, list = listReturn })); } else { return(JsonConvert.SerializeObject(new { err = "暂无数据" })); } } catch (Exception ex) { return(JsonConvert.SerializeObject(new { err = ex.Message.ToString() })); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(kpId)) { #region 添加 //验证KPCode是否已存在 string strWhereCount = " KPCode='" + txtKPCode.Text.Trim() + "' and GradeTerm='" + GradeTerm + "' and Subject='" + Subject + "' and Syllabus='" + Syllabus + "' and Test_Category='" + Exam_Type + "' and Data_Type='3'"; if (bll.GetRecordCount(strWhereCount) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('编码已存在。', { time: 2000, icon: 4})</script>"); return; } model.S_KnowledgePoint_Id = Guid.NewGuid().ToString(); model.Data_Type = "3"; model.GradeTerm = GradeTerm; model.Subject = Subject; model.Syllabus = Syllabus; model.Test_Category = Exam_Type; model.Parent_Id = parentId; model.KPName = txtKPName.Text.Trim(); model.KPCode = txtKPCode.Text.Trim(); model.KPLevel = ddlKPLevel.SelectedValue; model.Importance = hidImportance.Value; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; if (bll.Add(model)) { if (parentId == "0") { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadSubData2('0');parent.layer.close(index)});</script>"); return; } } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增失败!',{ time: 2000,icon:2});</script>"); return; } Rc.Common.SystemLog.SystemLog.AddLogFromBS(loginUser.SysUser_ID, "", "新增同步知识点"); #endregion } else { #region 修改 model = bll.GetModel(kpId); model.Data_Type = "3"; model.KPName = txtKPName.Text.Trim(); model.KPCode = txtKPCode.Text.Trim(); model.KPLevel = ddlKPLevel.SelectedValue; model.UpdateTime = DateTime.Now; model.UpdateUser = loginUser.SysUser_ID; if (bll.Update(model)) { if (parentId == "0") { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadSubData2('0');parent.layer.close(index);});</script>"); } } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败!',{ time: 2000,icon:2});</script>"); return; } Rc.Common.SystemLog.SystemLog.AddLogFromBS(loginUser.SysUser_ID, "", "修改同步知识点"); #endregion } } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('操作失败!',{ time: 2000,icon:2});});</script>"); } }
protected void btnSave_Click(object sender, EventArgs e) { try { bool flag = false; Model_S_KnowledgePoint model = new Model_S_KnowledgePoint(); if (string.IsNullOrEmpty(kpId)) { #region 添加 #region 验证KPCode是否已存在 string strWhereCount = " KPCode='" + txtKPCode.Text.Trim() + "' and GradeTerm='" + GradeTerm + "' and Subject='" + Subject + "' and Resource_Version='" + Resource_Version + "' and Book_Type='" + Book_Type + "'"; if (bll.GetRecordCount(strWhereCount) > 0) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script>layer.msg('编码已存在。', { time: 2000, icon: 4})</script>"); return; } #endregion if (rbtIsLast0.Checked || (rbtIsLast1.Checked && !string.IsNullOrEmpty(hidKPNameBasic_Id.Value))) { #region 是最后一级 或 是最后一级且基本知识点已存在 #region 知识点数据表 model.S_KnowledgePoint_Id = Guid.NewGuid().ToString(); model.GradeTerm = GradeTerm; model.Subject = Subject; model.Resource_Version = Resource_Version; model.Book_Type = Book_Type; model.Parent_Id = parentId; model.IsLast = "0"; model.S_KnowledgePointBasic_Id = ""; model.KPName = txtKPName.Text.Trim(); if (rbtIsLast1.Checked)//是最后一级 { model.IsLast = "1"; model.S_KnowledgePointBasic_Id = hidKPNameBasic_Id.Value; model.KPName = ""; } model.KPCode = txtKPCode.Text.Trim(); model.KPLevel = ddlKPLevel.SelectedValue; model.Cognitive_Level = ddlCognitive_Level.SelectedValue; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; flag = bll.Add(model); #endregion #endregion } else { #region 是最后一级 且 基本知识点不存在 #region 基本知识点表 Model_S_KnowledgePointBasic modelBasic = new Model_S_KnowledgePointBasic(); string S_KnowledgePointBasic_Id = Guid.NewGuid().ToString(); modelBasic.S_KnowledgePointBasic_Id = S_KnowledgePointBasic_Id; modelBasic.GradeTerm = GradeTerm; modelBasic.Subject = Subject; modelBasic.KPNameBasic = hidKPNameBasic.Value.Trim(); modelBasic.CreateTime = DateTime.Now; modelBasic.CreateUser = loginUser.SysUser_ID; #endregion #region 知识点数据表 model.S_KnowledgePoint_Id = Guid.NewGuid().ToString(); model.GradeTerm = GradeTerm; model.Subject = Subject; model.Resource_Version = Resource_Version; model.Book_Type = Book_Type; model.Parent_Id = parentId; model.IsLast = "1"; model.S_KnowledgePointBasic_Id = S_KnowledgePointBasic_Id; model.KPName = ""; model.KPCode = txtKPCode.Text.Trim(); model.KPLevel = ddlKPLevel.SelectedValue; model.Cognitive_Level = ddlCognitive_Level.SelectedValue; model.CreateTime = DateTime.Now; model.CreateUser = loginUser.SysUser_ID; #endregion flag = bll.AddBasic(model, modelBasic); #endregion } if (flag) { if (parentId == "0") { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增成功!',{ time: 2000,icon:1},function(){parent.loadSubData2('0');parent.layer.close(index)});</script>"); return; } } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('新增失败!',{ time: 2000,icon:2});</script>"); return; } Rc.Common.SystemLog.SystemLog.AddLogFromBS(loginUser.SysUser_ID, "", "新增同步知识点"); #endregion } else { #region 修改 if (rbtIsLast0.Checked || (rbtIsLast1.Checked && !string.IsNullOrEmpty(hidKPNameBasic_Id.Value))) { #region 是最后一级 或 是最后一级且基本知识点已存在 #region 知识点数据表 model = bll.GetModel(kpId); model.IsLast = "0"; model.S_KnowledgePointBasic_Id = ""; model.KPName = txtKPName.Text.Trim(); if (rbtIsLast1.Checked)//是最后一级 { model.IsLast = "1"; model.S_KnowledgePointBasic_Id = hidKPNameBasic_Id.Value; model.KPName = ""; } model.KPCode = txtKPCode.Text.Trim(); model.KPLevel = ddlKPLevel.SelectedValue; model.Cognitive_Level = ddlCognitive_Level.SelectedValue; model.UpdateTime = DateTime.Now; model.UpdateUser = loginUser.SysUser_ID; flag = bll.Update(model); #endregion #endregion } else { #region 是最后一级 且 基本知识点不存在 model = bll.GetModel(kpId); #region 基本知识点表 Model_S_KnowledgePointBasic modelBasic = new Model_S_KnowledgePointBasic(); string S_KnowledgePointBasic_Id = Guid.NewGuid().ToString(); modelBasic.S_KnowledgePointBasic_Id = S_KnowledgePointBasic_Id; modelBasic.GradeTerm = model.GradeTerm; modelBasic.Subject = model.Subject; modelBasic.KPNameBasic = hidKPNameBasic.Value.Trim(); modelBasic.CreateTime = DateTime.Now; modelBasic.CreateUser = loginUser.SysUser_ID; #endregion #region 知识点数据表 model.IsLast = "1"; model.S_KnowledgePointBasic_Id = S_KnowledgePointBasic_Id; model.KPName = ""; model.KPCode = txtKPCode.Text.Trim(); model.KPLevel = ddlKPLevel.SelectedValue; model.Cognitive_Level = ddlCognitive_Level.SelectedValue; model.UpdateTime = DateTime.Now; model.UpdateUser = loginUser.SysUser_ID; #endregion flag = bll.UpdateBasic(model, modelBasic); #endregion } if (flag) { if (parentId == "0") { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadData();parent.layer.close(index);});</script>"); } else { ClientScript.RegisterStartupScript(this.GetType(), "update", "<script type='text/javascript'>layer.msg('修改成功!',{ time: 2000,icon:1},function(){parent.loadSubData2('0');parent.layer.close(index);});</script>"); } } else { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.msg('修改失败!',{ time: 2000,icon:2});</script>"); return; } Rc.Common.SystemLog.SystemLog.AddLogFromBS(loginUser.SysUser_ID, "", "修改同步知识点"); #endregion } } catch (Exception) { ClientScript.RegisterStartupScript(this.GetType(), "save", "<script type='text/javascript'>layer.ready(function(){layer.msg('操作失败!',{ time: 2000,icon:2});});</script>"); } }