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();
}
}
