private int AddGroupsRecursion(TreeNode parent, Neusoft.HISFC.Models.Fee.ComGroup group) { ArrayList al = this.grpMgr.GetGroupsByDeptParent("1", group.deptCode, group.ID); if (al.Count == 0) { TreeNode newNode = new TreeNode(); newNode.Tag = group; newNode.Text = group.Name + "[" + group.ID + "]"; parent.Nodes.Add(newNode); return(-1); } else { foreach (Neusoft.HISFC.Models.Fee.ComGroup item in al) { //if (item.ID == "aaa") //{ // MessageBox.Show("aaa"); //} TreeNode newNode = new TreeNode(); newNode.Tag = group; newNode.Text = group.Name + "[" + group.ID + "]"; parent.Nodes.Add(newNode); return(this.AddGroupsRecursion(newNode, item)); } } return(1); }
/// <summary> /// 查询指定科室手术模板组套 /// </summary> /// <param name="DeptID">科室编码</param> /// <returns>组套对象列表</returns> public ArrayList GetOpsTreeComGroup(string DeptID) { ArrayList List = null; string strSql = ""; if (this.Sql.GetSql("Manager.ComGroup.GetOpsTreeComGroup", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, DeptID); try { this.ExecQuery(strSql); List = new ArrayList(); while (this.Reader.Read()) { Neusoft.HISFC.Models.Fee.ComGroup info = new Neusoft.HISFC.Models.Fee.ComGroup(); info.deptCode = Reader[0].ToString(); info.ID = Reader[1].ToString(); info.Name = Reader[2].ToString(); List.Add(info); } Reader.Close(); } catch (Exception ee) { this.Err = "Manager.ComGroup.GetOpsTreeComGroup"; this.ErrCode = ee.Message; this.WriteErr(); return(null); } return(List); }
public int DeleteComGroup(Neusoft.HISFC.Models.Fee.ComGroup com) { string strSql = ""; try { //delete fin_com_group where group_id = '{0}' if (this.Sql.GetSql("Manager.ComGroup.DeleteComGroup", ref strSql) == -1) { return(-1); } strSql = string.Format(strSql, com.ID); if (this.ExecNoQuery(strSql) == -1) { return(-1); } } catch (Exception ee) { this.Err = ee.Message; WriteErr(); return(-1); } return(0); }
/// <summary> /// 根据组套名称组套编码科室编码 /// </summary> /// <param name="groupName"></param> /// <param name="groupID"></param> /// <param name="deptID"></param> /// <returns></returns> public ArrayList QueryGroupsByName(string groupName, string deptID) { string strSql = ""; ArrayList group = new ArrayList(); if (this.Sql.GetSql("Manager.ComGroup.QueryGroupsByName", ref strSql) == -1) { return(null); } try { string [] str = new string[] { groupName, deptID }; //strSql = string.Format(strSql, groupName, deptID); if (this.ExecQuery(strSql, str) == -1) { return(null); } while (Reader.Read()) { Neusoft.HISFC.Models.Fee.ComGroup c = new Neusoft.HISFC.Models.Fee.ComGroup(); c.ID = Reader[0].ToString(); c.Name = Reader[1].ToString(); c.spellCode = Reader[2].ToString(); c.inputCode = Reader[3].ToString(); c.groupKind = Reader[4].ToString(); c.deptCode = Reader[5].ToString(); if (Reader[6] != DBNull.Value) { c.sortId = Convert.ToInt32(Reader[6].ToString()); } else { c.sortId = 0; } c.ValidState = (Neusoft.HISFC.Models.Base.EnumValidState)(Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[7].ToString())); c.reMark = Reader[8].ToString(); c.operCode = Reader[9].ToString(); c.operDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[10].ToString()); group.Add(c); } Reader.Close(); } catch (Exception e) { this.Err = "Manager.ComGroup.GetGroupsByDept!" + e.Message; WriteErr(); if (Reader.IsClosed != true) { Reader.Close(); } return(null); } return(group); }
/// <summary> /// 获取所有组套 /// </summary> /// <param name="GroupKind">0 财务用,1科室用,ALL 全部</param> /// <returns></returns> public ArrayList GetAllGroups(string GroupKind) { ArrayList List = null; string strSql = ""; if (this.Sql.GetSql("Manager.ComGroup.GetAllGroups", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, GroupKind); if (this.ExecQuery(strSql) == -1) { return(null); } List = new ArrayList(); Neusoft.HISFC.Models.Fee.ComGroup info = null; while (this.Reader.Read()) { info = new Neusoft.HISFC.Models.Fee.ComGroup(); info.ID = Reader[0].ToString(); info.Name = Reader[1].ToString(); info.spellCode = Reader[2].ToString(); info.inputCode = Reader[3].ToString(); info.groupKind = Reader[4].ToString(); info.deptCode = Reader[5].ToString(); info.sortId = System.Convert.ToInt32(Reader[6].ToString()); info.ValidState = (Neusoft.HISFC.Models.Base.EnumValidState)(Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[7].ToString())); info.reMark = Reader[8].ToString(); info.operCode = Reader[9].ToString(); info.operDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[10].ToString()); //增加父及节点 info.ParentGroupID = this.Reader[12].ToString(); List.Add(info); } this.Reader.Close(); } catch (Exception ee) { this.Err = "Manager.ComGroup.GetAllGroups" + ee.Message; this.ErrCode = ee.Message; WriteErr(); return(null); } return(List); }
public Neusoft.HISFC.Models.Fee.ComGroup GetComGroupByGroupID(string GroupID) { string strSql = ""; //select group_id,group_name ,a.spell_code,a.input_code,group_Kind,dept_name,a.sort_id,valid_flag,remark from fin_com_group a ,com_department b where a.dept_code =b.dept_code and group_id ='{0}' and a.PARENT_CODE ='[父级编码]' and a.CURRENT_CODE ='[本级编码]'; Neusoft.HISFC.Models.Fee.ComGroup info = null; try { if (this.Sql.GetSql("Manager.ComGroup.GetComGroupByGroupID", ref strSql) == -1) { return(null); } strSql = string.Format(strSql, GroupID); this.ExecQuery(strSql); while (this.Reader.Read()) { info = new Neusoft.HISFC.Models.Fee.ComGroup(); info.ID = Reader[0].ToString(); info.Name = Reader[1].ToString(); info.spellCode = Reader[2].ToString(); info.inputCode = Reader[3].ToString(); info.groupKind = Reader[4].ToString(); info.deptName = Reader[5].ToString(); if (Reader[6] != DBNull.Value) { info.sortId = Convert.ToInt32(Reader[6]); } else { info.sortId = 0; } info.ValidState = (Neusoft.HISFC.Models.Base.EnumValidState)(Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[7].ToString())); info.reMark = Reader[8].ToString(); } this.Reader.Close(); } catch (Exception ee) { this.Err = ee.Message; return(null); } return(info); }
private void tvGroup_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { Neusoft.HISFC.Models.Fee.ComGroup comGroup = new Neusoft.HISFC.Models.Fee.ComGroup(); try { comGroup = e.Node.Tag as Neusoft.HISFC.Models.Fee.ComGroup; if (comGroup == null) { return; } } catch (Exception) { return; } this.ucFeeForm1.InsertGroup(comGroup.ID); }
public int ModefyComGroup(Neusoft.HISFC.Models.Fee.ComGroup info) { string strSql = ""; try { //update fin_com_group set GROUP_NAME ='{0}',SPELL_COD ='{1}',INPUT_CODE='{2}',GROUP_KIND='{3}',DEPT_CODE=(select dept_code from com_department where dept_name ='{4}' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]') ,SORT_ID ={5},VALID_FLAG ='{6}',REMARK ='{7}',OPER_CODE ='{8}' where GROUP_ID ='{9}' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]' if (this.Sql.GetSql("Manager.ComGroup.ModefyComGroup", ref strSql) == -1) { return(-1); } string OperCode = this.Operator.ID; strSql = string.Format(strSql, info.Name, info.spellCode, info.inputCode, info.groupKind, info.deptName, info.sortId, ((int)info.ValidState).ToString(), info.reMark, OperCode, info.ID); } catch (Exception ee) { this.Err = ee.Message; return(-1); } return(this.ExecNoQuery(strSql)); }
public int InsertInToComGroup(Neusoft.HISFC.Models.Fee.ComGroup info) { string strSql = ""; string OperCode = this.Operator.ID; //{9F3CF1C0-AF96-4d17-96B1-6B34636A42A7}增加父及节点 string[] str = new string[] { info.ID, info.Name, info.spellCode, info.inputCode, info.groupKind, info.deptName, info.sortId.ToString(), ((int)info.ValidState).ToString(), info.reMark, OperCode, info.ParentGroupID }; try { //insert into fin_com_group values('[本级编码]','[父级编码]','{0}','{1}','{2}','{3}','{4}',(select dept_code from com_department where dept_name ='{5}' and PARENT_CODE ='[父级编码]' and CURRENT_CODE ='[本级编码]'),'{6}','{7}','{8}','{9}',sysdate) if (this.Sql.GetSql("Manager.ComGroup.InsertInToComGroup", ref strSql) == -1) { return(-1); } //strSql = string.Format(strSql, info.ID, info.Name, info.spellCode, info.inputCode, info.groupKind, info.deptName, info.sortId, ((int)info.ValidState).ToString(), info.reMark, OperCode); } catch (Exception ee) { this.Err = ee.Message; } return(this.ExecNoQuery(strSql, str)); }
/// <summary> /// 按科室获取所有有效组套 /// </summary> /// <returns></returns> public ArrayList GetAllGroupList(string deptID) { #region sql // SELECT group_id, --组套ID // group_name, --组套名称 // spell_code, --组套拼音码 // input_code, --组套助记吗 // group_kind, --组套类型 0 .财务用 1 .科室用 // dept_code, --组套科室 // sort_id, --显示顺序 // valid_flag, --有效标志,1有效/2无效 // remark, --组套备注 // oper_code, --操作员 // oper_date --操作时间 // FROM fin_com_group --组套信息表,用于门诊收费、住院收费、护士站收费、体检收费、手术组套、终端组套 // WHERE parent_code='[父级编码]' and current_code='[本级编码]' and dept_code='{0}' and valid_flag='1' #endregion string strSql = ""; ArrayList group = new ArrayList(); if (this.Sql.GetSql("Manager.ComGroup.GetAllGroupList", ref strSql) == -1) { return(null); } try { strSql = string.Format(strSql, deptID); if (this.ExecQuery(strSql) == -1) { return(null); } while (Reader.Read()) { Neusoft.HISFC.Models.Fee.ComGroup c = new Neusoft.HISFC.Models.Fee.ComGroup(); c.ID = Reader[0].ToString(); c.Name = Reader[1].ToString(); c.spellCode = Reader[2].ToString(); c.inputCode = Reader[3].ToString(); c.groupKind = Reader[4].ToString(); c.deptCode = Reader[5].ToString(); if (Reader[6] != DBNull.Value) { c.sortId = Convert.ToInt32(Reader[6].ToString()); } else { c.sortId = 0; } c.ValidState = (Neusoft.HISFC.Models.Base.EnumValidState)(Neusoft.FrameWork.Function.NConvert.ToInt32(Reader[7].ToString())); c.reMark = Reader[8].ToString(); c.operCode = Reader[9].ToString(); c.operDate = Neusoft.FrameWork.Function.NConvert.ToDateTime(Reader[10].ToString()); group.Add(c); } Reader.Close(); } catch (Exception e) { this.Err = "Manager.ComGroup.GetValidGroupList!" + e.Message; WriteErr(); if (Reader.IsClosed != true) { Reader.Close(); } return(null); } return(group); }