public int TagType_Add(TagTypeInfo info) { int rst = 0; try { OleDbParameter[] param = new OleDbParameter[4]; param[0] = new OleDbParameter("@ParentID", OleDbType.Integer); param[0].Value = info.ParentID; param[1] = new OleDbParameter("@Code", OleDbType.VarWChar, 20); param[1].Value = info.Code; param[2] = new OleDbParameter("@Title", OleDbType.VarWChar, 20); param[2].Value = info.Title; param[3] = new OleDbParameter("@Remark", OleDbType.VarWChar, 100); param[3].Value = info.Remark; string sql = "insert into Cm_TagType (ParentID,Code,Title,Remark) values (@ParentID,Code,@Title,@Remark)"; rst = DbHelper.ExecuteNonQuery(constring, CommandType.Text, sql, param); } catch (Exception ex) { rst = -1; } return(rst); }
public int TagType_Edit(TagTypeInfo info) { int rst = 0; try { OleDbParameter[] param = new OleDbParameter[4]; param[0] = new OleDbParameter("@Code", OleDbType.VarWChar, 20); param[0].Value = info.Code; param[1] = new OleDbParameter("@Title", OleDbType.VarWChar, 20); param[1].Value = info.Title; param[2] = new OleDbParameter("@Remark", OleDbType.VarWChar, 100); param[2].Value = info.Remark; param[3] = new OleDbParameter("@ID", OleDbType.VarWChar, 50); param[3].Value = info.ID; string sql = "update Cm_TagType set Code=@Code,Title=@Title,Remark=@Remark where ID=@ID"; rst = DbHelper.ExecuteNonQuery(constring, CommandType.Text, sql, param); } catch { rst = -1; } return(rst); }
/// <summary> /// 保存数据 /// </summary> private void SaveData() { TagTypeInfo info = new TagTypeInfo(); info.Code = tb_Code.Text.Trim(); info.Title = tb_Title.Text.Trim(); info.Remark = tb_Remark.Text.Trim(); if (info.Code == "") { MessageBox.Show("请输入编码。"); return; } if (info.Title == "") { MessageBox.Show("请输入名称。"); return; } int rst = -1; if (lb_ID.Text == "") { if (ParentInfo == null) { if (info.Code.Length != 3) { MessageBox.Show("请输入3位长度编码。"); return; } info.ParentID = 0; } else { if (info.Code.Length - ParentInfo.Code.Length != 3) { MessageBox.Show("请再输入3位长度编码。"); return; } info.ParentID = ParentInfo.ID; } rst = menuDal.TagType_Add(info); } else { info.ID = int.Parse(lb_ID.Text); rst = menuDal.TagType_Edit(info); } QueryData(); if (rst == 1) { MessageBox.Show("保存成功。"); } else { MessageBox.Show("保存失败。"); } }
public IList <TagTypeInfo> TagTypeByParentIDGetList(int ParentID) { IList <TagTypeInfo> ilist = new List <TagTypeInfo>(); DataTable dt = new DataTable(); OleDbParameter[] param = new OleDbParameter[1]; param[0] = new OleDbParameter("@ParentID", OleDbType.VarWChar, 20); param[0].Value = ParentID; string sql = "select * from Cm_TagType where ParentID=@ParentID order by ParentID,ID"; dt = DbHelper.ExecuteTable(constring, CommandType.Text, sql, param); for (int i = 0; i < dt.Rows.Count; i++) { TagTypeInfo info = new TagTypeInfo(); info.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); info.ParentID = int.Parse(dt.Rows[i]["ParentID"].ToString()); info.Code = dt.Rows[i]["Code"].ToString(); info.Title = dt.Rows[i]["Title"].ToString(); info.Remark = dt.Rows[i]["Remark"].ToString(); ilist.Add(info); } return(ilist); }
public override object RefreshCache() { string hql = "from TagTypeInfo t"; var list = TagTypeInfo.Execute(new HqlReadQuery <TagTypeInfo>(hql)) as IList <TagTypeInfo>; _dic = list.ToPerfectDictionary(t => t.TagTypeID); list.Clear(); return(null); }
/// <summary> /// 递归获取实体 /// </summary> /// <param name="ilist">节点</param> /// <param name="ninfo">实体</param> private void GetMenuInfo(IList <TagTypeInfo> ilist, TagTypeInfo ninfo) { ilist.Add(ninfo); var list = from tl in menuList where tl.ParentID == ninfo.ID select tl; foreach (TagTypeInfo info in list) { GetMenuInfo(ilist, info); } }
/// <summary> /// 递归获取目录节点 /// </summary> /// <param name="tn">节点</param> /// <param name="tinfo">实体</param> private void GetNode(TreeNode tn, TagTypeInfo tinfo) { var list = from tl in menuList where tl.ParentID == tinfo.ID select tl; foreach (TagTypeInfo info in list) { TreeNode tnode = new TreeNode(info.Title); GetNode(tnode, info); tnode.Tag = info; tn.Nodes.Add(tnode); } }
/// <summary> /// 显示菜单Treeview /// </summary> private void QueryMenu() { nodeid = 0; menuList = menuDal.TagTypeGetList(); TreeNode tn = new TreeNode("根目录"); TagTypeInfo info = new TagTypeInfo(); info.ID = 0; GetNode(tn, info); tn.ExpandAll(); tv_left.Nodes.Clear(); tv_left.Nodes.Add(tn); nodeMax1 = 0; TreeNodeCollection tnc = tv_left.Nodes; GetNodeNameMax(tnc); }
/// <summary> /// 递归获取数据实体 /// </summary> /// <param name="datalist">数据列表</param> /// <param name="ilist">返回数据列表</param> /// <param name="ninfo">实体</param> private void GetDataInfo(IList <TagInfo> datalist, IList <TagInfo> ilist, TagTypeInfo ninfo) { var dlist = from dl in datalist where dl.ParentID == ninfo.ID select dl; foreach (TagInfo dinfo in dlist) { ilist.Add(dinfo); } var list = from tl in menuList where tl.ParentID == ninfo.ID select tl; foreach (TagTypeInfo info in list) { GetDataInfo(datalist, ilist, info); } }
public IList <TagTypeInfo> TagTypeGetList() { IList <TagTypeInfo> ilist = new List <TagTypeInfo>(); DataTable dt = new DataTable(); string sql = "select * from Cm_TagType order by ParentID,ID"; dt = DbHelper.ExecuteTable(constring, CommandType.Text, sql, null); for (int i = 0; i < dt.Rows.Count; i++) { TagTypeInfo info = new TagTypeInfo(); info.ID = Convert.ToInt32(dt.Rows[i]["ID"].ToString()); info.ParentID = int.Parse(dt.Rows[i]["ParentID"].ToString()); info.Code = dt.Rows[i]["Code"].ToString(); info.Title = dt.Rows[i]["Title"].ToString(); info.Remark = dt.Rows[i]["Remark"].ToString(); ilist.Add(info); } return(ilist); }
public TagTypeInfo TagTypeGetInfo(int ID) { TagTypeInfo info = new TagTypeInfo(); DataTable dt = new DataTable(); OleDbParameter[] param = new OleDbParameter[1]; param[0] = new OleDbParameter("@ID", OleDbType.VarWChar, 20); param[0].Value = ID; string sql = "select * from Cm_TagType where ID=@ID"; dt = DbHelper.ExecuteTable(constring, CommandType.Text, sql, param); if (dt.Rows.Count > 0) { info.ID = Convert.ToInt32(dt.Rows[0]["ID"].ToString()); info.ParentID = int.Parse(dt.Rows[0]["ParentID"].ToString()); info.Code = dt.Rows[0]["Code"].ToString(); info.Title = dt.Rows[0]["Title"].ToString(); info.Remark = dt.Rows[0]["Remark"].ToString(); } return(info); }
private void tv_left_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { tv_left.SelectedNode = e.Node; if (tv_left.SelectedNode != null) { ClearInput(); if (tv_left.SelectedNode.Text == "根目录") { ParentInfo = null; lb_ParentTitle.Text = "根目录"; } else { TagTypeInfo info = tv_left.SelectedNode.Tag as TagTypeInfo; if (info != null) { ParentInfo = info; lb_ParentTitle.Text = info.Title; } } QueryData(); } }