/// <summary> /// ��ȡ��ǰ���Ŷ��� /// </summary> /// <param name="iDeptID">��ȡ���ű��</param> /// <returns></returns> public DepartmentModel Department_GetModel(int iDeptID) { string strsql = "select * from Department where DEPT_ID=" + iDeptID.ToString(); ShineKJ.DAL.KJ128.DataBaseDAL databasedal = new ShineKJ.DAL.KJ128.DataBaseDAL(); DataSet ds = databasedal.ExecSql(strsql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { DepartmentModel model = new DepartmentModel(); DataRow dr = ds.Tables[0].Rows[0]; model.DEPT_FUNC = dr["DEPT_FUNC"].ToString(); model.DEPT_ID = int.Parse(dr["DEPT_ID"].ToString()); model.DEPT_NAME = dr["DEPT_NAME"].ToString(); model.DEPT_NO = dr["DEPT_NO"].ToString(); model.DEPT_PARENT = int.Parse(dr["DEPT_PARENT"].ToString()); model.FAX_NO = dr["FAX_NO"].ToString(); model.LEADER1 = dr["LEADER1"].ToString(); model.LEADER2 = dr["LEADER2"].ToString(); model.MANAGER = dr["MANAGER"].ToString(); model.TEL_NO = dr["TEL_NO"].ToString(); return model; } else return null; }
/// <summary> /// 获取部门列表 /// </summary> /// <returns></returns> public DataSet Get_DeptList() { ShineKJ.DAL.KJ128.DataBaseDAL dal = new ShineKJ.DAL.KJ128.DataBaseDAL(); try { return dal.RunProcWithOutPara("Mine_Get_DeptList"); } catch { return null; } }
/// <summary> /// ��ȡ��ѡ��IJ������� /// </summary> /// <param name="strIDs">���ű��</param> /// <returns></returns> public string Department_GetDeptNamestr(string strIDs) { if (strIDs.Equals("ALL_DEPT")) return "ȫ�岿��"; else if (strIDs.Equals("")) return ""; else { string strDeptNames = string.Empty; string strsql = "select DEPT_NAME from Department where DEPT_ID in (" + strIDs.Remove(strIDs.LastIndexOf(",")) + ")"; ShineKJ.DAL.KJ128.DataBaseDAL databasedal = new ShineKJ.DAL.KJ128.DataBaseDAL(); DataSet ds = databasedal.ExecSql(strsql); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { strDeptNames += dr["DEPT_NAME"].ToString() + ","; } } return strDeptNames; } }