public static string SelectDeptNameById(string deptId) { SqlParameter[] deptPara = new SqlParameter[1]; deptPara[0] = new SqlParameter("@deptid", deptId); return(DbAccess.ExecuteScalar(CommandType.StoredProcedure, "dept_selectNameByID", deptPara).ToString()); }
//select dept by Groupid public static string SelectDeptByGroupid(string groupId) { SqlParameter[] para = new SqlParameter[1]; para[0] = new SqlParameter("@groupid", groupId); return(DbAccess.ExecuteScalar(CommandType.StoredProcedure, "Groups_SelectDeptByGroupid", para).ToString()); }