예제 #1
0
        /// <summary>
        /// 判断是否存在关联员工的用户
        /// </summary>
        /// <param name="sid"></param>
        /// <returns></returns>
        public static bool IsStaffExistByPositionID(int pid)
        {
            bool IsExist = false;

            string sql = "select * from ipvt_staffmessagetable where PositionID= '" + pid + "'";

            try
            {
                DataSet ds = CustomMySqlHelper.Query(sql);
                if (ds.Tables[0].Rows.Count != 0)
                {
                    IsExist = true;
                }
            }
            catch (Exception ex)
            {
            }

            return(IsExist);
        }