public int status (int jdkey)
{
    object count;
    string sqlstrng;
    int key;

    sqlstrng = "Select Count(*) from hr_staff_job where Job_Key in ( select JD_Key from HR_Jobs where JD_parentkey = " + jdkey + "";
    sqlstrng  = sqlstrng + "or Job_Key in ( select JD_Key from HR_Jobs where JD_Key  =  " + jdkey + ")  ";

    count = obj.ExecScalarQuery(sqlstrng);
    key = Convert.ToInt32(count);

    if (key > 0)
    {
        return 1;
    }
    else return 0;
}