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());
}