/// <summary> /// 新增大分类 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItemNewRoot_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //新增大分类的时候清空上次的值 ywk m_ItemCatalog = new ItemCatalog(m_app); m_ItemCatalog.BigOrSmallItem = "big"; m_ItemCatalog.CreateUser = m_app.User.Id; m_ItemCatalog.CanChangeFlag = true; m_ItemCatalog.SetContainerCodeEditFlag(true); m_ItemCatalog.SetIsPersonEditFlag(true); if (m_ItemCatalog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { string id = Guid.NewGuid().ToString(); //string createuser = ""; //if (m_ItemCatalog.IsPerson == "1")无论新增的是科室小模板还是个人小模板,都往数据库插入创建人 string createuser = m_app.User.Id; sqlHelper.ExecuteNoneQuery(string.Format(sql_insertCatalog, id, DS_Common.FilterSpecialCharacter(m_ItemCatalog.ITEMNAME), string.Empty, 1, DS_Common.FilterSpecialCharacter(m_ItemCatalog.Memo), m_app.User.CurrentDeptId, m_ItemCatalog.ContainerCode, m_ItemCatalog.IsPerson, DS_Common.FilterSpecialCharacter(createuser))); TreeListNode leafnode = treeList1.AppendNode(new object[] { id, m_ItemCatalog.ITEMNAME, "Folder", m_ItemCatalog.IsPerson, m_ItemCatalog.CreateUser, m_ItemCatalog.Memo, m_ItemCatalog.ContainerCode }, null); DataTable dt = sqlHelper.ExecuteDataTable("select * from emrtemplet_item_person_catalog where ID='" + id + "'"); if (null != dt && dt.Rows.Count > 0) { leafnode.Tag = dt.Rows[0]; } //if (treeList1.FocusedNode != null) // treeList1.FocusedNode.ExpandAll(); m_app.CustomMessageBox.MessageShow("新增成功"); treeList1.FocusedNode = leafnode; } catch (Exception EX) { m_app.CustomMessageBox.MessageShow(EX.Message); } } }
/// <summary> /// 修改分类操作 /// 当修改分类时,其分类下的具体模板也改掉 (分类为科室小模板,分类下模板也要更新掉) /// edit by ywk 2012年6月28日 13:29:46 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItemModified2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { if (treeList1.FocusedNode == null) { m_app.CustomMessageBox.MessageShow("请选择节点!"); return; } string nodeID = treeList1.FocusedNode.GetValue("ID").ToString(); string type = treeList1.FocusedNode.GetValue("NODETYPE").ToString(); string createUser = null == treeList1.FocusedNode.GetValue("createusers") ? "" : treeList1.FocusedNode.GetValue("createusers").ToString(); if (!type.Equals("Folder")) { m_app.CustomMessageBox.MessageShow("请选择分类节点!"); return; } DataRow drow = (DataRow)treeList1.FocusedNode.Tag; string isPerson = null == drow["isperson"] ? "" : drow["isperson"].ToString(); //只有创建者可以修改 by cyq2012-09-27 string msg = GetMsgIfNotCreateUser(nodeID, createUser, 0, 0, int.Parse(isPerson)); if (!string.IsNullOrEmpty(msg)) { m_app.CustomMessageBox.MessageShow(msg); return; } string containerCode = null == drow["container"] ? "" : drow["container"].ToString(); m_ItemCatalog.ITEMNAME = null == drow["Name"] ? "" : drow["Name"].ToString(); m_ItemCatalog.Memo = null == drow["memo"] ? "" : drow["memo"].ToString(); m_ItemCatalog.ContainerCode = containerCode; m_ItemCatalog.IsPerson = isPerson; m_ItemCatalog.CreateUser = null == drow["createusers"] ? "" : drow["createusers"].ToString(); //小分类的适应文件夹和模板类型不可修改 m_ItemCatalog.SetContainerCodeEditFlag(treeList1.FocusedNode.Level == 0 && !treeList1.FocusedNode.HasChildren); m_ItemCatalog.SetIsPersonEditFlag(treeList1.FocusedNode.Level == 0 && !treeList1.FocusedNode.HasChildren); //m_ItemCatalog.CanChangeFlag = !(treeList1.FocusedNode.Level == 0 && treeList1.FocusedNode.HasChildren); if (m_ItemCatalog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { if (treeList1.FocusedNode.HasChildren && !m_ItemCatalog.ContainerCode.Equals(containerCode)) { m_app.CustomMessageBox.MessageShow("该分类包含子集,不可修改适应病历夹"); m_ItemCatalog.ContainerCode = containerCode; return; } if (treeList1.FocusedNode.HasChildren && !m_ItemCatalog.IsPerson.Equals(isPerson)) { m_app.CustomMessageBox.MessageShow("该分类包含子集,不可修改模板类型"); m_ItemCatalog.IsPerson = isPerson; return; } //更新了emrtemplet_item_person_catalog sqlHelper.ExecuteNoneQuery(string.Format(sql_updateItem, nodeID, m_ItemCatalog.ITEMNAME, m_ItemCatalog.Memo, m_ItemCatalog.ContainerCode, m_ItemCatalog.IsPerson)); PersonItemManager_Load(null, null); m_app.CustomMessageBox.MessageShow("修改成功"); TreeListNode leafnode = treeList1.FindNodeByKeyID(nodeID); treeList1.FocusedNode = leafnode; } catch (Exception EX) { m_app.CustomMessageBox.MessageShow(EX.Message); } } }
/// <summary> /// 新增子分类 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void barButtonItemNew2_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { //新增子分类的时候清空上次的值 ywk m_ItemCatalog = new ItemCatalog(m_app); if (treeList1.FocusedNode == null) { m_app.CustomMessageBox.MessageShow("请选择父节点"); return; } if (!treeList1.FocusedNode.GetValue("NODETYPE").ToString().Equals("Folder")) { m_app.CustomMessageBox.MessageShow("请选择分类节点"); return; } string parentID = treeList1.FocusedNode.GetValue("ID").ToString(); string isPerson = treeList1.FocusedNode.GetValue("ISPERSON").ToString(); //分类权限控制 string msg = GetMsgIfNotCreateUser(parentID, null == treeList1.FocusedNode.GetValue("createusers") ? "" : treeList1.FocusedNode.GetValue("createusers").ToString(), 0, 2, int.Parse(isPerson)); if (!string.IsNullOrEmpty(msg)) { m_app.CustomMessageBox.MessageShow(msg); return; } m_ItemCatalog.IsPerson = isPerson; m_ItemCatalog.CreateUser = m_app.User.Id; //treeList1.FocusedNode.GetValue("CREATEUSER").ToString(); m_ItemCatalog.BigOrSmallItem = "small"; string containerCode = null == treeList1.FocusedNode.GetValue("CONTAINER") ? "" : treeList1.FocusedNode.GetValue("CONTAINER").ToString(); if (string.IsNullOrEmpty(containerCode)) { DataRow drow = (DataRow)treeList1.FocusedNode.Tag; containerCode = null == drow ? "" : (null == drow["CONTAINER"] ? "" : drow["CONTAINER"].ToString()); if (string.IsNullOrEmpty(containerCode)) { DataTable dt = m_app.SqlHelper.ExecuteDataTable(" select * from emrtemplet_item_person_catalog where id='" + parentID + "'"); if (null != dt && dt.Rows.Count > 0) { containerCode = null == dt.Rows[0]["CONTAINER"] ? "" : dt.Rows[0]["CONTAINER"].ToString(); } } } m_ItemCatalog.ContainerCode = containerCode; m_ItemCatalog.SetContainerCodeEditFlag(false); m_ItemCatalog.SetIsPersonEditFlag(false); if (m_ItemCatalog.ShowDialog() == System.Windows.Forms.DialogResult.OK) { try { string id = Guid.NewGuid().ToString(); //string createuser = ""; //if (m_ItemCatalog.IsPerson == "1") // createuser = m_app.User.Id; //无论科室小模板还是个人小模板都插入创建人 string createuser = m_app.User.Id; sqlHelper.ExecuteNoneQuery(string.Format(sql_insertCatalog, id, DS_Common.FilterSpecialCharacter(m_ItemCatalog.ITEMNAME), parentID, 1, DS_Common.FilterSpecialCharacter(m_ItemCatalog.Memo), m_app.User.CurrentDeptId, m_ItemCatalog.ContainerCode, m_ItemCatalog.IsPerson, DS_Common.FilterSpecialCharacter(createuser))); TreeListNode leafnode = treeList1.AppendNode(new object[] { id, m_ItemCatalog.ITEMNAME, "Folder", m_ItemCatalog.IsPerson, m_ItemCatalog.CreateUser, m_ItemCatalog.Memo, m_ItemCatalog.ContainerCode }, treeList1.FocusedNode); DataTable dt = sqlHelper.ExecuteDataTable("select * from emrtemplet_item_person_catalog where ID='" + id + "'"); if (null != dt && dt.Rows.Count > 0) { leafnode.Tag = dt.Rows[0]; } m_app.CustomMessageBox.MessageShow("新增成功"); //if (treeList1.FocusedNode != null) // treeList1.FocusedNode.ExpandAll(); treeList1.FocusedNode = leafnode; } catch (Exception EX) { m_app.CustomMessageBox.MessageShow(EX.Message); } } }