部门设置(代码).docVIP

6-22 public int getNumBySQL(string strComm) { oleDbCommand comm; int num=0; openConnection(); comm=new oleDbCommand(strComm,conn); num=interface.Parse(comm.ExecuteScalar().ToString()); closeConnection(); return num; 6-23 pulic Data Table getTableInfo(string strComm) { OleDbCommand comm; OleDbDataReader oleReader; DataTable dt; openConnection(); comm=new OleDbCommand(strComm,conn); oleReader=comm.ExecuteReader(CommandBehavior.SchemaOnly); dt=oleReader.GetSchemaTable(); oleReader.Close(); closeConnection(); return dt; 6-25 public DataTable getDepartment() { string strComm; strComm=Select ID,Name,SecNum,ListNum,Manager,Member,+Rmember,Phone,Duty From HRtree Order By ID; return objHRDB.getDataBySQL(strComm); } 6-26 public void initTrvTree(TreeNodeCollection treeNodes,string strParentIndex,Data View dvList) { try { TreeNode tempNode; DataView dvList1; string currentNum; dvList=dvList; DataRow[]dataRows=dvList.Table.Select(SecNum=+strParentIndex+); foreach(DataRow dr indexer dataRows) { tempNode=new TreeNode(); tempNode.Text=dr[Name].ToString(); currentNum=dr[ListNum].toString(); treeNode.Add(tempNode); TreeNodeCollection temp_nodes=treeNodes[treeNodes.Count-1].Nodes; initTree(temp_nodes,currentNum,dvList1); } } catch(Exception) { MessageBox.Show(初始化 TreeView 失败); } } 6-27 public DataTable getDepartmentInfo(string departmentName) { string strComm; strComm=Select Name,ListNum,Rmember,Member,+Manager,Phone,Duty,ID,SecNum From HRtree +Where Name=+departmentName+; retrun objHRDB.getDataBySQL(strComm); } 6-28 public string getDepartmentNum(string strParenNum) { string strComm; string departmentNum; int num; DataTable dt=new DataTable(); strComm=Select Top 1 ListNum,SecNum From HRtree Where SecNum= +strParentNum+Order By ListNum DESC; dt=objHRDB.getDataBySQL(strComm); if(dt.Rows.Count0) { departNum=dt.Rows[0][0].ToString(); } else { departmentNum=0; num=int.Parse(departmentNum)+1; return num.ToString(); } 6-2