public void MyBind()
{
if (Pid > 0)
{
PKnow_L.Text = knowBll.SelReturnModel(Pid).K_name;
}
if (NodeID > 0)//添加知识点
{
QuessClass_L.Text = classBll.GetSelect(NodeID).C_ClassName;
}
if (KnowID > 0)
{
M_Questions_Knowledge knowMod = knowBll.SelReturnModel(KnowID);
Name_T.Text = knowMod.K_name;
PKnow_L.Text = "无";
M_Questions_Knowledge parentMod = knowBll.SelReturnModel(knowMod.Pid);
if (parentMod != null)
{
PKnow_L.Text = knowBll.SelReturnModel(knowMod.Pid).K_name;
}
QuessClass_L.Text = classBll.GetSelect(knowMod.K_class_id).C_ClassName;
GradeList_Drop.SelectedValue = knowMod.Grade.ToString();
IsSyst_Check.Checked = knowMod.IsSys == 1;
Status_Check.Checked = knowMod.Status == 1;
OldName_Hid.Value = knowMod.K_name;
}
}
private SqlParameter[] GetParam(M_Questions_Knowledge mqk)
{
SqlParameter[] para = new SqlParameter[] {
new SqlParameter("@k_name", mqk.K_name),
new SqlParameter("@k_class_id", mqk.K_class_id),
new SqlParameter("@k_OrderBy", mqk.K_OrderBy),
new SqlParameter("@k_id", mqk.K_id)
};
return(para);
}
public ActionResult AddKnowledge()
{
int NodeID = DataConverter.CLng(Request.QueryString["nid"]);
if (NodeID > 0)
{
ViewBag.cname = classBll.GetSelect(NodeID).C_ClassName;
}
M_Questions_Knowledge knowMod = knowBll.SelReturnModel(Mid);
if (knowMod == null)
{
knowMod = new M_Questions_Knowledge();
}
ViewBag.gradelist = MVCHelper.ToSelectList(B_GradeOption.GetGradeList(6, 0), "GradeName", "GradeID", knowMod.Grade.ToString());
return(View(knowMod));
}
private List <M_Questions_Knowledge> GetKByds(DataSet ds)
{
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
List <M_Questions_Knowledge> mqks = new List <M_Questions_Knowledge>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
M_Questions_Knowledge mqk = new M_Questions_Knowledge();
mqk.K_id = DataConverter.CLng(dr["k_id"]);
mqk.K_name = dr["k_name"].ToString();
mqk.K_class_id = DataConverter.CLng(dr["k_class_id"]);
mqk.K_OrderBy = DataConverter.CLng(dr["k_orderBy"]);
mqks.Add(mqk);
}
return(mqks);
}
return(new List <M_Questions_Knowledge>());
}
public void Knowledge_Add()
{
M_Questions_Knowledge knowMod = knowBll.SelReturnModel(Mid);
if (knowMod == null)
{
knowMod = new M_Questions_Knowledge();
}
int NodeID = DataConverter.CLng(Request.QueryString["nid"]);
string name = Request.Form["K_name"].Trim();
if ((knowMod.K_id > 0 && !knowMod.K_name.Equals(name)) ||
knowMod.K_id <= 0)
{
DataTable tempdt = knowBll.SelByName(NodeID, name);
if (tempdt.Rows.Count > 0)
{
function.WriteErrMsg("同级下知识点名称不能重复!"); return;
}
}
knowMod.K_name = name;
knowMod.Status = string.IsNullOrEmpty(Request.Form["Status"]) ? 0 : 1;
knowMod.IsSys = string.IsNullOrEmpty(Request.Form["IsSys"]) ? 0 : 1;
knowMod.Grade = DataConverter.CLng(Request.Form["Grade"]);
knowMod.K_class_id = NodeID;
if (knowMod.K_id > 0)
{
knowBll.GetUpdate(knowMod);
}
else
{
knowMod.CUser = badmin.GetAdminLogin().AdminId;
knowMod.CDate = DateTime.Now;
knowBll.insert(knowMod);
}
function.WriteSuccessMsg("操作成功", "KnowledgeManage?nid=" + NodeID);
}
public IActionResult Knowledge_Add()
{
M_Questions_Knowledge knowMod = knowBll.SelReturnModel(Mid);
if (knowMod == null)
{
knowMod = new M_Questions_Knowledge();
}
int NodeID = DataConverter.CLng(RequestEx["nid"]);
string name = RequestEx["K_name"].Trim();
if ((knowMod.K_id > 0 && !knowMod.K_name.Equals(name)) ||
knowMod.K_id <= 0)
{
DataTable tempdt = knowBll.SelByName(NodeID, name);
if (tempdt.Rows.Count > 0)
{
return(WriteErr("同级下知识点名称不能重复!"));
}
}
knowMod.K_name = name;
knowMod.Status = string.IsNullOrEmpty(RequestEx["Status"]) ? 0 : 1;
knowMod.IsSys = string.IsNullOrEmpty(RequestEx["IsSys"]) ? 0 : 1;
knowMod.Grade = DataConverter.CLng(RequestEx["Grade"]);
knowMod.K_class_id = NodeID;
if (knowMod.K_id > 0)
{
knowBll.GetUpdate(knowMod);
}
else
{
knowMod.CUser = adminMod.AdminId;
knowMod.CDate = DateTime.Now;
knowBll.insert(knowMod);
}
return(WriteOK("操作成功", "KnowledgeManage?nid=" + NodeID));
}
protected void Save_Btn_Click(object sender, EventArgs e)
{
M_Questions_Knowledge knowMod = new M_Questions_Knowledge();
if (KnowID > 0)
{
knowMod = knowBll.SelReturnModel(KnowID);
}
knowMod.CDate = DateTime.Now;
knowMod.CUser = badmin.GetAdminLogin().AdminId;
string name = Name_T.Text.Replace(" ", "");//替换空格
knowMod.K_name = name;
knowMod.Status = Status_Check.Checked ? 1 : 0;
knowMod.IsSys = IsSyst_Check.Checked ? 1 : 0;
knowMod.Pid = KnowID > 0 ? knowMod.Pid : Pid;
knowMod.Grade = DataConverter.CLng(GradeList_Drop.SelectedValue);
knowMod.K_class_id = NodeID;
if (!OldName_Hid.Value.Equals(name))
{
DataTable tempdt = knowBll.SelByName(NodeID, Name_T.Text);
if (tempdt.Rows.Count > 0)
{
function.WriteErrMsg("同级下知识点名称不能重复!");
}
}
if (KnowID > 0)
{
knowMod.K_id = KnowID;
knowBll.GetUpdate(knowMod);
}
else
{
knowBll.insert(knowMod);
}
function.WriteSuccessMsg("操作成功!", "KnowledgeManage.aspx?nid=" + NodeID);
}
public int insert(M_Questions_Knowledge model)
{
return(DBCenter.Insert(model));
}
public bool GetUpdate(M_Questions_Knowledge model)
{
return(DBCenter.UpdateByID(model, model.K_id));
}
public int insert(M_Questions_Knowledge model)
{
return(Sql.insertID(strTableName, model.GetParameters(), BLLCommon.GetParas(model), BLLCommon.GetFields(model)));
}
public bool GetUpdate(M_Questions_Knowledge model)
{
return(Sql.UpdateByIDs(strTableName, PK, model.K_id.ToString(), BLLCommon.GetFieldAndPara(model), initMod.GetParameters()));
}